<?

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` = 'spring2012'  )

$genre2

$hq 

$rating

$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";

?>



            <div id="content3P">
                <div class="Box">
                    <div class="Title">
                        <strong>SPRING 2012 ANIME</strong>
                    </div>
                    <div class="Body">
                        <img src="http://www.animecrave.com/images/fansubs/spring2012/SPRING.jpg" width="796" height="250" />
                    </div>
                </div>
            </div>  
        
        
        <div id="ABC">
			<div class="Box">
                <div class="Title">

            	</div>
                <div class="Body">
                    <?
                                
                    echo "
                    
                    <table class=\"ABCMENU\" width=\"100%\" border=\"0\">
                      <tr>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=0-Z'\"><strong>All</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=.'\"><strong>#</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=a'\"><strong>A</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=b'\"><strong>B</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=c'\"><strong>C</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=d'\"><strong>D</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=e'\"><strong>E</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=f'\"><strong>F</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=g'\"><strong>G</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=h'\"><strong>H</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=i'\"><strong>I</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=j'\"><strong>J</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=k'\"><strong>K</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=l'\"><strong>L</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=m'\"><strong>M</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=n'\"><strong>N</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=o'\"><strong>O</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=p'\"><strong>P</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=q'\"><strong>Q</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=r'\"><strong>R</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=s'\"><strong>S</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=t'\"><strong>T</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=u'\"><strong>U</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=v'\"><strong>V</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=w'\"><strong>W</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=x'\"><strong>X</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=y'\"><strong>Y</strong></td>
                    
                    <td valign=\"middle\" align=\"center\" onclick=\"window.location.href='?page=multimedia/spring_2012&lett=z'\"><strong>Z</strong></td>
                    
                      </tr>
                    </table>";
                    
                    ?>
                </div>
			</div>
		</div>        






<?

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 "
		<div id=\"content3\">
            <div class=\"Box\">
                <div class=\"Title\">
                    
                    <table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\">
                        <tr>
                            <td width=\"90%\"><a href=\"http://www.animecrave.com/index.php?page=$data[page]\" class=\"url_white_3B\"><strong>$data[title]</strong></a>
                            
                            </td>
                            <td width=\"10%\"><img src=".add_stars($data[rating])."></td>
                        </tr>
                    </table>
            	</div>
                <div class=\"Body\">
				
                
                <table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\">
                  <tr>
    				<td width=\"10%\" valign=\"top\"><a href=\"http://www.animecrave.com/index.php?page=$data[page]\"><img style=\"background-image:url('$data[image]');\" src=\"http://www.animecrave.com/_SITE/IMAGES/media_pages/image_overlay.png\" border=\"0\" width=\"210\" height=\"96\" alt=\"$data[title]\" ></a></td>
                    <td width=\"90%\" valign=\"top\">
                        <strong>Synopsis:</strong><br />$data[desc_p1] <a href=\"http://www.animecrave.com/index.php?page=$data[page]\"><strong>Read More...</strong></a><br />
                    </td>
                  </tr>
                </table>

                    



                </div>
            </div>
		</div>
\n";
}
?>