X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-mem_add.php;h=008915782e6d8b9e7e0c531d431f37af28a8f1d5;hb=a6f5926aeaf7917cb4bca3d29ffd0e8e6290fb4e;hp=72b54fb70e4c44bc256f9f37af7b1160078e139c;hpb=d8148e3f1f3a6762b2e786dbe99ada269dcf2ea0;p=mailer.git diff --git a/inc/modules/admin/what-mem_add.php b/inc/modules/admin/what-mem_add.php index 72b54fb70e..008915782e 100644 --- a/inc/modules/admin/what-mem_add.php +++ b/inc/modules/admin/what-mem_add.php @@ -1,7 +1,7 @@ 0) { // Read menu structure - while (list($act, $title, $sort) = SQL_FETCHROW($result)) { + // @TODO Cant this be rewritten? + while ($content = SQL_FETCHARRAY($result)) { // Menu actions - $menus[] = $act; + $menus[] = $content['action']; // Menu titles - $titles[] = $title; + $titles[] = $content['title']; // Below this menu point should the new be added so we simply increase the sort value by 1 :-) - $below[] = $sort + 1; - } + $below[] = $content['sort'] + 1; + } // END - if // Free memory SQL_FREERESULT($result); // Remove double eintries - $prev = ""; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; + // @TODO This can be somehow rewritten to a function + $prev = ''; + $dmy = $menus; + $dmy2 = $titles; + $dmy3 = $below; foreach ($menus as $key => $value) { if ($value == $prev) { // Remove entries @@ -79,15 +91,15 @@ if (!IS_FORM_SENT()) { } else { $prev = $value; } - } + } // END - foreach // Prepare variables $menus = $dmy; $titles = $dmy2; $below = $dmy3; // Load sub menus :) foreach ($menus as $key_main => $value_main) { - $result = SQL_QUERY_ESC("SELECT what, title, sort FROM `{!_MYSQL_PREFIX!}_member_menu` WHERE `action`='%s' AND `what` != '' ORDER BY `sort`", - array($value_main), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT what, title, sort FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `action`='%s' AND `what` != '' ORDER BY `sort`", + array($value_main), __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Initialize arrays $menus[$value_main] = array(); @@ -95,22 +107,23 @@ if (!IS_FORM_SENT()) { $below[$value_main] = array(); // Read menu structure - while (list($act, $title, $sort) = SQL_FETCHROW($result)) { + while ($content = SQL_FETCHARRAY($result)) { // Menu actions - $menus[$value_main][] = $act; + $menus[$value_main][] = $content['what']; // Menu titles - $titles[$value_main][] = $title; + $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][] = $sort + 1; - } + $below[$value_main][] = $content['sort'] + 1; + } // END - while // Free memory SQL_FREERESULT($result); // Remove double eintries - $prev = ""; $dmy = $menus[$value_main]; $dmy2 = $titles[$value_main]; $dmy3 = $below[$value_main]; + // @TODO This can be somehow rewritten to a function + $prev = ''; $dmy = $menus[$value_main]; $dmy2 = $titles[$value_main]; $dmy3 = $below[$value_main]; foreach ($menus[$value_main] as $key => $value) { if ($value == $prev) { unset($dmy[$key]); @@ -119,64 +132,68 @@ if (!IS_FORM_SENT()) { } else { $prev = $value; } - } - $menus[$value_main] = $dmy; $titles[$value_main] = $dmy2; $below[$value_main] = $dmy3; - } - } - } + } // END - foreach + + // Transfer variables into array + $menus[$value_main] = $dmy; + $titles[$value_main] = $dmy2; + $below[$value_main] = $dmy3; + } // END - if + } // END - foreach + } // END - if $OUT = ""; - define('__BELOW_SELECTION' , $OUT); - define('__WHAT_SELECTION' , ADMIN_MAKE_MENU_SELECTION("member", "what", "name")); - define('__ACTION_SELECTION', ADMIN_MAKE_MENU_SELECTION("member", "action", "menu")); + // Prepare selection boxes for template + $content['below_selection'] = $OUT; + $content['what_selection'] = adminAddMenuSelectionBox('member', 'what' , 'name'); + $content['action_selection'] = adminAddMenuSelectionBox('member', 'action', 'menu'); // Display form - LOAD_TEMPLATE("admin_member_add"); -} elseif (!IS_DEMO()) { + loadTemplate('admin_member_add', false, $content); +} elseif (!isDemoModeActive()) { // Insert new menu entry - if (REQUEST_ISSET_POST(('menu'))) - { - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('%s','%s','%s','%s','%s','%s')", - array( - REQUEST_POST('menu'), - REQUEST_POST('name'), - REQUEST_POST('title'), - REQUEST_POST('visible'), - REQUEST_POST('active'), - bigintval(REQUEST_POST('sort')), -), __FILE__, __LINE__); + if (isPostRequestParameterSet('menu')) { + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('%s','%s','%s','%s','%s','%s')", + array( + postRequestParameter('menu'), + postRequestParameter('name'), + postRequestParameter('title'), + postRequestParameter('visible'), + postRequestParameter('active'), + bigintval(postRequestParameter('sort')), + ), __FILE__, __LINE__); } else { - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_member_menu` (`action`,`title`,`visible`,`locked`,`sort`) VALUES ('%s','%s','%s','%s','%s')", - array( - REQUEST_POST('name'), - REQUEST_POST('title'), - REQUEST_POST('visible'), - REQUEST_POST('active'), - bigintval(REQUEST_POST('sort')), -), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`title`,`visible`,`locked`,`sort`) VALUES ('%s','%s','%s','%s','%s')", + array( + postRequestParameter('name'), + postRequestParameter('title'), + postRequestParameter('visible'), + postRequestParameter('active'), + bigintval(postRequestParameter('sort')), + ), __FILE__, __LINE__); } - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED')); + loadTemplate('admin_settings_saved', false, getMessage('SETTINGS_SAVED')); } else { // Demo mode! - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_NOT_SAVED')); + loadTemplate('admin_settings_saved', false, getMessage('SETTINGS_NOT_SAVED')); } //