X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=b9edf20f42b769b9e8cdc0952930cdb639c1deea;hp=cb75867f7bf8ba0cc28ed1848401d607f8e579f3;hb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2 diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index cb75867f7b..b9edf20f42 100644 --- a/inc/modules/admin/what-edit_emails.php +++ b/inc/modules/admin/what-edit_emails.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * 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 * @@ -45,43 +43,53 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { // Add description as navigation point addYouAreHereLink('admin', __FILE__); -if ((isFormSent()) && (!isPostRequestParameterSet('id'))) { - unsetPostRequestParameter('ok'); +if ((isFormSent()) && (!isPostRequestElementSet('id'))) { + unsetPostRequestElement('ok'); } // END - if -// Query the pool -$result = SQL_QUERY('SELECT - `id`, `sender` AS `userid`, `subject`, `payment_id`, `cat_id` -FROM - `{?_MYSQL_PREFIX?}_pool` -ORDER BY - `timestamp` ASC', __FILE__, __LINE__); +// Form sent or anything else? ;-) +if ((isFormSent('edit')) && (isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) { + // Get data + $content = getPoolDataFromId(postRequestElement('id')); -// Entries found? -if (!SQL_HASZERONUMS($result)) { - if (isFormSent()) { - // Make mail editable... - $result = SQL_QUERY_ESC("SELECT - `id`, `sender` AS `userid`, `subject`, `text`, `url` + // Load template + loadTemplate('admin_edit_email', FALSE, $content); +} elseif ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) { + // Make also this email editable + $result = SQL_QUERY_ESC('SELECT + `id`, + `subject`, + `text`, + `url` FROM - `{?_MYSQL_PREFIX?}_pool` + `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s -LIMIT 1", - array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__); +LIMIT 1', + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); - // Fetch row - $content = SQL_FETCHARRAY($result); + // Fetch row + $content = SQL_FETCHARRAY($result); - // Free result - SQL_FREERESULT($result); + // Free result + SQL_FREERESULT($result); - // Load template - loadTemplate('admin_edit_email', false, $content); - } elseif (isPostRequestParameterSet('save')) { - // Save changes + // Load template + loadTemplate('admin_edit_bonus_email', FALSE, $content); +} elseif (isFormSent('do_edit')) { + // Save changes + if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) { + // Update pool + $isUpdated = updatePoolDataById(postRequestElement('id'), NULL, array('subject' => postRequestElement('subject'), 'text' => postRequestElement('text'), 'url' => postRequestElemenet('url'))); + if ($isUpdated === TRUE) { + $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}'; + } else { + $content = '{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}'; + } + } elseif ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) { + // Update pool SQL_QUERY_ESC("UPDATE - `{?_MYSQL_PREFIX?}_pool` + `{?_MYSQL_PREFIX?}_bonus` SET `subject`='%s', `text`='%s', @@ -90,37 +98,56 @@ WHERE `id`=%s LIMIT 1", array( - postRequestParameter('subject'), - postRequestParameter('text'), - postRequestParameter('url'), - bigintval(postRequestParameter('id')), + postRequestElement('subject'), + postRequestElement('text'), + postRequestElement('url'), + bigintval(postRequestElement('id')), ), __FILE__, __LINE__); if (!SQL_HASZEROAFFECTED()) { - $content = '{--SETTINGS_SAVED--}'; + $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}'; } else { - $content = '{--SETTINGS_NOT_SAVED--}'; + $content = '{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}'; } - - // Display message - loadTemplate('admin_settings_saved', false, $content); } else { + // No valid action + $content = '{--ADMIN_EDIT_EMAIL_FAILED--}'; + } + + // Display message + displayMessage($content); +} else { + // Query the pool + $result = SQL_QUERY('SELECT + `id`, + `sender`, + `subject`, + `payment_id`, + `cat_id` +FROM + `{?_MYSQL_PREFIX?}_pool` +ORDER BY + `sender` ASC, + `timestamp` ASC', __FILE__, __LINE__); + + // Entries found? + if (!SQL_HASZERONUMS($result)) { // There are mail orders available $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Load row template and switch colors - $OUT .= loadTemplate('admin_edit_email_row', true, $content); + $OUT .= loadTemplate('admin_edit_email_row', TRUE, $content); } // END - while // Free memory SQL_FREERESULT($result); // Load email template - loadTemplate('admin_edit_email_select', false, $OUT); + loadTemplate('admin_edit_email_select', FALSE, $OUT); + } else { + // No mail orders left in pool + displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}'); } -} else { - // No mail orders left in pool - loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); } // [EOF]