Erro Step 4 e 5 Gesior TFS 1.0

[Reloaded 8]

STEP 4

Add samples to DB:

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\classes\account.php on line 33

 

 

Alguem pode ajuda?

[nosqetah 0]

Também to com esse mesmo erro mano, ajuda nóis ai!

[paulo thush 179]

Vai em Index.PHP

 

define('DEBUG_DATABASE', false);

 

Muda de False Para treu.

[nosqetah 0]

mano já tentei isso, ainda continua o erro

[paulo thush 179]

Continua com o mesmo erro?.

[nosqetah 0]

sim mesmo erro ainda

[luanluciano93 1993]

Quando você coloca TRUE ele mostra qual é a coluna que esta faltando em determinada database.

Você deve adicionar aquela coluna direto no phpmyadmin, e depois volta pra FALSE no database_errors

Espero ter ajudado.

 

[nosqetah 0]

e como eu adiciono esta coluna cara?

 

 

 

 Add samples to DB:

Fatal error: Call to a member function fetch() on a non-object in C:\Users\Ricardo\Documents\xampp\htdocs\classes\account.php on line 33

 

 

aqui meu player.php

<?php

if(!defined('INITIALIZED'))

exit;

 

class Player extends ObjectData

{

const LOADTYPE_ID = 'id';

const LOADTYPE_NAME = 'name';

const LOADTYPE_ACCOUNT_ID = 'account_id';

public static $table = 'players';

public $data = array('name' => null, 'group_id' => null, 'account_id' => null, 'level' => null, 'vocation' => null, 'health' => null, 'healthmax' => null, 'experience' => null, 'lookbody' => null, 'lookfeet' => null, 'lookhead' => null, 'looklegs' => null, 'looktype' => null, 'lookaddons' => null, 'maglevel' => null, 'mana' => null, 'manamax' => null, 'manaspent' => null, 'soul' => null, 'town_id' => null, 'posx' => null, 'posy' => null, 'posz' => null, 'conditions' => null, 'cap' => null, 'sex' => null, 'lastlogin' => null, 'lastip' => null, 'save' => null, 'skull' => null, 'skulltime' => null, 'lastlogout' => null, 'blessings' => null, 'balance' => null, 'stamina' => null, 'skill_fist' => null, 'skill_fist_tries' => null, 'skill_club' => null, 'skill_club_tries' => null, 'skill_sword' => null, 'skill_sword_tries' => null, 'skill_axe' => null, 'skill_axe_tries' => null, 'skill_dist' => null, 'skill_dist_tries' => null, 'skill_shielding' => null, 'skill_shielding_tries' => null, 'skill_fishing' => null, 'skill_fishing_tries' => null , 'deleted' => null, 'create_ip' => null, 'create_date' => null, 'comment' => null, 'hide_char' => null);

public static $fields = array('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');

public static $skillNames = array('fist', 'club', 'sword', 'axe', 'dist', 'shielding', 'fishing');

public $items;

public $storages;

public $account;

public $rank;

public $guildNick;

public static $onlineList;

 

    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 Player search_by type.');

$fieldsArray = array();

foreach(self::$fields as $fieldName)

$fieldsArray[] = $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, self::LOADTYPE_ID);

}

 

public function loadByName($name)

{

$this->load($name, self::LOADTYPE_NAME);

}

 

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)

$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 getItems($forceReload = false)

{

if(!isset($this->items) || $forceReload)

$this->items = new ItemsList($this->getID());

 

return $this->items;

}

 

public function saveItems()

{

if(isset($this->items))

{

// if any script changed ID of player, function should save items with new player id

$this->items->setPlayerId($this->getID());

$this->items->save();

}

else

new Error_Critic('', 'Player::saveItems() - items not loaded, cannot save');

}

 

public function loadStorages()

{

$this->storages = array();

// load all

$storages = $this->getDatabaseHandler()->query('SELECT ' . $this->getDatabaseHandler()->fieldName('player_id') . ', ' . $this->getDatabaseHandler()->fieldName('key') . 

', ' . $this->getDatabaseHandler()->fieldName('value') . ' FROM ' .$this->getDatabaseHandler()->tableName('player_storage') .

' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']))->fetchAll();

foreach($storages as $storage)

{

$this->storages[$storage['key']] = $storage['value'];

}

}

 

public function saveStorages()

{

if(isset($this->storages))

{

$this->getDatabaseHandler()->query('DELETE FROM ' .$this->getDatabaseHandler()->tableName('player_storage') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));

foreach($this->storages as $key => $value)

{

//save each

$this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName('player_storage') . ' (' . $this->getDatabaseHandler()->fieldName('player_id') . ', ' . 

$this->getDatabaseHandler()->fieldName('key') . ', ' . $this->getDatabaseHandler()->fieldName('value') . ', ) VALUES (' . 

$this->getDatabaseHandler()->quote($this->data['id']) . ', ' . $this->getDatabaseHandler()->quote($key) . ', ' . $this->getDatabaseHandler()->quote($value) . ')');

}

}

else

new Error_Critic('', 'Player::saveStorages() - storages not loaded, cannot save');

}

 

public function getStorage($key)

{

if(!isset($this->storages))

{

$this->loadStorages();

}

if(isset($this->storages[$key]))

return $this->storages[$key];

else

return null;

}

 

public function getStorages()

{

if(!isset($this->storages))

{

$this->loadStorages();

}

return $this->storages;

}

 

public function setStorage($key, $value)

{

if(!isset($this->storages))

{

$this->loadStorages();

}

$this->storages[$key] = $value;

}

 

public function removeStorage($key)

{

if(!isset($this->storages))

{

$this->loadStorages();

}

if(isset($this->storages[$key]))

unset($this->storages[$key]);

}

 

public function getSkill($id)

{

if(isset(self::$skillNames[$id]))

return $this->data['skill_' . self::$skillNames[$id]];

else

new Error_Critic('', 'Player::getSkill() - Skill ' . htmlspecialchars($id) . ' does not exist');

}

 

public function setSkill($id, $value)

{

if(isset(self::$skillNames[$id]))

$this->data['skill_' . self::$skillNames[$id]] = $value;

}

 

public function getSkillCount($id)

{

if(isset(self::$skillNames[$id]))

return $this->data['skill_' . self::$skillNames[$id] . '_tries'];

else

new Error_Critic('', 'Player::getSkillCount() - Skill ' . htmlspecialchars($id) . ' does not exist');

}

 

public function setSkillCount($id, $count)

{

if(isset(self::$skillNames[$id]))

$this->data['skill_' . self::$skillNames[$id] . '_tries'] = $value;

}

 

public function loadAccount()

{

$this->account = new Account($this->getAccountID());

}

 

public function getAccount($forceReload = false)

{

if(!isset($this->account) || $forceReload)

$this->loadAccount();

 

return $this->account;

}

 

public function setAccount($account)

{

$this->account = $account;

$this->setAccountID($account->getID());

}

 

public function loadRank()

{

$ranks = $this->getDatabaseHandler()->query('SELECT ' . $this->getDatabaseHandler()->fieldName('rank_id') . ', ' . $this->getDatabaseHandler()->fieldName('nick') . ' FROM ' . $this->getDatabaseHandler()->tableName('guild_membership') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()))->fetch();

if($ranks)

{

$this->rank = new GuildRank($ranks['rank_id']);

$this->guildNick = $ranks['nick'];

}

else

{

$this->rank = null;

$this->guildNick = '';

}

}

 

public function getRank($forceReload = false)

{

if(!isset($this->guildNick) || !isset($this->rank) || $forceReload)

$this->loadRank();

 

return $this->rank;

}

 

public function setRank($rank = null)

{

$this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('guild_membership') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()));

if($rank !== null)

{

$this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName('guild_membership') . ' (' . $this->getDatabaseHandler()->fieldName('player_id') . ', ' . $this->getDatabaseHandler()->fieldName('guild_id') . ', ' . $this->getDatabaseHandler()->fieldName('rank_id') . ', ' . $this->getDatabaseHandler()->fieldName('nick') . ') VALUES (' . $this->getDatabaseHandler()->quote($this->getID()) . ', ' . $this->getDatabaseHandler()->quote($rank->getGuildID()) . ', ' . $this->getDatabaseHandler()->quote($rank->getID()) . ', ' . $this->getDatabaseHandler()->quote('') . ')');

}

$this->rank = $rank;

}

 

public function hasGuild()

{

return $this->getRank() != null && $this->getRank()->isLoaded();

}

 

public function setGuildNick($value)

{

$this->guildNick = $value;

$this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName('guild_membership') . ' SET ' . $this->getDatabaseHandler()->fieldName('nick') . ' = ' . $this->getDatabaseHandler()->quote($this->guildNick) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()));

}

 

public function getGuildNick()

{

if(!isset($this->guildNick) || !isset($this->rank))

$this->loadRank();

 

return $this->guildNick;

}

 

public function removeGuildInvitations()

{

$this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('guild_invites') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()));

}

 

public function unban()

{

$this->getAccount()->unban();

}

 

public function isBanned()

{

return $this->getAccount()->isBanned();

}

 

public function isNamelocked()

{

return false;

}

 

public function delete()

{

        $this->db->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . $this->getDatabaseHandler()->fieldName('deleted') . ' = 1 WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));

 

        unset($this->data['id']);

}

/*

 * default tfs 0.3.6 fields

*/

public function setID($value){$this->data['id'] = $value;}

public function getID(){return $this->data['id'];}

public function setAccountID($value){$this->data['account_id'] = $value;}

public function getAccountID(){return $this->data['account_id'];}

public function setName($value){$this->data['name'] = $value;}

public function getName(){return $this->data['name'];}

public function setGroupID($value){$this->data['group_id'] = $value;}

public function getGroupID(){return $this->data['group_id'];}

public function setVocation($value){$this->data['vocation'] = $value;}

public function getVocation(){return $this->data['vocation'];}

public function setLevel($value){$this->data['level'] = $value;}

public function getLevel(){return $this->data['level'];}

public function setExperience($value){$this->data['experience'] = $value;}

public function getExperience(){return $this->data['experience'];}

public function setHealth($value){$this->data['health'] = $value;}

public function getHealth(){return $this->data['health'];}

public function setHealthMax($value){$this->data['healthmax'] = $value;}

public function getHealthMax(){return $this->data['healthmax'];}

public function setMana($value){$this->data['mana'] = $value;}

public function getMana(){return $this->data['mana'];}

public function setManaMax($value){$this->data['manamax'] = $value;}

public function getManaMax(){return $this->data['manamax'];}

public function setMagLevel($value){$this->data['maglevel'] = $value;}

public function getMagLevel(){return $this->data['maglevel'];}

public function setManaSpent($value){$this->data['manaspent'] = $value;}

public function getManaSpent(){return $this->data['manaspent'];}

public function setSex($value){$this->data['sex'] = $value;}

public function getSex(){return $this->data['sex'];}

public function setTown($value){$this->data['town_id'] = $value;}

public function getTown(){return $this->data['town_id'];}

public function setPosX($value){$this->data['posx'] = $value;}

public function getPosX(){return $this->data['posx'];}

public function setPosY($value){$this->data['posy'] = $value;}

public function getPosY(){return $this->data['posy'];}

public function setPosZ($value){$this->data['posz'] = $value;}

public function getPosZ(){return $this->data['posz'];}

public function setCapacity($value){$this->data['cap'] = $value;}

public function getCapacity(){return $this->data['cap'];}

public function setSoul($value){$this->data['soul'] = $value;}

public function getSoul(){return $this->data['soul'];}

public function setConditions($value){$this->data['conditions'] = $value;}

public function getConditions(){return $this->data['conditions'];}

public function setLastIP($value){$this->data['lastip'] = $value;}

public function getLastIP(){return $this->data['lastip'];}

public function setLastLogin($value){$this->data['lastlogin'] = $value;}

public function getLastLogin(){return $this->data['lastlogin'];}

public function setLastLogout($value){$this->data['lastlogout'] = $value;}

public function getLastLogout(){return $this->data['lastlogout'];}

public function setSkull($value){$this->data['skull'] = $value;}

public function getSkull(){return $this->data['skull'];}

public function setSkullTime($value){$this->data['skulltime'] = $value;}

public function getSkullTime(){return $this->data['skulltime'];}

public function setSave($value = 1){$this->data['save'] = (int) $value;}

public function getSave(){return $this->data['save'];}

public function setBlessings($value){$this->data['blessings'] = $value;}

public function getBlessings(){return $this->data['blessings'];}

public function setBalance($value){$this->data['balance'] = $value;}

public function getBalance(){return $this->data['balance'];}

public function setStamina($value){$this->data['stamina'] = $value;}

public function getStamina(){return $this->data['stamina'];}

public function setDeleted($value){$this->data['deleted'] = (int) $value;}

public function isDeleted(){return (bool) $this->data['deleted'];}

public function setLookBody($value){$this->data['lookbody'] = $value;}

public function getLookBody(){return $this->data['lookbody'];}

public function setLookFeet($value){$this->data['lookfeet'] = $value;}

public function getLookFeet(){return $this->data['lookfeet'];}

public function setLookHead($value){$this->data['lookhead'] = $value;}

public function getLookHead(){return $this->data['lookhead'];}

public function setLookLegs($value){$this->data['looklegs'] = $value;}

public function getLookLegs(){return $this->data['looklegs'];}

public function setLookType($value){$this->data['looktype'] = $value;}

public function getLookType(){return $this->data['looktype'];}

public function setLookAddons($value){$this->data['lookaddons'] = $value;}

public function getLookAddons(){return $this->data['lookaddons'];}

/*

 * Custom AAC fields

 * create_ip , INT, default 0

 * create_date , INT, default 0

 * hide_char , INT, default 0

 * comment , TEXT, default ''

*/

public function setCreateIP($value){$this->data['create_ip'] = $value;}

public function getCreateIP(){return $this->data['create_ip'];}

public function setCreateDate($value){$this->data['create_date'] = $value;}

public function getCreateDate(){return $this->data['create_date'];}

public function setHidden($value){$this->data['hide_char'] = (int) $value;}

public function isHidden(){return (bool) $this->data['hide_char'];}

public function setComment($value){$this->data['comment'] = $value;}

public function getComment(){return $this->data['comment'];}

/*

 * for compability with old scripts

*/

public function setGroup($value){$this->setGroupID($value);}

public function getGroup(){return $this->getGroupID();}

public function getCreated(){return $this->getCreateDate();}

public function setCreated($value){$this->setCreateDate($value);}

public function setCap($value){$this->setCapacity($value);}

public function getCap(){return $this->getCapacity();}

public function isSaveSet(){return $this->getSave();}

public function unsetSave(){$this->setSave(0);}

public function getTownId(){return $this->getTown();}

public function getHideChar(){return $this->isHidden();}

public function find($name){$this->loadByName($name);}

 

public static function isPlayerOnline($playerID)

{

if(!isset(self::$onlineList))

{

self::$onlineList = array();

$onlines = Website::getDBHandle()->query('SELECT ' . Website::getDBHandle()->fieldName('player_id') . ' FROM ' . Website::getDBHandle()->tableName('players_online'))->fetchAll();

foreach($onlines as $online)

{

self::$onlineList[$online['player_id']] = $online['player_id'];

}

}

 

return isset(self::$onlineList[$playerID]);

}

 

public function isOnline()

{

return self::isPlayerOnline($this->getID());

}

 

public function getOnline()

{

return self::isPlayerOnline($this->getID());

}

}

 

e a linha 33 é essa:

$fieldsArray = array();

Editado Março 27, 2014 por nosqetah (veja o histórico de edições)

[luanluciano93 1993]

Amigo, tente exportar a tabela accounts da sua database e coloque ela aqui, assim podemos comparar com as do arquivo que você colocou acima, deve ter alguma coluna faltando.

[Reloaded 8]

mano to quase desistindo

[luanluciano93 1993]

O tópico foi movido para a área correta, preste mais atenção da próxima vez!

Leia as regras do fórum: http://tibiaking.com/forum/topic/1281-regras-gerais/?p=7680

Este tópico foi movido:

De: "OTServ → WebSites → Downloads de Websites"

Para: "OTServ → Suporte OTServ → Suporte de WebSites"

[Reloaded 8]

 

CREATE TABLE `accounts`

(

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(32) NOT NULL DEFAULT '',

`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,

`salt` VARCHAR(40) NOT NULL DEFAULT '',

`premdays` INT NOT NULL DEFAULT 0,

`lastday` INT UNSIGNED NOT NULL DEFAULT 0,

`email` VARCHAR(255) NOT NULL DEFAULT '',

` key` VARCHAR(32) NOT NULL DEFAULT '0',

`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',

`warnings` INT NOT NULL DEFAULT 0,

`group_id` INT NOT NULL DEFAULT 1,

PRIMARY KEY (`id`), UNIQUE (`name`)

) ENGINE = InnoDB;

[luanluciano93 1993]

?

[Reloaded 8]

voce pediu para posta a tabela account mano voces podem da uma db e um site que funfe nao? eu to precisando para monta o projeto de personalizaçao aqui

[luanluciano93 1993]

cara, vai no phpmyadmin na sua database e olha a tabela accounts, compara as colunas com as que estão no arquivo account.php que fica em system, se faltar algum poste aqui!

[Reloaded 8]

posta seu banco de dados com o account.php seria mais facil

[luanluciano93 1993]

o meu é diferente cara ... 

[Necrovisky 0]

cara to com o mesmo problema e tbm n to conseguindo resolver, tem como ser mais claro? ou no caso uma forma mais simples para os noobs como eu entenderem assim, eu ja coloquei todos os que eu axei faltando, removi praticamente todos os erros da janela DOS de abrir o server, da até server open, porém eu nao consigo concluir o site, continua dando o mesmo erro, mesmo depois de adicionas varias colunas e tables no database.

[luanluciano93 1993]

vai em index.php e procura pela linha que tem database debuug (algo assim) , mude o valor de false para true, depois atualize o site, vai mostrar mensagem de erro com a coluna que falta na tabela account, poste aqui qual é ... 

[Necrovisky 0]

no site da o mesmo erro. só muda no arquivo DOS de partida do servidor, porém vem em linguagem de programação e eu nao entendo mto pois nao é minha area de trabalho, apesar de eu trabalhar com computadores.

nos erros do arquivo de arranque do server da erros especificando colunas na table accounts que eu ja tenho, porém escrito em maiusculo NOT NULL, estando ja com valores ou seja not null, devo tirar os valores para deixa-los null? e como eu faço isso? sempre q eu tiro os valores da erro

Editado Maio 22, 2014 por Necrovisky (veja o histórico de edições)