X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=887262cb61f4c47886aeab6332f3e82472f7ba3b;hp=f8e35fea0e7cec580a0d125ddc28b46fb73371b7;hb=e3934352dffa6eb9da59a137ae1a9414e5b4d80b;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8 diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index f8e35fea0e..887262cb61 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, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 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 * @@ -43,37 +41,74 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +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`, `subject`, `payment_id`, `cat_id` +// Form sent or anything else? ;-) +if ((isFormSent()) && (isPostRequestElementSet('mid'))) { + // Make mail editable... + $result = SQL_QUERY_ESC("SELECT + `id`,`sender` AS `userid`,`subject`,`text`,`url` FROM `{?_MYSQL_PREFIX?}_pool` -ORDER BY - `timestamp` ASC', __FILE__, __LINE__); +WHERE + `id`=%s +LIMIT 1", + array(bigintval(postRequestElement('mid'))), __FILE__, __LINE__); -// Entries found? -if (!SQL_HASZERONUMS($result)) { - if (isFormSent()) { - // Make mail editable... - $result = SQL_QUERY_ESC("SELECT `id`, `subject`, `text`, `url` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1", - array(bigintval(postRequestParameter('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 (isGetRequestElementSet('mid')) { + // Make also this email editable + $result = SQL_QUERY_ESC("SELECT + `id`,`sender` AS `userid`,`subject`,`text`,`url` +FROM + `{?_MYSQL_PREFIX?}_pool` +WHERE + `id`=%s +LIMIT 1", + array(bigintval(getRequestElement('mid'))), __FILE__, __LINE__); - // Load template - loadTemplate('admin_edit_email', false, $content); - } elseif (isPostRequestParameterSet('save')) { - // Save changes + // Fetch row + $content = SQL_FETCHARRAY($result); + + // Free result + SQL_FREERESULT($result); + + // Load template + loadTemplate('admin_edit_email', false, $content); +} elseif (isGetRequestElementSet('bid')) { + // Make also this email editable + $result = SQL_QUERY_ESC("SELECT + `id`,`subject`,`text`,`url` +FROM + `{?_MYSQL_PREFIX?}_bonus` +WHERE + `id`=%s +LIMIT 1", + array(bigintval(getRequestElement('bid'))), __FILE__, __LINE__); + + // Fetch row + $content = SQL_FETCHARRAY($result); + + // Free result + SQL_FREERESULT($result); + + // Load template + loadTemplate('admin_edit_bonus_email', false, $content); +} elseif (isFormSent('save')) { + // Save changes + if (isPostRequestElementSet('mid')) { + // Update pool SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET @@ -84,21 +119,58 @@ WHERE `id`=%s LIMIT 1", array( - postRequestParameter('subject'), - postRequestParameter('text'), - postRequestParameter('url'), - bigintval(postRequestParameter('id')), + postRequestElement('subject'), + postRequestElement('text'), + postRequestElement('url'), + bigintval(postRequestElement('mid')), ), __FILE__, __LINE__); - if (SQL_AFFECTEDROWS() == 1) { - $content = '{--SETTINGS_SAVED--}'; + if (!SQL_HASZEROAFFECTED()) { + $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}'; } else { - $content = '{--SETTINGS_NOT_SAVED--}'; + $content = '{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}'; } + } elseif (isPostRequestElementSet('bid')) { + // Update pool + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_bonus` +SET + `subject`='%s', + `text`='%s', + `url`='%s' +WHERE + `id`=%s +LIMIT 1", + array( + postRequestElement('subject'), + postRequestElement('text'), + postRequestElement('url'), + bigintval(postRequestElement('bid')), + ), __FILE__, __LINE__); - // Display message - loadTemplate('admin_settings_saved', false, $content); + if (!SQL_HASZEROAFFECTED()) { + $content = '{--ADMIN_EMAIL_CHANGES_SAVED--}'; + } else { + $content = '{--ADMIN_EMAIL_CHANGES_NOT_SAVED--}'; + } } else { + // No valid action + $content = '{--ADMIN_EDIT_EMAIL_FAILED--}'; + } + + // Display message + displayMessage($content); +} else { + // 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__); + + // Entries found? + if (!SQL_HASZERONUMS($result)) { // There are mail orders available $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { @@ -111,10 +183,10 @@ LIMIT 1", // Load email template 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]