X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=187d3c8a30a7c075b06b671cbcaee1e0585f9fc5;hb=ccf34a2a92d80d01debd84b4b6e1f294d8f90cce;hp=72308c7e01e2df31d9f61d48a60ff5b1199e98c0;hpb=5b8d588fdbfa375fa859ca80a9b9e1735a13300e;p=mailer.git diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index 72308c7e01..187d3c8a30 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'); @@ -86,40 +90,36 @@ WHERE `id`=%s LIMIT 1", } // Display message - LOAD_TEMPLATE('admin_settings_saved', false, $content); + loadTemplate('admin_settings_saved', false, $content); } else { // There are mail orders available $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' => generateUserProfileLink($content['sender']), - 'pay' => getPaymentTitlePrice($content['payment_id']), - 'cat' => getCategory($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] ?>