function deleteMenuItem($id) { $item = is_object($id) ? $id : AROMenuItem::finder()->byPK($id); foreach ($item->getMenuItems() as $sitem) { deleteMenuItem($sitem); } $GLOBALS['db']->delete('menu_items', 'id = ' . $item->id); }
function deleteMenu($id) { $items = getMenuItems($id); foreach ($items as $i) { deleteMenuItem($i["id"]); } global $wpdb; $SQL = "DELETE FROM " . $wpdb->prefix . "menus WHERE id={$id}"; $wpdb->query($SQL); }
$listQuery = "SELECT tMenu.MenuID, tMenu.MenuName, tMenu.PagePath, tMenu.Sequence, tMenu.RequiresAuthentication, tParentMenu.MenuName, tMenu.Color, tMenu.QueryString FROM tMenu left outer join tMenu as tParentMenu on tMenu.ParentItem=tParentMenu.MenuID"; echo "<p class='debug'>Action: {$action} </p>"; switch ($action) { case "list": break; case "sort": $listQuery = $listQuery . " ORDER BY {$value}"; break; case "filter": $listQuery = $listQuery . " WHERE {$columnName} = {$value}"; break; case "like": $listQuery = $listQuery . " WHERE {$columnName} like '%" . $value . "%'"; break; case "delete": deleteMenuItem($MenuID); reloadMenu($userID); break; case "add": include_once './panels/dbMenuItem.php'; addMenuItem($MenuName, $PagePath, $Sequence, $RequiresAuthentication, $ParentItem, $Color, $QueryString); reloadMenu($userID); break; case "select": echo "<p class='debug'>MenuID: {$MenuID} :: ID: {$id}</p>"; include_once './panels/dbMenuItem.php'; if ($MenuID != "") { getMenuItem($MenuID, $userID); } else { if ($id != "") { getMenuItem($id, $userID);