X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-adminedit.php;h=19af03ec6d25286e9987319ba5ac6e590c4cb076;hb=9d3e47c8ab6ff3ab7efca2a968d66a5ccf76728d;hp=624a78b5e6ceeafcde6a2c6544e62716db0c64d9;hpb=508228c85fba8448d00865b1639cb8cd7a69e457;p=mailer.git diff --git a/inc/modules/admin/what-adminedit.php b/inc/modules/admin/what-adminedit.php index 624a78b5e6..19af03ec6d 100644 --- a/inc/modules/admin/what-adminedit.php +++ b/inc/modules/admin/what-adminedit.php @@ -10,7 +10,7 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Das Admin-Menue editieren * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * + * $Revision:: $ * * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * @@ -38,24 +38,24 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } // Add description as navigation point -ADD_DESCR("admin", __FILE__); +ADD_DESCR('admin', __FILE__); // Do we edit/delete/change main menus or sub menus? -$AND = "(`what` = '' OR `what` IS NULL)"; $SUB = ""; -if (REQUEST_ISSET_GET(('sub'))) +$AND = "(`what` = '' OR `what` IS NULL)"; $SUB = ''; +if (REQUEST_ISSET_GET('sub')) { - $AND = sprintf("action='%s' AND `what` IS NOT NULL", REQUEST_GET(('sub'))); - $SUB = REQUEST_GET(('sub')); + $AND = sprintf("`action`='%s' AND `what` IS NOT NULL", REQUEST_GET('sub')); + $SUB = REQUEST_GET('sub'); } // Get count of (maybe) selected menu points $chk = 0; -if (REQUEST_ISSET_POST('sel')) $chk = SELECTION_COUNT(REQUEST_POST('sel')); +if (REQUEST_ISSET_POST('sel')) $chk = countPostSelection(); // List all menu points and make them editable if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { @@ -69,7 +69,7 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { { $cnt++; $result = SQL_QUERY_ESC("SELECT title, action, what, descr FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1", - array(bigintval($sel)), __FILE__, __LINE__); + array(bigintval($sel)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Entry found so we load the stuff... @@ -78,8 +78,8 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { // Prepare data for the row template $content = array( - 'action' => ADMIN_MAKE_MENU_SELECTION("admin", "action", "sel_action[".$sel."]", $act), - 'what' => ADMIN_MAKE_MENU_SELECTION("admin", "what", "sel_what[".$sel."]", $wht), + 'action' => ADMIN_MAKE_MENU_SELECTION('admin', "action", "sel_action[".$sel."]", $act), + 'what' => ADMIN_MAKE_MENU_SELECTION('admin', "what", "sel_what[".$sel."]", $wht), 'sw' => $SW, 'sel' => $sel, 'menu' => $menu, @@ -88,7 +88,7 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { ); $OUT .= LOAD_TEMPLATE("admin_amenu_edit_row", true, $content); } - else + else { // Entry not found? $content = array( @@ -106,19 +106,19 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { // Load template LOAD_TEMPLATE("admin_amenu_edit_form"); } - elseif ((REQUEST_ISSET_POST('del')) && (!IS_DEMO())) +elseif ((REQUEST_ISSET_POST('del')) && (!IS_DEMO())) { define('__SUB_VALUE', $SUB); define('__CHK_VALUE', $chk); // Del menu entries with or without confirmation - $SW = 2; $cnt = 0; $OUT = ""; + $SW = 2; $cnt = 0; $OUT = ''; foreach (REQUEST_POST('sel') as $sel => $confirm) { if ($confirm == 1) { $cnt++; $result = SQL_QUERY_ESC("SELECT title FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1", - array(bigintval($sel)), __FILE__, __LINE__); + array(bigintval($sel)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Entry found so we load the stuff... @@ -134,7 +134,7 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { ); $OUT .= LOAD_TEMPLATE("admin_amenu_delete_row", true, $content); } - else + else { // Entry not found? $content = array( @@ -155,72 +155,72 @@ if ((REQUEST_ISSET_POST('edit')) && ($chk > 0) && (!IS_DEMO())) { // An action is done... switch (REQUEST_POST('ok')) { - case "edit": // Edit menu - foreach (REQUEST_POST('sel') as $sel => $menu) { - // Secure ID - $sel = bigintval($sel); + case 'edit': // Edit menu + foreach (REQUEST_POST('sel') as $sel => $menu) { + // Secure ID + $sel = bigintval($sel); - // Update entry - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET + // Update entry + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET title='%s', -action='%s', -what='%s', +`action`='%s', +`what`='%s', descr='%s' WHERE ".$AND." AND id=%s LIMIT 1", - array( - $menu, - REQUEST_POST('sel_action', $sel), - REQUEST_POST('sel_what', $sel), - REQUEST_POST('sel_desc', $sel), - $sel, -), __FILE__, __LINE__); - } + array( + $menu, + REQUEST_POST('sel_action', $sel), + REQUEST_POST('sel_what', $sel), + REQUEST_POST('sel_desc', $sel), + $sel, + ), __FILE__, __LINE__); + } - // Purge admin menu cache - CACHE_PURGE_ADMIN_MENU(0, REQUEST_POST('sel_action', $sel), REQUEST_POST('sel_what', $sel)); + // Purge admin menu cache + cachePurgeAdminMenu(0, REQUEST_POST('sel_action', $sel), REQUEST_POST('sel_what', $sel)); - // Load template - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED')); - break; + // Load template + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('SETTINGS_SAVED')); + break; - case "del": // Delete menu - foreach (REQUEST_POST('sel') as $sel => $menu) { - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1", + case 'del': // Delete menu + foreach (REQUEST_POST('sel') as $sel => $menu) { + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE ".$AND." AND id=%s LIMIT 1", array(bigintval($sel)), __FILE__, __LINE__); - CACHE_PURGE_ADMIN_MENU(0, "", "", $AND); - } // END - foreach + cachePurgeAdminMenu(0, '', '', $AND); + } // END - foreach - // Load template - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('SETTINGS_SAVED')); - break; + // Load template + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('SETTINGS_SAVED')); + break; - default: // Unexpected action - DEBUG_LOG(__FILE__, __LINE__, sprintf("Unsupported action %s detected.", REQUEST_POST('ok'))); - define('__OK_VALUE', REQUEST_POST('ok')); - LOAD_TEMPLATE("admin_menu_unknown_okay"); - break; + default: // Unexpected action + DEBUG_LOG(__FILE__, __LINE__, sprintf("Unsupported action %s detected.", REQUEST_POST('ok'))); + define('__OK_VALUE', REQUEST_POST('ok')); + LOAD_TEMPLATE("admin_menu_unknown_okay"); + break; } } else { if ((REQUEST_ISSET_GET(('act'))) && (REQUEST_ISSET_GET(('tid'))) && (REQUEST_ISSET_GET(('fid')))) { // Get IDs if (REQUEST_ISSET_GET(('w'))) { // Sub menus selected - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1", - array(REQUEST_GET('act'), bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1", + array(REQUEST_GET('act'), bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__); list($tid) = SQL_FETCHROW($result); SQL_FREERESULT($result); - $result = SQL_QUERY("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1", - array(REQUEST_GET('act'), bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__); + $result = SQL_QUERY("SELECT `id` FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `sort`='%s' LIMIT 1", + array(REQUEST_GET('act'), bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__); list($fid) = SQL_FETCHROW($result); SQL_FREERESULT($result); } else { // Main menu selected - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (what='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1", - array(bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1", + array(bigintval(REQUEST_GET('tid'))), __FILE__, __LINE__); list($tid) = SQL_FETCHROW($result); SQL_FREERESULT($result); - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (what='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1", - array(bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) AND `sort`='%s' LIMIT 1", + array(bigintval(REQUEST_GET('fid'))), __FILE__, __LINE__); list($fid) = SQL_FETCHROW($result); SQL_FREERESULT($result); } @@ -228,10 +228,10 @@ WHERE ".$AND." AND id=%s LIMIT 1", if ((!empty($tid)) && (!empty($fid))) { // Sort menu SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1", - array(bigintval(REQUEST_GET('tid')), bigintval($fid)), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('tid')), bigintval($fid)), __FILE__, __LINE__); SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1", - array(bigintval(REQUEST_GET('fid')), bigintval($tid)), __FILE__, __LINE__); - CACHE_PURGE_ADMIN_MENU(0, "", "", $AND); + array(bigintval(REQUEST_GET('fid')), bigintval($tid)), __FILE__, __LINE__); + cachePurgeAdminMenu(0, '', '', $AND); } } @@ -239,10 +239,10 @@ WHERE ".$AND." AND id=%s LIMIT 1", if (!empty($SUB)) { // Sub menus of a main menu $result = SQL_QUERY_ESC("SELECT id, action, what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", - array($SUB), __FILE__, __LINE__); + array($SUB), __FILE__, __LINE__); } else { // Main menus - $result = SQL_QUERY("SELECT id, action, what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (what='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT id, action, what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); } $max = SQL_NUMROWS($result); @@ -251,7 +251,7 @@ WHERE ".$AND." AND id=%s LIMIT 1", define('__SUB_VALUE', $SUB); // Init variables - $OUT = ""; $SW = 2; $cnt = 0; + $OUT = ''; $SW = 2; $cnt = 0; // Process all entries while ($content = SQL_FETCHARRAY($result)) { @@ -259,7 +259,7 @@ WHERE ".$AND." AND id=%s LIMIT 1", $cnt++; // Init navigation variable - $content['navi'] = ""; + $content['navi'] = ''; if (($content['sort'] == 0) || (($content['sort'] == 1) && (!empty($SUB)))) { // Is highest position $content['navi'] = "{--LOWER--}"; @@ -278,7 +278,7 @@ WHERE ".$AND." AND id=%s LIMIT 1", // Add more data to $content $content['sw'] = $SW; - $content['mode'] = "admin"; + $content['mode'] = 'admin'; // Load row template and switch colors $OUT .= LOAD_TEMPLATE("admin_menu_overview_row", true, $content); @@ -295,7 +295,7 @@ WHERE ".$AND." AND id=%s LIMIT 1", LOAD_TEMPLATE("admin_amenu_edit"); } else { // Menu entries are missing... (???) - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NO_MENUS_FOUND')); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_MENUS_FOUND')); } }