X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=345830600eda1b7c1d86587bf19182d187dc810f;hb=d9f35786166902b9bc3f402d4f2abeed5ae0528d;hp=e087a97c3eb0b4d4343bb98327ca2a9d6b01dac8;hpb=fb7120ffa230b62b54895bcf95952e1cf30f8594;p=mailer.git diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index e087a97c3e..345830600e 100644 --- a/inc/modules/admin/what-edit_emails.php +++ b/inc/modules/admin/what-edit_emails.php @@ -1,7 +1,7 @@ 0) { - if (IS_FORM_SENT()) { + if (isFormSent()) { // Make mail editable... - $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1", - array(bigintval(REQUEST_POST('id'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT subject, text, url FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1", + array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__); list($subj, $text, $url) = SQL_FETCHROW($result); SQL_FREERESULT($result); - // @TODO More constants to rewrite - define('__ID_VALUE' , REQUEST_POST('id')); - define('__URL_VALUE' , $url); - define('__SUBJ_VALUE', $subj); - define('__TEXT_VALUE', $text); + + // Prepare constant for template + $content['id'] = bigintval(postRequestParameter('id')); + $content['url'] = $url; + $content['subject'] = $subj; + $content['text'] = $text; // Load template - LOAD_TEMPLATE("admin_edit_email"); - } elseif (REQUEST_ISSET_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( - REQUEST_POST('subj'), - REQUEST_POST('text'), - REQUEST_POST('url'), - bigintval(REQUEST_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 = getMessage('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 - $OUT = ""; $SW = 2; + $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the row template - // @TODO Rewritings: subj->subject in template $content = array( - 'sw' => $SW, - 'id' => $content['id'], - 'subj' => $content['subject'], - 'uid' => ADMIN_USER_PROFILE_LINK($content['sender']), - 'pay' => GET_PAYMENT($content['payment_id']), - 'cat' => GET_CATEGORY($content['cat_id']), + 'sw' => $SW, + 'id' => $content['id'], + 'subject' => $content['subject'], + 'userid' => generateUserProfileLink($content['sender']), + 'pay' => getPaymentTitlePrice($content['payment_id']), + 'cat' => getCategory($content['cat_id']), ); // 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; } // Free memory SQL_FREERESULT($result); - // @TODO Yet another constant to rewrite - 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 - LOAD_TEMPLATE("admin_settings_saved", false, "{--ADMIN_NO_MAILS_IN_POOL--}"); + loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); } -// +// [EOF] ?>