More rewrites/templates swapped out:

[mailer.git] / inc / modules / admin / what-list_transfer.php

diff --git a/inc/modules/admin/what-list_transfer.php b/inc/modules/admin/what-list_transfer.php
index 96a8c72526afee6ac1e15919051d22af8b4df317..799d9ab25f838daa8db5d2298f355f89252e3dca 100644 (file)
--- a/inc/modules/admin/what-list_transfer.php
+++ b/inc/modules/admin/what-list_transfer.php
@@ -46,37 +46,37 @@ 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, getMessage('TRANSFER_NO_INOUT_TRANSFERS')) . '
   </td>
-</tr>";
+</tr>';
 }
 
 // ... and add them to a constant for the template