page_title='notstarring.com -- Submit a New Entry'; //$gbl->meta_key=''; //$gbl->meta_desc=''; //$gbl->show_ads = 'left'; $gbl->getHeader(); //some intitializing $error=''; $done=''; $_POST['actor'] = isset($_POST['actor']) ? $_POST['actor'] : ''; $_POST['movie'] = isset($_POST['movie']) ? $_POST['movie'] : ''; $_POST['year'] = isset($_POST['year']) ? $_POST['year'] : ''; $_POST['source'] = isset($_POST['source']) ? $_POST['source'] : ''; $_POST['description'] = isset($_POST['description']) ? $_POST['description'] : ''; $_POST['submitted_by'] = isset($_POST['submitted_by']) ? $_POST['submitted_by'] : ''; $_POST['actual_actor'] = isset($_POST['actual_actor']) ? $_POST['actual_actor'] : ''; ?> '; } if (!$_POST['actor']) { $error .= '- Please enter the actor that DIDN\'T get the part.
'; } if (!$_POST['description']) { $error .= '- Please enter a short description. Use the example as a guideline.
'; } if (!$_POST['source']) { $error .= '- Please tell us the source - hopefully a web page we can go check out.
'; } if (strlen($_POST['description']) > 800 ) { $error .= '- Sorry, your description is tooooooo long.
'; } if ($_POST['description'] && strlen($_POST['description']) < 25 ) { $error .= '- Sorry, your description is tooooooo short.
'; } if ( preg_match("/http/i",$_POST['description'])) { $error .= '- Please include the URL in the source, not the description.
'; } if (!$_POST['submitted_by']) { $error .= '- Please enter your name or nickname so we can keep track of your entries.
'; } if (( preg_match("/ and /i",$_POST['actor']) || preg_match("/ & /i",$_POST['actor']) || preg_match("/,/i",$_POST['actor'])) && !preg_match("/jr/i",$_POST['actor'])) { $error .= '- Please enter these actors one-at-a-time. You can use your back button to modify and re-submit the form if that is easier.
'; } if ( preg_match("/^imdb$/i",$_POST['source']) || preg_match("/^imdb.com$/i",$_POST['source']) || preg_match("/^www.imdb.com$/i",$_POST['source'])) { $error .= '- If you are claiming IMDB as the best source, please give us the full URL to the page so we can review. Better yet, please verify with another source and submit that instead. IMDB is sometimes prone to rumor.
'; } //error checking for status 'live' duplicates $query = "select count(*) as count,max(movie_sort_by) as sort_by from entries where movie='" . mysql_real_escape_string($_POST['movie']) . "' and '" . mysql_real_escape_string($_POST['actor']) . "'= concat(actor_first,' ',actor_last) and status='live'"; $dup_result = $db->query($query); $dup = $db->fetch_assoc($dup_result); if ($dup['count']>0) { $error .= '- This trivia appears to already be on the site. If you are submitting a correction, please use the contact form instead.
'; } //error checking for status 'new' duplicates from same person $query = "select count(*) as count,max(movie_sort_by) as sort_by from entries where movie='" . mysql_real_escape_string($_POST['movie']) . "' and '" . mysql_real_escape_string($_POST['actor']) . "'= concat(actor_first,' ',actor_last) and status!='live' and submitted_by='" . mysql_real_escape_string($_POST['submitted_by']) . "'"; $mydup_result = $db->query($query); $mydup = $db->fetch_assoc($mydup_result); if ($mydup['count']>0) { $error .= '- Thanks '.$_POST[submitted_by].' - looks like you\'ve submitted that one before, but our editors haven\'t reviewed it yet. We are very back-logged right now, but we promise to get to it soon!
'; } //error checking for status 'new' duplicates and this source is imdb or wiki if ($mydup['count']==0 && (preg_match("/imdb/i",$_POST['source']) || preg_match("/wiki/i",$_POST['source']))) { $query = "select count(*) as count,max(movie_sort_by) as sort_by from entries where movie='" . mysql_real_escape_string($_POST['movie']) . "' and '" . mysql_real_escape_string($_POST['actor']) . "'= concat(actor_first,' ',actor_last) and status='new'"; $dup_result = $db->query($query); $dup = $db->fetch_assoc($dup_result); if ($dup['count']>0) { $error .= '- Looks like someone has already submitted this one - our editors just haven\'t published it to the site yet. Sorry for the inconvenience! Please contact us if you have questions.
'; } } //clean up POST data foreach ($_POST as $k => $v) { $_POST[$k] = trim(preg_replace("/\s+/", " ", $v)); } // if no errors, generate remaining fields, and insert row if ( !$error ) { //add period to end of description if not already there // reminder: if strcmp matches it returns 0 if ( strcmp(substr($_POST['description'],-1,1),'.') and strcmp(substr($_POST['description'],-1,1),'"') ) { $_POST['description'] .= '.'; } $_POST['description'] = ucfirst($_POST['description']); //captilize the movie correctly $_POST['movie'] = ucwords($_POST['movie']); //would this be better using explode and testing equality?? $_POST['movie'] = preg_replace( "/ To /", " to ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ In /", " in ", $_POST['movie']); // $_POST['movie'] = preg_replace( "/ The /", " the ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ And /", " and ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ Of /", " of ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ For /", " for ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ On /", " on ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ With /", " with ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ At /", " at ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ As /", " as ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ An /", " an ", $_POST['movie']); $_POST['movie'] = preg_replace( "/ A /", " a ", $_POST['movie']); $_POST['movie'] = ucfirst($_POST['movie']); //sentence case these fields too $_POST['actor'] = ucwords($_POST['actor']); $_POST['actual_actor'] = ucwords($_POST['actual_actor']); // determine movie_sort_by & movie_file_under list( $_POST['movie_sort_by'], $_POST['movie_file_under'] ) = $gbl->makeMovieValues($_POST['movie']); // split actor name into first/last list( $_POST['actor_first'], $_POST['actor_last'] ) = $gbl->makeFirstLast($_POST['actor']); // determine actor_sort_by & actor_file_under list( $_POST['actor_sort_by'], $_POST['actor_file_under'] ) = $gbl->makeActorValues($_POST['actor_first'],$_POST['actor_last']); // split ACTUAL actor name into first/last list( $_POST['actual_actor_first'], $_POST['actual_actor_last'] ) = $gbl->makeFirstLast($_POST['actual_actor']); $status = 'new'; if (strtolower($_POST['submitted_by']) == 'mc' and $_SERVER['REMOTE_ADDR'] == $gbl->my_ip) { $status = 'live'; } //set defaults, unless overridden by posting a duplicate from edit.html //bind to my IP so that override only works from my machine //in fact, let's even only show the hidden fields if my IP /* if ($_SERVER['REMOTE_ADDR'] == $gbl->my_ip) { if (!$_POST['date_entered']) { $_POST['date_entered'] = $gbl->INtime(); } if (!$_POST['uagent']) { $_POST['uagent'] = $_SERVER['HTTP_USER_AGENT']; } if (!$_POST['ip']) { $_POST['ip'] = $_SERVER['REMOTE_ADDR']; } } */ $_POST['date_entered'] = $gbl->INtime(); $_POST['uagent'] = $_SERVER['HTTP_USER_AGENT']; $_POST['ip'] = $_SERVER['REMOTE_ADDR']; //magic_quotes is off via .htaccess, so escape data before inserting $_POST = array_map('mysql_real_escape_string', $_POST); $query = "INSERT INTO entries ( date_entered, movie, year, actor_first, actor_last, description, actual_actor_first, actual_actor_last, source, movie_file_under, movie_sort_by, actor_file_under, actor_sort_by, status, submitted_by, uagent, ip ) VALUES ( '$_POST[date_entered]', '$_POST[movie]', '$_POST[year]', '$_POST[actor_first]', '$_POST[actor_last]', '$_POST[description]', '$_POST[actual_actor_first]', '$_POST[actual_actor_last]', '$_POST[source]', '$_POST[movie_file_under]', '$_POST[movie_sort_by]', '$_POST[actor_file_under]', '$_POST[actor_sort_by]', '$status', '$_POST[submitted_by]', '$_POST[uagent]', '$_POST[ip]' )"; $db->query($query); //set mode for thankyou page if not me //if me, leave fields there for me to re-submit next entry if (strtolower($_POST['submitted_by']) == 'mc' and $_SERVER['REMOTE_ADDR'] == $gbl->my_ip) { $done = 0; } else { $done = 1; } } } ?>
 Thank You !
Thank you for helping build the database! Your entry is greatly appreciated! Note: All entries are reviewed before appearing on the site. This process can sometimes take up to a few days. We reserve the right to edit or remove any entry for any reason.


Click here to submit another entry


Can you contribute anything to our newest site?



 Submit A New Entry!
Do you know one that we missed? Fill out the form below and help us build the archive. It's easy! ***If you submit an entry & don't see it appear right away, PLEASE DON'T RE-SUBMIT IT! We're just a little behind right now. Thanks!***

"; } ?> $error

"; } ?>


3 Things to Know Before Submitting a New Entry...

1. Don't Violate Copyrights
Please, please, please do not just copy/paste from another source. We are very careful to not violate copyrighted material, so please change the wording enough to make it your own expression.

2. Include Your Source!!
Please tell us the full address of a webpage so we can go check it out. If it's a TV show or book, please include the title and even the date if possible. We don't want to post rumors, so just be sure that it came from a trusted source.

3. It May Not Show Right Away
We approve each submission before it appears on the site, so don't worry if your entry doesn't appear immediately. We also reserve the right to edit or remove any entry for any reason.

  REQUIRED:   EXAMPLE:
Movie
Movie
The Matrix
Actor that DIDN'T get the part
Actor that DIDN'T get the part
Will Smith
Description
Description
Will Smith turned down the lead role, admitting later that he had no regrets because "Keanu was brilliant as Neo."
Source (URL, magazine name, TV show name, etc.)
Source
http://www.imdb.com/name/nm0000226/bio
Submitted By (your name or nickname)


Submitted By
Tell us who you are so we can keep track of your entries.
OPTIONAL, BUT HELPFUL:  
Actor that DID get the part
Actor that DID get the part
Keanu Reeves
Year the movie was released
(type "none" if movie was never made)
Year the movie was released
1999
my_ip && ) { ?> */ ?>
 
getFooter(); ?>