<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
require_once(com_path("html"));
include($includes_dir."mambo.php");
if(!$my->isauth("admin_menu"))return not_auth();
/* the section function handling part */
if(!isset($menutype))
{
switch($task)
{
case "delete":
		$easydb->data_table("categories","admin.php?com_option=menu","section='com_menu'");
		break;
case "create" :
        $conn->Execute("INSERT INTO #__categories (title,section) VALUES ('$menu_title','com_menu')");
		$limbocore->redir("admin.php?com_option=menu");
		break;
case "new" : create_menu();	break;		
default : menu_table();
}
}else 
{
//this is common to save and new 
$module_params="";
foreach($_POST as $var=>$val)
{
	if(strstr($var,"param_")){
	$module_params.=str_replace("param_","",$var)."=".$val."[NL]";
}
}

switch($task)
{

case "orderup":
case "orderdown":
case "reorder":
case "publish":
case "unpublish":
case "delete":
		$easydb->data_table("menu","admin.php?com_option=menu&menutype=$menutype","menutype='$menutype'");
		break;		
				
case "save": {

if($link_type == "cc" || $link_type == "cs" || $link_type == "ci" || $link_type == "cb")
{
$lm_name= '';
$link ='';
get_link($link_type,$menu_id,$link,$lm_name);
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$lm_name',link='$link',parent=$link_parent,componentid=$menu_id,access=$link_access WHERE  id=$link_id");
}else if ($link_type == 'separator')
{
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$link_name',parent=$link_parent,access=$link_access WHERE  id=$link_id");
}
else if ($link_type == 'url')
{
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$link_name',link='$link_url',parent=$link_parent,browsernav=$link_browsernav,access=$link_access WHERE  id=$link_id");
}
else if ($link_type == 'cl')
{
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$link_name',link='$link_url',parent=$link_parent,access=$link_access WHERE id=$link_id");
}
else if ($link_type == 'wrapper')
{
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$link_name',link='$link_url',parent=$link_parent,access=$link_access,params='$module_params' WHERE  id=$link_id");
}
else if ($link_type == 'component' )
{
$conn->Execute("UPDATE #__menu ".
		"\nSET name='$link_name',parent=$link_parent,access=$link_access,params='$module_params' WHERE  id=$link_id");
}

if($link_parent!=$olink_parent) {
if($link_parent!=0)$conn->Execute("UPDATE #__menu SET sublevel=1 WHERE id=$link_parent");
if($olink_parent!=0)
{
$rs=$conn->Execute("SELECT id FROM #__menu WHERE parent=$olink_parent");
if($rs && $rs->RecordCount()==0)$conn->Execute("UPDATE #__menu SET sublevel=0 WHERE id=$olink_parent");
}
}

$limbocore->redir("admin.php?com_option=menu&menutype=$menutype");		
break; 
}
				
case "create":
{
$order=$easydb->neworder("menu","menutype='$menutype'");
$publish=0;
if($link_parent!=0) {
$conn->Execute("UPDATE #__menu SET sublevel=1 WHERE id=$link_parent");
}
if($link_type == "cc" || $link_type == "cs" || $link_type == "ci" || $link_type == "cb")
{
$lm_name= '';
$link ='';

get_link($link_type,$menu_id,$link,$lm_name);

$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link,link_type,published,parent,componentid,ordering,access) ".
	"\nVALUES ('$link_menutype','$lm_name','$link','$link_type',$publish,$link_parent,$menu_id,$order,$link_access)");
}else if ($link_type == 'separator')
{
$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link_type,published,parent,ordering,browsernav,access) ".
	"\nVALUES ('$link_menutype','$link_name','$link_type',$publish,$link_parent,$order,3,$link_access)");
}
else if ($link_type == 'url')
{
$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link,link_type,published,parent,ordering,browsernav,access) ".
	"\nVALUES ('$link_menutype','$link_name','$link_url','$link_type',$publish,$link_parent,$order,$link_browsernav,$link_access)");
}
else if ($link_type == 'wrapper')
{
$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link,link_type,parent,ordering,access) ".
	"\nVALUES ('$link_menutype','$link_name','$link_url','$link_type',$link_parent,$order,$link_access)");
}
else if ($link_type == 'cl')
{
$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link,link_type,parent,ordering,access) ".
	"\nVALUES ('$link_menutype','$link_name','$link_url','$link_type',$link_parent,$order,$link_access)");
}
else if ($link_type == 'component' )
{
$rs=$conn->Execute("SELECT id,link FROM #__components WHERE id = $link_componentid");
$rsa=$rs->GetArray();
$link_url="index.php?".$rsa[0]['link'];
$conn->Execute("INSERT INTO #__menu ".
	"\n(menutype,name,link,link_type,published,parent,componentid,ordering,access,params) ".
	"\nVALUES ('$link_menutype','$link_name','$link_url','$link_type',$publish,$link_parent,$link_componentid,$order,$link_access,'$module_params')");

}
echo $conn->ErrorMsg();
$limbocore->redir("admin.php?com_option=menu&menutype=$menutype");
break;
}

case "edit" : new_menu("edit");break;
case "new" : new_menu("new"); break;
default: menutype_table(); break;

} 

}

function add_child($parent)
{
global $conn;
$rs=$conn->Execute("SELECT id,sublevel FROM #__menu WHERE id=$parent");
$rsa=$conn->GetArray();
$row=$rsa[0];
if($row['sublevel']==0){}
}
function remove_child($parent)
{
}
function get_link($link_type,$menu_id,&$link,&$lm_name)
{
global $conn;
if($link_type=="cc") { 
$rs=$conn->GetRow("SELECT id,title FROM #__categories WHERE id= $menu_id");
$lm_name=$rs['title'];
$link="index.php?option=content&amp;task=category&amp;id=".$menu_id;
}else if($link_type=="cb") { 
$rs=$conn->GetRow("SELECT id,title FROM #__categories WHERE id= $menu_id");
$lm_name=$rs['title'];
$link="index.php?option=content&amp;task=showblog&amp;id=".$menu_id;
}
else if($link_type=="cs") {
$rs=$conn->GetRow("SELECT id,title FROM #__sections WHERE id= $menu_id");
$lm_name=$rs['title'];
$link="index.php?option=content&amp;task=section&amp;id=".$menu_id;
}else if($link_type=="ci") {
$rs=$conn->GetRow("SELECT id,title_alias FROM #__content WHERE id= $menu_id");
$lm_name=$rs['title_alias'];
$link="index.php?option=content&amp;pcontent=1&amp;task=view&amp;id=".$menu_id;
}
}
?>