<?


if(!isset($_POST[submit_search])) {
//Users Live Status

if(userNotLive()) { $live_num = "(votes_live)+0"; } else { $live_num = "(votes_live)+1"; } 

$u_id = $plus->quote($User->Id);



//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: http://animecrave.com/index.php?page=request');

}



//+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])."' AND votes NOT LIKE '%|$u_id|%' LIMIT 1");

$note = "Your request was added to it's total amount of votes. To increase its chances of being added please promote it on forums & chat!";

} 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])."' AND votes NOT LIKE '%|$u_id|%' LIMIT 1");

$note = "Your request was added to it's total amount of votes. To increase its chances of being added please promote it on forums & chat!";

} 





@header('Location: http://animecrave.com/index.php?page=request');

}



//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: http://animecrave.com/index.php?page=request');

}



//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: http://animecrave.com/index.php?page=request');

}



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=request&or=1"; } else { $voteor = "?page=request&or=0"; }

if($_GET['or'] == 2) { $nameor = "?page=request&or=3"; } else { $nameor = "?page=request&or=2"; }

if($_GET['or'] == 4) { $dateor = "?page=request&or=5"; } else { $dateor = "?page=request&or=4"; }

if(!empty($User->Id)) { 

$theme = explode(",", $User->Info['theme']);

$color1="#{$theme[1]}";

 }
 
//include "/home/ac/public_html/_content/equest.php";
 ?>

hi

<br>


<? if(!empty($User->Id)) { ?>

<?
echo " 

<form  method=\"POST\" action=\"http://animecrave.com/index.php?page=request\"> 

<input type=\"hidden\" value=\"3\" name=\"irequest\">

<input name=\"group1\" type=\"radio\" value=\"1\" checked> anime eps

<input name=\"group1\" type=\"radio\" value=\"2\">ova

<input name=\"group1\" type=\"radio\" value=\"3\">movies

<input name=\"group1\" type=\"radio\" value=\"4\">live

<input name=\"group1\" type=\"radio\" value=\"5\">fansubs

<input name=\"group1\" type=\"radio\" value=\"7\">music

<input type=\"text\" name=\"title\" id=\"textfield\" class=\"FORM_03\">

<input type=\"submit\" name=\"submit_search\" value=\"Search\" class=\"FORM_03\">

<input type=\"submit\" name=\"submit\" value=\"Request it!\" class=\"FORM_03\">

</form>";

}



if(!isset($_POST[submit_search])) {
?>






<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG1.png" valign="middle" class="text_white_2">&nbsp;&nbsp;Anime Series</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '1' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</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 bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</label></td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_series\">View All Series Request</a></tbody></table>";

echo "</tbody></table><br>";

?>










<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG3.png" valign="middle" class="text_white_2">&nbsp;&nbsp;Anime OVA's</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '2' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</td>";

switch ($data['type'])

{

case 0: $type = "Series"; break;

case 1: $type = "Movie"; break;

case 2: $type = "OVA"; break;

case 3: $type = "Live Action"; break;

case 4: $type = "Fansub"; break;

case 5: $type = "mp3s"; break;
}

echo "<td bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</label></td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_ovas\">View All OVAs Request</a></tbody></table>";

echo "</tbody></table><br>";

?>









<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG2.png" valign="middle" class="text_white_2">&nbsp;&nbsp;Anime Movies</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '3' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</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 bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_movies\">View All Movies Request</a></tbody></table>";
echo "</tbody></table><br>";

?>



<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG4.png" valign="middle" class="text_white_2">&nbsp;&nbsp;Live Action</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '4' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</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 bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</label></td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_live_action\">View All Live Action Request</a></tbody></table>";

echo "</tbody></table><br>";

?>






<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG5.png" valign="middle" class="text_white_2">&nbsp;&nbsp;Anime Fansubs</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '5' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</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 bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</label></td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_fansubs\">View All Fansub Request</a></tbody></table>";

echo "</tbody></table><br>";

?>




<table width="100%" border="0" cellspacing="0" cellpadding="10">

<tr>

<td bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="67" background="http://animecrave.com/images/request/BG6.png" valign="middle" class="text_white_2">&nbsp;&nbsp;MP3's</td>
</tr>
</table>

<table width="100%" border="0" cellspacing="1" cellpadding="5">

  <tr>

  <td width="30%" bgcolor="#d4dcdf"><a href="<?=$nameor?>">Anime:</a></td>

  <td width="10%" bgcolor="#d4dcdf">Type:</td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$dateor?>">Requested on:</a></td>

  <td width="20%" bgcolor="#d4dcdf"><a href="<?=$voteor?>"># of Requests:</a></td>

  <td width="20%" bgcolor="#d4dcdf">&nbsp;</td>

  </tr>

<?

$result_request = $Db->query("SELECT * FROM user_request WHERE status = '0' AND type = '7' ORDER BY {$orderby} LIMIT 10"); 

while ($data = mysql_fetch_array($result_request, MYSQL_ASSOC)) { 

echo "

  <tr>

  <td bgcolor=\"#f2f5f6\">".$data['name']."</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 bgcolor=\"#f2f5f6\">{$type}</td>

<td bgcolor=\"#f2f5f6\">".date('m.d.y', $data[date])."</td>";

$votes_array = explode("|", $data['votes']);

$votes = count($votes_array);

echo "<td bgcolor=\"#f2f5f6\">{$data['votes_num']} "; if($User->Info['level'] > 1) { echo "(L: {$data['votes_live']})"; } echo "</td>

<td bgcolor=\"#f2f5f6\">

<form name=\"form1\" method=\"post\" action=\"\">

<label>";

if(!in_array("$User->Id", $votes_array) && !empty($User->Id)) {

echo "<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">"; 

echo "<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">";

echo "<input type=\"Submit\" name=\"request\" value=\"Request Also\"></form>";
} else { echo "<center>Already Requested!</center>";
}

echo "</label></td></tr>";

echo "<tr>";

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"note\" value=\"{$data['note']}\" id=\"textfield\"></td>

<td><input type=\"Submit\" name=\"submit\" value=\"Update Note\"></form>

</td>";

} elseif(!empty($data['note'])) {

echo "<td colspan=\"2\">{$data['note']}</td>";

}

if($User->Info['level'] > 1) { 

echo "<td>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"id\">

<input type=\"text\" name=\"url\" value=\"\" id=\"textfield\">

<input type=\"Submit\" name=\"fill\" value=\"Filled\"></form>

<form method=\"POST\" action=\"http://animecrave.com/index.php?page=request\">

<input type=\"hidden\" value=\"{$data['id']}\" name=\"delete_id\">

<input type=\"Submit\" name=\"delete\" value=\"Delete\"></form>

</td>";

} else {

echo "<td></td>";

}

echo "<td></td>

<td></td>

</tr>";


}

echo "<tr><td colspan=\"5\"><center><a href=\"http://animecrave.com/index.php?page=request_mp3s\">View All Series MP3's</a></tbody></table>";
echo "</tbody></table><br>";
} else { include "/home/ac/public_html/_content/sreq.shtml"; }
?>

</table>

</table>