0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 1 GROUP BY user_rating.page_id HAVING amount > 10 ORDER BY rate DESC LIMIT 10"; $top_sql_movie = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 3 GROUP BY user_rating.page_id HAVING amount > 0 ORDER BY rate DESC LIMIT 10"; $top_sql_ova = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 2 GROUP BY user_rating.page_id HAVING amount > 0 ORDER BY rate DESC LIMIT 10"; $top_sql_live = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 4 GROUP BY user_rating.page_id HAVING amount > 0 ORDER BY rate DESC LIMIT 10"; $top_sql_fansub = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 5 GROUP BY user_rating.page_id HAVING amount > 0 ORDER BY rate DESC LIMIT 10"; function show_sorting_icon($link, $column) { $sorting_link_asc = $link . "&sorting_column=" . $column . "&sorting_order=asc"; $sorting_link_desc = $link . "&sorting_column=" . $column . "&sorting_order=desc"; echo "  "; } function show_stars($rate) { switch ($rate) { case 10: echo "\"$anime_name"; break; case 9: echo "\"$anime_name"; break; case 8: echo "\"$anime_name"; break; case 7: echo "\"$anime_name"; break; case 6: echo "\"$anime_name"; break; case 5: echo "\"$anime_name"; break; case 4: echo "\"$anime_name"; break; case 3: echo "\"$anime_name"; break; case 2: echo "\"$anime_name"; break; case 1: echo "\"$anime_name"; break; } } ?> Top Rated Banner
ANIME SERIES
Ranking Name # of votes Views Rating
query($top_sql_anime); while ($data = mysql_fetch_array($top_ten_anime_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$a1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $a1++; } echo "
View Full Series List
\n"; ?>
ANIME MOVIES
Ranking Name # of votes Views Rating
query($top_sql_movie); while ($data = mysql_fetch_array($top_ten_movie_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$m1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $m1++; } echo "
View Full Movies List
\n"; ?>
OVA's
Ranking Name # of votes Views Rating
query($top_sql_ova); while ($data = mysql_fetch_array($top_ten_ova_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$o1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $o1++; } echo "
View Full OVA's List
\n"; ?>
LIVE ACTION
Ranking Name # of votes Views Rating
query($top_sql_live); while ($data = mysql_fetch_array($top_ten_live_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$l1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $l1++; } echo "
View Full Live Action List
\n"; ?>
ANIME FANSUBS
Ranking Name # of votes Views Rating
query($top_sql_fansub); while ($data = mysql_fetch_array($top_ten_fansub_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$l1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $l1++; } echo "
View Full Fansubs List
\n"; ?>
0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 1 $append_genre GROUP BY user_rating.page_id HAVING amount > 0 " . $sql_sorting; $top_sql_movie_all = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 3 $append_genre GROUP BY user_rating.page_id HAVING amount > 0 " . $sql_sorting; $top_sql_ova_all = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 2 $append_genre GROUP BY user_rating.page_id HAVING amount > 0 " . $sql_sorting; $top_sql_live_all = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 4 $append_genre GROUP BY user_rating.page_id HAVING amount > 0 " . $sql_sorting; $top_sql_fansub_all = "SELECT AVG( user_rating.rating ) AS rate, COUNT( user_rating.id ) AS amount, user_rating.page_id AS a_id, (SELECT ac_anime.title FROM ac_anime WHERE ac_anime.id = a_id) AS title, (SELECT ac_anime.page FROM ac_anime WHERE ac_anime.id = a_id) AS link, (SELECT ac_anime.views FROM ac_anime WHERE ac_anime.id = a_id) AS views FROM user_rating WHERE user_rating.page_id > 0 AND (SELECT ac_anime.type FROM ac_anime WHERE ac_anime.id = user_rating.page_id) = 5 $append_genre GROUP BY user_rating.page_id HAVING amount > 0 " . $sql_sorting; $arr_genre = array('Action', 'Adventure', 'Comedy', 'Drama', 'Fantasy', 'Historical', 'Horror', 'Mystery', 'Psychological', 'Romance', 'Tournament', 'Science Fiction', 'Supernatural'); $genre_form = ''; $genre_form .= '
'; $genre_form .= 'Filter by Genre: '; $genre_form .= '
'; if($_REQUEST['sel_genre'] != '') $query_string_genre = "&sel_genre=".$_REQUEST['sel_genre']; else $query_string_genre = ''; if($_GET['x'] == 1){ ?> Top Rated Banner
ALL ANIME EPISODES
Ranking Name (# of votes) Views Rating
query($top_sql_anime_all); while ($data = mysql_fetch_array($top_ten_anime_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$a1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $a1++; } ?>
Top Rated Banner
ALL ANIME MOVIES
Ranking Name (# of votes) Views Rating
query($top_sql_movie_all); while ($data = mysql_fetch_array($top_ten_movie_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$td $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $td++; } ?>
Top Rated Banner
ALL OVA's
Ranking Name (# of votes) Views Rating
query($top_sql_ova_all); while ($data = mysql_fetch_array($top_ten_ova_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$o1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $o1++; } ?>
Top Rated Banner
ALL LIVE ACTION MOVIES
Ranking Name (# of votes) Views Rating
query($top_sql_live_all); while ($data = mysql_fetch_array($top_ten_live_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$l1 $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $l1++; } ?>
Top Rated Banner
ALL ANIME FANSUBS
Ranking Name (# of votes) Views Rating
query($top_sql_fansub_all); while ($data = mysql_fetch_array($top_ten_fansub_q)) { $rate = $data['rate']; $anime_name = $data['title']; $page = $data['link']; $anime_views = $data['views']; $anime_url = strtolower($anime_name); $anime_url = str_replace(" ", "_", "$anime_url"); $rate = round($rate, 0); if (preg_match("[episodes]", $page)) { $url_insert = "anime_episodes"; $type_insert = "Anime Series";} if (preg_match("[oVAs]", $page)) { $url_insert = "anime_oVAs"; $type_insert = "Anime OVA"; } if (preg_match("[movies]", $page)) { $url_insert = "anime_movies"; $type_insert = "Anime Movie"; } if (preg_match("[live]", $page)) { $url_insert = "live_action"; $type_insert = "Live Action"; } if (preg_match("[fansub]", $page)) { $url_insert = "anime_fansubs"; $type_insert = "Anime Fansubs"; } echo "
#$bb $anime_name $data[amount] $anime_views "; show_stars($rate); echo "
\n"; $bb++; } ?>