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 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2015 by Mailer Developer Team *
20 * For more information visit: http://mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if ((!defined('__SECURITY')) || (!isAdmin())) {
43 // Add description as navigation point
44 addYouAreHereLink('admin', __FILE__);
46 if (isFormSent('delete')) {
47 // Delete entries from tables
48 if (ifPostContainsSelections()) {
53 foreach (postRequestElement('sel') as $id => $sel) {
54 addSql(sqlQueryEscaped('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `trans_id`=%s LIMIT 1',
55 array(bigintval($id)), __FILE__, __LINE__, FALSE));
56 addSql(sqlQueryEscaped('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `trans_id`=%s LIMIT 1',
57 array(bigintval($id)), __FILE__, __LINE__, FALSE));
61 runFilterChain('run_sqls');
67 // Only out-going transfers are needed
68 $result = sqlQuery('SELECT
69 `userid` AS `from_userid`,
76 `{?_MYSQL_PREFIX?}_user_transfers_out`
78 `trans_id` ASC', __FILE__, __LINE__);
80 if (!ifSqlHasZeroNumRows($result)) {
83 while ($content = sqlFetchArray($result)) {
84 // Prepare data for the row template
85 $content['time_trans'] = generateDateTime($content['time_trans'], 3);
88 $OUT .= loadTemplate('admin_delete_transfer_row', TRUE, $content);
90 // Sum points and switch colors
91 $total += $content['points'];
95 sqlFreeResult($result);
97 // Nothing for in and out
99 <td colspan="6" align="center" class="bottom">
100 ' . displayMessage('{--TRANSFER_NO_INOUT_TRANSFERS--}', TRUE) . '
105 // ... and add them to a constant for the template
106 $content['rows'] = $OUT;
108 // Remeber total amount
109 $content['total_points'] = $total;
112 $content['title'] = '{--TRANSFER_LIST_ALL--}';
114 // Show delete button here
115 $content['delete'] = '<input type="reset" class="form_reset" value="{--UNDO_SELECTIONS--}" />
116 <input type="submit" name="delete" class="form_delete" value="{--ADMIN_DELETE_TRANSFERS_SUBMIT--}" />';
118 // Load final template
119 loadTemplate('admin_list_transfer', FALSE, $content);