X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=71f5ad53c76844f68e79cc77775817ab77c9e67a;hb=b6a10f5ccfe2ff6e9e5c43f42e33966ae25ffbaa;hp=8be4f99466c24678cd55411f19d323f0fb09a760;hpb=5b8d588fdbfa375fa859ca80a9b9e1735a13300e;p=mailer.git diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php index 8be4f99466..71f5ad53c7 100644 --- a/inc/modules/admin/what-refbanner.php +++ b/inc/modules/admin/what-refbanner.php @@ -1,7 +1,7 @@ $sel) { - // Secure ID + foreach (postRequestParameter('sel') as $id => $sel) { + // Secure id $id = bigintval($id); // Update entry - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET url='%s', alternate='%s', `visible`='%s' WHERE `id`=%s LIMIT 1", - array( - REQUEST_POST('url', $id), - REQUEST_POST('alternate', $id), - REQUEST_POST('visible'), - $id - ), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET url='%s', alternate='%s', `visible`='%s' WHERE `id`=%s LIMIT 1", + array( + postRequestParameter('url', $id), + postRequestParameter('alternate', $id), + postRequestParameter('visible'), + $id + ), __FILE__, __LINE__); } break; } + // Check if we have saved (updated) if (SQL_AFFECTEDROWS() == 1) { + // Updated! $content = getMessage('SETTINGS_SAVED'); } else { - $content = "{--SETTINGS_NOT_SAVED--}"; + // Nothing has been updated + $content = '{--SETTINGS_NOT_SAVED--}'; } - LOAD_TEMPLATE('admin_settings_saved', false, $content); -} elseif (($SEL > 0) && (REQUEST_ISSET_POST('edit'))) { + + // Display message + loadTemplate('admin_settings_saved', false, $content); +} elseif ((countPostSelection() > 0) && (isPostRequestParameterSet('edit'))) { // Edit banner $SW = 2; $OUT = ''; - foreach (REQUEST_POST('sel') as $id => $sel) { + foreach (postRequestParameter('sel') as $id => $sel) { // Load data - $result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); list($url, $alt, $vis) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -116,31 +114,29 @@ VALUES ('%s','%s','%s')", 'id' => $id, 'url' => $url, 'alt' => $alt, - 'vis' => ADD_SELECTION('yn', $vis , "visible"), + 'vis' => addSelectionBox('yn', $vis , 'visible'), ); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_refbanner_edit_row", true, $content); + $OUT .= loadTemplate('admin_refbanner_edit_row', true, $content); $SW = 3 - $SW; } - // @TODO Rewrite this constant - define('__BANNER_ROWS', $OUT); - // Load main template - LOAD_TEMPLATE("admin_refbanner_edit"); + loadTemplate('admin_refbanner_edit', false, $OUT); } else { - if (($SEL > 0) && (REQUEST_ISSET_POST('del'))) { + if ((countPostSelection() > 0) && (isPostRequestParameterSet('del'))) { // Delete banner - foreach (REQUEST_POST('sel') as $id => $sel) { - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `id`=%s LIMIT 1", + foreach (postRequestParameter('sel') as $id => $sel) { + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - } - } + } // END - foreach + } // END - if // Referal levels - $result = SQL_QUERY("SELECT id, url, alternate, visible, counter, clicks FROM `{!_MYSQL_PREFIX!}_refbanner` ORDER BY url", - __FILE__, __LINE__); + $result = SQL_QUERY("SELECT id, url, alternate, visible, counter, clicks FROM `{?_MYSQL_PREFIX?}_refbanner` ORDER BY url", __FILE__, __LINE__); + + // Entries found? if (SQL_NUMROWS($result) > 0) { // Make referal banner editable and deletable $OUT = ''; $SW = 2; @@ -158,23 +154,20 @@ VALUES ('%s','%s','%s')", ); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_refbanner_row", true, $content); + $OUT .= loadTemplate('admin_refbanner_row', true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result); - // @TODO Rewrite this constant - define('__BANNER_ROWS', $OUT); - // Load main template - LOAD_TEMPLATE("admin_refbanner"); + loadTemplate('admin_refbanner', false, $OUT); } // Form for adding new referal levels - LOAD_TEMPLATE("admin_add_banner"); + loadTemplate('admin_add_banner'); } -// +// [EOF] ?>