Файл: include/clan.php
Строк: 138
<?php
include_once("base.php");
/**
clan classes
*/
class CClan extends CBase
{
function CClan($database,$vnum=0)
{
$this->db = $database;
$this->table_name="data_clan";
$this->vnum=$vnum;
}
/**
Create clan
*/
function createClan($name,$leader_vnum,$open,$site)
{
$cur_time=time();
$sql = "INSERT INTO data_clan(name,leader,open,site) VALUES ('$name','$leader_vnum','$open','$site')";
$this->execSQL($sql);
}
/**
Get list all clans
*/
function getList()
{
$sql = "SELECT t1.vnum, t1. name, t2.name,t1.site,t1.open FROM data_clan AS t1, data_player AS t2 WHERE t1.leader=t2.vnum";
$result=$this->execSQL($sql);
$list_clan = array();
while($row = $result->fetchRow())
{
$list_clan[] = array("vnum" => $row[0],"name" => $row[1], "leader" => $row[2],"site" => $row[3],"open" => $row[4]);
}
return $list_clan;
}
/**
Get clan name
*/
function getName()
{
return $this->getProperty('name');
}
/**
Get clan members
*/
function getClanMembers()
{
$sql = "SELECT vnum,name FROM data_player WHERE clan='$this->vnum'";
$members = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $members;
}
/**
get clan gold
*/
function getGold()
{
return $this->getProperty("gold");
}
/**
update clan gold
*/
function updateGold($gold)
{
$this->changeProperty('gold',$gold);
}
/**
Get leader clan
*/
function getLeader()
{
return $this->getProperty("leader");
}
}
class CClanDemand extends CBase
{
function CClanDemand($database,$vnum=0)
{
$this->db = $database;
$this->table_name="data_clan_demand";
$this->vnum=$vnum;
}
function addDemand($clan)
{
$ts = time();
$uuid = getUniqValue();
$sql = "INSERT INTO $this->table_name(vnum_player,vnum_clan,uuid,times)
VALUES('$this->vnum','$clan','$uuid','$ts')";
$this->execSQL($sql);
}
function getDemandForClan($clan)
{
$sql = "SELECT t1.vnum,t1.vnum_player,t1.vnum_clan,t1.uuid,t1.times,t2.name FROM $this->table_name as t1, data_player as t2 WHERE vnum_clan='$clan' and t1.vnum_player=t2.vnum";
$demand = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $demand;
}
function getDemand()
{
$sql = "SELECT vnum_player FROM $this->table_name WHERE vnum_player=$this->vnum";
$demand = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $demand;
}
function chechDemand($uuid)
{
$sql = "SELECT * FROM $this->table_name WHERE uuid='$uuid'";
$demand = $this->db->getAll($sql,DB_FETCHMODE_ASSOC);
return $demand;
}
function delDemand($vnum)
{
$sql = "DELETE FROM $this->table_name WHERE vnum='$vnum'";
$this->execSQL($sql);
}
}
?>