<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
function frontpage_table()
{
global $conn;

$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("com_header",_FRONTPAGE_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%') ,
					  array('title'=>_CMN_PUBLISHED,'val'=>'published','len'=>'10%','align'=>'center'),
					  array('title'=>_CMN_ACCESS,'val'=>'access','len'=>'10%','align'=>'center') ,
					  array('title'=>_CMN_ORDERING,'val'=>'ordering','len'=>'10%','align'=>'center')
					 ); 
$gui->order=-1;					 
$rs=$conn->Execute("SELECT id,ordering FROM #__content_frontpage ORDER BY ordering DESC");
$table_data='';					   
if($rs && $rs->RecordCount()>0 && $table_data=$rs->GetArray())
{
for($i=0;$i<count($table_data);$i++)
{
$rsc=$conn->Execute("SELECT title,published,access FROM #__content WHERE id =".$table_data[$i]['id']);
$rsca=$conn->GetArray();
$table_data[$i]['title']=$rsca[0]['title'];
$table_data[$i]['published']=$rsca[0]['published'];
$table_data[$i]['access']=$rsca[0]['access'];
}
}
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}
?>