0)
$results_per_page = (int)$_GET['show'];
else
$results_per_page = 15;
// Delete payments //
if (isset($_POST['delete']) && $_POST['delete'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$pid = (int)$v;
smart_mysql_query("DELETE FROM exchangerix_reserve_requests WHERE reserve_request_id='$pid'");
}
header("Location: reserve_requests.php?msg=deleted");
exit();
}
}
////////////////// filter //////////////////////
if (isset($_GET['column']) && $_GET['column'] != "")
{
switch ($_GET['column'])
{
case "username": $rrorder = "user_id"; break;
case "amount": $rrorder = "amount"; break;
case "currency": $rrorder = "currency_name"; break;
case "exdirection": $rrorder = "exdirection_id"; break;
default: $rrorder = "reserve_request_id"; break;
}
}
else
{
$rrorder = "reserve_request_id";
}
if (isset($_GET['order']) && $_GET['order'] != "")
{
switch ($_GET['order'])
{
case "asc": $rorder = "asc"; break;
case "desc": $rorder = "desc"; break;
default: $rorder = "asc"; break;
}
}
else
{
$rorder = "desc";
}
///////////////////////////////////////////////////////
if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; }
$from = ($page-1)*$results_per_page;
$query = "SELECT *, DATE_FORMAT(added, '".DATE_FORMAT."
%h:%i %p') AS date_created FROM exchangerix_reserve_requests ORDER BY $rrorder $rorder LIMIT $from, $results_per_page";
$result = smart_mysql_query($query);
$total_on_page = mysqli_num_rows($result);
$query2 = "SELECT * FROM exchangerix_reserve_requests";
$result2 = smart_mysql_query($query2);
$total = mysqli_num_rows($result2);
$cc = 0;
$title = "Reserve Amount Requests";
require_once ("inc/header.inc.php");
?>