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;
DeletePayment($pid);
}
header("Location: user_payments.php?id=$uid&msg=deleted");
exit();
}
}
$where = " 1=1 AND ";
if (isset($_GET['id']) && is_numeric($_GET['id']))
{
////////////////// filter //////////////////////
if (isset($_GET['column']) && $_GET['column'] != "")
{
switch ($_GET['column'])
{
case "created": $rrorder = "created"; break;
case "transaction_id": $rrorder = "transaction_id"; break;
case "reference_id": $rrorder = "reference_id"; break;
case "payment_type": $rrorder = "payment_type"; break;
case "amount": $rrorder = "amount"; break;
case "status": $rrorder = "status"; break;
default: $rrorder = "added"; break;
}
}
else
{
$rrorder = "created";
}
if (isset($_GET['order']) && $_GET['order'] != "")
{
switch ($_GET['order'])
{
case "asc": $rorder = "asc"; break;
case "desc": $rorder = "desc"; break;
default: $rorder = "desc"; break;
}
}
else
{
$rorder = "desc";
}
if (isset($_GET['filter']) && $_GET['filter'] != "")
{
$filter = mysqli_real_escape_string($conn, trim(getGetParameter('filter')));
$where .= " (reference_id='$filter') AND ";
}
if (isset($_GET['only_exchanges']) && $_GET['only_exchanges'] == 1)
{
$where .= " payment_type='exchange' AND ";
}
///////////////////////////////////////////////////////
if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; }
$from = ($page-1)*$results_per_page;
$uid = (int)$_GET['id'];
$query = "SELECT *, DATE_FORMAT(created, '".DATE_FORMAT." %h:%i %p') AS date_created FROM exchangerix_exchanges WHERE $where user_id='$uid' 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_exchanges WHERE $where user_id='$uid'";
$result2 = smart_mysql_query($query2);
$total = mysqli_num_rows($result2);
$cash_row = mysqli_fetch_array(smart_mysql_query("SELECT SUM(receive_amount) AS total FROM exchangerix_exchanges WHERE $where user_id='".(int)$uid."' AND status='confirmed' OR status='pending'"));
$title2 = GetUsername($uid);
}
$title = $title2." Payment History";
require_once ("inc/header.inc.php");
?>
Account Balance:
- Payment History
0) { $total_amount = 0; ?>
There are no exchanges at this time.