Daniel Kopeć
Member
After creating an account, I cannot log in to the game. Tibia client shows Invalid password.
The new account and character normally appears in the database.
Gesior Acc Maker 2012 TFS0.4 Tibia8.6
In config.lua password encryption is 'sha1'
config.php
account.php
Which could be causing the problem logging into the game?
How to fix it?
If it uses encryption 'plain' then I can log into the game normally but when starting in the engine I have such an error.
The new account and character normally appears in the database.
Gesior Acc Maker 2012 TFS0.4 Tibia8.6
In config.lua password encryption is 'sha1'
Lua:
sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "test123"
sqlDatabase = "thornera"
sqlFile = "mysql.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 55
mysqlWriteTimeout = 55
encryptionType = "sha1"
config.php
PHP:
<?PHP
# Account Maker Config
$config['site']['serverPath'] = "D:/Tibia pliki/paczkaOts i Str/home/verbania/ots/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'Acc. Maker Test World');
$towns_list[0] = array(1 => 'Thais', 2 => 'Venore', 5 => 'Carlin');
$config['site']['outfit_images_url'] = 'http://outfit-images.ots.me/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 999;
$config['site']['send_register_email'] = false;
# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['max_players_per_account'] = 4;
# Emails Config
$config['site']['send_emails'] = false;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "mail.gmx.com";
$config['site']['smtp_port'] = 25;
$config['site']['smtp_auth'] = false;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxxx";
# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/
# PAGE: characters.php
$config['site']['quests'] = array();
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 0;
# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = false;
$config['site']['generate_new_reckey_price'] = 500;
# PAGE: guilds.php
$config['site']['guild_need_level'] = 15;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;
# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
# PAGE: latestnews.php
$config['site']['news_limit'] = 6;
# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;
# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6);
# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);
# PAGE: shopsystem.php
$config['site']['shop_system'] = false;
# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;
# Layout Config
$config['site']['layout'] = 'tibiacom';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;
account.php
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, '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();}
}
Which could be causing the problem logging into the game?
How to fix it?
Post automatically merged:
If it uses encryption 'plain' then I can log into the game normally but when starting in the engine I have such an error.
Last edited: