= '4.3.0') //if using new version of PHP and mysql_real_escape_string { $string = mysql_real_escape_string(htmlentities($string, ENT_QUOTES)); } else //for the old version of PHP and mysql_escape_string { $string = mysql_escape_string(htmlentities($string, ENT_QUOTES)); } return $string; //return the secure string } if ($_GET["sex"] == "male") $gender = "Gender = 'M' "; else $gender = "Gender = 'F' "; if ($_GET["time"] == "recent") $time = " Latest_Scene >= date_sub(now(), INTERVAL 1 YEAR) AND "; else $time = ""; if ($_GET["time_scene"] == "recent") $time2 = " WHERE Date_Released >= date_sub(now(), INTERVAL 1 YEAR) "; else if (ctype_digit($_GET["time_scene"]) && $_GET["time_scene"] <= idate('Y') && $_GET["time_scene"] >= 2004 ) $time2 = " WHERE Date_Released BETWEEN '".$_GET["time_scene"]."-01-01' and '".($_GET["time_scene"] + 1)."-01-01' "; else $time2 = ""; //echo $_GET["sort"]; if ($_GET["website"] == "any") $website = ""; else if($time2 == "") $website = "WHERE Website = '" . $_GET["website"] . "' "; else $website = "AND Website = '" . $_GET["website"] . "' "; switch($_GET["sort"]) { case "a_score": $sort = "ORDER BY Actor_Score DESC "; break; case "a_rating": $sort = "ORDER BY Actor_Rating DESC "; break; case "t_rating": $sort = "ORDER BY Avg_Traffic_Rating DESC "; break; case "count": $sort = "ORDER BY Scene_Count DESC "; break; case "b_rating": $sort = "ORDER BY Bayesian_Rating DESC "; break; case "tr_rating": $sort = "ORDER BY Traffic_Rating DESC "; break; case "vote_count": $sort = "ORDER BY Actor_Votecount DESC "; break; case "rating_count": $sort = "ORDER BY Number_of_Ratings DESC "; break; case "f_scene": $sort = "ORDER BY First_Scene DESC "; break; default: $sort = "ORDER BY Actor_Score DESC "; break; } switch($_GET["topcount"]) { case "25": $limit = "LIMIT 25"; break; case "50": $limit = "LIMIT 50"; break; case "75": $limit = "LIMIT 75"; break; case "100": $limit = "LIMIT 100"; break; case "10": $limit = "LIMIT 10"; break; case "200": $limit = "LIMIT 200"; break; case "nolimit": $limit = ""; break; default: $limit = "LIMIT 50"; break; } if ($_GET["actor_name"] != "" && $_GET["actor_name"] != null) $name = secure_string($_GET["actor_name"]); if($_GET["tour"] == "yes") { $url_start = "http://tour.naughtyamerica.com/"; $url_end = "&nats=MTA3NDE3LjEyLjMuMy44LjAuMC4wLjA"; } else { $url_start = "http://members.naughtyamerica.com/"; $url_end = ""; } // Performing SQL query if ($_GET["query"] == "topnewgirls") { if ($_GET["sort"] == "f_scene") $query = "SELECT concat('', Actor_Name,''), round(Actor_Score,4), round(Actor_Rating,4), Scene_Count, round(Avg_Traffic_Rating,4) as 'ATR', Date_Format(First_Scene, '%b %d, %Y') FROM All_Actors WHERE First_Scene > date_sub(now(), INTERVAL 1 YEAR) AND Actor_Votecount >= 50 AND Gender = 'F' ". $sort . $limit; else $query = "SELECT concat('', Actor_Name,''), round(Actor_Score,4), round(Actor_Rating,4), Scene_Count, round(Avg_Traffic_Rating,4) as 'ATR', Date_Format(First_Scene, '%b %d, %Y') FROM All_Actors WHERE First_Scene > date_sub(now(), INTERVAL 1 YEAR) AND Actor_Votecount >= 50 AND Gender = 'F' ORDER BY Actor_Rating DESC ". $limit; $tabletype = "actors"; } else if ($_GET["query"] == "actors") { $query = "SELECT concat('', Actor_Name,''), round(Actor_Score,4), round(Actor_Rating,4), Scene_Count, round(Avg_Traffic_Rating,4) as 'ATR' FROM All_Actors WHERE Actor_Name LIKE '%" . $name . "%'"; $tabletype = "actors"; } else if ($_GET["query"] == "topscenes") { $query = "SELECT concat('',Website, ' - ', Scene_Title, ''), Date_Format(Date_Released, '%b %d, %Y'), round(Bayesian_Rating, 4), round(Traffic_Rating, 4) as 'Traffic Rating', trim(';' FROM Actors) as Actors FROM All_Scenes ". $time2 . $website . $sort . $limit; $tabletype = "scenes"; } else if ($_GET["query"] == "scenes") { $query = "SELECT concat('',Website, ' - ', Scene_Title, ''), Date_Format(Date_Released, '%b %d, %Y'), round(Bayesian_Rating, 4), round(Traffic_Rating, 4) as 'Traffic Rating', trim(';' FROM Actors) as Actors FROM All_Scenes WHERE Actors LIKE '%" . $name . "%'"; $tabletype = "scenes"; } else { $query = "SELECT concat('', Actor_Name,''), round(Actor_Score,4), round(Actor_Rating,4), Scene_Count, round(Avg_Traffic_Rating,4) FROM All_Actors WHERE Scene_Count >= 3 AND Actor_Votecount >= 100 AND " . $time . $gender . $sort . $limit; $tabletype = "actors"; } // echo $query; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "\n"; if ($tabletype == "actors") { echo "\n\n\n\n\n" . ($_GET["query"] == "topnewgirls" ? "\n" : ""); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; foreach ($line as $key => $col_value) { echo "\t\t$col_value\n"; } echo "\t\n"; } } else if ($tabletype = "scenes") { echo "\n\n\n\n\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t\n"; foreach ($line as $key => $col_value) { echo "\t\t$col_value\n"; } echo "\t\n"; } } echo "
Name Actor Score Actor Rating# of ScenesAvg Traffic RatingFirst Scene
Scene NameDate ReleasedRatingTraffic RatingActors
\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>