X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;fp=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=e22c9eef08f55cc792ab305e1d75e9f39736a2e8;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=d00ca14d7051c4c76bb1acf930ede394ef7d0c2e;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-edit_emails.php b/0.2.1/inc/modules/admin/what-edit_emails.php index d00ca14d70..e22c9eef08 100644 --- a/0.2.1/inc/modules/admin/what-edit_emails.php +++ b/0.2.1/inc/modules/admin/what-edit_emails.php @@ -1,138 +1,138 @@ - 0) -{ - if (isset($_POST['ok'])) - { - // Make mail editable... - $result = SQL_QUERY_ESC("SELECT subject, text, url FROM "._MYSQL_PREFIX."_pool WHERE id=%d LIMIT 1", - array(bigintval($_POST['id'])), __FILE__, __LINE__); - list($subj, $text, $url) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - define('__ID_VALUE' , $_POST['id']); - define('__URL_VALUE' , stripslashes($url)); - define('__SUBJ_VALUE', stripslashes($subj)); - define('__TEXT_VALUE', stripslashes($text)); - - // Load template - LOAD_TEMPLATE("admin_edit_email"); - } - elseif (!empty($_POST['save'])) - { - // Save changes - if (!empty($SQL)) - { - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_pool SET -subject='%s', -text='%s', -url='%s' -WHERE id=%d LIMIT 1", - array( - addslashes($_POST['subj']), - addslashes($_POST['text']), - addslashes($_POST['url']), - bigintval($_POST['id']), -), __FILE__, __LINE__); - if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 1) - { - $content = "".SETTINGS_SAVED.""; - } - else - { - $content = "".SETTINGS_NOT_SAVED.""; - } - } - else - { - $content = "".SETTINGS_NOT_SAVED.""; - } - - // Display message - LOAD_TEMPLATE("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), - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_edit_email_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - define('__EMAIL_SELECT_ROWS', $OUT); - - // Load email template - LOAD_TEMPLATE("admin_edit_email_select"); - } -} - else -{ - // No mail orders left in pool - OUTPUT_HTML ("".ADMIN_NO_MAILS_IN_POOL.""); -} -CLOSE_TABLE(); -// -?> + 0) +{ + if (isset($_POST['ok'])) + { + // Make mail editable... + $result = SQL_QUERY_ESC("SELECT subject, text, url FROM "._MYSQL_PREFIX."_pool WHERE id=%d LIMIT 1", + array(bigintval($_POST['id'])), __FILE__, __LINE__); + list($subj, $text, $url) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + define('__ID_VALUE' , $_POST['id']); + define('__URL_VALUE' , stripslashes($url)); + define('__SUBJ_VALUE', stripslashes($subj)); + define('__TEXT_VALUE', stripslashes($text)); + + // Load template + LOAD_TEMPLATE("admin_edit_email"); + } + elseif (!empty($_POST['save'])) + { + // Save changes + if (!empty($SQL)) + { + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_pool SET +subject='%s', +text='%s', +url='%s' +WHERE id=%d LIMIT 1", + array( + addslashes($_POST['subj']), + addslashes($_POST['text']), + addslashes($_POST['url']), + bigintval($_POST['id']), +), __FILE__, __LINE__); + if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 1) + { + $content = "".SETTINGS_SAVED.""; + } + else + { + $content = "".SETTINGS_NOT_SAVED.""; + } + } + else + { + $content = "".SETTINGS_NOT_SAVED.""; + } + + // Display message + LOAD_TEMPLATE("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), + ); + + // Load row template and switch colors + $OUT .= LOAD_TEMPLATE("admin_edit_email_row", true, $content); + $SW = 3 - $SW; + } + + // Free memory + SQL_FREERESULT($result); + define('__EMAIL_SELECT_ROWS', $OUT); + + // Load email template + LOAD_TEMPLATE("admin_edit_email_select"); + } +} + else +{ + // No mail orders left in pool + OUTPUT_HTML ("".ADMIN_NO_MAILS_IN_POOL.""); +} +CLOSE_TABLE(); +// +?>