0)
{
$trow = mysqli_fetch_array($tresult);
}
if ($status == "confirmed")
{
//smart_mysql_query("UPDATE exchangerix_currencies SET total_exchanges=total_exchanges+1 WHERE currency_id='".(int)$trow['from_currency_id']."' LIMIT 1");
smart_mysql_query("UPDATE exchangerix_exdirections SET today_exchanges=today_exchanges+1, total_exchanges=total_exchanges+1, last_exchange_date=NOW() WHERE exdirection_id='".(int)$trow['exchange_id']."' LIMIT 1");
//smart_mysql_query("UPDATE exchangerix_settings SET setting_value='' WHERE setting_key='total_exchanges_usd' LIMIT 1");
//dev
}elseif ($status == "declined" || $status == "cancelled")
{
// update reserve
smart_mysql_query("UPDATE exchangerix_currencies SET reserve+='".floatval($trow['receive_amount'])."', status='pending' WHERE currency_id='".(int)$trow['to_currency']."' LIMIT 1");
}
smart_mysql_query("UPDATE exchangerix_exchanges SET status='$status', updated=NOW(), process_date=NOW() WHERE exchange_id='$exchange_id' LIMIT 1");
}
if ($send_notification == 1)
{
//////////////////////////////// Send notification ////////////////////////
if ($status == "paid")
{
$etemplate = GetEmailTemplate('payment_success');
}
elseif ($status == "declined")
{
$etemplate = GetEmailTemplate('payment_declined');
}
$esubject = $etemplate['email_subject'];
$emessage = $etemplate['email_message'];
$emessage = str_replace("{transaction_id}", $trow['reference_id'], $emessage);
$emessage = str_replace("{first_name}", $urow['fname'], $emessage);
$emessage = str_replace("{commission}", DisplayMoney($trow['transaction_commision']), $emessage);
if ($trow['transaction_commision'] != "0.0000")
$amount = $trow['amount']-$trow['transaction_commision'];
else
$amount = $trow['amount'];
$emessage = str_replace("{amount}", DisplayMoney($amount), $emessage);
$emessage = str_replace("{reason}", $reason, $emessage);
$to_email = $urow['fname'].' '.$urow['lname'].' <'.$urow['email'].'>';
SendEmail($to_email, $esubject, $emessage, $noreply_mail = 1);
}
header("Location: exchanges.php?msg=updated");
exit();
}
if (isset($_GET['id']) && is_numeric($_GET['id']))
{
$id = (int)$_GET['id'];
$query = "SELECT *, DATE_FORMAT(created, '".DATE_FORMAT." %h:%i %p') AS payment_date, DATE_FORMAT(updated, '".DATE_FORMAT." %h:%i %p') AS updated_date, DATE_FORMAT(process_date, '".DATE_FORMAT." %h:%i %p') AS processed_date FROM exchangerix_exchanges WHERE exchange_id='$id' LIMIT 1";
$result = smart_mysql_query($query);
$total = mysqli_num_rows($result);
}
$title = "Exchange Details";
require_once ("inc/header.inc.php");
?>
0) {
$row = mysqli_fetch_array($result);
$send_row = mysqli_fetch_array(smart_mysql_query("SELECT * FROM exchangerix_currencies WHERE currency_id='".(int)$row['from_currency_id']."' LIMIT 1"));
$receive_row = mysqli_fetch_array(smart_mysql_query("SELECT * FROM exchangerix_currencies WHERE currency_id='".(int)$row['to_currency_id']."' LIMIT 1"));
?>
Exchange Details #
| ID: |
|
| Reference ID: |
|
0) { ?>
| Member: |
|
| Exchanges: |
|
| User: |
Visitor |
| Country: |
 |
0) { ?>
| Referral ID: |
|
| Comment: |
|
| Created: |
|
| Updated: |
|
| Process Date: |
|
| Status: |
confirmed"; break;
case "pending": echo "awaiting confirmation"; break;
case "waiting": echo "waiting for payment"; break;
case "declined": echo " declined"; break;
case "failed": echo "failed"; break;
case "cancelled": echo " cancelled"; break;
case "timeout": echo " timeout"; break;
case "request": echo "awaiting approval"; break;
case "paid": echo "paid"; break;
default: echo "".$row['status'].""; break;
}
?>
|
Proceed Exchange
Edit Exchange
Go Back
Delete
Exchange Details
Sorry, no exchange found.