<?

$protocol = strpos(strtolower($_SERVER['SERVER_PROTOCOL']),'https') 

                === FALSE ? 'http' : 'https';

$host     = $_SERVER['HTTP_HOST'];

$script   = $_SERVER['SCRIPT_NAME'];

$params   = $_SERVER['QUERY_STRING'];

 
$currentUrl = $protocol . '://' . $host . $script . '?' . $params;


//Users Live Status

if(userNotLive()) { $live_num = "(votes_live)+0"; } else { $live_num = "(votes_live)+1"; } 

$u_id = $plus->quote($User->Id);

function full_url()
{
    $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : "";
    $protocol = substr(strtolower($_SERVER["SERVER_PROTOCOL"]), 0, strpos(strtolower($_SERVER["SERVER_PROTOCOL"]), "/")) . $s;
    $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]);
    return $protocol . "://" . $_SERVER['SERVER_NAME'] . $port . $_SERVER['REQUEST_URI'];
}
$actual_link = full_url();


//update request status

if(!empty($User->Id)) {

if(isset($_POST['fill'])) {

$fill_request = $Db->query("UPDATE user_request SET `status` = '1', `date_filled` = '" .time(). "', `url` = '".$plus->quote($_POST[url])."' WHERE id = '".$plus->quote($_POST[id])."' LIMIT 1");

//email_request(#);

include "/home/ac/public_html/email.php";

//include "/home/ac/public_html/add_alert.php";

# addAlertRequested($_POST['id']);


@header("location:$currentUrl");

}


//+1 vote for request

if(isset($_POST['request'])) {

$u_id = $plus->quote($User->Id);

if(userNotLive()) {

$fill_request = $Db->query("UPDATE user_request SET votes = concat(votes,'|{$u_id}|'), votes_num=(votes_num)+1 WHERE id = '".$plus->quote($_POST[id])."' LIMIT 1");

} else { 

$fill_request = $Db->query("UPDATE user_request SET votes = concat(votes,'|{$u_id}|'), votes_num=(votes_num)+1, votes_live=(votes_live)+1 WHERE id = '".$plus->quote($_POST[id])."' LIMIT 1");

} 

/*** Kailash code start here  ****/

add_point_to_users($User->Id, 'Request Anime');

/*** Kailash code end here   ****/


@header("location:$currentUrl");


}


//Update Request Note

if(isset($_POST['note'])) {

$note = $plus->quote($_POST['note']);

$fill_request = $Db->query("UPDATE user_request SET note = '{$note}' WHERE id = '".$plus->quote($_POST[id])."' LIMIT 1");


@header("location:$currentUrl");

}


//Delete Request

if(isset($_POST['delete_id'])) {

$delete_id = $plus->quote($_POST['delete_id']);

$fill_request = $Db->query("DELETE FROM `user_request` WHERE `user_request`.`id` = '{$delete_id}' LIMIT 1");


@header("location:$currentUrl");

}


if(isset($_POST['irequest']) && isset($_POST[title]) && isset($_POST[group1])) { if(userNotLive()) { $live_num = 0; }  else { $live_num = 1; }


$if_onac = $Db->query("SELECT id FROM ac_animecrave.ac_anime WHERE title='".$plus->quote($_POST[title])."' AND 	type='".$plus->quote($_POST[group1])."'  LIMIT 1");

if (mysql_num_rows($if_onac) > 0) { 

$note = "The media you requested is already available on Anime Crave.";

$cancel = "1";

}


$if_requested = $Db->query("SELECT id FROM ac_animecrave.user_request WHERE name='".$plus->quote($_POST[title])."' AND 	type='".$plus->quote($_POST[group1])."'  LIMIT 1");

if (mysql_num_rows($if_requested) > 0) { 

$note = "The media you requested has already been requested.  Your request was added to it's total amount of votes. To increase its chances of being added please promote it on forums & chat!";

$cancel = "2";

}


if(!isset($cancel)) {

$add_request = $Db->query("INSERT INTO user_request (name, date, type, user_id, votes, votes_num, votes_live) VALUES ('".$plus->quote($_POST[title])."', '" .time(). "', '".$plus->quote($_POST[group1])."', '".$plus->quote($User->Id)."', '|".$plus->quote($User->Id)."|', '1', '{$live_num}')");

$note = "The request has been added, to increase its chances of being added please promote it on forums & chat!";

}


if($cancel == "2") {

$fill_request = $Db->query("UPDATE user_request SET votes = concat(votes,'|{$u_id}|'), votes_num=(votes_num)+1, votes_live=(votes_live)+$live_num WHERE name = '".$plus->quote($_POST[title])."' AND votes NOT LIKE '%|$u_id|%' LIMIT 1");

}

}

}


switch ($_GET['or'])

{

case 0: $orderby = "votes_num DESC"; break;

case 1: $orderby = "votes_num ASC"; break;

case 2: $orderby = "name DESC"; break;

case 3: $orderby = "name ASC"; break;

case 4: $orderby = "date DESC"; break;

case 5: $orderby = "date ASC"; break;

default: $orderby = "name ASC";

}


if($_GET['or'] == 0) { $voteor = "?page=anime_request_fansubs&or=1"; } else { $voteor = "?page=anime_request_fansubs&or=0"; }

if($_GET['or'] == 2) { $nameor = "?page=anime_request_fansubs&or=3"; } else { $nameor = "?page=anime_request_fansubs&or=2"; }

if($_GET['or'] == 4) { $dateor = "?page=anime_request_fansubs&or=5"; } else { $dateor = "?page=anime_request_fansubs&or=4"; }


?>


<div align="center"><img src="http://animecrave.com/images/request/main_fansubs.png" /></div>


		<div id="request">
    		<div class="Box">
        		<div class="Title_B">

                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td><strong>ANIME FANSUBS</strong></td>
                    <td class="TitleSelectionNAV" onclick="location.href='http://www.animecrave.com/index.php?page=anime_request'"> <a href="http://www.animecrave.com/index.php?page=anime_request"><strong style=" color:#FFFFFF;">Back to All Requests</strong></a></td>
                  </tr>
                </table>
    
                    
        		</div>
                
        		<div class="Body">

                    <table bgcolor="#3b3630" width="100%" border="0" cellspacing="0" cellpadding="10">
                      <tr>
                        <td width="35%" class="REQ_CATS" onclick="location.href='<?=$nameor?>'">Sort By<br /> <strong>TITLE</strong></td>
                        <td width="12%"><strong>TYPE</strong></td>
                        <td width="13%" class="REQ_CATS" onclick="location.href='<?=$dateor?>'">Sort by<br /><strong>DATE</strong></td>
                        <td width="20%" class="REQ_CATS" onclick="location.href='<?=$voteor?>'">Sort By<br /><strong># of REQUESTS</strong></td>
                        <td width="20%"><strong>AVAILABILITY</strong></td>
                      </tr>
                    </table>

                    <?
                    
                    $cpage = $_GET['cpage']; 
                    $limit = 20; 
                    if (!($cpage)){ 
                    $cpage = 0;} // Default page value. 
                    $numresults = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '5'"); 
                    $numrows = mysql_num_rows($numresults);  
                     
                    $pages = intval($numrows/$limit);  
                     
                    if ($numrows%$limit) {$pages++;}  
                    $current = ($cpage/$limit) + 1;  
                    if (($pages < 1) || ($pages == 0)) { 
                    $total = 1;}  
                    else { 
                    $total = $pages; }  
                    $first = $cpage + 1; 
                    if (!((($cpage + $limit) / $limit) >= $pages) && $pages != 1) { 
                    $last = $cpage + $limit; }  
                    else{ $last = $numrows; }  
                    
                    $result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '5' ORDER BY {$orderby} LIMIT $cpage, $limit"); 
                    
                    while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 
                    
                    echo "
                    
                    <div class=\"REQ_INDV\">
                    
                    <table width=\"100%\" style=\"padding:5px 5px 0 5px;  \">
                    
                    <tr>
                    
                    <td width=\"35%\"><strong>".$data['name']."</strong></td>
                    
                    ";
                    
                    switch ($data['type'])
                    
                    {
                    
                    case 1: $type = "Series"; break;
                    
                    case 2: $type = "OVA"; break;
                    
                    case 3: $type = "Movie"; break;
                    
                    case 4: $type = "Live Action"; break;
                    
                    case 5: $type = "Fansub"; break;
                    
                    case 7: $type = "mp3s"; break;
                    
                    }
                    
                    echo "
                    
                    <td width=\"12%\"><strong>{$type}</strong></td>
                    
                    <td width=\"13%\"><strong>".date('m.d.y', $data[date])."</strong></td>
                    
                    ";
                    
                    $votes_array = explode("|", $data['votes']);
                    
                    $votes = count($votes_array);
                    
                    echo "
                    
                    <td width=\"20%\"><strong>{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</strong></td>
                    
                    <td width=\"20%\">
                    
                    <form name=\"form1\" method=\"post\" action=\"\">
                    
                    ";
                    
                    if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {
                    
                    echo "<form method=\"POST\" action=\"$actual_link\">"; 
                    
                    echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";
                    
                    echo "<input type=\"Submit\" class=\"BUTTON_REQ\" name=\"request\" value=\"\"></form>";
                    
                    } else { echo "<img src=\"http://www.animecrave.com/_SITE/IMAGES/req_0.jpg\" width=\"126\" height=\"23\" alt=\"NOT ALLOWED\" />";
                    
                    }
                    
                    echo "
                    
                    </td> </tr> </table>
                    
                    ";
                    
                    echo "
                    
                    <table width=\"100%\" style=\"border-bottom:1px; border-bottom-style:solid; border-bottom-color:#666; padding:0 5px 5px 5px; \">
                    
                    <tr>
                    
                    <td width=\"5%\"></td>";
                    
                    if($User->Info['level'] > 1) { 
                    
                    echo "<td width=\"35%\">
                    
                    <form method=\"POST\" action=\"$actual_link\">
                    
                    <input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">
                    
                    <input type=\"text\" size=\"40\" class=\"BUTTON_INPUT\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\">
                    
                    </td>
                    
                    <td width=\"10%\"><input type=\"Submit\" class=\"BUTTON_UPDATE\" name=\"submit\" value=\"\"></form></td>";
                    
                    } elseif(!empty($data['note'])) {
                    
                    echo "<td width=\"95%\"><strong>NOTES:</strong> {$data['note']}</td>";
                    
                    }
                    
                    if($User->Info['level'] > 1) { 
                    
                    echo "<script type=\"text/javascript\">
                function v{$data['id']}( )
                {
                var x=document.forms[\"fill{$data['id']}\"][\"textfield\"].value
                if (x==null || x==\"\")
                  {
                  alert(\"Field cannot be empty\");
                  return false;
                  }
			    
                }
                </script><td width=\"10%\">
                    
                    <form method=\"POST\" action=\"$actual_link\" id=\"fill{$data['id']}\" onsubmit=\"return v{$data['id']}( );\">
                    
                    <input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">
                    
                    <input type=\"text\" size=\"20\" class=\"BUTTON_INPUT\" name=\"url\" value=\"\" id=\"textfield\">
                    
                    </td>
                    
                    <td width=\"1%\">
                    
                    <input type=\"Submit\" class=\"BUTTON_FILL\" name=\"fill\" value=\"\">
                    
                    </form>
                    </td>
                    
                    <td width=\"1%\">
                    
                    <form method=\"POST\" action=\"$actual_link\">
                    
                    <input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">
                    
                    <input type=\"Submit\" class=\"BUTTON_DEL\" name=\"delete\" value=\"\">
                    
                    </form>
                    
                    </td>
                    
                    
                    <td width=\"28%\"></td>
                    
                    
                    ";
                    
                    } else {
                    
                    echo "";
                    
                    }
                    
                    echo "
                    
                    </tr></table></div>";
                    
                    }
                    
                    echo "<br /><br /><div align=\"center\">";
                    
                    
                    if ($cpage != 0) { 
                    
                    $back_page = $cpage - $limit;
                    
                    echo("<a href=\"http://www.animecrave.com/index.php?page=anime_request_fansubs&cpage={$back_page}&or={$_GET['or']}\"><strong class=\"REQ_PAGE\"> &nbsp;PREVIOUS&nbsp; </strong></a>\n");}
                    
                    
                    for ($i=1; $i <= $pages; $i++)  {
                    
                    $ppage = $limit*($i - 1);
                    
                    if ($ppage == $cpage AND $total > 1){  echo("<strong class=\"REQ_PAGE_SELECT\">&nbsp;$i&nbsp;</strong> \n"); } 
                    
                    else{  echo("<a href=\"http://www.animecrave.com/index.php?page=anime_request_fansubs&cpage={$ppage}&or={$_GET['or']}\"><strong class=\"REQ_PAGE\"> &nbsp;$i&nbsp; </strong></a> \n"); }
                    
                    }
                    
                    if (!((($cpage+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
                    
                    $next_page = $cpage + $limit;
                    
                    echo("<a href=\"http://www.animecrave.com/index.php?page=anime_request_fansubs&cpage={$next_page}&or={$_GET['or']}\"><strong class=\"REQ_PAGE\"> &nbsp;NEXT&nbsp; </strong></a>\n"); }
                    echo "<br></div>";

     
                    ?>

        		</div>

    		</div>
		</div>