X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guest_add.php;h=b17b369e97621c8fbc569331156813620b479e66;hp=4ebead8c23d00a840790437c8991dbaa1da8e94c;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=09f5758c42a33a56bdd461c946ffe759a59c54aa diff --git a/inc/modules/admin/what-guest_add.php b/inc/modules/admin/what-guest_add.php index 4ebead8c23..b17b369e97 100644 --- a/inc/modules/admin/what-guest_add.php +++ b/inc/modules/admin/what-guest_add.php @@ -14,12 +14,10 @@ * $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 * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2015 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -40,15 +38,15 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); // Check if the admin has entered title and what-php file name... -if (((!isPostRequestParameterSet('title')) || (!isPostRequestParameterSet('menu'))) && (isFormSent())) { +if (((!isPostRequestElementSet('title')) || (!isPostRequestElementSet('menu'))) && (isFormSent())) { // Abort adding the menu entry - unsetPostRequestParameter('ok'); + unsetPostRequestElement('ok'); } // END - if if (!isFormSent()) { @@ -56,7 +54,7 @@ if (!isFormSent()) { $menus = array(); $titles = array(); $below = array(); // Get all available main menus - $result = SQL_QUERY("SELECT + $result_menu = sqlQuery("SELECT `action`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_guest_menu` @@ -64,23 +62,21 @@ WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + + if (!ifSqlHasZeroNumRows($result_menu)) { // Read menu structure // @TODO Cant this be rewritten? - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result_menu)) { // Menu actions - $menus[] = $content['action']; + array_push($menus, $content['action']); // Menu titles - $titles[] = $content['title']; + array_push($titles, $content['title']); // Below this menu point should the new be added so we simply increase the sort value by 1 :-) - $below[] = $content['sort'] + 1; + array_push($below, $content['sort'] + 1); } // END - while - // Free memory - SQL_FREERESULT($result); - // Remove double eintries // @TODO This can be somehow rewritten to a function $prev = ''; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; @@ -102,7 +98,7 @@ ORDER BY // Load sub menus :) foreach ($menus as $key_main => $value_main) { // Query for sub menus - $result = SQL_QUERY_ESC("SELECT + $result = sqlQueryEscaped("SELECT `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_guest_menu` @@ -112,26 +108,24 @@ WHERE `what` IS NOT NULL ORDER BY `sort` ASC", array($value_main), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + + if (!ifSqlHasZeroNumRows($result)) { // Initialize arrays $menus[$value_main] = array(); $titles[$value_main] = array(); $below[$value_main] = array(); // Read menu structure - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result)) { // Menu actions - $menus[$value_main][] = $content['what']; + array_push($menus[$value_main], $content['what']); // Menu titles - $titles[$value_main][] = $content['title']; + array_push($titles[$value_main], $content['title']); // Below this menu point should the new be added so we simply increase the sort value by 1 :-) - $below[$value_main][] = $content['sort'] + 1; - } - - // Free memory - SQL_FREERESULT($result); + array_push($below[$value_main], $content['sort'] + 1); + } // END - while // Remove double eintries // @TODO This can be somehow rewritten to a function @@ -144,34 +138,40 @@ ORDER BY `sort` ASC", } else { $prev = $value; } - } + } // END - foreach // Transfer dummy array $menus[$value_main] = $dmy; $titles[$value_main] = $dmy2; $below[$value_main] = $dmy3; - } - } - } + } // END - if + + // Free memory + sqlFreeResult($result); + } // END - foreach + } // END - if + + // Free memory + sqlFreeResult($result_menu); - $OUT = " + '; foreach ($below as $key => $m) { if (is_array($m)) { foreach ($m as $key2 => $m2) { - $OUT .= " \n"; + $OUT .= ''; } } else { - $OUT .= " \n"; + $OUT .= ''; } } - $OUT .= ""; + $OUT .= ''; // Prepare selections for template $content['below_selection'] = $OUT; @@ -179,33 +179,33 @@ ORDER BY `sort` ASC", $content['action_selection'] = adminAddMenuSelectionBox('guest', 'action', 'menu'); // Display form - loadTemplate('admin_guest_add', false, $content); + loadTemplate('admin_add_guest_menu', FALSE, $content); } elseif (!isDemoModeActive()) { // Insert new menu entry - if (isPostRequestParameterSet('menu')) { - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('%s','%s','%s','%s','%s','%s')", + if (isPostRequestElementSet('menu')) { + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `what`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s','%s')", array( - postRequestParameter('menu'), - postRequestParameter('name'), - postRequestParameter('title'), - bigintval(postRequestParameter('sort')), - postRequestParameter('visible'), - postRequestParameter('active'), + postRequestElement('menu'), + postRequestElement('name'), + postRequestElement('title'), + bigintval(postRequestElement('sort')), + postRequestElement('visible'), + postRequestElement('active'), ), __FILE__, __LINE__); } else { - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s')", + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s')", array( - postRequestParameter('name'), - postRequestParameter('title'), - bigintval(postRequestParameter('sort')), - postRequestParameter('visible'), - postRequestParameter('active'), + postRequestElement('name'), + postRequestElement('title'), + bigintval(postRequestElement('sort')), + postRequestElement('visible'), + postRequestElement('active'), ), __FILE__, __LINE__); } - loadTemplate('admin_settings_saved', false, getMessage('SETTINGS_SAVED')); + displayMessage('{--SETTINGS_SAVED--}'); } else { // Demo mode! - loadTemplate('admin_settings_saved', false, getMessage('SETTINGS_NOT_SAVED')); + displayMessage('{--SETTINGS_NOT_SAVED--}'); } // [EOF]