Changeset 9984 for trunk/inc/checkout.inc.php

Timestamp:

04/06/09 22:50:09 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/inc/checkout.inc.php (modified) (9 diffs)

trunk/inc/checkout.inc.php

@@ -211 +211 @@
     $transactionString = transDataToString( $transactionData );
     $transactionDesc = process_db_input( $checkoutData['description'], 0, 1 );
-    $res = db_res( "INSERT INTO `Transactions` SET
+    $res = db_res( "INSERT INTO `sys_transactions` SET
                         `IDMember` = {$memberID},
                         `IDProvider` = {$providerID},
@@ -252 +252 @@
     $status = ($approved ? 'approved' : 'declined');
 
-    $res = db_res( "UPDATE `Transactions` SET
+    $res = db_res( "UPDATE `sys_transactions` SET
                         `Status` = '{$status}',
                         `Date` = NOW(),
@@ -283 +283 @@
     $localTranID = (int)$localTranID;
 
-    $tranRes = db_res( "SELECT `Data` FROM `Transactions`
+    $tranRes = db_res( "SELECT `Data` FROM `sys_transactions`
                             WHERE `ID` = {$localTranID}" );
     if ( !$tranRes || mysql_num_rows($tranRes) == 0 )
@@ -353 +353 @@
 
     // delete dummy transaction
-    $res = db_res( "DELETE FROM `Transactions`
+    $res = db_res( "DELETE FROM `sys_transactions`
                         WHERE `ID` = {$localTranID}" );
     if ( $res && mysql_affected_rows( $MySQL->link ) > 0 )
@@ -382 +382 @@
 
     // select dummy transaction info
-    $tranRes = db_res( "SELECT `IDProvider`, `Data` FROM `Transactions`
+    $tranRes = db_res( "SELECT `IDProvider`, `Data` FROM `sys_transactions`
                             WHERE `ID` = {$localTranID}" );
     if ( !$tranRes || mysql_num_rows($tranRes) == 0 )
@@ -506 +506 @@
     if ( $localTranID )
     {
-        $tranRes = db_res( "SELECT `Data` FROM `Transactions`
+        $tranRes = db_res( "SELECT `Data` FROM `sys_transactions`
                                 WHERE `ID` = {$localTranID}" );
         if ( $tranRes && mysql_num_rows($tranRes) > 0 )
@@ -698 +698 @@
     $localTranID = (int)$localTranID;
 
-    $tranRes = db_res( "SELECT `Data` FROM `Transactions`
+    $tranRes = db_res( "SELECT `Data` FROM `sys_transactions`
                             WHERE `ID` = {$localTranID}" );
     if ( !$tranRes || mysql_num_rows($tranRes) == 0 )
@@ -852 +852 @@
     // Fill the array
     $fin = array();
-    $arr = db_arr( "SELECT `Percent` FROM `aff` WHERE `ID` = $affID");
+    $arr = db_arr( "SELECT `Percent` FROM `sys_aff` WHERE `ID` = $affID");
     $percent = (float)$arr['Percent'] / 100.0;
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}membership{$separator}%' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}membership{$separator}%' AND `Currency` = '{$currency_code}'" );
     $fin['membership_amount'] = sprintf( "%.2f", $percent * (float)$arr[0] );
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}profiles{$separator}%' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}profiles{$separator}%' AND `Currency` = '{$currency_code}'" );
     $fin['sales_amount'] = sprintf( "%.2f", $percent * (float)$arr[0] );
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` INNER JOIN `sys_aff_members` ON (`idProfile` = `IDMember`) WHERE {$tranFilter} AND `idAff` = {$affID} AND `Status` = 'approved' AND `Currency` = '{$currency_code}'" );
     $fin['total'] = sprintf( "%.2f", $percent * (float)$arr[0] );
 
@@ -930 +930 @@
     // Fill the array
     $fin = array();
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}membership{$separator}%' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}membership{$separator}%' AND `Currency` = '{$currency_code}'" );
     $fin['membership_amount'] = sprintf( "%.2f", (float)$arr[0] );
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}profiles{$separator}%' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Data` LIKE '%{$separator}profiles{$separator}%' AND `Currency` = '{$currency_code}'" );
     $fin['sales_amount'] = sprintf( "%.2f", (float)$arr[0] );
-    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `Transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Currency` = '{$currency_code}'" );
+    $arr = db_arr( "SELECT SUM( `Amount` ) FROM `sys_transactions` WHERE {$tranFilter} AND `Status` = 'approved' AND `Currency` = '{$currency_code}'" );
     $fin['total'] = sprintf( "%.2f", (float)$arr[0] );