function nh($value){
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);}
if (!is_numeric($value)) {
$value = mysql_real_escape_string($value); }
return $value; }
if($_POST['name'] != "Search Anime") { $name = nh($_POST['name']); }
if($_POST['hq'] == "") $hq = ""; else $hq = "& (`hq` = '1')";
if($_POST['lq'] == "") $hq = ""; else $lq = "& (`lq` = '1')";
if($_POST['hd'] == "") $hd = ""; else $hd = "& (`hd` = '1')";
if($_POST['eng_lang'] == "") $eng_lang = ""; else $eng_lang = "& (`eng_lang` = '1')";
if($_POST['jpn_lang'] == "") $jpn_lang = ""; else $jpn_lang = "& (`jpn_lang` = '1')";
if($_POST['complete'] == "1") { $complete = "& (`e_online` = `e_total`)"; } else { $complete = ""; }
if(!empty($_POST['genre'])) {
$genre = $_POST['genre'];
foreach($genre as $type) {
$type = nh($type);
$genre2 .= " & (`genre` LIKE '%$type%')";
}
}
if(!empty($_POST['content'])) {
$content = $_POST['content'];
foreach($content as $type) {
$type = nh($type);
$content2 .= " & (`content` NOT LIKE '%$type%')";
}
}
if($_POST[order] == "1" || !isset($_POST[order])) { $order = "name ASC"; }
if($_POST[order] == "2") { $order = "views DESC"; }
if($_POST[order] == "3") { $order = "rating DESC"; }
if($_POST[order] == "4") { $order = "type DESC"; }
if(empty($User->Id)){ $dont_show = ""; }
if(!isset($_POST['name']) && !isset($_GET[lett])) { $letters = "& ((LEFT(name,1) REGEXP '[0 - A]') OR (LEFT(name,1) = '.'))"; }
if(!isset($_POST['name']) && $_GET[lett] == "a") { $letters = "& (LEFT(name,1) REGEXP '[A]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "b") { $letters = "& (LEFT(name,1) REGEXP '[B]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "c") { $letters = "& (LEFT(name,1) REGEXP '[C]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "d") { $letters = "& (LEFT(name,1) REGEXP '[D]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "e") { $letters = "& (LEFT(name,1) REGEXP '[E]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "f") { $letters = "& (LEFT(name,1) REGEXP '[F]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "g") { $letters = "& (LEFT(name,1) REGEXP '[G]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "h") { $letters = "& (LEFT(name,1) REGEXP '[H]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "i") { $letters = "& (LEFT(name,1) REGEXP '[I]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "j") { $letters = "& (LEFT(name,1) REGEXP '[J]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "k") { $letters = "& (LEFT(name,1) REGEXP '[K]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "l") { $letters = "& (LEFT(name,1) REGEXP '[L]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "m") { $letters = "& (LEFT(name,1) REGEXP '[M]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "n") { $letters = "& (LEFT(name,1) REGEXP '[N]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "o") { $letters = "& (LEFT(name,1) REGEXP '[O]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "p") { $letters = "& (LEFT(name,1) REGEXP '[P]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "q") { $letters = "& (LEFT(name,1) REGEXP '[Q]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "r") { $letters = "& (LEFT(name,1) REGEXP '[R]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "s") { $letters = "& (LEFT(name,1) REGEXP '[S]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "t") { $letters = "& (LEFT(name,1) REGEXP '[T]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "u") { $letters = "& (LEFT(name,1) REGEXP '[U]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "v") { $letters = "& (LEFT(name,1) REGEXP '[V]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "w") { $letters = "& (LEFT(name,1) REGEXP '[W]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "x") { $letters = "& (LEFT(name,1) REGEXP '[X]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "y") { $letters = "& (LEFT(name,1) REGEXP '[Y]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "z") { $letters = "& (LEFT(name,1) REGEXP '[Z]')"; }
if(!isset($_POST['name']) && $_GET[lett] == "0-z") { $letters = "& (LEFT(name,1) REGEXP '[0 - Z]')"; }
if(!isset($_POST['name']) && $_GET[lett] == ".") { $letters = "& (LEFT(name,1) = '.')"; }
$anime_search = "SELECT *
FROM `ac_reviews`
WHERE (`name` LIKE '%$name%')
$genre2
$hq
$lq
$hd
$eng_lang
$jpn_lang
$content2
$complete
$dont_show
$letters
ORDER BY $order";
?>
ANIME TRAILERS
Welcome to the animecrave reviews section. Check out what professional anime watchers have to say about that anime you are thinking about watching or even anime that you have seen. Don't see the review you want then feel free to request it and or even submit your own if you want!
function add_stars($rating) {
switch ($rating)
{
case 10: $stars = "http://www.animecrave.com/_content/images/STARS/5Stars.png"; break;
case 9: $stars = "http://www.animecrave.com/_content/images/STARS/4_5Stars.png"; break;
case 8: $stars = "http://www.animecrave.com/_content/images/STARS/4Stars.png"; break;
case 7: $stars = "http://www.animecrave.com/_content/images/STARS/3_5Stars.png"; break;
case 6: $stars = "http://www.animecrave.com/_content/images/STARS/3Stars.png"; break;
case 5: $stars = "http://www.animecrave.com/_content/images/STARS/2_5Stars.png"; break;
case 4: $stars = "http://www.animecrave.com/_content/images/STARS/2Stars.png"; break;
case 3: $stars = "http://www.animecrave.com/_content/images/STARS/1_5Stars.png"; break;
case 2: $stars = "http://www.animecrave.com/_content/images/STARS/1Stars.png"; break;
case 1: $stars = "http://www.animecrave.com/_content/images/STARS/_55tars.png"; break;
case 0: $stars = "http://www.animecrave.com/_content/images/STARS/0Stars.png"; break;
} return $stars;}
$result_search = $Db->query($anime_search);
while ($data = mysql_fetch_array($result_search,MYSQL_ASSOC)) {
echo "
![\"$data[name]\"](\"http://www.animecrave.com/_SITE/IMAGES/info/overlay.png\") |
Review By: animecrave.com
Posted on: $data[date]
|
\n";
}
?>