include $_SERVER['DOCUMENT_ROOT'].'/_content/multimedia/anime_oVAs_functions.php'; 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 (`title` LIKE '%$title%') $genre2 $hq $lq $hd $eng_lang $jpn_lang $content2 $complete $dont_show $letters & (`type` = '2') ORDER BY $order"; $anime_dropbox = "SELECT title, page FROM `ac_anime` WHERE `type` = '2' $dont_show ORDER BY title ASC"; ?>