• 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!

PHP Setup Gesior 0.2 and 0.3

JoccE

CopyLeft (ɔ)
Joined
Aug 26, 2007
Messages
3,418
Solutions
1
Reaction score
92
Location
Sweden, Stockholm

I just made this tutorial for OTFans so why not post it here to :p
I wont be active too answer all the questions but if you need help PM me here or on OTFans.
Will ofc update it if i update on OTFans

As many of you know i just closed my old Gesior Tutorial because it was really outdated. So here comes my new one
As you all know there is 2 versions of TFS 0.2 and 0.3, you need different gesior AACs for each one of them.

TFS Mystic Sprite 0.2.2 Guide:
First you need to download the Gesior AAC that works with 0.2 which you can fine here:
UNNAMED031a for TFS 02.rar - UploadHyper.com

Extract all the files to /xampp/htdocs
zlx3c8.jpg


After that goto http://localhost/install.php
and it will look like this:
2mz7rd.jpg


After that press on step one
1. Set server path
There you should write something like this:
C:\Documents and Settings\Administrator\Desktop\Mystic Spirit\

You should get a message like this:
Check server configuration
File config.lua loaded from C:/Documents and Settings/Administrator/Desktop/Mystic Spirit/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection

Follow the guide and press on Step 3. Add tables and columns to DB
And you should get a message like this:
Add tables and columns to DB
Installer try to add new tables and columns to database.
Added columns to table accounts
Added columns to table guilds.
Added columns to table players
Added table z_news_big (news).
Added table z_news_tickers (tickers).
Added table z_spells (spells list).
Added table z_monsters (monsters list).
All tables and columns added to database.
Go to STEP 4 - Add samples

Now goto STEP 4 - Add samples.
If everything going as it should you will get this message:
Add samples to DB:
News ticker sample is already in database. New sample is not needed.
News sample is already in database. New sample is not needed.
Character 'Rook Sample' already in database.
Character 'Sorcerer Sample' already in database.
Character 'Druid Sample' already in database.
Character 'Paladin Sample' already in database.
Character 'Knight Sample' already in database.
All samples added to database. Now you can go to STEP 5 - Set Admin Account

Now press on STEP 5 - Set Admin
Here you will need to choose a password for your page admin account.
REMEMBER TO CHOOSE A SECURE PASSWORD!

After that you need to press
6. Load Monsters from OTS
7. Load Spells from OTS

And all your monsters/spells will be loaded.

When you press load vocations. it will look something like this:
9biq0y.jpg


You need to add some things so it looks like this when you are done:
15h2anq.jpg


after that you only have one more thing left to config.
its the acc page config and here you will choose the config you want for your server. It look like this:
91e83r.jpg


Now your aac page should work just fine if you followed all the steps.

TFS Crying Damson 0.3.4 Guide:
First you need to download the AAC page for 0.3. Heres a link to the latest one which also supports Multi-World system:
gesior0.3.4beta.zip - UploadHyper.com

Extract all the files to /xampp/htdocs
zlx3c8.jpg


After that goto http://localhost/install.php
and it will look like this:
2mz7rd.jpg


After that press on step one
1. Set server path
There you should write something like this:
C:\Documents and Settings\Administrator\Desktop\cryingdamson4pl2-console\

when you press next you will most likely get this error:
Warning: Error parsing C:/Documents and Settings/Administrator/Desktop/cryingdamson4pl2-console/config.lua on line 142 in C:\xampp\htdocs\install.php on line 150
File config.lua loaded from C:/Documents and Settings/Administrator/Desktop/cryingdamson4pl2-console/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.
To fix that you just goto you server folder open config.lua and remove this at line 142:
-- NOTE: defaultPriority works only on Windows and niceLevel on *nix
-- coresUsed are seperated by comma cores ids used by server process,
-- default is -1, so it stays untouched (automaticaly assigned by OS).
and this at line 152~
-- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature,
-- called "exception tracer" (__EXCEPTION_TRACER__ flag).
then at line 190~
-- NOTE: Stamina is stored in miliseconds, so seconds are multiplied by 1000.
-- rateStaminaHits multiplies every hit done a creature, which are later
-- multiplied by player attack speed.
-- rateStaminaGain is multiplying every second of logged out time, eg:
-- 60 * 1000 / 3 = 20 seconds, what gives 1 stamina minute for 3 being logged off.
-- rateStaminaThresholdGain is dividing in case the normal gain (that is
-- multiplied by rateStaminaGain, btw.) passed above threshold, eg:
-- 60 * 1000 / 3 = 20 / 4 = 5 seconds (3 * 4 = 12 minutes for 1 stamina minute).
-- staminaRatingLimit* is in minutes.

Then try again.
After that you should get this msg:
Check server configuration
File config.lua loaded from C:/Documents and Settings/Administrator/Desktop/Mystic Spirit/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection

Then you press on Step 2 - Check database connection.
if you don't get any errors just continue to step 3.

There you will get this but it will stand added instead of can't add:
Code:
STEP 3

Add tables and columns to DB
Installer try to add new tables and columns to database.
Add columns to table accounts

Can't add column key to table accounts, already exist?
Can't add column page_lastday to table accounts, already exist?
Can't add column email_new to table accounts, already exist?
Can't add column email_new_time to table accounts, already exist?
Can't add column created to table accounts, already exist?
Can't add column rlname to table accounts, already exist?
Can't add column location to table accounts, already exist?
Can't add column page_access to table accounts, already exist?
Can't add column email_code to table accounts, already exist?
Can't add column next_email to table accounts, already exist?
Can't add column premium_points to table accounts, already exist?
Add columns to table guilds

Can't add column description to table guilds, already exist?
Can't add column logo_gfx_name to table guilds, already exist?
Add columns to table players

Can't add column online to table players, already exist?
Can't add column created to table players, already exist?
Can't add column nick_verify to table players, already exist?
Can't add column old_name to table players, already exist?
Can't add column hide_char to table players, already exist?
Can't add column comment to table players, already exist?
Add new tables to database

Tabel z_news_big not added. Already exist?
Tabel z_news_tickers not added. Already exist?
Tabel z_spells not added. Already exist?
Tabel z_monsters not added. Already exist?
Tables and columns added to database.
Go to STEP 4 - Add samples
After that continue to Step 4 - Add samples.
THere you will see this: (but will stand added instead of already in databse)
Add samples to DB:
News ticker sample is already in database. New sample is not needed.
News sample is already in database. New sample is not needed.
Character 'Rook Sample' already in database.
Character 'Sorcerer Sample' already in database.
Character 'Druid Sample' already in database.
Character 'Paladin Sample' already in database.
Character 'Knight Sample' already in database.
All samples added to database. Now you can go to STEP 5 - Set Admin Account

Now it's just one more step until the account page will work and that it. Set Admin account.
REMEMBER TO HAVE A SECURE PASSWORD.
now you account page should work just fine. Before you start using the page you can also press on load Spells/Monsters but you can ofc do that later if you want.


Error Messages:
0.2
No errors yet
0.3
If you get this error:
PHP:
atal error: Uncaught exception 'E_OTS_NotLoaded' in C:xampphtdocspotOTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1832
While making a character. You solve it like this:
Goto phpmyadmin then your database.
Press on the SQL button and run this code:
Code:
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 6, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 6, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(3, 6, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(4, 6, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(5, 6, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 0, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 1, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 2, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 3, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 4, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 5, 10, 0);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(6, 6, 10, 0);

Other small things you may need to know:
How to change layout
Goto /xampp/htdocs/config and the config.php(0.3) or config.ini 0.2)
and change this $config['site']['layout'] = "tibiacom"; // layout name

Tutorial made by JoccE
Special thanks to Gesior for making the AAC
 
can sby help me, i want to create my server with a page like tibia's one but when i write localhost/install on my browser it says :

Index of /
Name Last modified Size Description-------------------------------------------------------------------------------- before/ 20-Dec-2007 23:01 -
--------------------------------------------------------------------------------
Apache/2.2.8 (Win32) DAV/2 mod_ssl/2.2.8 OpenSSL/0.9.8g mod_autoindex_color PHP/5.2.5 Server at localhost Port 80
 
Excuse me but how can i eddit
the zone and level of starters ppl
becouse they start at lvl 1 in yalahar
 
Hello, Could some1 help me? I have done a web page but no1 cant go into it. Should i change ip somewhere or open any ports? please help!
 
Last edited:
everything is fine but i got this at step 2

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't open SQLite database. Possible reasons:
C:/Documents and Settings/Administrador/Escritorio/Dovux By Jose v4/ - file isn't valid SQLite database.
C:/Documents and Settings/Administrador/Escritorio/Dovux By Jose v4/ - doesn't exist.
 
I made everything like in here . my home page was created but the others canr go there -.- i have opnened all ports and stuff could some body help me ? whats wrong ?
 
I get dis problems evertime.

I dont remember have to fix it :S

Warning: syntax error, unexpected ',' in C:/Users/josef/Desktop/otserv/config.lua on line 11 in C:\xampp\htdocs\install.php on line 156
File config.lua loaded from C:/Users/josef/Desktop/otserv/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.
 
I get dis problems evertime.

I dont remember have to fix it :S

Warning: syntax error, unexpected ',' in C:/Users/josef/Desktop/otserv/config.lua on line 11 in C:\xampp\htdocs\install.php on line 156
File config.lua loaded from C:/Users/josef/Desktop/otserv/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.

Delete all lines which starts with an "--".

rep me for helping++
 
Hello,

I've done al the steps, when i got at step 4 (add sample to db) i got an error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'skulltime' in 'field list'' in C:\Program Files\xampp\xampplite\htdocs\xampp\install.php:576 Stack trace: #0 C:\Program Files\xampp\xampplite\htdocs\xampp\install.php(576): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\Program Files\xampp\xampplite\htdocs\xampp\install.php on line 576

Mabye someone know how to fix?

Greetz


EDIT; Fixed already, needed other sql tables :)
 
Last edited:
lol when i goto my accc page anytime i click my account/create account it redirects me to otland...



editt// fixed.. silly silly...


just change the last lines of the config.lua to your sites url (where it says otland.net)
 
Last edited:
I keep getting this erron when i try to setup the website,

At step 4:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\install.php:415 Stack trace: #0 C:\xampp\htdocs\install.php(415): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 415

Using the newest dist of TFS 0.3.6 and the gesior ACC for TFS 0.3.6

Could anyone help?

T~
 
Can't load file config.lua from C:/Users/Kevin/Desktop/TFS/config.lua File doesn't exist in selected directory it is right directory??:O
whats wrong anyone?
 
Warning: syntax error, unexpected '(' in C:/TFS/config.lua on line 17 in C:\xampp\htdocs\install.php on line 156
File config.lua loaded from C:/TFS/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author.





whats problem?
 
you dont have acces to admin panel shit whats that and how i do so the server is on my ip? or the no-ip. ?
 
Back
Top