debug = 1; //right here we should XSS clean $_REQUEST //initialize to avoid warnings $p = array(); $p['id']=0; $p['typo_or_synonym']=''; $alias_name=''; $alias_search_name=''; // first see if we have an alias to work with if (isset($_REQUEST['alias'])) { $query = "select * from aliases where alias_sort_by='" . strtolower($_REQUEST['alias']) . "' limit 1;"; $parent_result = $db->query($query); if ( $db->num_rows($parent_result) ) { $p = $db->fetch_assoc($parent_result); //if there was a match, then load the "parent" actor sort_by into $_REQUEST $_REQUEST['actor']= $p['parent_sort_by']; //default alias & alias_search to the actor's name. if typo, then convert //search to "search for actor name". it's just easier to work with. $alias_name = $alias_search_name = $p['alias']; if ($p['typo_or_synonym']=='t') { $alias_search_name = 'Search for "' . $p['alias'] . '"'; } } } // take actor from post info & see if there is a match //removed unconfirmed ones 2/4/2010 (status='live' or status='unconfirmed') $query = "select * from entries where actor_sort_by='" . strtolower($_REQUEST['actor']) . "' and status='live' order by movie_sort_by;"; $result = $db->query($query); $entry_count = $db->num_rows($result); //if no match, redirect out of here if ( $entry_count == 0 ) { header( "Location: http://www.notstarring.com/actors/menu.html" ); exit; } //now get some global-ish stuff from the array then rewind $stuff = $db->fetch_assoc($result); $actor_name = $stuff['actor_first'] . " " . $stuff['actor_last']; $actor_first = addslashes($stuff['actor_first']); //used only for select below $actor_last = addslashes($stuff['actor_last']); //used only for select below $letter = $stuff['actor_file_under']; //calculate seed for anchoring aliases, alias+parent+month $seed = $p['id']+$stuff['id']+date("m"); mysql_data_seek( $result, 0 ); // see if there are movies that they were not the first choice for $query = "select distinct(movie) as movie,movie_sort_by from entries where actual_actor_first='$actor_first' and actual_actor_last='$actor_last' and status='live' order by movie_sort_by;"; $firstchoice_result = $db->query($query); $firstchoice_count = $db->num_rows($firstchoice_result); //see if this actor appears on hardlyfamous.com, if so show link box // you have to run get_hf_pages.php occasionaly to update list // $query = "select star_sort_by from hf_pages where star_sort_by='" . strtolower($_REQUEST['actor']) . "' limit 1"; // $hf_result = $db->query($query); // if ($hf_result) { // $hf_record = $db->fetch_assoc($hf_result); // $hf_link = $hf_record['star_sort_by']; // } //temporarily hide these altogether - 6/22/09 $hf_link=''; // create the menu box of links to other actors with same letter $query = "select max(actor_first) as actor_first,max(actor_last) as actor_last,actor_sort_by,count(*) as count from entries where status='live' and actor_sort_by > '" . $_REQUEST['actor'] . "' group by actor_sort_by order by actor_sort_by limit 35"; $menu_result = $db->query($query); $actor_count = $db->num_rows($menu_result); // check if there are aliases for this actor //$query = "select * from aliases where parent_sort_by='" . $_REQUEST['actor'] . "' order by rand($seed) limit 2"; //$alias_result = $db->query($query); //$alias_count = $db->num_rows($alias_result); //set global variables #$title_string = ($stuff['id']%2==0) ? 'Funny Trivia' : 'Rejected Movie Roles'; $gbl->page_title= ($alias_name) ? $alias_name : $actor_name." - Trivia"; $gbl->meta_key= ($alias_name ? $alias_name : $actor_name) . ' Trivia, Roles turned down by ' . ($alias_name ? $alias_name : $actor_name); $gbl->meta_desc= 'See which roles ' . ($alias_name ? $alias_name : $actor_name) . ' turned down.'; $gbl->show_ads='none'; $gbl->getHeader(); if ( !$p['typo_or_synonym']=='t' ) { $temp_footer_name = ($alias_name && $p['typo_or_synonym']=='s' ? $alias_name : $actor_name); $gbl->footer_override = " This $temp_footer_name trivia and all celebrity trivia on notstarring.com is submitted and reviewed by movie fans from around the world. We strive to provide reliability with our rejected movie roles, and we go to great lengths to try and corroborate entries. Still, by its nature, this type of trivia will always be prone to rumor and funny Hollywood gossip and should be relied upon with appropriate caution. Please help by reporting corrections for this $temp_footer_name trivia or other celebrity trivia."; } $old_actor = ''; /* temp remove this for performance reasons 2/4/2010 // select previous link $query = "select actor_sort_by,actor_first,actor_last from entries where status='live' and actor_sort_by < '" . $_REQUEST['actor'] . "' order by actor_sort_by desc limit 1;"; $prev_menu_result = $db->query($query); $prev_menu_array = $db->fetch_assoc($prev_menu_result); $prev_link = ($db->num_rows($prev_menu_result)) ? '/actors/'.$prev_menu_array['actor_sort_by'] : '/actors/menu.html'; $prev_name = ($db->num_rows($prev_menu_result)) ? $prev_menu_array['actor_first'] . " " . $prev_menu_array['actor_last'] : 'Menu'; // select next link $query = "select actor_sort_by,actor_first,actor_last from entries where status='live' and actor_sort_by > '" . $_REQUEST['actor'] . "' order by actor_sort_by limit 1;"; $next_menu_result = $db->query($query); $next_menu_array = $db->fetch_assoc($next_menu_result); $next_link = ($db->num_rows($next_menu_result)) ? '/actors/'.$next_menu_array['actor_sort_by'] : '/actors/menu.html'; $next_name = ($db->num_rows($next_menu_result)) ? $next_menu_array['actor_first'] . " " . $next_menu_array['actor_last'] : 'Menu'; */ ?>  «   »  */ ?>
Did you mean: ? Movie Triva » "" Actors » Trivia Tell a friend about this site!    Save to del.icio.us    digg it
*/ ?>
 Did you mean: ?
 Roles turned down by :

fetch_assoc($result)) { ?>
new_days)) ); if ( $e['date_published'] > $thirty_days ) { echo ''; } ?> (?????)'; } ?>
Submitted by:
Actor who got the part:
Help! Can you verify this entry?  » THIS IS TRUE  » JUST A RUMOR 






Did you know that was not the only choice for ? (click to learn more)
fetch_assoc($firstchoice_result)) { ?> »








 Other Popular Actors:
fetch_assoc($menu_result)) { $class = 't1'; if ($m['count'] >= 3) { $class = 't2'; } if ($m['count'] >= 5) { $class = 't3'; } if ($m['count'] >= 10) { $class = 't4'; } $big_menu_string .= ''.$m['actor_first'].' '.$m['actor_last'].''; $big_menu_string .= " · "; } $big_menu_string = preg_replace('/ · $/', '', $big_menu_string); echo $big_menu_string; ?>

getFooter(); ?>