* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009, 2010 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
addYouAreHereLink('admin', __FILE__);
// We only need outgoing transfers
-$result = SQL_QUERY('SELECT
- `userid` AS `from_userid`, `to_userid`, `trans_id`, `points`, `reason`, `time_trans`
+$result = sqlQuery('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_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
// Output rows
$OUT = '';
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Prepare data for the row template
$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);
+ $OUT .= loadTemplate('admin_list_transfer_row', TRUE, $content);
$total += $content['points'];
} // END - while
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Nothing for in and out
$OUT = '<tr>
<td colspan="6" align="center" class="bottom">
- ' . loadTemplate('admin_settings_saved', true, '{--TRANSFER_NO_INOUT_TRANSFERS--}') . '
+ ' . displayMessage('{--TRANSFER_NO_INOUT_TRANSFERS--}', TRUE) . '
</td>
</tr>';
}
$content['rows'] = $OUT;
// Remeber total amount
-$content['total'] = $total;
+$content['total_points'] = $total;
// Set title
$content['title'] = '{--TRANSFER_LIST_ALL--}';
$content['delete'] = ' ';
// Load final template
-loadTemplate('admin_list_transfer', false, $content);
+loadTemplate('admin_list_transfer', FALSE, $content);
// [EOF]
?>