X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=f90c9c1e3b90d791191c2ccabe6bdfe4a9d597c8;hp=bb171d0de35768701a0bf72df35906451a60222d;hb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;hpb=7b9f2d4c956e37c4c079c1e612ecd6a7947e7e05 diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index bb171d0de3..f90c9c1e3b 100644 --- a/inc/modules/admin/what-edit_emails.php +++ b/inc/modules/admin/what-edit_emails.php @@ -1,7 +1,7 @@ 0) { - if (isset($_POST['ok'])) { + if (isFormSent()) { // Make mail editable... - $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1", - array(bigintval($_POST['id'])), __FILE__, __LINE__); - list($subj, $text, $url) = SQL_FETCHROW($result); + $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); + + // Free result SQL_FREERESULT($result); - define('__ID_VALUE' , $_POST['id']); - define('__URL_VALUE' , $url); - define('__SUBJ_VALUE', $subj); - define('__TEXT_VALUE', $text); // Load template - LOAD_TEMPLATE("admin_edit_email"); - } elseif (!empty($_POST['save'])) { + loadTemplate('admin_edit_email', false, $content); + } elseif (isPostRequestParameterSet('save')) { // Save changes - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_pool` SET -subject='%s', -text='%s', -url='%s' -WHERE id=%s LIMIT 1", - array( - $_POST['subj'], - $_POST['text'], - $_POST['url'], - bigintval($_POST['id']), -), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_pool` +SET + `subject`='%s', + `text`='%s', + `url`='%s' +WHERE + `id`=%s +LIMIT 1", + array( + postRequestParameter('subject'), + postRequestParameter('text'), + postRequestParameter('url'), + bigintval(postRequestParameter('id')), + ), __FILE__, __LINE__); if (SQL_AFFECTEDROWS() == 1) { - $content = SETTINGS_SAVED; + $content = '{--SETTINGS_SAVED--}'; } else { - $content = "{--SETTINGS_NOT_SAVED--}"; + $content = '{--SETTINGS_NOT_SAVED--}'; } // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $content); + loadTemplate('admin_settings_saved', false, $content); } else { // There are mail orders available - $SW = 2; $OUT = ""; - while (list($id, $sender, $subj, $pay, $cat) = SQL_FETCHROW($result)) { - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'subj' => $subj, - 'uid' => ADMIN_USER_PROFILE_LINK($sender), - 'pay' => GET_PAYMENT($pay), - 'cat' => GET_CATEGORY($cat), - ); + $OUT = ''; $SW = 2; + while ($content = SQL_FETCHARRAY($result)) { + // Add color swapping + $content['sw'] = $SW; // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_edit_email_row", true, $content); + $OUT .= loadTemplate('admin_edit_email_row', true, $content); $SW = 3 - $SW; - } + } // END - while // Free memory SQL_FREERESULT($result); - define('__EMAIL_SELECT_ROWS', $OUT); // Load email template - LOAD_TEMPLATE("admin_edit_email_select"); + loadTemplate('admin_edit_email_select', false, $OUT); } } else { // No mail orders left in pool - OUTPUT_HTML("".ADMIN_NO_MAILS_IN_POOL.""); + loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); } -// +// [EOF] ?>