<?
class message{

function message(){

}

function getMessages($seen) {
	global $dbi;
	$sql="select * from message where seen='$seen' order by timestamp desc";
	$res=sql_query($sql,$dbi);
	while($a=sql_fetch_assoc($res,$dbi)){
		$data[]=$a;
	}
	return $data;
}

function getMessage($id) {
	global $dbi;
	$sql="select * from message where id='$id'";
	$res=sql_query($sql,$dbi);
	$a=sql_fetch_assoc($res,$dbi);
	return $a;
}

function saveNewMessage($post) {
	global $dbi,$lang,$SITEGLOBALS;
	extract($post);

	$message=strip_tags($message);
	
	$sql="insert into message (name,email,message) ".
		"values ('$name','$email','$message')";
	sql_query($sql,$dbi);
	
	$content=new content;
	$email_sender=$email;
	$email=$SITEGLOBALS[MAIL_ADMIN];
	$data=compact(email, name, email_sender, message);
	$content->sendMail('ADMIN_MESSAGE',$data);
}

function markMessageAsRead($id) {
	global $dbi;
	$sql="update message set seen=1 where id='$id'";
	sql_query($sql,$dbi);
}

function deleteMessage($id) {
	global $dbi;
	$sql="delete from message where id='$id'";
	sql_query($sql,$dbi);
}

}

?>