<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
require_once(com_path("html"));
if(!$my->isauth("admin_content"))return not_auth();
switch($option)
{
/* the items function handling part */
case "archive":
switch($task)
{
case "unarchive":
		$easydb->data_table("content","admin.php?com_option=content&option=items&sec_id=$sec_id","sectionid=$sec_id",true);
		break;
case "delete":
	   $easydb->data_table("content","","",true);
       foreach($cid as $var)$conn->Execute("DELETE FROM #__content_frontpage WHERE id = $var");
       $limbocore->redir("admin.php?com_option=content&option=items&sec_id=$sec_id");
	   break;		
default: archive_items_table(); break;
} break;

case "items" : 
switch($task)
{

case "orderup":
case "orderdown":
case "reorder":
case "publish":
case "unpublish":
case "archive":
case "unarchive":
		$easydb->data_table("content","admin.php?com_option=content&option=items&sec_id=$sec_id","sectionid=$sec_id",true);
		break;		
case "delete":
	   $easydb->data_table("content","","",true);
       foreach($cid as $var)$conn->Execute("DELETE FROM #__content_frontpage WHERE id = $var");
       $limbocore->redir("admin.php?com_option=content&option=items&sec_id=$sec_id");
	   break;				
case "create":
{

$content_created=format_date($content_created);
$content_modified=format_date($content_modified);

$order=$easydb->neworder("content","sectionid='$sec_id'");
$conn->Execute("INSERT INTO #__content ".
	"\n(title,title_alias,introtext,bodytext,sectionid,mask,catid,created,modified,created_by_alias,frontpage,ordering,metakey,metadesc,access) ".
	"\nVALUES ('$content_title','$content_title_alias','$content_introtext','$content_fulltext',$sec_id,$content_mask,$content_catid,'$content_created','$content_modified','$content_created_by_alias',$content_frontpage,$order,'$content_metakey','$content_metadesc',$content_access)");
if($content_frontpage){
						$order=$easydb->neworder("content_frontpage");
						$last_id = $conn->Insert_ID();
						$conn->Execute("INSERT INTO #__content_frontpage (id,ordering) VALUES ($last_id,$order)");
						}				
$limbocore->redir("admin.php?com_option=content&option=items&sec_id=$sec_id");
break;
}

case "save":
{

$content_created=format_date($content_created);
$content_modified=format_date($content_modified);

$conn->Execute("UPDATE #__content ".
	"\nSET title = '$content_title' , title_alias = '$content_title_alias' , introtext = '$content_introtext' , bodytext = '$content_fulltext' , mask = $content_mask , catid = $content_catid , created = '$content_created', modified = '$content_modified' , created_by_alias = '$content_created_by_alias', frontpage = $content_frontpage , metakey = '$content_metakey' , metadesc = '$content_metadesc' , access = '$content_access' ".
	"\nWHERE id = $content_id");
$easydb->check_category('content',$content_id,$content_catid,$content_ocatid);	
if(!$content_frontpage)
	{
	$conn->Execute("DELETE FROM #__content_frontpage WHERE id = $content_id");
	}
if($content_frontpage)
	{
	$rs=$conn->Execute("SELECT id FROM #__content_frontpage WHERE id = $content_id");
	if($rs->RecordCount()==0)
	{
	$order=$easydb->neworder("content_frontpage");
	$conn->Execute("INSERT INTO #__content_frontpage (id,ordering) VALUES ($content_id,$order)");
	}
	}	
$limbocore->redir("admin.php?com_option=content&option=items&sec_id=$sec_id");
break;
}

case "edit" : edit_items();break;
case "new" :  edit_items('new'); break;
default: items_table(); break;

} break;

/* the categories function handling part */
case "categories" : 
switch($task)
{

case "orderup":
case "orderdown":
case "reorder":
case "publish":
case "unpublish":
		$easydb->data_table("categories","admin.php?com_option=content&option=categories&sec_id=$sec_id","section=$sec_id");
		break;
case "delete":
		change_val("sections",$sec_id,"count",-1); 
		$conn->Execute("DELETE FROM #__content WHERE catid = ".$cid[0]);		
		$easydb->data_table("categories","admin.php?com_option=content&option=categories&sec_id=$sec_id","section=$sec_id");
		break;
			
case "create":
{
$order=$easydb->neworder("categories","section=$sec_id");
$conn->Execute("INSERT INTO #__categories ".
	"\n(title,name,image,image_position,section,description,ordering,access) ".
	"\nVALUES ('$section_title','$section_name','$section_image','$section_image_position',$sec_id,'$section_description',$order,$section_access)");
	
change_val("sections",$sec_id,"count",1); 
	
$limbocore->redir("admin.php?com_option=content&option=categories&sec_id=$sec_id");

}

case "save":
{
$conn->Execute("UPDATE #__categories ".
	"\nSET title = '$section_title' , name = '$section_name' ,image = '$section_image' ,image_position = '$section_image_position' , description = '$section_description' ,access = $section_access ".
	"\nWHERE id = $section_id");
$limbocore->redir("admin.php?com_option=content&option=categories&sec_id=$sec_id");
}

case "edit" : edit_categories();break;
case "new" : edit_categories('new'); break;
default: categories_table(); break;

} break;

/* the section function handling part */
default :
switch($task)
{

case "orderup":
case "orderdown":
case "reorder":
case "publish":
case "unpublish":
case "delete":
		$easydb->data_table("sections","admin.php?com_option=content","id<>1");
		break;
			
case "create":
{
$order=$easydb->neworder("sections");
$conn->Execute("INSERT INTO #__sections ".
	"\n(title,name,image,image_position,description,ordering,access) ".
	"\nVALUES ('$section_title','$section_name','$section_image','$section_image_position','$section_description',$order,$section_access)");
$limbocore->redir("admin.php?com_option=content");
}

case "save":
{
$conn->Execute("UPDATE #__sections ".
	"\nSET title = '$section_title' , name = '$section_name' ,image = '$section_image' ,image_position = '$section_image_position' ,description = '$section_description' ,access = $section_access ".
	"\nWHERE id = $section_id");
$limbocore->redir("admin.php?com_option=content");
}


case "edit" : edit_section();break;
case "new" : edit_section('new'); break;
default: sections_table(); break;

} break;

}


?>