Hello, ive been searching around and found other post about this but nothing where its solved.
just that its fetched to only show one death.
So if someone can try help out then please do
just that its fetched to only show one death.
So if someone can try help out then please do
Code:
class Player {
private $attrs, $skills, $storage, $deaths, $guild, $is_online, $sql;
public function __construct() {
$this->sql = AAC::$SQL;
}
public function find($name) {
if (empty($name)) throw new PlayerNotFoundException();
$player = $this->sql->myRetrieve('players', array('name' => $name));
if ($player === false) throw new PlayerNotFoundException();
$this->load($player['id']);
return true;
}
private function load_deaths() {
if(empty($this->attrs['id'])) throw new PlayerNotLoadedException();
if($this->sql->isTable('player_deaths')) {
$query = "SELECT * FROM `player_deaths` WHERE (`player_id` = '".$this->sql->quote($this->attrs['id'])."') ORDER BY time DESC LIMIT 10";
$this->sql->myQuery($query);
$i = 0;
while($a = $this->sql->fetch_array()) {
$killer = new Player();
try {
$killer->find($a['lasthit_killer']);
$this->deaths[$i]['killer_name'] = $killer->attrs['name'];
$this->deaths[$i]['killer_id'] = $killer->attrs['id'];
} catch(PlayerNotFoundException $e) {
try {
$killer->load($death['lasthit_killer']);
$this->deaths[$i]['killer_name'] = $killer->attrs['name'];
$this->deaths[$i]['killer_id'] = $killer->attrs['id'];
} catch(PlayerNotFoundException $e) {
$this->deaths[$i]['killer_name'] = $a['lasthit_killer'];
$this->deaths[$i]['killer_id'] = null;
}
}
$this->deaths[$i]['victim_level'] = $a['level'];
$this->deaths[$i]['date'] = $a['time'];
$i++;
}
} else throw new DatabaseException('Deaths data not found in database or it is not compatible.');
return true;
}
private function load_skills() {
if(empty($this->attrs['id'])) throw new PlayerNotLoadedException();
$this->sql->myQuery('SELECT * FROM `player_skills` WHERE `player_id` = '.$this->sql->quote($this->attrs['id']));
while($a = $this->sql->fetch_array()) {
$this->skills[$a['skillid']]['skill'] = (int)$a['value'];
$this->skills[$a['skillid']]['tries'] = (int)$a['count'];
}
return true;
}
private function load_storage() {
if(empty($this->attrs['id'])) throw new PlayerNotLoadedException();
$this->sql->myQuery('SELECT * FROM `player_storage` WHERE `player_id` = '.$this->sql->quote($this->attrs['id']));
while($a = $this->sql->fetch_array())
$this->storage[$a['key']] = (int)$a['value'];
return true;
}
private function load_guild() {
if(empty($this->attrs['rank_id']) || $this->attrs['rank_id'] == 0) throw new GuildNotFoundException();
$this->sql->myQuery("SELECT guild_ranks.level, guild_ranks.name AS rank_name, guilds.id, guilds.name AS guild_name FROM guild_ranks, guilds WHERE guilds.id = guild_ranks.guild_id AND guild_ranks.id = ".$this->sql->quote($this->attrs['rank_id']));
if ($this->sql->num_rows() == 1) {
$a = $this->sql->fetch_array();
$this->guild['guild_nick'] = $this->attrs['guildnick'];
$this->guild['guild_level'] = $a['level'];
$this->guild['guild_rank_name'] = $a['rank_name'];
$this->guild['guild_rank_id'] = $this->attrs['rank_id'];
$this->guild['guild_id'] = $a['id'];
$this->guild['guild_name'] = $a['guild_name'];
}
return true;
}
public function reload() {
if(empty($this->attrs['id'])) throw new PlayerNotLoadedException();
unset($this->skills, $this->storage, $this->deaths, $this->guild);
load($this->attrs['id']);
return true;
}
public function load($id) {
if (!is_numeric($id)) throw new PlayerNotFoundException();
//Load player attributes
$player = $this->sql->myRetrieve('players', array('id' => $id));
if ($player === false) throw new PlayerNotFoundException();
$group = $this->sql->myRetrieve('groups', array('id' => (int) $player['group_id']));
if ($group === false)
$this->attrs['access'] = 0;
else {
$this->attrs['access'] = (int) $group['access'];
$this->attrs['position'] = (string) $group['name'];
}
if(isset($player['online'])) {
if((bool) $player['online'] == true) {
$this->is_online = true;
} else {
$this->is_online = false;
}
} elseif(isset($player['lastlogin']) && isset($player['lastlogout'])) {
if($player['lastlogin'] > $player['lastlogout']) {
$this->is_online = true;
} else {
$this->is_online = false;
}
} else {
$this->is_online = false;
}
$this->attrs['group'] = (int) $player['group_id'];
$this->attrs['id'] = (int) $player['id'];
$this->attrs['name'] = (string) $player['name'];
$this->attrs['account'] = (int) $player['account_id'];
$this->attrs['level'] = (int) $player['level'];
$this->attrs['vocation'] = (int) $player['vocation'];
$this->attrs['experience'] = (int) $player['experience'];
$this->attrs['maglevel'] = (int) $player['maglevel'];
$this->attrs['city'] = (int) $player['town_id'];
$this->attrs['sex'] = (int) $player['sex'];
$this->attrs['lastlogin'] = (int) $player['lastlogin'];
$this->attrs['rank_id'] = (int) $player['rank_id'];
$this->attrs['guildnick'] = (string) $player['guildnick'];
$this->attrs['spawn']['x'] = (int) $player['posx'];
$this->attrs['spawn']['y'] = (int) $player['posy'];
$this->attrs['spawn']['z'] = (int) $player['posz'];
$this->attrs['guildnick'] = (string) $player['guildnick'];
return true;
}
public function save() {
//cannot save player unless it's offline
if($this->is_online) throw new PlayerIsOnlineException();
//only save these fields
$d['group_id'] = $this->attrs['group'];
$d['name'] = $this->attrs['name'];
$d['account_id'] = $this->attrs['account'];
$d['level'] = $this->attrs['level'];
$d['vocation'] = $this->attrs['vocation'];
$d['experience'] = $this->attrs['experience'];
$d['maglevel'] = $this->attrs['maglevel'];
$d['town_id'] = $this->attrs['city'];
$d['sex'] = $this->attrs['sex'];
$d['rank_id'] = $this->attrs['rank_id'];
$d['guildnick'] = $this->attrs['guildnick'];
$this->sql->myUpdate('players', $d, array('id' => $this->attrs['id']));
return true;
}
public function save_guild() {
$d['rank_id'] = $this->attrs['rank_id'];
$d['guildnick'] = $this->attrs['guildnick'];
$this->sql->myUpdate('players', $d, array('id' => $this->attrs['id']));
return true;
}
public function setAttr($attr, $val) {
if(array_key_exists($attr, $this->attrs))
$this->attrs[$attr] = $val;
else
throw new ClassException('Parameter '.$attr.' does not exist.');
}
public function isOnline() {
return $this->is_online;
}
static public function exists($name) {
$SQL = AAC::$SQL;
$SQL->myQuery('SELECT * FROM `players` WHERE `name` = '.$SQL->quote($name));
if ($SQL->num_rows() > 0) return true;
return false;
}
public function __get($attr) {
if(empty($this->attrs['id']))
throw new ClassException('Attempt to get attribute of player that is not loaded.');
if($attr == 'attrs') {
return $this->attrs;
}elseif($attr == 'skills') {
if(empty($this->skills)) $this->load_skills();
return $this->skills;
}elseif($attr == 'deaths') {
if(empty($this->deaths)) $this->load_deaths();
return $this->deaths;
}elseif($attr == 'storage') {
if(empty($this->storage)) $this->load_storage();
return $this->storage;
}elseif($attr == 'guild') {
if(empty($this->guild)) $this->load_guild();
return $this->guild;
}else {
throw new ClassException('Undefined property: '.$attr);
}
}
public function delete() {
if(empty($this->attrs['id'])) throw new PlayerNotLoadedException();
try {
$guild = new Guild();
$guild->load($this->guild['guild_id']);
$guild->remove();
} catch (GuildNotFoundException $e) {}
$this->sql->myDelete('players',array('id' => $this->attrs['id']),0)
&& $this->sql->myDelete('player_items',array('player_id' => $this->attrs['id']),0)
&& $this->sql->myDelete('player_depotitems',array('player_id' => $this->attrs['id']),0)
&& $this->sql->myDelete('player_skills',array('player_id' => $this->attrs['id']),0)
&& $this->sql->myDelete('player_storage',array('player_id' => $this->attrs['id']),0)
&& $this->sql->myDelete('player_viplist',array('player_id' => $this->attrs['id']),0)
&& $this->sql->myDelete('guilds',array('ownerid' => $this->attrs['id']),0);
}
static public function Create($name, $account, $vocation, $sex, $city) {global $cfg;
$SQL = AAC::$SQL;
$group_id = $cfg['vocations'][$vocation]['group'];
if ($SQL->isTable('groups')) {
$group = $SQL->myRetrieve('groups', array('id' => $group_id));
if ($group === false) {
throw new ClassException('Player::Create() Group #'.$group_id.' does not exist. Check your database and config file.', 6);
}
}
$d['id'] = NULL;
$d['name'] = $name;
$d['account_id'] = $account;
$d['group_id'] = $group_id;
$d['rank_id'] = 0;
$d['vocation'] = $vocation;
$d['sex'] = $sex;
$d['level'] = getVocLvl($vocation);
$d['experience'] = getVocExp($vocation);
$d['health'] = $cfg['vocations'][$vocation]['health'];
$d['healthmax'] = $cfg['vocations'][$vocation]['health'];
$d['looktype'] = $cfg['vocations'][$vocation]['look'][$sex];
$d['maglevel'] = $cfg['vocations'][$vocation]['maglevel'];
$d['mana'] = $cfg['vocations'][$vocation]['mana'];
$d['manamax'] = $cfg['vocations'][$vocation]['mana'];
$d['cap'] = $cfg['vocations'][$vocation]['cap'];
$d['town_id'] = $city;
$d['posx'] = $cfg['temple'][$city]['x'];
$d['posy'] = $cfg['temple'][$city]['y'];
$d['posz'] = $cfg['temple'][$city]['z'];
$d['conditions'] = '';
$SQL->myInsert('players',$d);
$pid = $SQL->insert_id();
unset($d);
//make items
$sid = 100;
while ($item = current($cfg['vocations'][$vocation]['equipment'])) {
$sid++;
$d['player_id'] = $pid;
$d['pid'] = key($cfg['vocations'][$vocation]['equipment']);
$d['sid'] = $sid;
$d['itemtype'] = $item;
$d['attributes']= '';
$SQL->myInsert('player_items',$d);
unset($d);
next($cfg['vocations'][$vocation]['equipment']);
}
//make skills only if not created by trigger
$SQL->myQuery('SELECT COUNT(player_skills.skillid) as count FROM player_skills WHERE player_id = '.$SQL->quote($pid));
$a = $SQL->fetch_array();
$i = 0;
while ($skill = current($cfg['vocations'][$vocation]['skills'])) {
$skill_id = key($cfg['vocations'][$vocation]['skills']);
if ($a['count'] == 0) {
$SQL->myInsert('player_skills',array('player_id' => $pid, 'skillid' => $skill_id, 'value' => $skill, 'count' => 0));
}else {
$SQL->myUpdate('player_skills',array('value' => $skill),array('player_id' => $pid, 'skillid' => $skill_id));
}
next($cfg['vocations'][$vocation]['skills']);
}
$player = new Player();
$player->load($pid);
return $player;
}
public function repair() {global $cfg;
$lvl = $this->attrs['level'];
$exp = AAC::getExperienceByLevel($lvl);
$this->sql->myUpdate('players',array(
'posx' => $cfg['temple'][$this->attrs['city']]['x'],
'posy' => $cfg['temple'][$this->attrs['city']]['y'],
'posz' => $cfg['temple'][$this->attrs['city']]['z']
), array('id' => $this->attrs['id']));
}
}
?>