Rewrites/fixes for handling config entries in SQLs

[mailer.git] / inc / modules / member / what-transfer.php

diff --git a/inc/modules/member/what-transfer.php b/inc/modules/member/what-transfer.php
index ba40074cf842234a089c2d9e22d1f5676d9b66c2..ddc7586b6f4001a2144985461ef6fd5f4e7c6b29 100644 (file)
--- a/inc/modules/member/what-transfer.php
+++ b/inc/modules/member/what-transfer.php
@@ -280,14 +280,14 @@ switch ($mode) {
                $nothingMessage = '';
                switch ($mode) {
                        case 'list_in':
-                               $sql = "SELECT `trans_id`, `from_userid` AS party_userid, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `userid`=%s ORDER BY `time_trans` DESC LIMIT ".getConfig('transfer_max');
+                               $sql = "SELECT `trans_id`, `from_userid` AS party_userid, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `userid`=%s ORDER BY `time_trans` DESC LIMIT {?transfer_max?}";
                                $nothingMessage = getMessage('TRANSFER_NO_INCOMING_TRANSFERS');
                                $content['balance'] = getMessage('TRANSFER_TOTAL_INCOMING');
                                $content['title']   = getMessage('TRANSFER_LIST_INCOMING');
                                break;
 
                        case 'list_out':
-                               $sql = "SELECT `trans_id`, `to_userid` AS party_userid, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `userid`=%s ORDER BY `time_trans` DESC LIMIT ".getConfig('transfer_max');
+                               $sql = "SELECT `trans_id`, `to_userid` AS party_userid, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `userid`=%s ORDER BY `time_trans` DESC LIMIT {?transfer_max?}";
                                $nothingMessage = getMessage('TRANSFER_NO_OUTGOING_TRANSFERS');
                                $content['balance'] = getMessage('TRANSFER_TOTAL_OUTGOING');
                                $content['title']   = getMessage('TRANSFER_LIST_OUTGOING');