• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Brunowots realmap - Tibia 8.0 TFS 1.2

K

Kuba Rozrooba

New Member
Joined
Oct 18, 2024
Messages
1
Reaction score
0
I'm completely new to the world of Open Tibia and i can't get this project to work.
The database and server itself appear to be working correctly, but any attempt to connect to the server results in "Invalid Account Number".


---

What I've used:

For the most part I've followed this tutorial, trying to adapt.

---

First thing I've unzipped UniServer and started both MySQL and Apache server. Unpacked Znote and put it into www directory, removing anything that was there before. Then I've entered phpMyAdmin, created database (Collatation, whatever that means) and imported into it, in this sequence:
  • schema.sql from Celohere Branch [no errors]
  • ZnoteAAC schema: www/engine/database/znote_schema.sql, so the website may work properly [no errors]
  • znote_schema.sql from this repository. [there was an error]

Importing znote_schema from ths repo returned error:
Code: 
Error
SQL query:

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `password` char(40) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '1',
  `premdays` int(11) NOT NULL DEFAULT '0',
  `lastday` int(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `creation` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3
MySQL said: Documentation

#1050 - Table 'accounts' already exists
but it still loaded a lot of things into database (I don't know if everything)

Then i went to configure Znote. Modified config.php (sqlUser, sqlPassword, sqlDatabase). Got following error:
Code: 
Configuration error!
Cannot save cache to memory, but it is configured to do so.
You need to enable PHP extension APCu to enable memory cache.
Install it or set $config['cache']['memory'] to false!
Ubuntu install: sudo apt install php-apcu
So I've changed 'memory' to false and it worked. I've successfully made account and character.

---

IMPORTANT SIDENOTE: There might be confusion "why did i import the original .sql, then Znote and THEN the one attached in repository. This is because if i did the way that's most logical (repo sql, then Znote) after creation of account I got an error:
Code: 
Register Account
string(168) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `active`, `active_email`, `activekey`, `flag`) VALUES ('3', '0', '1729348760', '1', '0', '226538379', 'pl')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'active_email' in 'field list'

Attempt to login in this case gave this error:
Code: 
string(122) "SELECT `ip`, `created`, `points`, `cooldown`, `flag`, `active_email` FROM `znote_accounts` WHERE `account_id` = 3 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'active_email' in 'field list'

---

Then I've configured database in config.lua. Again, username, password and database name. I've turned on theforgottenserver_x64.exe and it went pretty well - the server started. However, it was spurting error every minute (or so)

Code: 
[Error - mysql_store_result] Query: SELECT * FROM z_ots_comunication;
Message: Table 'tibiaots.z_ots_comunication' doesn't exist
I've applied solution that can be found there and the problem stopped.
Code: 
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

---

So that's about it when it comes to hosting server. I've tried OTClient to connect to it (IP: 127.0.0.1:7171, version 800) but all I've got was "Invalid account number". I've tried to debug it but I've no idea. It is appearantly problem with autentication (Like, wrong password or something) What I've found interesting was: the only query sent to database during login process was
Code: 
Query SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = ...
Which has nothing to do with autentication.

---

IMPORTANT SIDENOTE: Regardless of schema.sql import used (original -> Znote AAC -> repo, or repo -> ZNOTE AAC) the end result is the same, but in the latter the website is unusable due to mentioned errors.
Post automatically merged:

Also what i really look for isn't THIS particular version of Open Tibia, I just want any plug&play project that has the most recent real Tibia map, quests included, preferrably without modifications. If you can recommand something, I'm open to suggestions!
 
Last edited:
Back
Top