120 lines
3.1 KiB
PHP
120 lines
3.1 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
class beta5_msg_library {
|
||
|
|
var $index = array(
|
||
|
|
'get',
|
||
|
|
'getHeaders',
|
||
|
|
'send',
|
||
|
|
'sendInAlliance',
|
||
|
|
'sendToPlanet',
|
||
|
|
'sendToPlayer'
|
||
|
|
);
|
||
|
|
|
||
|
|
function beta5_msg_library($lib) {
|
||
|
|
$this->lib = $lib;
|
||
|
|
$this->db = $this->lib->game->db;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Lists custom folders for a player
|
||
|
|
function getCustomFolders($pid) {
|
||
|
|
$q = $this->db->query("SELECT id,name FROM custom_folder WHERE player = $pid ORDER BY name");
|
||
|
|
$a = array();
|
||
|
|
while ($r = dbFetchArray($q)) {
|
||
|
|
$a[$r[0]] = $r[1];
|
||
|
|
}
|
||
|
|
return $a;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Creates a custom folder
|
||
|
|
function createFolder($pid, $name) {
|
||
|
|
$this->db->query("INSERT INTO custom_folder(name,player) VALUES('".addslashes($name)."',$pid)");
|
||
|
|
}
|
||
|
|
|
||
|
|
// Renames a custom folder
|
||
|
|
function renameFolder($fid, $name) {
|
||
|
|
$this->db->query("UPDATE custom_folder SET name = '".addslashes($name)."' WHERE id=$fid");
|
||
|
|
}
|
||
|
|
|
||
|
|
// Flushes messages from a folder
|
||
|
|
function flushFolder($pid, $ft, $fid) {
|
||
|
|
$qs = "UPDATE message SET deleted=TRUE WHERE player=$pid AND ftype='$ft'";
|
||
|
|
if ($ft == 'CUS') {
|
||
|
|
$qs .= " AND fcustom=$fid";
|
||
|
|
}
|
||
|
|
$this->db->query($qs);
|
||
|
|
}
|
||
|
|
|
||
|
|
// Deletes a custom folder
|
||
|
|
function deleteFolder($pid, $fid) {
|
||
|
|
$this->db->query("UPDATE message SET deleted=TRUE WHERE player=$pid AND ftype='CUS' AND fcustom=$fid");
|
||
|
|
$this->db->query("DELETE FROM custom_folder WHERE player=$pid AND id=$fid");
|
||
|
|
}
|
||
|
|
|
||
|
|
// Get count of all messages in a player's folder
|
||
|
|
function getAll($pid, $ft, $cfid = null) {
|
||
|
|
$qs = "SELECT COUNT(*) FROM message WHERE player=$pid AND ftype='$ft' AND NOT deleted";
|
||
|
|
if (!is_null($cfid)) {
|
||
|
|
$qs .= " AND fcustom = $cfid";
|
||
|
|
}
|
||
|
|
$q = $this->db->query($qs);
|
||
|
|
if (!($q && count($q) == 1)) {
|
||
|
|
return 0;
|
||
|
|
}
|
||
|
|
list($r) = dbFetchArray($q);
|
||
|
|
return $r;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Get count of new messages in a player's folder
|
||
|
|
function getNew($pid, $ft = null, $cfid = null) {
|
||
|
|
$qs = "SELECT COUNT(*) FROM message WHERE player=$pid AND is_new AND NOT deleted";
|
||
|
|
if (!is_null($ft)) {
|
||
|
|
$qs .= " AND ftype='$ft'";
|
||
|
|
if (!is_null($cfid)) {
|
||
|
|
$qs .= " AND fcustom = $cfid";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$q = $this->db->query($qs);
|
||
|
|
if (!($q && count($q) == 1)) {
|
||
|
|
return 0;
|
||
|
|
}
|
||
|
|
list($r) = dbFetchArray($q);
|
||
|
|
return $r;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Sets a message status to "read"
|
||
|
|
function setRead($mId) {
|
||
|
|
$this->db->query("UPDATE message SET is_new = FALSE WHERE id = $mId");
|
||
|
|
}
|
||
|
|
|
||
|
|
// Sets a message as deleted
|
||
|
|
function delete($mId, $pId) {
|
||
|
|
$this->db->query("UPDATE message SET deleted = TRUE WHERE id = $mId AND player = $pId");
|
||
|
|
}
|
||
|
|
|
||
|
|
// Moves a message
|
||
|
|
function move($mId, $pId, $tTp, $tId) {
|
||
|
|
$qs = "ftype='$tTp',fcustom=" . ($tTp == "CUS" ? $tId : "NULL");
|
||
|
|
$this->db->query("UPDATE message SET $qs WHERE id = $mId AND player = $pId");
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// Loads message formatting scripts
|
||
|
|
function loadFormat($type, $lang, $player) {
|
||
|
|
if (!is_null($this->formats[$type])) {
|
||
|
|
return $this->formats[$type];
|
||
|
|
}
|
||
|
|
|
||
|
|
$path = config::$main['scriptdir'] . "/game/beta5/msgformat/$lang/$type.inc";
|
||
|
|
if (!(file_exists($path) && is_readable($path))) {
|
||
|
|
return null;
|
||
|
|
}
|
||
|
|
require_once($path);
|
||
|
|
eval('$this->formats[$type] = new msgformat_'.$type.'($this->lib->game);');
|
||
|
|
$this->formats[$type]->game = $this->game;
|
||
|
|
$this->formats[$type]->player = $player;
|
||
|
|
return $this->formats[$type];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|