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['title'] != "Search Anime") { $title = nh($_POST['title']); }
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 = "title 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['title']) && !isset($_GET[lett])) { $letters = "& ((LEFT(title,1) REGEXP '[0-z]') OR (LEFT(title,1) = '.'))"; }
if(!isset($_POST['title']) && $_GET[lett] == "a") { $letters = "& (LEFT(title,1) REGEXP '[A]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "b") { $letters = "& (LEFT(title,1) REGEXP '[B]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "c") { $letters = "& (LEFT(title,1) REGEXP '[C]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "d") { $letters = "& (LEFT(title,1) REGEXP '[D]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "e") { $letters = "& (LEFT(title,1) REGEXP '[E]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "f") { $letters = "& (LEFT(title,1) REGEXP '[F]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "g") { $letters = "& (LEFT(title,1) REGEXP '[G]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "h") { $letters = "& (LEFT(title,1) REGEXP '[H]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "i") { $letters = "& (LEFT(title,1) REGEXP '[I]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "j") { $letters = "& (LEFT(title,1) REGEXP '[J]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "k") { $letters = "& (LEFT(title,1) REGEXP '[K]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "l") { $letters = "& (LEFT(title,1) REGEXP '[L]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "m") { $letters = "& (LEFT(title,1) REGEXP '[M]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "n") { $letters = "& (LEFT(title,1) REGEXP '[N]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "o") { $letters = "& (LEFT(title,1) REGEXP '[O]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "p") { $letters = "& (LEFT(title,1) REGEXP '[P]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "q") { $letters = "& (LEFT(title,1) REGEXP '[Q]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "r") { $letters = "& (LEFT(title,1) REGEXP '[R]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "s") { $letters = "& (LEFT(title,1) REGEXP '[S]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "t") { $letters = "& (LEFT(title,1) REGEXP '[T]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "u") { $letters = "& (LEFT(title,1) REGEXP '[U]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "v") { $letters = "& (LEFT(title,1) REGEXP '[V]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "w") { $letters = "& (LEFT(title,1) REGEXP '[W]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "x") { $letters = "& (LEFT(title,1) REGEXP '[X]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "y") { $letters = "& (LEFT(title,1) REGEXP '[Y]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "z") { $letters = "& (LEFT(title,1) REGEXP '[Z]')"; }
if(!isset($_POST['title']) && $_GET[lett] == "0-z") { $letters = "& (LEFT(title,1) REGEXP '[0 - Z]')"; }
if(!isset($_POST['title']) && $_GET[lett] == ".") { $letters = "& (LEFT(title,1) = '.')"; }
$anime_search = "SELECT * FROM `ac_anime` WHERE ( `dist` = 'fall2013' )
$genre2
$hq
$lq
$hd
$eng_lang
$jpn_lang
$content2
$complete
$dont_show
$letters
& (`type` = '5')
ORDER BY $order";
$anime_dropbox = "SELECT title, page
FROM `ac_anime`
WHERE
`type` = '5'
$dont_show
ORDER BY title ASC";
?>
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 "
| "; if ($User->Info['level']==1 or $User->Info['level']=="") echo ""; else echo "[EDIT]"; echo " $data[title]
|
.) |
![\"$data[title]\"](\"http://www.animecrave.com/_SITE/IMAGES/media_pages/image_overlay.png\") |
| AVAILABLE |
|
QUALITY |
|
GENRE |
| $data[e_online] out of $data[e_total] |
|
"; if ($data[hq] == "1" && $data[lq] == "1" ) { $qual = "SD + HQ"; } if ($data[hq] == "1" && $data[lq] == "0" ) { $qual = "HQ"; } if ($data[hq] == "0" && $data[lq] == "1" ) { $qual = "SD"; } echo "$qual"; echo " |
|
$data[genre] |
Synopsis:
|
";
if (!userNotLive()) { echo ""; } else { echo "
"; if ($data[hq] == "1" && $data[lq] == "1" ) { $Whois = "
"; } if ($data[hq] == "1" && $data[lq] == "0" ) { $Whois = "
"; } if ($data[hq] == "0" && $data[lq] == "1" ) { $Whois = "
"; } echo "$Whois";
echo "
"; }
echo "
\n";
}
?>