Ir para conteúdo
  • Cadastre-se

erro ao ver uma conta banida


Posts Recomendados

qnd clico numa conta banida, aparece esse erro:

Warning: Invalid argument supplied for foreach() in C:\xampp2\htdocs\classes\account.php on line 159

aqui a minha account.php:

<?php
if(!defined('INITIALIZED'))
exit;
 
class Account extends ObjectData
{
const LOADTYPE_ID = 'id';
const LOADTYPE_NAME = 'name';
const LOADTYPE_MAIL = 'email';
public static $table = 'accounts';
public $data = array('name' => null, 'password' => null, 'premdays' => null, 'lastday' => null, 'email' => null, 'key' => null, 'create_ip' => null, 'creation' => null, 'premium_points' => null, 'page_access' => null, 'location' => null, 'rlname' => null, 'email_new' => null, 'email_new_time' => null, 'email_code' => null, 'next_email' => null, 'last_post' => null, 'flag' => null);
public static $fields = array('id', 'name', 'password', 'premdays', 'lastday', 'email', 'key', 'create_ip', 'creation', 'premium_points', 'page_access', 'location', 'rlname', 'email_new', 'email_new_time', 'email_code', 'next_email', 'last_post', 'flag');
public $players;
public $playerRanks;
public $guildAccess;
public $bans;
 
    public function __construct($search_text = null, $search_by = self::LOADTYPE_ID)
    {
if($search_text != null)
$this->load($search_text, $search_by);
    }
 
public function load($search_text, $search_by = self::LOADTYPE_ID)
{
if(in_array($search_by, self::$fields))
$search_string = $this->getDatabaseHandler()->fieldName($search_by) . ' = ' . $this->getDatabaseHandler()->quote($search_text);
else
new Error_Critic('', 'Wrong Account search_by type.');
$fieldsArray = array();
foreach(self::$fields as $fieldName)
$fieldsArray[$fieldName] = $this->getDatabaseHandler()->fieldName($fieldName);
$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();
}
 
public function loadById($id)
{
$this->load($id, 'id');
}
 
public function loadByName($name)
{
$this->load($name, 'name');
}
 
public function loadByEmail($mail)
{
$this->load($mail, 'email');
}
 
public function save($forceInsert = false)
{
if(!isset($this->data['id']) || $forceInsert)
{
$keys = array();
$values = array();
foreach(self::$fields as $key)
if($key != 'id')
{
$keys[] = $this->getDatabaseHandler()->fieldName($key);
$values[] = $this->getDatabaseHandler()->quote($this->data[$key]);
}
$this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName(self::$table) . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')');
$this->setID($this->getDatabaseHandler()->lastInsertId());
}
else
{
$updates = array();
foreach(self::$fields as $key)
if($key != 'id')
$updates[] = $this->getDatabaseHandler()->fieldName($key) . ' = ' . $this->getDatabaseHandler()->quote($this->data[$key]);
$this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . implode(', ', $updates) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
}
}
 
public function getPlayers($forceReload = false)
{
if(!isset($this->players) || $forceReload)
{
$this->players = new DatabaseList('Player');
$this->players->setFilter(new SQL_Filter(new SQL_Field('account_id'), SQL_Filter::EQUAL, $this->getID()));
$this->players->addOrder(new SQL_Order(new SQL_Field('name')));
}
return $this->players;
}
/*
public function getGuildRanks($forceReload = false)
{
if(!isset($this->playerRanks) || $forceReload)
{
$this->playerRanks = new DatabaseList('AccountGuildRank');
$filterAccount = new SQL_Filter(new SQL_Field('account_id', 'players'), SQL_Filter::EQUAL, $this->getID());
$filterPlayer1 = new SQL_Filter(new SQL_Field('id', 'players'), SQL_Filter::EQUAL, new SQL_Field('player_id', 'guild_membership'));
$filterPlayer2 = new SQL_Filter(new SQL_Field('rank_id', 'guild_membership'), SQL_Filter::EQUAL, new SQL_Field('id', 'guild_ranks'));
$filterGuild = new SQL_Filter(new SQL_Field('guild_id', 'guild_ranks'), SQL_Filter::EQUAL, new SQL_Field('id', 'guilds'));
$filter = new SQL_Filter($filterAccount, SQL_Filter::CRITERIUM_AND, $filterPlayer1);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterPlayer2);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterGuild);
$this->playerRanks->setFilter($filter);
}
return $this->playerRanks;
}
 
public function loadGuildAccess($forceReload = false)
{
if(!isset($this->guildAccess) || $forceReload)
{
$this->guildAccess = array();
foreach($this->getGuildRanks($forceReload) as $rank)
if($rank->getOwnerID() == $rank->getPlayerID())
$this->guildAccess[$rank->getGuildID()] = Guild::LEVEL_OWNER;
elseif(!isset($this->guildAccess[$rank->getGuildID()]) || $rank->getLevel() > $this->guildAccess[$rank->getGuildID()])
$this->guildAccess[$rank->getGuildID()] = $rank->getLevel();
}
}
 
public function isInGuild($guildId, $forceReload = false)
{
$this->loadGuildAccess($forceReload);
return isset($this->guildAccess[$guildId]);
}
 
public function getGuildLevel($guildId, $forceReload = false)
{
$this->loadGuildAccess($forceReload);
if(isset($this->guildAccess[$guildId]))
return $this->guildAccess[$guildId];
else
return 0;
}
*/
public function unban()
{
        $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('account_bans') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('account_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
 
        unset($this->bans);
}
 
public function loadBans($forceReload = false)
{
if(!isset($this->bans) || $forceReload)
{
$this->bans = new DatabaseList('AccountBan');
$filter = new SQL_Filter(new SQL_Field('account_id'), SQL_Filter::EQUAL, $this->data['id']);
$this->bans->setFilter($filter);
}
}
 
public function isBanned($forceReload = false)
{
$this->loadBans($forceReload);
return count($this->bans) > 0;
}
 
public function getBanTime($forceReload = false)
{
$this->loadBans($forceReload);
$lastExpires = 0;
foreach($bans as $ban)
{
if($ban->getExpiresAt() <= 0)
{
$lastExpires = 0;
break;
}
if($ban->getExpiresAt() > time() && $ban->getExpiresAt() > $lastExpires)
$lastExpires = $ban->getExpiresAt();
}
return $lastExpires;
}
 
    public function delete()
    {
        $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
 
        unset($this->data['id']);
    }
 
public function setID($value){$this->data['id'] = $value;}
public function getID(){return $this->data['id'];}
public function setName($value){$this->data['name'] = $value;}
public function getName(){return $this->data['name'];}
public function setPassword($value)
{
$this->data['password'] = Website::encryptPassword($value, $this);
}
public function getPassword(){return $this->data['password'];}
public function setPremDays($value){$this->data['premdays'] = $value;}
public function getPremDays(){return $this->data['premdays'] - (date("z", time()) + (365 * (date("Y", time()) - date("Y", $this->data['lastday']))) - date("z", $this->data['lastday']));}
public function setLastDay($value){$this->data['lastday'] = $value;}
public function getLastDay(){return $this->data['lastday'];}
public function setMail($value){$this->data['email'] = $value;}
public function getMail(){return $this->data['email'];}
public function setKey($value){$this->data['key'] = $value;}
public function getKey(){return $this->data['key'];}
/*
 * Custom AAC fields
 * create_ip , INT, default 0
 * premium_points , INT, default 0
 * page_access, INT, default 0
 * location, VARCHAR(255), default ''
 * rlname, VARCHAR(255), default ''
*/
public function setCreateIP($value){$this->data['create_ip'] = $value;}
public function getCreateIP(){return $this->data['create_ip'];}
public function setCreateDate($value){$this->data['creation'] = $value;}
public function getCreateDate(){return $this->data['creation'];}
public function setPremiumPoints($value){$this->data['premium_points'] = $value;}
public function getPremiumPoints(){return $this->data['premium_points'];}
public function setPageAccess($value){$this->data['page_access'] = $value;}
public function getPageAccess(){return $this->data['page_access'];}
 
public function setLocation($value){$this->data['location'] = $value;}
public function getLocation(){return $this->data['location'];}
public function setRLName($value){$this->data['rlname'] = $value;}
public function getRLName(){return $this->data['rlname'];}
public function setFlag($value){$this->data['flag'] = $value;}
public function getFlag(){return $this->data['flag'];}
/*
 * for compability with old scripts
*/
public function getEMail(){return $this->getMail();}
public function setEMail($value){$this->setMail($value);}
public function getPlayersList(){return $this->getPlayers();}
public function getGuildAccess($guildID){return $this->getGuildLevel($guildID);}
 
public function isValidPassword($password)
{
return ($this->data['password'] == Website::encryptPassword($password, $this));
}
 
public function find($name){$this->loadByName($name);}
public function findByEmail($email){$this->loadByEmail($email);}
public function isPremium(){return ($this->getPremDays() > 0);}
public function getLastLogin(){return $this->getLastDay();}
}

Te ajudei? Então Rep + ;)

Link para o post
Compartilhar em outros sites

Tenta assim.

 

<?php
if(!defined('INITIALIZED'))
exit;
 
class Account extends ObjectData
{
const LOADTYPE_ID = 'id';
const LOADTYPE_NAME = 'name';
const LOADTYPE_MAIL = 'email';
public static $table = 'accounts';
public $data = array('name' => null, 'password' => null, 'premdays' => null, 'lastday' => null, 'email' => null, 'key' => null, 'create_ip' => null, 'creation' => null, 'premium_points' => null, 'page_access' => null, 'location' => null, 'rlname' => null, 'email_new' => null, 'email_new_time' => null, 'email_code' => null, 'next_email' => null, 'last_post' => null, 'flag' => null);
public static $fields = array('id', 'name', 'password', 'premdays', 'lastday', 'email', 'key', 'create_ip', 'creation', 'premium_points', 'page_access', 'location', 'rlname', 'email_new', 'email_new_time', 'email_code', 'next_email', 'last_post', 'flag');
public $players;
public $playerRanks;
public $guildAccess;
public $bans;
 
    public function __construct($search_text = null, $search_by = self::LOADTYPE_ID)
    {
if($search_text != null)
$this->load($search_text, $search_by);
    }
 
public function load($search_text, $search_by = self::LOADTYPE_ID)
{
if(in_array($search_by, self::$fields))
$search_string = $this->getDatabaseHandler()->fieldName($search_by) . ' = ' . $this->getDatabaseHandler()->quote($search_text);
else
new Error_Critic('', 'Wrong Account search_by type.');
$fieldsArray = array();
foreach(self::$fields as $fieldName)
$fieldsArray[$fieldName] = $this->getDatabaseHandler()->fieldName($fieldName);
$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();
}
 
public function loadById($id)
{
$this->load($id, 'id');
}
 
public function loadByName($name)
{
$this->load($name, 'name');
}
 
public function loadByEmail($mail)
{
$this->load($mail, 'email');
}
 
public function save($forceInsert = false)
{
if(!isset($this->data['id']) || $forceInsert)
{
$keys = array();
$values = array();
foreach(self::$fields as $key)
if($key != 'id')
{
$keys[] = $this->getDatabaseHandler()->fieldName($key);
$values[] = $this->getDatabaseHandler()->quote($this->data[$key]);
}
$this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName(self::$table) . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')');
$this->setID($this->getDatabaseHandler()->lastInsertId());
}
else
{
$updates = array();
foreach(self::$fields as $key)
if($key != 'id')
$updates[] = $this->getDatabaseHandler()->fieldName($key) . ' = ' . $this->getDatabaseHandler()->quote($this->data[$key]);
$this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . implode(', ', $updates) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
}
}
 
public function getPlayers($forceReload = false)
{
if(!isset($this->players) || $forceReload)
{
$this->players = new DatabaseList('Player');
$this->players->setFilter(new SQL_Filter(new SQL_Field('account_id'), SQL_Filter::EQUAL, $this->getID()));
$this->players->addOrder(new SQL_Order(new SQL_Field('name')));
}
return $this->players;
}
/*
public function getGuildRanks($forceReload = false)
{
if(!isset($this->playerRanks) || $forceReload)
{
$this->playerRanks = new DatabaseList('AccountGuildRank');
$filterAccount = new SQL_Filter(new SQL_Field('account_id', 'players'), SQL_Filter::EQUAL, $this->getID());
$filterPlayer1 = new SQL_Filter(new SQL_Field('id', 'players'), SQL_Filter::EQUAL, new SQL_Field('player_id', 'guild_membership'));
$filterPlayer2 = new SQL_Filter(new SQL_Field('rank_id', 'guild_membership'), SQL_Filter::EQUAL, new SQL_Field('id', 'guild_ranks'));
$filterGuild = new SQL_Filter(new SQL_Field('guild_id', 'guild_ranks'), SQL_Filter::EQUAL, new SQL_Field('id', 'guilds'));
$filter = new SQL_Filter($filterAccount, SQL_Filter::CRITERIUM_AND, $filterPlayer1);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterPlayer2);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterGuild);
$this->playerRanks->setFilter($filter);
}
return $this->playerRanks;
}
 
public function loadGuildAccess($forceReload = false)
{
if(!isset($this->guildAccess) || $forceReload)
{
$this->guildAccess = array();
foreach($this->getGuildRanks($forceReload) as $rank)
if($rank->getOwnerID() == $rank->getPlayerID())
$this->guildAccess[$rank->getGuildID()] = Guild::LEVEL_OWNER;
elseif(!isset($this->guildAccess[$rank->getGuildID()]) || $rank->getLevel() > $this->guildAccess[$rank->getGuildID()])
$this->guildAccess[$rank->getGuildID()] = $rank->getLevel();
}
}
 
public function isInGuild($guildId, $forceReload = false)
{
$this->loadGuildAccess($forceReload);
return isset($this->guildAccess[$guildId]);
}
 
public function getGuildLevel($guildId, $forceReload = false)
{
$this->loadGuildAccess($forceReload);
if(isset($this->guildAccess[$guildId]))
return $this->guildAccess[$guildId];
else
return 0;
}
*/
public function unban()
{
        $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('account_bans') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('account_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
 
        unset($this->bans);
}
 
public function loadBans($forceReload = false)
{
if(!isset($this->bans) || $forceReload)
{
$this->bans = new DatabaseList('AccountBan');
$filter = new SQL_Filter(new SQL_Field('account_id'), SQL_Filter::EQUAL, $this->data['id']);
$this->bans->setFilter($filter);
}
}
 
public function isBanned($forceReload = false)
{
$this->loadBans($forceReload);
return count($this->bans) > 0;
}
 
public function getBanTime($forceReload = false)
{
$this->loadBans($forceReload);
$lastExpires = 0;
foreach ($bans as $ban) {
     // ...
    }
}
{
if($ban->getExpiresAt() <= 0)
{
$lastExpires = 0;
break;
}
if($ban->getExpiresAt() > time() && $ban->getExpiresAt() > $lastExpires)
$lastExpires = $ban->getExpiresAt();
}
return $lastExpires;
}
 
    public function delete()
    {
        $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
 
        unset($this->data['id']);
    }
 
public function setID($value){$this->data['id'] = $value;}
public function getID(){return $this->data['id'];}
public function setName($value){$this->data['name'] = $value;}
public function getName(){return $this->data['name'];}
public function setPassword($value)
{
$this->data['password'] = Website::encryptPassword($value, $this);
}
public function getPassword(){return $this->data['password'];}
public function setPremDays($value){$this->data['premdays'] = $value;}
public function getPremDays(){return $this->data['premdays'] - (date("z", time()) + (365 * (date("Y", time()) - date("Y", $this->data['lastday']))) - date("z", $this->data['lastday']));}
public function setLastDay($value){$this->data['lastday'] = $value;}
public function getLastDay(){return $this->data['lastday'];}
public function setMail($value){$this->data['email'] = $value;}
public function getMail(){return $this->data['email'];}
public function setKey($value){$this->data['key'] = $value;}
public function getKey(){return $this->data['key'];}
/*
 * Custom AAC fields
 * create_ip , INT, default 0
 * premium_points , INT, default 0
 * page_access, INT, default 0
 * location, VARCHAR(255), default ''
 * rlname, VARCHAR(255), default ''
*/
public function setCreateIP($value){$this->data['create_ip'] = $value;}
public function getCreateIP(){return $this->data['create_ip'];}
public function setCreateDate($value){$this->data['creation'] = $value;}
public function getCreateDate(){return $this->data['creation'];}
public function setPremiumPoints($value){$this->data['premium_points'] = $value;}
public function getPremiumPoints(){return $this->data['premium_points'];}
public function setPageAccess($value){$this->data['page_access'] = $value;}
public function getPageAccess(){return $this->data['page_access'];}
 
public function setLocation($value){$this->data['location'] = $value;}
public function getLocation(){return $this->data['location'];}
public function setRLName($value){$this->data['rlname'] = $value;}
public function getRLName(){return $this->data['rlname'];}
public function setFlag($value){$this->data['flag'] = $value;}
public function getFlag(){return $this->data['flag'];}
/*
 * for compability with old scripts
*/
public function getEMail(){return $this->getMail();}
public function setEMail($value){$this->setMail($value);}
public function getPlayersList(){return $this->getPlayers();}
public function getGuildAccess($guildID){return $this->getGuildLevel($guildID);}
 
public function isValidPassword($password)
{
return ($this->data['password'] == Website::encryptPassword($password, $this));
}
 
public function find($name){$this->loadByName($name);}
public function findByEmail($email){$this->loadByEmail($email);}
public function isPremium(){return ($this->getPremDays() > 0);}
public function getLastLogin(){return $this->getLastDay();}
}

Link para o post
Compartilhar em outros sites

Nao aconteceu nada,

acho que é nessa aqui: ban.php

<?php
if(!defined('INITIALIZED'))
exit;
 
class Ban extends ObjectData
{
const TYPE_IP = 1;
const TYPE_PLAYER = 2;
const TYPE_ACCOUNT = 3;
const TYPE_NOTATION = 4;
const TYPE_STATEMENT = 5;
 
const PLAYERBAN_NONE = 0;
const PLAYERBAN_REPORT = 1;
const PLAYERBAN_LOCK = 2;
const PLAYERBAN_BANISHMENT = 3;
 
public static $table = 'bans';
public $data = array('type' => null, 'value' => null, 'param' => null, 'active' => null, 'expires' => null, 'added' => null, 'admin_id' => null, 'comment' => null);
public static $fields = array('id', 'type', 'value', 'param', 'active', 'expires', 'added', 'admin_id', 'comment');
 
    public function __construct($search_text = null)
    {
if($search_text != null)
$this->load($search_text);
    }
 
public function load($search_text)
{
$search_string = $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($search_text);
$fieldsArray = array();
foreach(self::$fields as $fieldName)
$fieldsArray[$fieldName] = $this->getDatabaseHandler()->fieldName($fieldName);
$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();
}
 
public function save($forceInsert = false)
{
if(!isset($this->data['id']) || $forceInsert)
{
$keys = array();
$values = array();
foreach(self::$fields as $key)
if($key != 'id')
{
$keys[] = $this->getDatabaseHandler()->fieldName($key);
$values[] = $this->getDatabaseHandler()->quote($this->data[$key]);
}
$this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName(self::$table) . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')');
$this->setID($this->getDatabaseHandler()->lastInsertId());
}
else
{
$updates = array();
foreach(self::$fields as $key)
if($key != 'id')
$updates[] = $this->getDatabaseHandler()->fieldName($key) . ' = ' . $this->getDatabaseHandler()->quote($this->data[$key]);
$this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . implode(', ', $updates) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
}
}
 
 
public function setID($value){$this->data['id'] = $value;}
public function getID(){return $this->data['id'];}
public function setType($value){$this->data['type'] = $value;}
public function getType(){return $this->data['type'];}
public function setValue($value){$this->data['value'] = $value;}
public function getValue(){return $this->data['value'];}
public function setParam($value){$this->data['param'] = $value;}
public function getParam(){return $this->data['param'];}
public function setActive($value){$this->data['active'] = $value;}
public function getActive(){return $this->data['active'];}
public function setExpires($value){$this->data['expires'] = $value;}
public function getExpires(){return $this->data['expires'];}
public function setAdded($value){$this->data['added'] = $value;}
public function getAdded(){return $this->data['added'];}
public function setAdminID($value){$this->data['admin_id'] = $value;}
public function getAdminID(){return $this->data['admin_id'];}
public function setComment($value){$this->data['comment'] = $value;}
public function getComment(){return $this->data['comment'];}
}

 
uso gesior tfs 1.0

Te ajudei? Então Rep + ;)

Link para o post
Compartilhar em outros sites

aqu o erro

Query: SELECT `id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Teste' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `create_ip`, `creation`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `id` = '3' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `player_id` FROM `players_online` SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` WHERE `account_id` = '3' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '522' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `id`, `guild_id`, `name`, `level` FROM `guild_ranks` WHERE `id` = '1' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '1' SQLSTATE: 00000 Driver code:   Error message:   Query: SELECT `player_deaths`.`player_id`, `player_deaths`.`time`, `player_deaths`.`level`, `player_deaths`.`killed_by`, `player_deaths`.`is_player`, `player_deaths`.`mostdamage_by`, `player_deaths`.`mostdamage_is_player`, `player_deaths`.`unjustified`, `player_deaths`.`mostdamage_unjustified`, `players`.`id`, `players`.`name` FROM `players`, `player_deaths` WHERE `player_id` = '522' AND `players`.`id` = `player_deaths`.`player_id` ORDER BY `time` DESC LIMIT 20 SQLSTATE: 00000 Driver code:   Error message:  

Warning: Invalid argument supplied for foreach() in C:\xampp2\htdocs\classes\account.php on line 159
 

Query: SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char` FROM `players` WHERE `account_id` = '3' ORDER BY `name` ASC SQLSTATE: 00000 Driver code:   Error message:

Te ajudei? Então Rep + ;)

Link para o post
Compartilhar em outros sites

edit

 
Alias, onde vejo iss?
Editado por narazaky (veja o histórico de edições)

Te ajudei? Então Rep + ;)

Link para o post
Compartilhar em outros sites

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo