What's new

Problem Z Utworzeniem Postaci GESIOR ACC

bejo669

Active User
Joined
May 3, 2009
Messages
114
Reaction score
1
Witam
Postanowi?em sobie postawi? serwer dedykowany , zainstalowa?em acca ale mam problem z za?o?eniem postaci wyskakuje mi b??d :
The Following Errors Have Occurred:
Wrong characters configuration. Try again or contact with admin. ADMIN: Edit file config/config.php and set valid characters to copy names. Character to copy Druid Sample doesn't exist.

Wyczyta?em ?e wystarczy doda? zapytanie do PHP my admin/sql i tu wklejam zapytanie do bazy z http://tibia.net.pl/threads/526165-Sorcerer-Druid-Plaladin-Knight-Sample-Jak-dodać
Niestety wyskakuje mi b??d
84cd1e71da679.png.html


Prosz? o pomoc .

---------- Tre?? dodana o 10:02 ----------

link do zdj?cia https://zapodaj.net/84cd1e71da679.png.html
 

danio4don

Advanced User
Joined
Oct 6, 2011
Messages
233
Reaction score
6
Age
28
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

mia?em podobny problem. teraz pytania

czy na pewno w bazie masz profesje sample? czyli druid,sorc,knight,paladyn,i rook?

i czy w config acc makera masz dodane nazwy ich?

bo z tego co pisze to masz ?le skonfigurowane profesje w config acc tam trzeba wpisa? nazwy profesji z bazy danych do config
 

TenTypSwir

NNSTORY.EU Developer
Joined
Jun 8, 2010
Messages
1,657
Reaction score
117
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

"Bo z tego co JEST NAPISANE". Reszta informacji si? zgadza :)
 

bejo669

Active User
Joined
May 3, 2009
Messages
114
Reaction score
1
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

Ju? uda?o mi si? tamten problem rozwi?za? teraz mam nowy
Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\classes\account.php on line 33

Jakie? pomys?y ?

---------- Tre?? dodana o 17:02 ----------

Problem pojawia si? przy STEP 5
Set Admin Account

;/ ;/
 

danio4don

Advanced User
Joined
Oct 6, 2011
Messages
233
Reaction score
6
Age
28
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

sprawd? co kryje si? w account.php w 33 linijce niekt?re rzeczy s? tak proste do rozwi?zania ?e wystarczy wpisa? je w google.

ps: tak poza tym na xampp zawsze jakie? problemy s? zobacz na jakim? darmowym hostingu czy dzia?a normalnie acc i jeszcze jedna rzecz pami?tam ze w ustawieniach xampp trzeba by?o w??czy? jak?? bibliotek? inaczej gesior nie dzia?a? i wywala?o jakie? b??dy
 

bejo669

Active User
Joined
May 3, 2009
Messages
114
Reaction score
1
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

Nic nie wymy?li?em , czyta?em na r??nych forach o tym ale nic nie pomaga .
Ma kto? jaki? pomys? ? Wklejam tu sw?j ca?y account.php mo?e kto? co? wymy?li .
Prosz? o pomoc .

<?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, 'salt' => null, 'premdays' => null, 'lastday' => null, 'email' => null, 'key' => null, 'group_id' => null, 'create_ip' => null, 'create_date' => 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', 'salt', 'premdays', 'lastday', 'email', 'key', 'group_id', 'create_ip', 'create_date', '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());
$filterPlayer = new SQL_Filter(new SQL_Field('rank_id', 'players'), 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, $filterPlayer);
$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()
{
$bans = new DatabaseList('Ban');
$filterType = new SQL_Filter(new SQL_Field('type'), SQL_Filter::EQUAL, Ban::TYPE_ACCOUNT);
$filterValue = new SQL_Filter(new SQL_Field('value'), SQL_Filter::EQUAL, $this->data['id']);
$filterActive = new SQL_Filter(new SQL_Field('active'), SQL_Filter::EQUAL, 1);
$filter = new SQL_Filter($filterType, SQL_Filter::CRITERIUM_AND, $filterValue);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterActive);
$bans->setFilter($filter);
foreach($bans as $ban)
{
$ban->setActive(0);
$ban->save();
}
}

public function loadBans($forceReload = false)
{
if(!isset($this->bans) || $forceReload)
{
$this->bans = new DatabaseList('Ban');
$filterType = new SQL_Filter(new SQL_Field('type'), SQL_Filter::EQUAL, Ban::TYPE_ACCOUNT);
$filterValue = new SQL_Filter(new SQL_Field('value'), SQL_Filter::EQUAL, $this->data['id']);
$filterActive = new SQL_Filter(new SQL_Field('active'), SQL_Filter::EQUAL, 1);
$filter = new SQL_Filter($filterType, SQL_Filter::CRITERIUM_AND, $filterValue);
$filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterActive);
$this->bans->setFilter($filter);
}
}

public function isBanned($forceReload = false)
{
$this->loadBans($forceReload);
$isBanned = false;
foreach($this->bans as $ban)
{
if($ban->getExpires() <= 0 || $ban->getExpires() > time())
$isBanned = true;
}
return $isBanned;
}

public function getBanTime($forceReload = false)
{
$this->loadBans($forceReload);
$lastExpires = 0;
foreach($bans as $ban)
{
if($ban->getExpires() <= 0)
{
$lastExpires = 0;
break;
}
if($ban->getExpires() > time() && $ban->getExpires() > $lastExpires)
$lastExpires = $ban->getExpires();
}
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['salt'] = md5(microtime(true));
$this->data['password'] = Website::encryptPassword($value, $this);
}
public function getPassword(){return $this->data['password'];}
public function setSalt($value){$this->data['salt'] = $value;}
public function getSalt(){return $this->data['salt'];}
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'];}
public function setGroupID($value){$this->data['group_id'] = $value;}
public function getGroupID(){return $this->data['group_id'];}
/*
* Custom AAC fields
* create_ip , INT, default 0
* create_date , 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['create_date'] = $value;}
public function getCreateDate(){return $this->data['create_date'];}
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 getGroup(){return $this->getGroupID();}
public function setGroup($value){$this->setGroupID($value);}
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 (strtoupper($this->data['password']) == strtoupper(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();}
}
 

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

index.php zmie? false na true define('DEBUG_DATABASE', true); zobaczymy czego brakuje w bazie.
 

bejo669

Active User
Joined
May 3, 2009
Messages
114
Reaction score
1
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

Zmieni?em , zmienia?em i nadal ten sam problem .
STEP 5
Set Admin Account

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

buchaLL

bez spiny, luźno
Joined
Aug 2, 2011
Messages
1,013
Reaction score
68
Age
27
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

Je?li zmieni?e? to powiniene? otrzyma? wiadomo?? z b??dem. Error message: xxx
 

bejo669

Active User
Joined
May 3, 2009
Messages
114
Reaction score
1
Odp: Problem Z Utworzeniem Postaci GESIOR ACC

Zmieni?em . Nigdzie nie widz? tej wiadomo?ci , gdzie powinna si? pojawi? ? je?eli na accu to nic nie ma .

---------- Tre?? dodana o 18:02 ----------

Problem rozwi?zany zmieni?em ACC MARKER i pomog?o
 
Top