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);
