X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=abab32ca9bb617f7689dc028ce767a09e7e2ae22;hb=5b794a32b30ec5322765c89a22c4c27aece94a42;hp=cab32b931155914b10d6fbf57f8fb903b488b36c;hpb=7297440d795390abd70ddc339b1a81d34f76c953;p=mailer.git diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php index cab32b9311..abab32ca9b 100644 --- a/inc/modules/admin/what-refbanner.php +++ b/inc/modules/admin/what-refbanner.php @@ -17,7 +17,7 @@ * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * - * Copyright (c) 2003 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -37,40 +37,32 @@ ************************************************************************/ // Some security stuff... -if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; - require($INC); +if ((!defined('__SECURITY')) || (!isAdmin())) { + die(); } // Add description as navigation point -ADD_DESCR('admin', __FILE__); - -// Init variable -$SEL = 0; +addMenuDescription('admin', __FILE__); // Some sanity-check -if ((!REQUEST_ISSET_POST('url')) || (!REQUEST_ISSET_POST(('alternate')))) { - REQUEST_UNSET_POST('ok'); +if ((!isPostRequestElementSet('url')) || (!isPostRequestElementSet(('alternate')))) { + unsetPostRequestElement('ok'); } -// Check selection count -if (REQUEST_ISSET_POST('sel')) $SEL = countPostSelection(); - if (isFormSent()) { // Fix older calls from add-new-banner-form - if (!REQUEST_ISSET_GET('mode')) REQUEST_SET_GET('mode', 'add'); + if (!isGetRequestElementSet('mode')) setRequestGetElement('mode', 'add'); $sql = ''; - switch (REQUEST_GET('mode')) - { + switch (getRequestElement('mode')) { case 'add': // Check if banner is already added - $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE url='%s' LIMIT 1", - array(REQUEST_POST('url')), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) { + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE url='%s' LIMIT 1", + array(postRequestElement('url')), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == '0') { // Add banner - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_refbanner` (url, alternate, visible) + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_refbanner` (url, alternate, visible) VALUES ('%s','%s','%s')", - array(REQUEST_POST('url'), REQUEST_POST('alternate'), REQUEST_POST('visible')), __FILE__, __LINE__); + array(postRequestElement('url'), postRequestElement('alternate'), postRequestElement('visible')), __FILE__, __LINE__); } else { // Free memory SQL_FREERESULT($result); @@ -78,16 +70,16 @@ VALUES ('%s','%s','%s')", break; case 'edit': // Update banner - foreach (REQUEST_POST('sel') as $id => $sel) { - // Secure ID + foreach (postRequestElement('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", + 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'), + postRequestElement('url', $id), + postRequestElement('alternate', $id), + postRequestElement('visible'), $id ), __FILE__, __LINE__); } @@ -99,13 +91,13 @@ VALUES ('%s','%s','%s')", } else { $content = "{--SETTINGS_NOT_SAVED--}"; } - LOAD_TEMPLATE('admin_settings_saved', false, $content); -} elseif (($SEL > 0) && (REQUEST_ISSET_POST('edit'))) { + loadTemplate('admin_settings_saved', false, $content); +} elseif ((countPostSelection() > 0) && (isPostRequestElementSet('edit'))) { // Edit banner $SW = 2; $OUT = ''; - foreach (REQUEST_POST('sel') as $id => $sel) { + foreach (postRequestElement('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,30 +108,27 @@ 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) && (isPostRequestElementSet('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 (postRequestElement('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) { @@ -159,23 +148,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] ?>