<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
function message_table()
{
global $conn;

$gui=new admin_interface();
$gui->add("form","adminform");
$gui->add("com_header",_MSG_HEAD);
$table_head = array ( array('title'=>'#' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>'checkbox' , 'val'=>'id' , 'len'=>'1%','align'=>'center') , 
					  array('title'=>_MSG_SUBJECT,'val'=>'message_subject','len'=>'60%','ilink'=>'admin.php?com_option=messages&task=edit&cid[]=ivar1','ivar1'=>'id') ,
					  array('title'=>_MSG_FROM,'val'=>'name','len'=>'20%','ilink'=>'mailto:ivar1','ivar1'=>'email') ,
					  array('title'=>_MSG_POSTED,'val'=>'date','date'=>'1','len'=>'20%','align'=>'center') ,
					  array('title'=>_MSG_STATUS,'val'=>'status','len'=>'10%','align'=>'center')
					 ); 
	 
$rs=$conn->Execute("SELECT id,name,email,message_subject,date,status FROM #__messages ORDER BY date DESC");					   
$table_data=$rs->GetArray();

$replace = array( 	   "status"=>array(array("value"=>"0","name"=>_TB_NEW),
				   				   array("value"=>"1","name"=>_MSG_STATUS_READ),
								   array("value"=>"2","name"=>_MSG_STATUS_REPLIED)				 
								   )
					);
$table_data=array_replace($table_data,$replace);
$gui->add("data_table_arr","maintable",$table_head,$table_data);
$gui->add("end_form");
$gui->generate();					
}

function read_message()
{
global $conn,$cid,$limbocore;
$rsar=$conn->GetRow("SELECT * FROM #__messages WHERE id = ".$cid[0]);		   
if($rsar['status']==0)change_val("messages",$cid[0],"status",1); // it has been read 

$lm_name = dbdecode($rsar['name']);
$lm_email = dbdecode($rsar['email']);
$message = text_html(dbdecode($rsar['message_text']));
$adminname=$limbocore->getVar("lm_name");
$adminemail=$limbocore->getVar("lm_email");
$adminwebsite=$limbocore->getVar("lm_website");
$gui=new admin_interface();
$gui->add("form","adminform","","admin.php?com_option=messages");
$gui->add("bar");
$gui->add("com_header",_MSG_EDIT_HEAD);
$gui->add("tab_head");
$gui->add("tab_simple","",_MSG_EDIT_HEAD,"");
$gui->add("form_hidden","message_id","",$rsar['id']);
$gui->add("form_text","",_MSG_FROM,$lm_name);
$gui->add("form_text","",_CMN_EMAIL,$lm_email);
$gui->add("form_hidden","message_email","email",$lm_email);
$gui->add("form_text","",_MSG,$message);
$gui->add("bar");
$gui->add("form_textfield","message_subject",_MSG_EDIT_REPLY_TITLE,_MSG_RE." : ".$rsar['message_subject']);
$gui->add("form_textarea_big","message_body_data",_MSG_EDIT_REPLY_BODY,sprintf(_MSG_EDIT_REPLY_BODY_DRAFT,$lm_name,$adminname,$adminemail,$adminwebsite,str_replace("\n","\n>>",dbdecode($rsar['message_text']))),"10");
$gui->add("tab_end");
$gui->add("tab_tail");
$gui->add("end_form");
$gui->generate();
}

?>