Файл: include/personal_msg.php
Строк: 76
<?php
include_once("base.php");
/**
Class for work player personal message
*/
class CPlayerPersonalMsg extends CBase
{
function CPlayerPersonalMsg($database,$vnum)
{
$this->db=$database;
$this->vnum=$vnum;
}
function getListTo()
{
$sql = "SELECT t1.vnum,t1.vnum_from,t1.vnum_to,t1.pdate,t1.caption,t1.msg_text,t1.flag_read,t2.name FROM data_personal_msg AS t1, data_player AS t2 WHERE t1.vnum_to!='$this->vnum' AND t1.vnum_from='$this->vnum' AND t2.vnum=t1.vnum_to ORDER BY t1.pdate DESC";
$list_msg = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $list_msg;
}
function getListFrom()
{
$sql = "SELECT t1.vnum,t1.vnum_from,t1.vnum_to,t1.pdate,t1.caption,t1.msg_text,t1.flag_read,t2.name FROM data_personal_msg AS t1, data_player AS t2 WHERE t1.vnum_to='$this->vnum' AND t2.vnum=t1.vnum_from ORDER BY t1.pdate DESC";
$list_msg = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $list_msg;
}
function sendMail($to,$subject,$msg)
{
$pdate=time();
$read=0;
$sql = "INSERT INTO data_personal_msg(vnum_from,vnum_to,pdate,caption,msg_text,flag_read)
VALUES ('$this->vnum','$to','$pdate','$subject','$msg','$read')";
$this->execSQL($sql);
}
function getMailTo($vnum)
{
$sql = "SELECT t1.vnum,t1.vnum_from,t1.vnum_to,t1.pdate,t1.caption,t1.msg_text,t1.flag_read,t2.name FROM data_personal_msg AS t1, data_player AS t2 WHERE t1.vnum='$vnum' AND t2.vnum=t1.vnum_to LIMIT 1";
$msg = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $msg[0];
}
function getMailFrom($vnum)
{
$sql = "SELECT t1.vnum,t1.vnum_from,t1.vnum_to,t1.pdate,t1.caption,t1.msg_text,t1.flag_read,t2.name FROM data_personal_msg AS t1, data_player AS t2 WHERE t1.vnum='$vnum' AND t2.vnum=t1.vnum_from LIMIT 1";
$msg = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $msg[0];
}
}
?>