<?php
 
// load default script
include_once("php4_cms_asset.php");
 
$table = 'news';
$param = 'news_id';
 
$asset_def = array(
	'name'	=>	'news',
	'title'	=>	'News',
	
	'list_per_page'	=> 18,
	'list_width'	=>	'720px',
	
	'param'	=>	$param,
	
	// elements definition
	'elements'	=>	array(
		'date_added'	=>	array	(
			'default'	=>	time(),
			'in_list'	=>	true,
			'date_format'	=>	'%e-%b-%Y %r',
			'sql_path'	=>	'date_added',
			'caption'	=>	'Date Added',
			'type'	=>	'date',
			'params'	=>	array(
				'show_time'	=>true,
				'class'	=>	'input'
			)
		),
		
		'newsInfo'	=>	array	(
			'in_list'	=>	true,
			'list_truncate'	=>	60,
			'sql_path'	=>	'newsInfo',
			'caption'	=>	'News Body',
			'type'	=>	'textarea',
			'params'	=>	array(
				'cols'	=>	'70',
				'rows'	=>	'20',
				'class'	=>	'textarea'
			)
		)
	),
	
	// sql queries
	'list_sql'	=>	"select %sql_val% from `" . $table . "` where news_id != 1 %sql_order% %sql_limit%",
	'edit_sql'	=>	"select * from `" . $table . "` where `" . $param . "`='%param%' limit 1",
	'save_sql'	=>	"update `" . $table . "` set %update_sql% where `" . $param . "`='%param%' limit 1",
	'add_sql'	=>	"insert into `" . $table . "` (%sql_left%) values (%sql_right%)",
	'delete_sql'	=>	"delete from `" . $table . "` where `" . $param . "`='%param%' and news_id != 1 limit 1"
);
 
$asset = new asset($asset_def);
$sectionData = $asset->out();
 
$tpl_section_file = 'sections/asset.tpl';
 
?>