<?php
/************************************************************************
- * MXChange v0.2.1 Start: 10/07/2004 *
- * ================ Last change: 10/14/2004 *
+ * Mailer v0.2.1-FINAL Start: 10/07/2004 *
+ * =================== Last change: 10/14/2004 *
* *
* -------------------------------------------------------------------- *
* File : what-list_transfer.php *
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Punktetransfers *
* -------------------------------------------------------------------- *
- * *
+ * $Revision:: $ *
+ * $Date:: $ *
+ * $Tag:: 0.2.1-FINAL $ *
+ * $Author:: $ *
* -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2003 - 2009 by Roland Haeder *
+ * 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 *
************************************************************************/
// Some security stuff...
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']) || (!IS_ADMIN())) {
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
- require($INC);
-}
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+ die();
+} // END - if
// Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+addYouAreHereLink('admin', __FILE__);
// We only need outgoing transfers
-$result = SQL_QUERY("SELECT userid, to_uid, trans_id, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY trans_id", __FILE__, __LINE__);
-$total = 0;
-if (SQL_NUMROWS($result) > 0)
-{
+$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 (!ifSqlHasZeroNums($result)) {
// Output rows
- $OUT = ""; $SW = 2;
- while(list($uid1, $uid2, $idx, $points, $reason, $stamp) = SQL_FETCHROW($result))
- {
+ $OUT = '';
+ while ($content = sqlFetchArray($result)) {
// Prepare data for the row template
- $content = array(
- 'sw' => $SW,
- 'idx' => $idx,
- 'stamp' => MAKE_DATETIME($stamp, "3"),
- 'from_link' => ADMIN_USER_PROFILE_LINK($uid1),
- 'to_link' => ADMIN_USER_PROFILE_LINK($uid2),
- 'reason' => wordwrap($reason, 15),
- 'points' => TRANSLATE_COMMA($points),
- );
+ $content['time_trans'] = generateDateTime($content['time_trans'], 3);
// Load row template add points and switch color
- $OUT .= LOAD_TEMPLATE("admin_list_transfer_row", true, $content);
- $total += $points; $SW = 3 - $SW;
- }
+ $OUT .= loadTemplate('admin_list_transfer_row', TRUE, $content);
+ $total += $content['points'];
+ } // END - while
// Free memory
- SQL_FREERESULT($result);
-}
- else
-{
+ sqlFreeResult($result);
+} else {
// Nothing for in and out
- $OUT = "<TR>
- <TD colspan=\"6\" align=\"center\" class=\"bottom2\" height=\"70\">
- ".LOAD_TEMPLATE("admin_settings_saved", true, TRANSFER_NO_INOUT_TRANSFERS)."
- </TD>
-</TR>";
+ $OUT = '<tr>
+ <td colspan="6" align="center" class="bottom">
+ ' . displayMessage('{--TRANSFER_NO_INOUT_TRANSFERS--}', TRUE) . '
+ </td>
+</tr>';
}
// ... and add them to a constant for the template
-define('__TRANSFER_ROWS', $OUT);
+$content['rows'] = $OUT;
// Remeber total amount
-define('__TRANSFER_TOTAL_VALUE', TRANSLATE_COMMA($total));
+$content['total_points'] = $total;
// Set title
-define('__TRANSFER_TITLE', TRANSFER_LIST_ALL);
+$content['title'] = '{--TRANSFER_LIST_ALL--}';
// Set "balance" word
-define('__TRANSFER_SUM', TRANSFER_TOTAL_BALANCE);
+$content['balance'] = '{--TRANSFER_TOTAL_BALANCE--}';
// Don't show a delete button
-define('__TRANSFER_DELETE', " ");
+$content['delete'] = ' ';
// Load final template
-LOAD_TEMPLATE("admin_list_transfer");
+loadTemplate('admin_list_transfer', FALSE, $content);
-//
+// [EOF]
?>