What my problem is.
at my database it shows killed_by "dragon lord"
but at my homepage it only shows
20th July 2011 12:37:58 Killed at level 9 by
Because i dont got the same code in player_deaths as i have in player.php
player_deaths columns.
player.php
Where i think it all needs to be edited.
at my database it shows killed_by "dragon lord"
but at my homepage it only shows
20th July 2011 12:37:58 Killed at level 9 by
Because i dont got the same code in player_deaths as i have in player.php
player_deaths columns.
Code:
player_id time level killed_byplayer.php
Code:
<?php
/*
Copyright (C) 2007 - 2009 Nicaw
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
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']));
}
}
?>Where i think it all needs to be edited.
Code:
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;
}
}