# Confirm the reversal
if (empty($Confirm)) {
$DetailsLookup = mysql_query("SELECT * FROM transactions WHERE TransactionID = '{$TransactionID}' AND Amount < 0 AND Description != 'Transaction Fee'");
$Details = mysql_fetch_array($DetailsLookup);
$BuyerLookup = mysql_query("SELECT AccountName FROM account WHERE AccountID = {$Details['AccountID']}");
$Buyer = mysql_result($BuyerLookup, 0, 'AccountName');
$SellerLookup = mysql_query("SELECT AccountName FROM account WHERE AccountID = {$Details['OtherAccountID']}");
$Seller = mysql_result($SellerLookup, 0, 'AccountName');
include "header.php";
print "<h2>Trade Reversal</h2>\r\nPlease confirm the following details:<p>\r\n<table noborder>\r\n<tr class=Banner><th colspan=2>Reverse Transaction #{$TransactionID}</th></tr>\r\n<tr><th class=Data>Buyer Account:</th><td>{$Details['AccountID']} ({$Buyer})</td></tr>\r\n<tr><th class=Data>Seller Account:</th><td>{$Details['OtherAccountID']} ({$Seller})</td></tr>\r\n<tr><th class=Data>Description:</th><td>{$Details['Description']}</td></tr>\r\n<tr><th class=Data>Amount:</th><td>{$Details['Amount']}</td></tr>\r\n<tr><td colspan=2> </td></tr>\r\n<tr><td colspan=2 align=center><form action=tradereversal.php method=post>\r\n<input type=hidden name=TransactionID value={$TransactionID}>\r\n<input type=hidden name=Confirm value=1>\r\n<input type=submit value='Confirm Reversal'>\r\n</form></td></tr>\r\n</table>";
include "footer.php";
exit;
}
# Get a TransactionID for the Reversal
include "verifytrade.php";
$TransID = TransID($MemberID);
# Process the reversal
$TransLookup = mysql_query("SELECT * FROM transactions WHERE TransactionID = {$TransactionID} ORDER BY ABS(Amount) DESC");
while ($Trans = mysql_fetch_array($TransLookup)) {
$BalanceLookup = mysql_query("SELECT CurrentBalance FROM transactions WHERE AccountID={$Trans['AccountID']} ORDER BY Reference DESC LIMIT 1");
$Balance = mysql_result($BalanceLookup, 0, 'CurrentBalance');
$NewBalance = $Balance - $Trans[Amount];
$Date = date("Y-m-d");
if ($Trans["Description"] == 'Transaction Fee') {
$Description = "Transaction {$TransactionID} fee reversal";
} else {
$Description = "Reversal of Transaction {$TransactionID}";
}
if ($Trans["Amount"] < 0) {
$type = 'credit';
} else {
include "footer.php";
exit;
} else {
mysql_query("UPDATE member\n SET PriorLogin=1\n WHERE LoginID = '{$LoginID}'\n AND Password = '******'");
}
} elseif ($ApproveFee == 'Yes') {
$FeeLookup = mysql_query("SELECT SetupFee FROM administration");
$Fee = mysql_result($FeeLookup, 0);
$lookupbalance = mysql_query("SELECT CurrentBalance\n FROM transactions\n WHERE AccountID = '{$ChargeTo}'\n ORDER BY Reference DESC\n LIMIT 1");
$balance = mysql_result($lookupbalance, 0);
$balance = $balance - $Fee;
$systembalance = mysql_query("SELECT CurrentBalance\n FROM transactions\n WHERE AccountID = '{$SystemAccountID}'\n\n ORDER BY Reference DESC\n LIMIT 1");
$system = mysql_result($systembalance, 0);
$system = $system + $Fee;
$Date = date("Y-m-d");
$FeeID = TransID($currentRow[0]);
mysql_query("INSERT INTO transactions\n SET TransactionID = '{$FeeID}',\n\t\t\t\t\t TradeDate = '{$Date}',\n\t\t\t\t\t AccountID = '{$ChargeTo}',\n\t\t\t\t\t Amount = '-{$Fee}',\n\t\t\t\t\t Description = 'Online Account Set-up',\n\t\t\t\t\t CurrentBalance = '{$balance}',\n\t\t\t\t\t OtherAccountID = '{$SystemAccountID}'");
print mysql_error();
mysql_query("INSERT INTO transactions\n SET TransactionID = '{$FeeID}',\n\t\t\t\t\t TradeDate = '{$Date}',\n\t\t\t\t\t AccountID = '{$SystemAccountID}',\n\t\t\t\t\t Amount = '{$Fee}',\n\t\t\t\t\t Description = 'Online Account Set-up',\n\t\t\t\t\t CurrentBalance = '{$system}',\n\t\t\t\t\t OtherAccountID = '{$ChargeTo}'");
mysql_query("UPDATE member\n SET PriorLogin=1\n WHERE LoginID = '{$LoginID}'\n AND Password = '******'");
} else {
$title = "Unable to Login";
include "header.php";
print "<strong>Sorry</strong>,<p>use of the online web system requires payment of the system set-up fee.\n <p>You may continue to use the system as a guest, or if you choose to register your login and password, select \"Member Login\" and choose \"Yes\" when asked if you consent to having your account debited.";
include "footer.php";
exit;
}
}
SetCookie("MemberID", $currentRow[0], time() + 3600);
$MemberID = $currentRow[0];
SetCookie("MemberFirstName", $currentRow[1], time() + 3600);
case 'Individual':
$Type = 2;
}
$Renewal = date('Y') + 1;
$Renewal .= "-01-01";
$accountquery = "INSERT INTO account VALUES(\"{$AccountID[$R]}\",\"{$AccountName[$R]}\",'{$Type}','{$Renewal}','{$JoinDate[$R]}','','300.00','OK')";
if (!mysql_query("{$accountquery}")) {
fputs("{$Errorfile}", mysql_error() . "\n{$accountquery}\n\n");
}
$m2alinkquery = "INSERT INTO membertoaccountlink VALUES ('{$AccountID[$R]}','{$MemberID}','1')";
if (!mysql_query("{$m2alinkquery}")) {
fputs("{$Errorfile}", mysql_error() . "\n{$m2alinkquery}\n\n");
}
# Look up the transaction ID
$creditID = TransID();
$debitID = TransID();
$creditquery = "INSERT INTO transactions SET TransactionID = '{$creditID}',TradeDate = '{$date}',AccountID = '{$AccountID[$R]}',Amount = '{$PVolume}',Description = 'Previous Sales Credit', CurrentBalance = '{$PVolume}',OtherAccountID = '0'";
if (!mysql_query("{$creditquery}")) {
fputs("{$Errorfile}", mysql_error() . "\n{$creditquery}\n\n");
}
$debitquery = "INSERT INTO transactions SET TransactionID = '{$debitID}',TradeDate = '{$date}',AccountID = '{$AccountID[$R]}',Amount = '-{$NVolume}',Description = 'Previous Purchase Debit',CurrentBalance = '{$Balance[$R]}',OtherAccountID = '0'";
if (!mysql_query("{$debitquery}")) {
fputs("{$Errorfile}", mysql_error() . "\n{$debitquery}\n\n");
}
print "Completed processing AccountID {$AccountID[$R]}.\n";
}
fputs("{$Errorfile}", "End of Error File");
if (!mysql_query("ALTER TABLE account MODIFY AccountID int(11) NOT NULL auto_increment")) {
print "\n\n\nWARNING: UNABLE TO RESTORE TABLE STRUCTURE\n\n\n";
}
print "\nPROCESSING COMPLETE. Check Qlets_Errors.txt for error messages.\n";
