X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=inc%2Fmodules%2Fadmin%2Fwhat-list_transfer.php;h=fe7fea5f0a8d7fadb7d70f8e432c3e2a38738855;hb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;hp=96a8c72526afee6ac1e15919051d22af8b4df317;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa;p=mailer.git

diff --git a/inc/modules/admin/what-list_transfer.php b/inc/modules/admin/what-list_transfer.php
index 96a8c72526..fe7fea5f0a 100644
--- a/inc/modules/admin/what-list_transfer.php
+++ b/inc/modules/admin/what-list_transfer.php
@@ -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;';