X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guest_add.php;h=25949845ca7e2c983a5ccd11528df401ed66c0ed;hp=7824b6b7693c5f5534ddcc7a97d42dbba10cc85d;hb=e8ca54fe91872ab95a6ffdc4f1268bf18889021d;hpb=e01fcf1ca8ddeb72af76465df3ef72301a1cdae7 diff --git a/inc/modules/admin/what-guest_add.php b/inc/modules/admin/what-guest_add.php index 7824b6b769..25949845ca 100644 --- a/inc/modules/admin/what-guest_add.php +++ b/inc/modules/admin/what-guest_add.php @@ -1,7 +1,7 @@ 0) { + $result_menu = SQL_QUERY("SELECT + `action`, `title`, `sort` +FROM + `{?_MYSQL_PREFIX?}_guest_menu` +WHERE + (`what`='' OR `what` IS NULL) +ORDER BY + `sort` ASC", __FILE__, __LINE__); + if (!SQL_HASZERONUMS($result_menu)) { // Read menu structure - while ($content = SQL_FETCHARRAY($result)) { + // @TODO Cant this be rewritten? + while ($content = SQL_FETCHARRAY($result_menu)) { // Menu actions $menus[] = $content['action']; @@ -68,14 +74,11 @@ if (!IS_FORM_SENT()) { // Below this menu point should the new be added so we simply increase the sort value by 1 :-) $below[] = $content['sort'] + 1; - } - - // Free memory - SQL_FREERESULT($result); + } // END - while // Remove double eintries // @TODO This can be somehow rewritten to a function - $prev = ""; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; + $prev = ''; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; foreach ($menus as $key => $value) { if ($value == $prev) { unset($dmy[$key]); @@ -93,11 +96,18 @@ if (!IS_FORM_SENT()) { // Load sub menus :) foreach ($menus as $key_main => $value_main) { - $result = SQL_QUERY_ESC("SELECT what, title, sort -FROM `{!_MYSQL_PREFIX!}_guest_menu` -WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort`", + // Query for sub menus + $result = SQL_QUERY_ESC("SELECT + `what`, `title`, `sort` +FROM + `{?_MYSQL_PREFIX?}_guest_menu` +WHERE + `action`='%s' AND + `what` != '' AND + `what` IS NOT NULL +ORDER BY `sort` ASC", array($value_main), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { + if (!SQL_HASZERONUMS($result)) { // Initialize arrays $menus[$value_main] = array(); $titles[$value_main] = array(); @@ -106,21 +116,18 @@ WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort`", // Read menu structure while ($content = SQL_FETCHARRAY($result)) { // Menu actions - $menus[$value_main][] = $content['action']; + $menus[$value_main][] = $content['what']; // Menu titles $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); + } // END - while // Remove double eintries // @TODO This can be somehow rewritten to a function - $prev = ""; $dmy = $menus[$value_main]; $dmy2 = $titles[$value_main]; $dmy3 = $below[$value_main]; + $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]); @@ -129,73 +136,75 @@ WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort`", } else { $prev = $value; } - } + } // END - foreach // Transfer dummy array $menus[$value_main] = $dmy; $titles[$value_main] = $dmy2; $below[$value_main] = $dmy3; - } - } - } - - $OUT = " + '; + foreach ($below as $key => $m) { + if (is_array($m)) { + foreach ($m as $key2 => $m2) { + $OUT .= '\n"; + $OUT .= ''; } } else { - $OUT .= " \n"; + $OUT .= ''; } } - $OUT .= ""; + $OUT .= ''; - define('__BELOW_SELECTION' , $OUT); - define('__WHAT_SELECTION' , ADMIN_MAKE_MENU_SELECTION("guest", "what", "name")); - define('__ACTION_SELECTION', ADMIN_MAKE_MENU_SELECTION("guest", "action", "menu")); + // Prepare selections for template + $content['below_selection'] = $OUT; + $content['what_selection'] = adminAddMenuSelectionBox('guest', 'what' , 'name'); + $content['action_selection'] = adminAddMenuSelectionBox('guest', 'action', 'menu'); // Display form - LOAD_TEMPLATE("admin_guest_add"); -} elseif (!IS_DEMO()) { + loadTemplate('admin_add_guest_menu', false, $content); +} elseif (!isDemoModeActive()) { // Insert new menu entry - if (REQUEST_ISSET_POST(('menu'))) { - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('%s','%s','%s','%s','%s','%s')", - array( - REQUEST_POST('menu'), - REQUEST_POST('name'), - REQUEST_POST('title'), - bigintval(REQUEST_POST('sort')), - REQUEST_POST('visible'), - REQUEST_POST('active'), -), __FILE__, __LINE__); + 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')", + array( + postRequestParameter('menu'), + postRequestParameter('name'), + postRequestParameter('title'), + bigintval(postRequestParameter('sort')), + postRequestParameter('visible'), + postRequestParameter('active'), + ), __FILE__, __LINE__); } else { - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_guest_menu` (action, title, sort, visible, locked) VALUES ('%s','%s','%s','%s','%s')", - array( - REQUEST_POST('name'), - REQUEST_POST('title'), - bigintval(REQUEST_POST('sort')), - REQUEST_POST('visible'), - REQUEST_POST('active'), -), __FILE__, __LINE__); + SQL_QUERY_ESC("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'), + ), __FILE__, __LINE__); } - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED')); + loadTemplate('admin_settings_saved', false, '{--SETTINGS_SAVED--}'); } else { // Demo mode! - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_NOT_SAVED')); + loadTemplate('admin_settings_saved', false, '{--SETTINGS_NOT_SAVED--}'); } -// +// [EOF] ?>