# 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";