X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=01880f16704002739a06db4aa12acf0d3cb9a594;hb=c5173c4d66be7ec72fbf8051a2097cbb377e87a0;hp=230c7069255eb9b47ecfce500c737360e6bd82a8;hpb=449003a0cf1cf2434ef63e4b7d39685ba3804786;p=mailer.git diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index 230c706925..01880f1670 100644 --- a/inc/modules/admin/what-edit_emails.php +++ b/inc/modules/admin/what-edit_emails.php @@ -40,10 +40,10 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); if ((isFormSent()) && (!isPostRequestParameterSet('id'))) { unsetPostRequestParameter('ok'); @@ -51,7 +51,7 @@ if ((isFormSent()) && (!isPostRequestParameterSet('id'))) { // Query the pool $result = SQL_QUERY('SELECT - `id`, `sender`, `subject`, `payment_id`, `cat_id` + `id`, `sender` AS `userid`, `subject`, `payment_id`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` ORDER BY @@ -61,7 +61,13 @@ ORDER BY 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", + $result = SQL_QUERY_ESC("SELECT + `id`, `sender` AS `userid`, `subject`, `text`, `url` +FROM + `{?_MYSQL_PREFIX?}_pool` +WHERE + `id`=%s +LIMIT 1", array(bigintval(postRequestParameter('id'))), __FILE__, __LINE__); // Fetch row @@ -90,7 +96,7 @@ LIMIT 1", bigintval(postRequestParameter('id')), ), __FILE__, __LINE__); - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { $content = '{--SETTINGS_SAVED--}'; } else { $content = '{--SETTINGS_NOT_SAVED--}';