Id)){ $dont_show = ""; } if(!isset($_POST['title']) && !isset($_GET[lett])) { $letters = "& ((LEFT(title,1) REGEXP '[9]') OR (LEFT(title,1) = '8'))"; } 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 `ac_anime`.*, ac_anime.id AS a_id, (SELECT AVG( user_rating.rating ) FROM user_rating WHERE user_rating.page_id = a_id) AS rate FROM `ac_anime` WHERE (`title` LIKE '%$title%') AND (`type` $pleasework) $genre2 $hq $lq $hd $eng_lang $jpn_lang $content2 $mobiles $complete $dont_show $letters $ttype ORDER BY $order"; ?> query($anime_search); while ($data = mysql_fetch_array($result_search,MYSQL_ASSOC)) { $rate = round($data[rate], 0); echo "
$data[title]
\"$data[title]\"
AVAILABLE QUALITY GENRE
$data[e_online] out of $data[e_total] "; if ($data[hd] == "1" && $data[hq] == "1" && $data[lq] == "1" ) { $qual = "HD | HQ | SD"; } if ($data[hd] == "1" && $data[hq] == "1" && $data[lq] == "0" ) { $qual = "HD | HQ "; } if ($data[hd] == "1" && $data[hq] == "0" && $data[lq] == "1" ) { $qual = "HD | SD "; } if ($data[hd] == "0" && $data[hq] == "1" && $data[lq] == "1" ) { $qual = "HQ | SD "; } if ($data[hd] == "0" && $data[hq] == "1" && $data[lq] == "0" ) { $qual = "HQ"; } if ($data[hd] == "0" && $data[hq] == "0" && $data[lq] == "1" ) { $qual = "SD"; } if ($data[hd] == "1" && $data[hq] == "0" && $data[lq] == "0" ) { $qual = "HD"; } echo "$qual"; echo " $data[genre]
Warnings
$data[content]
Synopsis:
"; } ?>
CAN'T FIND IT?
Request It!