Portions created by the Initial Developer are Copyright (C) 2008-2012 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ include "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; if (permission_exists('menu_edit')) { //access granted } else { echo "access denied"; return; } //add multi-lingual support $language = new text; $text = $language->get(); //move down more than one level at a time //update v_menu_items set menu_order = (menu_order+1) where menu_order > 2 or menu_order = 2 if (count($_GET)>0) { $menu_item_id = $_GET["menu_item_id"]; $menu_order = $_GET["menu_order"]; if ($menu_order != 1) { //clear the menu session so it will rebuild with the update $_SESSION["menu"] = ""; //move the current item's order number down $sql = "update v_menu_items set "; $sql .= "menu_order = (menu_order + 1) "; //move down $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and menu_order = :menu_order "; $parameters['domain_uuid'] = $domain_uuid; $parameters['menu_order'] = $menu_order - 1; $database = new database; $database->app_name = 'menu'; $database->app_uuid = 'f4b3b3d2-6287-489c-2a00-64529e46f2d7'; $database->execute($sql, $parameters); unset($sql, $parameters); //move the selected item's order number up $sql = "update v_menu_items set "; $sql .= "menu_order = (menu_order - 1) "; //move up $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and menu_item_id = :menu_item_id "; $parameters['domain_uuid'] = $domain_uuid; $parameters['menu_item_id'] = $menu_item_id; $database = new database; $database->app_name = 'menu'; $database->app_uuid = 'f4b3b3d2-6287-489c-2a00-64529e46f2d7'; $database->execute($sql, $parameters); unset($sql, $parameters); //set message message::add($text['message-moved_up']); } //redirect the user header("Location: menu_list.php?menu_item_id=".$menu_item_id); return; } ?>