X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guest_add.php;h=423415b7bb8d1d9cb3c3756527066c5bdca5980a;hp=460cbb0e815621a77cbf48810bb18409675e6fdd;hb=04b69ac9f33369cbf654396c4a42cb1fff710ff4;hpb=5ef6ed7373ae85e5635e39e2a0adf9496a8add05 diff --git a/inc/modules/admin/what-guest_add.php b/inc/modules/admin/what-guest_add.php index 460cbb0e81..423415b7bb 100644 --- a/inc/modules/admin/what-guest_add.php +++ b/inc/modules/admin/what-guest_add.php @@ -1,7 +1,7 @@
"); -OPEN_TABLE("100%", "admin_content admin_content_align", ""); +// Add description as navigation point +addMenuDescription('admin', __FILE__); // Check if the admin has entered title and what-php file name... -if (((empty($_POST['title'])) || (empty($_POST['menu']))) && (isset($_POST['ok']))) -{ - unset($_POST['ok']); -} +if (((!isPostRequestParameterSet('title')) || (!isPostRequestParameterSet('menu'))) && (isFormSent())) { + // Abort adding the menu entry + unsetPostRequestParameter('ok'); +} // END - if -if (!isset($_POST['ok'])) -{ +if (!isFormSent()) { // Create arrays $menus = array(); $titles = array(); $below = array(); // Get all available main menus - $result = SQL_QUERY("SELECT action, title, sort FROM "._MYSQL_PREFIX."_guest_menu WHERE what='' ORDER BY sort", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = 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_NUMROWS($result) > 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 - while // Free memory SQL_FREERESULT($result); // Remove double eintries - $prev = ""; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; - foreach ($menus as $key=>$value) - { - if ($value == $prev) - { + // @TODO This can be somehow rewritten to a function + $prev = ''; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below; + foreach ($menus as $key => $value) { + if ($value == $prev) { unset($dmy[$key]); unset($dmy2[$key]); unset($dmy3[$key]); - } - else - { + } else { $prev = $value; } } - $menus = $dmy; $titles = $dmy2; $below = $dmy3; + + // Init 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."_guest_menu -WHERE action='%s' AND what != '' ORDER BY sort", - array(bigintval($value_main)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + foreach ($menus as $key_main => $value_main) { + // 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) { // Initialize arrays $menus[$value_main] = array(); $titles[$value_main] = array(); $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; } // Free memory SQL_FREERESULT($result); // Remove double eintries - $prev = ""; $dmy = $menus[$value_main]; $dmy2 = $titles[$value_main]; $dmy3 = $below[$value_main]; - foreach ($menus[$value_main] as $key=>$value) - { - if ($value == $prev) - { + // @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]); unset($dmy2[$key]); unset($dmy3[$key]); - } - else - { + } else { $prev = $value; } } - $menus[$value_main] = $dmy; $titles[$value_main] = $dmy2; $below[$value_main] = $dmy3; + + // 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 .= "\n"; } - } - else - { - $OUT .= " \n"; + } else { + $OUT .= " \n"; } } - $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_guest_add', false, $content); +} elseif (!isDemoModeActive()) { // Insert new menu entry - if (!empty($_POST['menu'])) - { - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_guest_menu -(action, what, title, sort, visible, locked) -VALUES('%s', '%s', '%s', '%s', '%s', '%s')", - array( - $_POST['menu'], - $_POST['name'], - $_POST['title'], - bigintval($_POST['sort']), - $_POST['visible'], - $_POST['active'], -), __FILE__, __LINE__); - } - else - { - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_guest_menu -(action, title, sort, visible, locked) -VALUES('%s', '%s', '%s', '%s', '%s')", - array( - $_POST['name'], - $_POST['title'], - bigintval($_POST['sort']), - $_POST['visible'], - $_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( + postRequestParameter('name'), + postRequestParameter('title'), + bigintval(postRequestParameter('sort')), + postRequestParameter('visible'), + postRequestParameter('active'), + ), __FILE__, __LINE__); } - LOAD_TEMPLATE("admin_settings_saved", false, SAVING_DONE); -} - else -{ + loadTemplate('admin_settings_saved', false, '{--SETTINGS_SAVED--}'); +} else { // Demo mode! - LOAD_TEMPLATE("admin_settings_saved", false, SETTINGS_NOT_SAVED); + loadTemplate('admin_settings_saved', false, '{--SETTINGS_NOT_SAVED--}'); } -CLOSE_TABLE(); -// +// [EOF] ?>