<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
function sections_table()
{
global $conn;

$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("bar");
$gui->add("com_header",_CONTENT_SECTION_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>'checkbox' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>_CMN_NAME,'val'=>'name','len'=>'60%','bval'=>'title','ilink'=>'admin.php?com_option=content&task=edit&cid[]=ivar1','ivar1'=>'id') ,
					  array('title'=>_CMN_PUBLISHED,'val'=>'published','len'=>'10%','align'=>'center'),
					  array('title'=>_CMN_RECORDS , 'val'=>'count' , 'len'=>'10%','align'=>'center') , 
					  array('title'=>_CMN_ACCESS,'val'=>'access','len'=>'10%','align'=>'center') ,
					  array('title'=>_CMN_ORDERING,'val'=>'ordering','len'=>'10%','align'=>'center') 
					 ); 
$rs=$conn->Execute("SELECT id,title,name,published,ordering,access,count FROM #__sections ORDER BY ordering ASC");					   
$table_data=$rs->GetArray();
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}

function edit_section($type='edit')
{
global $conn,$cid;

if($type=='edit')
{
$rs=$conn->Execute("SELECT id,title,name,image,image_position,description,access FROM #__sections WHERE id = ".$cid[0]);					   
$rsa=$rs->GetArray();
$rsar=$rsa[0];
$c_head = _CONTENT_SECTION_EDIT_HEAD;
}else
{
$rsar=array("id"=>"","title"=>"","name"=>"","image"=>"","image_position"=>"left","description"=>"","access"=>"0");
$c_head = _CONTENT_SECTION_NEW_HEAD;
}
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content");
$gui->add("bar");
$gui->add("com_header",$c_head);
$gui->add("tab_head");
$gui->add("tab_simple","",$c_head,"");
$gui->add("form_hidden","section_id","",$rsar['id']);
$gui->add("form_textfield","section_title",_CMN_TITLE,$rsar['title']);
$gui->add("form_textfield","section_name",_CMN_NAME,$rsar['name']);
$img_arr=select_array('images/stories/',_CMN_SELECTIMAGE,$rsar['image']);
$gui->add("form_list_image","section_image",_CMN_SELECTIMAGE,$img_arr,"images/stories/");
$pos=pos_array($rsar['image_position']);
$gui->add("form_select","section_image_position",_CMN_IMAGEPOS,$pos);
$access_level=access_array($rsar['access']);
$gui->add("form_select","section_access",_CMN_ACCESS,$access_level);
$gui->add("form_textarea","section_description",_CMN_DESC,$rsar['description'],"5");
$gui->add("tab_end");
$gui->add("tab_tail");
$gui->add("end_form");
$gui->generate();
}

function categories_table()
{
global $conn,$sec_id;
$row=$conn->GetRow("SELECT title FROM #__sections WHERE id = $sec_id");
$sec_title=$row['title'];
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content&option=categories&sec_id=$sec_id");
$gui->add("com_header","$sec_title :: "._CONTENT_CAT_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>'checkbox' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>_CMN_NAME,'val'=>'name','len'=>'60%','bval'=>'title','ilink'=>'admin.php?com_option=content&option=categories&task=edit&sec_id=ivar1&cid[]=ivar2','ivar1'=>'section','ivar2'=>'id') ,
					  array('title'=>_CMN_PUBLISHED,'val'=>'published','len'=>'10%','align'=>'center'),
					  array('title'=>_CMN_RECORDS , 'val'=>'count' , 'len'=>'10%','align'=>'center') , 
					  array('title'=>_CMN_ACCESS,'val'=>'access','len'=>'10%','align'=>'center') ,
					  array('title'=>_CMN_ORDERING,'val'=>'ordering','len'=>'10%','align'=>'center') 
					 ); 			 
$rs=$conn->Execute("SELECT id,title,name,section,published,ordering,access,count ".
					"\nFROM #__categories ".
					"\nWHERE section = $sec_id ".
					"\nORDER BY ordering ASC");					   
$table_data=$rs->GetArray();
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}

function edit_categories($type='edit')
{
global $conn,$cid,$lm_absolute_path,$sec_id;
$row=$conn->GetRow("SELECT title FROM #__sections WHERE id = $sec_id");
$sec_title=$row['title'];
if($type=='edit')
{
$rs=$conn->Execute("SELECT id,title,name,image,image_position,description,access FROM #__categories WHERE id = ".$cid[0]);					   
$rsa=$rs->GetArray();
$rsar=$rsa[0];
$c_head = _CONTENT_CAT_EDIT_HEAD;
}else
{
$rsar=array("id"=>"","title"=>"","name"=>"","description"=>"","access"=>"0","image"=>"","image_position"=>"left",);
$c_head = _CONTENT_CAT_NEW_HEAD;
}
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content&option=categories&sec_id=$sec_id");
$gui->add("com_header","$sec_title :: $c_head");
$gui->add("tab_head");
$gui->add("tab_simple","",$c_head,"");
$gui->add("form_hidden","section_id","",$rsar['id']);
$gui->add("form_textfield","section_title",_CMN_TITLE,$rsar['title']);
$gui->add("form_textfield","section_name",_CMN_NAME,$rsar['name']);
$img_arr=select_array('images/stories/',_CMN_SELECTIMAGE,$rsar['image']);
$gui->add("form_list_image","section_image",_CMN_SELECTIMAGE,$img_arr,"images/stories/");
$pos=pos_array($rsar['image_position']);
$gui->add("form_select","section_image_position",_CMN_IMAGEPOS,$pos);
$access_level=access_array($rsar['access']);
$gui->add("form_select","section_access",_CMN_ACCESS,$access_level);
$gui->add("form_textarea","section_description",_CMN_DESC,$rsar['description'],"5");
$gui->add("tab_end");
$gui->add("tab_tail");
$gui->add("end_form");
$gui->generate();
}


/* archive system interface */
function archive_items_table()
{
global $conn,$sec_id;
$row=$conn->GetRow("SELECT title FROM #__sections WHERE id = $sec_id");
$sec_title=$row['title'];
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content&option=items&sec_id=$sec_id");
$gui->add("com_header","$sec_title ::"._CONTENT_ARCHIVE_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>'checkbox' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>_CMN_TITLE,'val'=>'title','len'=>'70%','ilink'=>'admin.php?com_option=content&option=items&task=edit&sec_id='.$sec_id.'&cid[]=ivar1','ivar1'=>'id') ,
					  array('title'=>_CMN_CAT,'val'=>'catid','len'=>'30%','align'=>'center'),
					 ); 			 			 
$rs=$conn->Execute("SELECT id,title,sectionid,catid,created,published,access,hits FROM #__content WHERE sectionid = $sec_id AND published = 4 ORDER BY created DESC");					   
$table_data=$rs->GetArray();
$cat_arr=category_array($sec_id,"-1");
$replace = array("catid"=> $cat_arr);
$table_data=array_replace($table_data,$replace);
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}

/* items interface */
function items_table()
{
global $conn,$sec_id;
$row=$conn->GetRow("SELECT title FROM #__sections WHERE id = $sec_id");
$sec_title=$row['title'];
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content&option=items&sec_id=$sec_id");
$gui->add("com_header","$sec_title ::"._CONTENT_ITEM_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>'checkbox' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>_CMN_TITLE,'val'=>'title','len'=>'50%','ilink'=>'admin.php?com_option=content&option=items&task=edit&sec_id='.$sec_id.'&cid[]=ivar1','ivar1'=>'id') ,
					  array('title'=>_CMN_PUBLISHED,'val'=>'published','len'=>'10%','align'=>'center'),
					  array('title'=>_CMN_CAT,'val'=>'catid','len'=>'10%','align'=>'center'),
					  array('title'=>_CMN_ACCESS,'val'=>'access','len'=>'10%','align'=>'center') ,
					  array('title'=>_CMN_FRONTPAGE,'val'=>'frontpage','len'=>'10%','align'=>'center') ,
					  array('title'=>_CMN_ORDERING,'val'=>'ordering','len'=>'10%','align'=>'center') 
					 ); 			 
$gui->order=-1;					 
$rs=$conn->Execute("SELECT id,title,catid,published,frontpage,ordering,access,hits FROM #__content WHERE sectionid = $sec_id AND published <> 4 ORDER BY ordering DESC");					   
$table_data=$rs->GetArray();
$cat_arr=category_array($sec_id,"-1");
$replace = array( "catid"=> $cat_arr);
$table_data=array_replace($table_data,$replace);
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}

function edit_items($type='edit')
{
global $conn,$cid,$sec_id,$lm_name,$time;

$row=$conn->GetRow("SELECT title FROM #__sections WHERE id = $sec_id");
$sec_title=$row['title'];

if($type=='edit')
{
$rs=$conn->Execute("SELECT * FROM #__content WHERE id = ".$cid[0]);					   
$rsa=$rs->GetArray();
$rsar=$rsa[0];
$c_head = _CONTENT_ITEM_EDIT_HEAD;
}else
{
$rsar=array("id"=>"","title"=>"","title_alias"=>"","catid"=>"","created"=>$time,"modified"=>$time,"name"=>"","description"=>"","introtext"=>"","bodytext"=>"","access"=>"0","mask"=>"","created_by_alias"=>"$lm_name","frontpage"=>"","metakey"=>"","metadesc"=>"");
$c_head = _CONTENT_ITEM_NEW_HEAD;
}
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=content&option=items&sec_id=$sec_id");
$gui->add("bar");
$gui->add("com_header","$sec_title :: $c_head");
$gui->add("tab_link","dtab");
$gui->add("tab_head");
$gui->add("tab","Content",$c_head,"dtab");
$gui->add("form_hidden","content_id","",$rsar['id']);
$gui->add("form_textfield","content_title",_CMN_TITLE,$rsar['title'],"",'$required=true;');
$gui->add("form_textfield","content_title_alias",_CONTENT_ITEM_CONTENT_TALIAS,$rsar['title_alias'],"",'$required=true;');
$cat_drop=category_array($sec_id,$rsar['catid']);
$gui->add("form_select","content_catid",_CMN_SELECTCAT,$cat_drop,"",'$required=true;');
$gui->add("form_hidden","content_ocatid","",$rsar['catid']);
$gui->add("form_htmlarea","content_introtext",_CONTENT_ITEM_CONTENT_INTRO,$rsar['introtext'],"",'$required=true;');
$gui->add("form_htmlarea","content_fulltext",_CONTENT_ITEM_CONTENT_COMPLETE,$rsar['bodytext'],"");
$gui->add("tab_end");
$gui->add("tab",_CONTENT_ITEM_PUBLISH,_CONTENT_ITEM_PUBLISH_EXP,"dtab");
$access_level=access_array($rsar['access']);
$gui->add("form_select","content_access",_CMN_ACCESS,$access_level);
$gui->add("form_textfield","content_created_by_alias",_CONTENT_ITEM_PUBLISH_AALIAS,$rsar['created_by_alias']);
$gui->add("form_boolean","content_mask",_CONTENT_ITEM_PUBLISH_HTITLE,$rsar['mask']);
$gui->add("form_boolean","content_frontpage",_CONTENT_ITEM_PUBLISH_FRONTPAGE,$rsar['frontpage']);
$gui->add("form_date","content_created",_CMN_CDATE,$rsar['created']);
$gui->add("form_date","content_modified",_CMN_MDATE,$rsar['modified']);
$gui->add("tab_end");
$gui->add("tab",_CONTENT_ITEM_META,_CONTENT_ITEM_META_EXP,"dtab");
$gui->add("form_textarea","content_metakey",_CONTENT_ITEM_META_KEYWORDS,$rsar['metakey']);
$gui->add("form_textarea","content_metadesc",_CONTENT_ITEM_META_DESC,$rsar['metadesc']);
$gui->add("tab_end");
$gui->add("tab_tail");
$gui->add("end_form");
$gui->add("tab_sel","dtab","","1");
$gui->generate();
}


?>