<?php
/************************************************************************
- * MXChange v0.2.1 Start: 10/07/2004 *
- * ================ Last change: 11/25/2004 *
+ * Mailer v0.2.1-FINAL Start: 10/07/2004 *
+ * =================== Last change: 11/25/2004 *
* *
* -------------------------------------------------------------------- *
* File : what-del_transfer.php *
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Punktetransfers *
* -------------------------------------------------------------------- *
- * $Revision:: 856 $ *
- * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ *
+ * $Revision:: $ *
+ * $Date:: $ *
* $Tag:: 0.2.1-FINAL $ *
- * $Author:: stelzi $ *
+ * $Author:: $ *
* Needs to be in all Files and every File needs "svn propset *
* svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * Copyright (c) 2003 - 2009 by Roland Haeder *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
************************************************************************/
// 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();
}
// Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+addMenuDescription('admin', __FILE__);
-if (REQUEST_ISSET_POST('del')) {
+if (isFormSent('del')) {
// Delete entries from tables
- $SEL = SELECTION_COUNT(REQUEST_POST('sel'));
- if ($SEL > 0) {
+ if (ifPostContainsSelections()) {
// Init SQLs
- INIT_SQLS();
+ initSqls();
// Delete entries...
- foreach (REQUEST_POST('sel') as $id => $sel) {
- ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_transfers_in` WHERE trans_id=%s LIMIT 1",
+ foreach (postRequestParameter('sel') as $id => $sel) {
+ addSql(SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `trans_id`=%s LIMIT 1',
array(bigintval($id)), __FILE__, __LINE__, false));
- ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_transfers_out` WHERE trans_id=%s LIMIT 1",
+ addSql(SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `trans_id`=%s LIMIT 1',
array(bigintval($id)), __FILE__, __LINE__, false));
} // END - foreach
// Run all SQLs
runFilterChain('run_sqls');
- }
-}
+ } // END - if
+} // END - if
// 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 = 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_HASZERONUMS($result)) {
// Output rows
- $OUT = ""; $SW = 2;
+ $OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
- // @TODO Rewritings: idx->trans_id in template
- $content = array(
- 'sw' => $SW,
- 'idx' => $content['trans_id'],
- 'stamp' => MAKE_DATETIME($content['time_trans'], "3"),
- 'uid_from' => ADMIN_USER_PROFILE_LINK($content['userid']),
- 'uid_to' => ADMIN_USER_PROFILE_LINK($content['to_uid']),
- 'reason' => $content['reason'],
- 'points' => TRANSLATE_COMMA($content['points']),
- );
+ $content['time_trans'] = generateDateTime($content['time_trans'], 3);
// Load row template
- $OUT .= LOAD_TEMPLATE("admin_del_transfer_row", true, $content);
+ $OUT .= loadTemplate('admin_del_transfer_row', true, $content);
// Sum points and switch colors
- $total += $content['points']; $SW = 3 - $SW;
- }
+ $total += $content['points'];
+ } // END - while
// Free memory
SQL_FREERESULT($result);
} else {
// Nothing for in and out
- $OUT = "<tr>
- <td colspan=\"6\" align=\"center\" class=\"bottom2\" height=\"70\">
- ".LOAD_TEMPLATE("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
-// @TODO Rewrite all these constants
-define('__TRANSFER_ROWS', $OUT);
+$content['rows'] = $OUT;
// Remeber total amount
-define('__TRANSFER_TOTAL_VALUE', $total);
+$content['total'] = translateComma($total);
// Set title
-define('__TRANSFER_TITLE', getMessage('TRANSFER_LIST_ALL'));
+$content['title'] = '{--TRANSFER_LIST_ALL--}';
// Show delete button here
-define('__TRANSFER_DELETE', "<input type=\"reset\" class=\"admin_reset\" value=\"{--UNDO_SELECTIONS--}\" /> * <input type=\"submit\" name=\"del\" class=\"admin_delete\" value=\"{--TRANSFER_DELETE--}\" />");
+$content['delete'] = '<input type="reset" class="form_reset" value="{--UNDO_SELECTIONS--}" />
+<input type="submit" name="del" class="form_delete" value="{--TRANSFER_DELETE--}" />';
// Load final template
-LOAD_TEMPLATE("admin_list_transfer");
+loadTemplate('admin_list_transfer', false, $content);
-//
+// [EOF]
?>