Changeset 9984 for trunk/membership.php

Timestamp:

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

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/membership.php (modified) (2 diffs)

trunk/membership.php

@@ -54 +54 @@
         case 'cancel_subscription':
             $transactionID = (int)$_REQUEST['tran_id'];
-            $subscriptionArr = db_arr( "SELECT `sys_payment_subscriptions`.`TransactionID`, DATE_FORMAT(`sys_payment_subscriptions`.`StartDate`,  '$date_format' ) AS StartDate, `sys_payment_subscriptions`.`Period`, `Transactions`.`Description`, `sys_payment_providers`.`Caption` AS `ProviderCaption` FROM `sys_payment_subscriptions`
-                                            LEFT JOIN `Transactions` ON `sys_payment_subscriptions`.`TransactionID` = `Transactions`.`ID`
-                                            LEFT JOIN `sys_payment_providers` ON `Transactions`.`IDProvider` = `sys_payment_providers`.`ID`
+            $subscriptionArr = db_arr( "SELECT `sys_payment_subscriptions`.`TransactionID`, DATE_FORMAT(`sys_payment_subscriptions`.`StartDate`,  '$date_format' ) AS StartDate, `sys_payment_subscriptions`.`Period`, `sys_transactions`.`Description`, `sys_payment_providers`.`Caption` AS `ProviderCaption` FROM `sys_payment_subscriptions`
+                                            LEFT JOIN `sys_transactions` ON `sys_payment_subscriptions`.`TransactionID` = `sys_transactions`.`ID`
+                                            LEFT JOIN `sys_payment_providers` ON `sys_transactions`.`IDProvider` = `sys_payment_providers`.`ID`
                                             WHERE `sys_payment_subscriptions`.`TransactionID` = {$transactionID}" );
 
@@ -149 +149 @@
     ob_start();
 
-    $subscriptionsRes = db_res( "SELECT `sys_payment_subscriptions`.`TransactionID`, DATE_FORMAT(`sys_payment_subscriptions`.`StartDate`, '$date_format' ) AS StartDate, `sys_payment_subscriptions`.`Period`, `sys_payment_subscriptions`.`ChargesNumber`, `Transactions`.`Description` FROM `sys_payment_subscriptions`
-                                    LEFT JOIN `Transactions` ON `sys_payment_subscriptions`.`TransactionID` = `Transactions`.`ID`
-                                    WHERE `Transactions`.`IDMember` = {$memberID}
-                                        AND `Transactions`.`Status` = 'declined'" );
+    $subscriptionsRes = db_res( "SELECT `sys_payment_subscriptions`.`TransactionID`, DATE_FORMAT(`sys_payment_subscriptions`.`StartDate`, '$date_format' ) AS StartDate, `sys_payment_subscriptions`.`Period`, `sys_payment_subscriptions`.`ChargesNumber`, `sys_transactions`.`Description` FROM `sys_payment_subscriptions`
+                                    LEFT JOIN `sys_transactions` ON `sys_payment_subscriptions`.`TransactionID` = `sys_transactions`.`ID`
+                                    WHERE `sys_transactions`.`IDMember` = {$memberID}
+                                        AND `sys_transactions`.`Status` = 'declined'" );
     $daysLangString = _t('_days');
     $cancelLangString = _t('_Cancel');