2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 10/07/2004 *
4 * =================== Last change: 11/25/2004 *
6 * -------------------------------------------------------------------- *
7 * File : what-del_transfer.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Point transfers *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Punktetransfers *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * Copyright (c) 2003 - 2009 by Roland Haeder *
21 * Copyright (c) 2009, 2010 by Mailer Developer Team *
22 * For more information visit: http://www.mxchange.org *
24 * This program is free software; you can redistribute it and/or modify *
25 * it under the terms of the GNU General Public License as published by *
26 * the Free Software Foundation; either version 2 of the License, or *
27 * (at your option) any later version. *
29 * This program is distributed in the hope that it will be useful, *
30 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
31 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
32 * GNU General Public License for more details. *
34 * You should have received a copy of the GNU General Public License *
35 * along with this program; if not, write to the Free Software *
36 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
38 ************************************************************************/
40 // Some security stuff...
41 if ((!defined('__SECURITY')) || (!isAdmin())) {
45 // Add description as navigation point
46 addMenuDescription('admin', __FILE__);
48 if (isFormSent('del')) {
49 // Delete entries from tables
50 if (ifPostContainsSelections()) {
55 foreach (postRequestParameter('sel') as $id => $sel) {
56 addSql(SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `trans_id`=%s LIMIT 1',
57 array(bigintval($id)), __FILE__, __LINE__, false));
58 addSql(SQL_QUERY_ESC('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `trans_id`=%s LIMIT 1',
59 array(bigintval($id)), __FILE__, __LINE__, false));
63 runFilterChain('run_sqls');
67 // We only need outgoing transfers
68 $result = SQL_QUERY('SELECT
69 `userid` AS `from_userid`, `to_userid`, `trans_id`, `points`, `reason`, `time_trans`
71 `{?_MYSQL_PREFIX?}_user_transfers_out`
73 `trans_id` ASC', __FILE__, __LINE__);
76 if (!SQL_HASZERONUMS($result)) {
79 while ($content = SQL_FETCHARRAY($result)) {
80 // Prepare data for the row template
81 $content['time_trans'] = generateDateTime($content['time_trans'], 3);
84 $OUT .= loadTemplate('admin_del_transfer_row', true, $content);
86 // Sum points and switch colors
87 $total += $content['points'];
91 SQL_FREERESULT($result);
93 // Nothing for in and out
95 <td colspan="6" align="center" class="bottom">
96 ' . loadTemplate('admin_settings_saved', true, '{--TRANSFER_NO_INOUT_TRANSFERS--}') . '
101 // ... and add them to a constant for the template
102 $content['rows'] = $OUT;
104 // Remeber total amount
105 $content['total'] = translateComma($total);
108 $content['title'] = '{--TRANSFER_LIST_ALL--}';
110 // Show delete button here
111 $content['delete'] = '<input type="reset" class="admin_reset" value="{--UNDO_SELECTIONS--}" />
112 <input type="submit" name="del" class="admin_delete" value="{--TRANSFER_DELETE--}" />';
114 // Load final template
115 loadTemplate('admin_list_transfer', false, $content);