Next wave of lesser getMessage() usage and more EL
[mailer.git] / inc / modules / admin / what-list_transfer.php
index 96a8c72526afee6ac1e15919051d22af8b4df317..fe7fea5f0a8d7fadb7d70f8e432c3e2a38738855 100644 (file)
@@ -46,50 +46,50 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 addMenuDescription('admin', __FILE__);
 
 // We only need outgoing transfers
-$result = SQL_QUERY("SELECT userid, to_userid, trans_id, points, reason, time_trans FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY trans_id", __FILE__, __LINE__);
+$result = SQL_QUERY('SELECT
+       `userid` AS `from_userid`, `to_userid`, `trans_id`, `points`, `reason`, `time_trans`
+FROM
+       `{?_MYSQL_PREFIX?}_user_transfers_out`
+ORDER BY
+       `trans_id` ASC', __FILE__, __LINE__);
+
 $total = '0';
 if (SQL_NUMROWS($result) > 0) {
        // Output rows
        $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result)) {
                // Prepare data for the row template
-               $content = array(
-                       'sw'         => $SW,
-                       'trans_id'   => $content['trans_id'],
-                       'time_trans' => generateDateTime($content['time_trans'], 3),
-                       'from_link'  => generateUserProfileLink($content['userid']),
-                       'to_link'    => generateUserProfileLink($content['to_userid']),
-                       'reason'     => wordwrap($content['reason'], 15),
-                       'points'     => translateComma($content['points']),
-               );
+               $content['sw']          = $SW;
+               $content['time_trans']  = generateDateTime($content['time_trans'], 3);
+               $content['reason']      = wordwrap($content['reason'], 15);
 
                // Load row template add points and switch color
                $OUT .= loadTemplate('admin_list_transfer_row', true, $content);
                $total += $content['points']; $SW = 3 - $SW;
-       }
+       } // END - while
 
        // Free memory
        SQL_FREERESULT($result);
 } else {
        // Nothing for in and out
-       $OUT = "<tr>
-  <td colspan=\"6\" align=\"center\" class=\"bottom\">
-    ".loadTemplate('admin_settings_saved', true, getMessage('TRANSFER_NO_INOUT_TRANSFERS'))."
+       $OUT = '<tr>
+  <td colspan="6" align="center" class="bottom">
+    ' . loadTemplate('admin_settings_saved', true, '{--TRANSFER_NO_INOUT_TRANSFERS--}') . '
   </td>
-</tr>";
+</tr>';
 }
 
 // ... and add them to a constant for the template
 $content['rows'] = $OUT;
 
 // Remeber total amount
-$content['total'] = translateComma($total);
+$content['total'] = $total;
 
 // Set title
-$content['title'] = getMessage('TRANSFER_LIST_ALL');
+$content['title'] = '{--TRANSFER_LIST_ALL--}';
 
 // Set "balance" word
-$content['balance'] = getMessage('TRANSFER_TOTAL_BALANCE');
+$content['balance'] = '{--TRANSFER_TOTAL_BALANCE--}';
 
 // Don't show a delete button
 $content['delete'] = '&nbsp;';