X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-edit_emails.php;h=cf78ba0e33834bb5cceaaf7ab2f47509d326aca6;hb=101e5f161c0c367c022c9288398226a57f3919d7;hp=f90c9c1e3b90d791191c2ccabe6bdfe4a9d597c8;hpb=80c4d572aeea86286b6e1db8b845f46813b478c5;p=mailer.git diff --git a/inc/modules/admin/what-edit_emails.php b/inc/modules/admin/what-edit_emails.php index f90c9c1e3b..cf78ba0e33 100644 --- a/inc/modules/admin/what-edit_emails.php +++ b/inc/modules/admin/what-edit_emails.php @@ -14,11 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -40,28 +38,34 @@ // 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'); } // END - if // Query the pool -$result = SQL_QUERY("SELECT - `id`, `sender`, `subject`, `payment_id`, `cat_id` +$result = SQL_QUERY('SELECT + `id`, `sender` AS `userid`, `subject`, `payment_id`, `cat_id` FROM `{?_MYSQL_PREFIX?}_pool` ORDER BY - `timestamp` ASC", __FILE__, __LINE__); + `timestamp` ASC', __FILE__, __LINE__); // Entries found? -if (SQL_NUMROWS($result) > 0) { +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,24 +94,20 @@ LIMIT 1", bigintval(postRequestParameter('id')), ), __FILE__, __LINE__); - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { $content = '{--SETTINGS_SAVED--}'; } else { - $content = '{--SETTINGS_NOT_SAVED--}'; + $content = '{--SETTINGS_NOT_SAVED--}'; } // Display message - loadTemplate('admin_settings_saved', false, $content); + displayMessage($content); } else { // There are mail orders available - $OUT = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { - // Add color swapping - $content['sw'] = $SW; - // Load row template and switch colors $OUT .= loadTemplate('admin_edit_email_row', true, $content); - $SW = 3 - $SW; } // END - while // Free memory @@ -118,7 +118,7 @@ LIMIT 1", } } else { // No mail orders left in pool - loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); + displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}'); } // [EOF]