X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=a157c80fd4bc1232abb7992a50a43261a81cd376;hp=1866e42f987fc2fde0cbe2ea9d9edb7735127259;hb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b;hpb=7b9f2d4c956e37c4c079c1e612ecd6a7947e7e05 diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php index 1866e42f98..a157c80fd4 100644 --- a/inc/modules/admin/what-refbanner.php +++ b/inc/modules/admin/what-refbanner.php @@ -10,9 +10,14 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Alle Banner fuer die Ref-Links verwalten * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 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 * @@ -32,71 +37,74 @@ ************************************************************************/ // 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__); +addMenuDescription('admin', __FILE__); // Init variable -$SEL = 0; +$SEL = '0'; // Some sanity-check -if ((empty($_POST['url'])) || (empty($_POST['alternate']))) { - unset($_POST['ok']); +if ((!isPostRequestElementSet('url')) || (!isPostRequestElementSet(('alternate')))) { + unsetPostRequestElement('ok'); } // Check selection count -if (!empty($_POST['sel'])) $SEL = SELECTION_COUNT($_POST['sel']); +if (isPostRequestElementSet('sel')) $SEL = countPostSelection(); -if (isset($_POST['ok'])) { +if (isFormSent()) { // Fix older calls from add-new-banner-form - if (empty($_GET['mode'])) $_GET['mode'] = "add"; - $SQL = ""; - switch ($_GET['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($_POST['url']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) { - // Add banner - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_refbanner` (url, alternate, visible) + if (!isGetRequestElementSet('mode')) setRequestGetElement('mode', 'add'); + $sql = ''; + 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(postRequestElement('url')), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == '0') { + // Add banner + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_refbanner` (url, alternate, visible) VALUES ('%s','%s','%s')", - array($_POST['url'], $_POST['alternate'], $_POST['visible']), __FILE__, __LINE__); - } else { - // Free memory - SQL_FREERESULT($result); - } - break; - - case "edit": // Update banner - foreach ($_POST['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($_POST['url'][$id], $_POST['alternate'][$id], $_POST['visible'], $id), __FILE__, __LINE__); - } - break; + array(postRequestElement('url'), postRequestElement('alternate'), postRequestElement('visible')), __FILE__, __LINE__); + } else { + // Free memory + SQL_FREERESULT($result); + } + break; + + case 'edit': // Update banner + 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", + array( + postRequestElement('url', $id), + postRequestElement('alternate', $id), + postRequestElement('visible'), + $id + ), __FILE__, __LINE__); + } + break; } if (SQL_AFFECTEDROWS() == 1) { - $content = SETTINGS_SAVED; + $content = getMessage('SETTINGS_SAVED'); } else { $content = "{--SETTINGS_NOT_SAVED--}"; } - LOAD_TEMPLATE("admin_settings_saved", false, $content); -} elseif (($SEL > 0) && (isset($_POST['edit']))) { + loadTemplate('admin_settings_saved', false, $content); +} elseif (($SEL > 0) && (isPostRequestElementSet('edit'))) { // Edit banner - $SW = ""; $OUT = ""; - foreach ($_POST['sel'] as $id => $sel) { + $SW = 2; $OUT = ''; + 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", - array(bigintval($id)), __FILE__, __LINE__); + $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); @@ -106,62 +114,60 @@ 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; } - define('__BANNER_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_refbanner_edit"); + loadTemplate('admin_refbanner_edit', false, $OUT); } else { - if (($SEL > 0) && (isset($_POST['del']))) - { + if (($SEL > 0) && (isPostRequestElementSet('del'))) { // Delete banner - foreach ($_POST['sel'] as $id => $sel) { - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - } + 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__); - if (SQL_NUMROWS($result) > 0) - { + $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 - $SW = 2; $OUT = ""; - while (list($id, $url, $alt, $vis, $cntr, $clks) = SQL_FETCHROW($result)) - { + $OUT = ''; $SW = 2; + while ($content = SQL_FETCHARRAY($result)) { // Preapre data for the row + // @TODO Rewritings: alt->alternate,cnt->counter,clx->clicks in template $content = array( 'sw' => $SW, - 'id' => $id, - 'url' => $url, - 'alt' => $alt, - 'vis' => TRANSLATE_YESNO($vis), - 'cnt' => $cntr, - 'clx' => $clks + 'id' => $content['id'], + 'url' => $content['url'], + 'alt' => $content['alternate'], + 'vis' => translateYesNo($content['visible']), + 'cnt' => $content['counter'], + 'clx' => $content['clicks'] ); // 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); - 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] ?>