X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-admin_add.php;h=d9a9a59155313607d3a6bb462d3e118e0d34c640;hp=fa44c2de380af8a0ece0ccf0876240d565493d43;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=143e78d4231adddd9e706cbf55ec5dd8c1651890 diff --git a/inc/modules/admin/what-admin_add.php b/inc/modules/admin/what-admin_add.php index fa44c2de38..d9a9a59155 100644 --- a/inc/modules/admin/what-admin_add.php +++ b/inc/modules/admin/what-admin_add.php @@ -1,7 +1,7 @@ 0) - { + $result = sqlQuery("SELECT `action`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); + if (!ifSqlHasZeroNumRows($result)) { // Read menu structure - while (list($act, $title, $sort) = SQL_FETCHROW($result)) - { + // @TODO Cant this be rewritten? + while ($content = sqlFetchArray($result)) { // Menu actions - $menus[] = $act; + array_push($menus, $content['action']); // Menu titles - $titles[] = $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[] = $sort + 1; - } + array_push($below, $content['sort'] + 1); + } // END - while // Free memory - SQL_FREERESULT($result); + sqlFreeResult($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; + } // END - foreach + + // Write dummys back to our array + $menus = $dmy; unset($dmy); + $titles = $dmy2; unset($dmy2); + $below = $dmy3; unset($dmy3); + // Load sub menus :) - foreach ($menus as $key_main => $value_main) - { - $result = SQL_QUERY_ESC("SELECT what, title, sort FROM "._MYSQL_PREFIX."_admin_menu WHERE action='%s' AND what != '' AND what IS NOT NULL ORDER BY sort", - array($value_main), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + foreach ($menus as $key_main => $value_main) { + $result = sqlQueryEscaped("SELECT `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", + array($value_main), __FILE__, __LINE__); + if (!ifSqlHasZeroNumRows($result)) { + // Init 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 = sqlFetchArray($result)) { // Menu actions - $menus[$value_main][] = $act; + array_push($menus[$value_main], $content['what']); // Menu titles - $titles[$value_main][] = $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][] = $sort + 1; - } + array_push($below[$value_main], $content['sort'] + 1); + } // END - while // Free memory - SQL_FREERESULT($result); + sqlFreeResult($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; - } + } // END - foreach + $menus[$value_main] = $dmy; + $titles[$value_main] = $dmy2; + $below[$value_main] = $dmy3; + } // END - if + } // END - foreach + } // END - if + + $OUT = ' - \n"; - foreach ($below as $key => $m) - { - if (is_array($m)) - { - foreach ($m as $key2 => $m2) - { - $OUT .= " \n"; - } - } - else - { - $OUT .= " \n"; - } - } - $OUT .= ""; + $OUT .= ''; - define('__BELOW_SELECTION' , $OUT); - define('__WHAT_SELECTION' , ADMIN_MAKE_MENU_SELECTION("admin", "what", "name")); - define('__ACTION_SELECTION', ADMIN_MAKE_MENU_SELECTION("admin", "action", "menu")); + // Prepare selections for template + $content['below_selection'] = $OUT; + $content['what_selection'] = adminAddMenuSelectionBox('admin', 'what' , 'name'); + $content['action_selection'] = adminAddMenuSelectionBox('admin', 'action', 'menu'); // Display form - LOAD_TEMPLATE("admin_admin_add"); -} - elseif (!IS_DEMO()) -{ + loadTemplate('admin_add_admin_menu', FALSE, $content); +} elseif (!isDemoModeActive()) { // Insert new menu entry - if (!empty($_POST['menu'])) - { + if (isPostRequestElementSet('menu')) { // Add sub menu - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) -VALUES('%s','%s','%s','%s','%s')", - array( - $_POST['menu'], - $_POST['name'], - $_POST['title'], - addslashes($_POST['descr']), - bigintval($_POST['sort']), -), __FILE__, __LINE__); - CACHE_PURGE_ADMIN_MENU(0, $_POST['menu'], $_POST['name']); - } - else - { + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`, `what`, `title`, `descr`, `sort`) VALUES ('%s','%s','%s','%s','%s')", + array( + postRequestElement('menu'), + postRequestElement('name'), + postRequestElement('title'), + postRequestElement('descr'), + bigintval(postRequestElement('sort')), + ), __FILE__, __LINE__ + ); + } else { // Add main menu - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, title, descr, sort) -VALUES('%s','%s','%s','%s')", - array( - $_POST['name'], - $_POST['title'], - addslashes($_POST['descr']), - bigintval($_POST['sort']), -), __FILE__, __LINE__); - CACHE_PURGE_ADMIN_MENU(0, $_POST['name']); + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (action, title, descr, sort) VALUES ('%s','%s','%s','%s')", + array( + postRequestElement('name'), + postRequestElement('title'), + postRequestElement('descr'), + bigintval(postRequestElement('sort')), + ), __FILE__, __LINE__ + ); } - LOAD_TEMPLATE("admin_settings_saved", false, SAVING_DONE); -} - else -{ + displayMessage('{--SETTINGS_SAVED--}'); +} else { // Is demo login! - LOAD_TEMPLATE("admin_settings_saved", false, SETTINGS_NOT_SAVED); + displayMessage('{--SETTINGS_NOT_SAVED--}'); } -// +// [EOF] ?>