Shanksera
New Member
- Joined
- Sep 23, 2008
- Messages
- 379
- Reaction score
- 1
Hello.I've using NICAW AAC v3.20 for my server (Avesta).I can make account and when i trying to maker player the error is:
player.php
Someone told me the bug is in my DB.I need table for groups , but which table?
Code:
Player::make() Cannot insert attributes:Error #1452
INSERT INTO `players` (`id`,`name`,`account_id`,`group_id`,`rank_id`,`vocation`,`sex`,`level`,`experience`,`health`,`healthmax`,`looktype`,`maglevel`,`mana`,`manamax`,`cap`,`town_id`,`posx`,`posy`,`posz`,`conditions`) VALUES (NULL,'Nicawtopedal',882171,1,0,1,1,10,9300,195,195,130,0,95,95,490,3,32369,32241,7,'');
Cannot add or update a child row: a foreign key constraint fails (`old`.`players`, CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`))
player.php on line: 192Script was terminated because something unexpected happened. You can report this, if you think it's a bug.player.php
Code:
*/
class Player extends SQL
{
private $attrs, $skills, $storage;
public function __construct()
{
parent::__construct();
}
public function find($name)
{
$player = $this->myRetrieve('players', array('name' => $name));
if ($player === false) return false;
$this->load($player['id']);
return true;
}
public function load($id)
{
//I don't load complete data like items etc, just the stuff I need
$player = $this->myRetrieve('players', array('id' => $id));
if ($player === false) return false;
$group = $this->myRetrieve('groups', array('id' => (int) $player['group_id']));
if ($group === false)
$this->attrs['access'] = 0;
else{
$this->attrs['group'] = (int) $player['group_id'];
$this->attrs['access'] = (int) $group['access'];
$this->attrs['position'] = (string) $group['name'];
}
$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['promoted'] = 0;
$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['redskulltime'] = (int) $player['redskulltime'];
$this->attrs['spawn']['x'] = (int) $player['posx'];
$this->attrs['spawn']['y'] = (int) $player['posy'];
$this->attrs['spawn']['z'] = (int) $player['posz'];
//get skills
$this->myQuery('SELECT * FROM `player_skills` WHERE `player_id` = '.$this->attrs['id']);
if ($this->failed()) throw new Exception('Cannot retrieve player skills<br/>'.$this->getError());
while($a = $this->fetch_array()){
$this->skills[$a['skillid']]['skill'] = (int)$a['value'];
$this->skills[$a['skillid']]['tries'] = (int)$a['count'];
}
//get storage
$this->myQuery('SELECT * FROM `player_storage` WHERE `player_id` = '.$this->attrs['id']);
if ($this->failed()) throw new Exception('Cannot retrieve player storage<br/>'.$this->gerError());
while($a = $this->fetch_array())
$this->storage[$a['key']] = (int)$a['value'];
//get guild stuff
$this->myQuery("SELECT players.guildnick, guild_ranks.level, guild_ranks.name, guilds.id, guilds.name FROM guild_ranks, players, guilds WHERE guilds.id = guild_ranks.guild_id AND players.rank_id = guild_ranks.id AND players.id = ".$this->attrs['id']);
if (!$this->failed() && $this->num_rows() == 1){
$a = $this->fetch_array();
$this->attrs['guild_nick'] = $a[0];
$this->attrs['guild_level'] = $a[1];
$this->attrs['guild_rank'] = $a[2];
$this->attrs['guild_id'] = $a[3];
$this->attrs['guild_name'] = $a[4];
}
return true;
}
public function save()
{
$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['redskulltime'] = (int) $player['redskulltime'];
return $this->myUpdate('players', $d, array('id' => $this->attrs['id']));
}
public function exists()
{
$this->myQuery('SELECT * FROM `players` WHERE `name` = '.$this->quote($this->attrs['name']));
if ($this->failed()) throw new Exception('Player::exists() cannot determine whether player exists');
if ($this->num_rows() > 0) return true;
return false;
}
public function getAttr($attr)
{
return $this->attrs[$attr];
}
public function isAttr($attr)
{
return isset($this->attrs[$attr]);
}
public function setAttr($attr,$value)
{
$this->attrs[$attr] = $value;
}
public function getStorage($id)
{
return $this->storage[$id];
}
public function getDeaths()
{
$query = "SELECT * FROM `player_deaths` WHERE (`player_id` = '".$this->escape_string($this->attrs['id'])."') ORDER BY time DESC LIMIT 10";
$this->myQuery($query);
if ($this->failed()) throw new Exception('Cannot retrieve deaths! This is only compatible with TFS.'.$this->getError());;
$i = 0;
while($a = $this->fetch_array()){
$list[$i]['killer'] = $a['killed_by'];
$list[$i]['level'] = $a['level'];
$list[$i]['date'] = $a['time'];
$i++;
}
return $list;
}
public function getSkill($n)
{
return $this->skills[$n]['skill'];
}
public function delete()
{
return $this->myDelete('players',array('id' => $this->attrs['id']),0)
&& $this->myDelete('player_items',array('player_id' => $this->attrs['id']),0)
&& $this->myDelete('player_depotitems',array('player_id' => $this->attrs['id']),0)
&& $this->myDelete('player_skills',array('player_id' => $this->attrs['id']),0)
&& $this->myDelete('player_storage',array('player_id' => $this->attrs['id']),0)
&& $this->myDelete('player_viplist',array('player_id' => $this->attrs['id']),0);
}
public function create()
{global $cfg;
if ($this->exists())
throw new Exception('Player already exists');
//make player
$d['id'] = NULL;
$d['name'] = $this->attrs['name'];
$d['account_id'] = $this->attrs['account'];
$d['group_id'] = $cfg['vocations'][$this->attrs['vocation']]['group'];
$d['rank_id'] = 0;
$d['vocation'] = $this->attrs['vocation'];
$d['sex'] = $this->attrs['sex'];
$d['level'] = getVocLvl($this->attrs['vocation']);
$d['experience'] = getVocExp($this->attrs['vocation']);
$d['health'] = $cfg['vocations'][$this->attrs['vocation']]['health'];
$d['healthmax'] = $cfg['vocations'][$this->attrs['vocation']]['health'];
$d['looktype'] = $cfg['vocations'][$this->attrs['vocation']]['look'][(int)$this->attrs['sex']];
$d['maglevel'] = $cfg['vocations'][$this->attrs['vocation']]['maglevel'];
$d['mana'] = $cfg['vocations'][$this->attrs['vocation']]['mana'];
$d['manamax'] = $cfg['vocations'][$this->attrs['vocation']]['mana'];
$d['cap'] = $cfg['vocations'][$this->attrs['vocation']]['cap'];
$d['town_id'] = $this->attrs['city'];
$d['posx'] = $cfg['temple'][$this->attrs['city']]['x'];
$d['posy'] = $cfg['temple'][$this->attrs['city']]['y'];
$d['posz'] = $cfg['temple'][$this->attrs['city']]['z'];
$d['conditions'] = '';
if (!$this->myInsert('players',$d)) throw new Exception('Player::make() Cannot insert attributes:<br/>'.$this->getError());
$this->attrs['id'] = $this->insert_id();
unset($d);
//make items
$sid = 100;
while ($item = current($cfg['vocations'][$this->attrs['vocation']]['equipment'])){
$sid++;
$d['player_id'] = $this->attrs['id'];
$d['pid'] = key($cfg['vocations'][$this->attrs['vocation']]['equipment']);
$d['sid'] = $sid;
$d['itemtype'] = $item;
$d['attributes']= '';
if (!$this->myInsert('player_items',$d)) throw new Exception('Player::make() Cannot insert items:<br/>'.$this->getError());
unset($d);
next($cfg['vocations'][$this->attrs['vocation']]['equipment']);
}
//make skills only if not created by trigger
$this->myQuery('SELECT COUNT(player_skills.skillid) as count FROM player_skills WHERE player_id = '.$this->quote($this->attrs['id']));
$a = $this->fetch_array();
$i = 0;
while ($skill = current($cfg['vocations'][(int)$this->attrs['vocation']]['skills'])){
$skill_id = key($cfg['vocations'][(int)$this->attrs['vocation']]['skills']);
if ($a['count'] == 0){
if (!$this->myInsert('player_skills',array('player_id' => $this->attrs['id'], 'skillid' => $skill_id, 'value' => $skill, 'count' => 0)))
throw new Exception('Player::make() Cannot insert skills:<br/>'.$this->getError());
}else{
if (!$this->myUpdate('player_skills',array('value' => $skill),array('player_id' => $this->attrs['id'], 'skillid' => $skill_id)))
throw new Exception('Player::make() Cannot update skills:<br/>'.$this->getError());
}
next($cfg['vocations'][$this->attrs['vocation']]['skills']);
}
return $this->load($this->attrs['id']);
}
public function repair()
{global $cfg;
$lvl = $this->attrs['level'];
$exp = AAC::getExperienceByLevel($lvl);
if (!$this->myUpdate('players',array(
'posx' => $cfg['temple'][$this->attrs['city']]['x'],
'posy' => $cfg['temple'][$this->attrs['city']]['y'],
'posz' => $cfg['temple'][$this->attrs['city']]['z']
/*, 'experience' => $exp*/), array('id' => $this->attrs['id']))) throw new Exception($this->getError());
return $this->load($this->attrs['id']);
}
}
?>Someone told me the bug is in my DB.I need table for groups , but which table?
