2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 09/28/2003 *
4 * =================== Last change: 04/09/2004 *
6 * -------------------------------------------------------------------- *
7 * File : what-edit_emails.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Edit ordered mails e.g. redirecting the URL *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Werbebuchungen aendern (z.B. umleiten der URL) *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2013 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()) && (!isPostRequestElementSet('id'))) {
47 unsetPostRequestElement('ok');
50 // Form sent or anything else? ;-)
51 if ((isFormSent('edit')) && (isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) {
53 $content = getPoolDataFromId(postRequestElement('id'));
56 loadTemplate('admin_edit_email', FALSE, $content);
57 } elseif ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) {
58 // Make also this email editable
59 $result = sqlQueryEscaped('SELECT
65 `{?_MYSQL_PREFIX?}_bonus`
69 array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
72 $content = sqlFetchArray($result);
75 sqlFreeResult($result);
78 loadTemplate('admin_edit_bonus_email', FALSE, $content);
79 } elseif (isFormSent('do_edit')) {
81 if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) {
83 $isUpdated = updatePoolDataById(postRequestElement('id'), NULL, array('subject' => postRequestElement('subject'), 'text' => postRequestElement('text'), 'url' => postRequestElemenet('url')));
84 if ($isUpdated === TRUE) {
85 $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}';
87 $content = '<span class="bad">{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}</span>';
89 } elseif ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) {
91 sqlQueryEscaped("UPDATE
92 `{?_MYSQL_PREFIX?}_bonus`
101 postRequestElement('subject'),
102 postRequestElement('text'),
103 postRequestElement('url'),
104 bigintval(postRequestElement('id')),
105 ), __FILE__, __LINE__);
107 if (!ifSqlHasZeroAffectedRows()) {
108 $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}';
110 $content = '<span class="bad">{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}</span>';
114 $content = '<span class="bad">{--ADMIN_EDIT_EMAIL_FAILED--}</span>';
118 displayMessage($content);
121 $result = sqlQuery('SELECT
128 `{?_MYSQL_PREFIX?}_pool`
131 `timestamp` ASC', __FILE__, __LINE__);
134 if (!ifSqlHasZeroNums($result)) {
135 // There are mail orders available
137 while ($content = sqlFetchArray($result)) {
138 // Load row template and switch colors
139 $OUT .= loadTemplate('admin_edit_email_row', TRUE, $content);
143 sqlFreeResult($result);
145 // Load email template
146 loadTemplate('admin_edit_email_select', FALSE, $OUT);
148 // No mail orders left in pool
149 displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}');