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

The Forgotten Tibia (no vocations, new skills, skills by points, dual wield, auto loot, quiver, etc)

Blez said:
Receiving this error when trying to make a character

string(741) "INSERT INTO players(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, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing) VALUES ('Test', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '0', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'manaspent' in 'field list
@Delusion
Click to expand...
did you use his supplied sql?
 
I did yes, i dont know if he posted and updated one, but im using the schema.sql that was inside the folder. by any chance you have one i could test?
Post automatically merged:

I get this error when i try to reupload the new schema
--
-- Extraindo dados da tabela players
--

INSERT INTO players (id, name, group_id, account_id, level, max_level_reached, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, maglevel, mana, manamax, resets, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, stamina, skill_points, skill_points_total, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing, deleted, description, comment, create_ip, create_date, hide_char) VALUES
(1, 'God', 3, 1, 120, 120, 0, 1000, 1000, 0, 62, 39, 116, 1, 75, 3, 75, 1000, 1000, 0, 100, 15, 33011, 31310, 7, '', 2000, 1, 0, 0, 1, 0, 0, 0, 31, 0, 0, 0, 2520, 100, 250, 50, 50, 50, 50, 50, 50, 50, 0, '', '', 0, 0, 0),
(8, 'No Build', 1, 2, 1, 1, 0, 120, 120, 0, 76,[...]



MySQL said: Documentation

#1054 - Unknown column 'skill_points_total' in 'field list'
Post automatically merged:

After i import to the database for all znote things for site i get this error
string(122) "SELECT ip, created, points, cooldown, flag, active_email FROM znote_accounts WHERE account_id = 2 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'active_email' in 'field list'

and it wont allow for guild wars to be implemented.
 
Last edited:
Blez said:
Receiving this error when trying to make a character

string(741) "INSERT INTO players(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, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing) VALUES ('Test', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '0', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'manaspent' in 'field list
@Delusion
Click to expand...

Simply add

ALTER TABLE players ADD COLUMN manaspent int(10) DEFAULT 0;

I think there are few more tables needed so simply replace (EDITHERE) with the name missing.

ALTER TABLE players ADD COLUMN (EDITHERE) int(10) DEFAULT 0;
 
string(173) "INSERT INTO accounts (name, password, email, creation) VALUES ('9069978', '0247cc8424795bc1700c7f2cfaeaa5084bc4d368', '[email protected]', '1576628000')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'id' doesn't have a default value

Last thing im running into while creating an account.
I made one prior with the wrong database but said character couldnt be loaded, which was probabaly due to the wrong database.
 
Blez said:
string(173) "INSERT INTO accounts (name, password, email, creation) VALUES ('9069978', '0247cc8424795bc1700c7f2cfaeaa5084bc4d368', '[email protected]', '1576628000')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'id' doesn't have a default value

Last thing im running into while creating an account.
I made one prior with the wrong database but said character couldnt be loaded, which was probabaly due to the wrong database.
Click to expand...

Run this in MySQL

set global sql_mode='';
 
I was able to create an account and character. now 2 things when i try and login it says that the character could not be loaded and i receive this error in the server log.
Message: Unknown column 'skill_points_total' in 'field list'
[Error - mysql_store_result] Query: SELECT id, name, group_id, account_id, level, max_level_reached, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, maglevel, mana, manamax, resets, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, skull, skulltime, lastlogout, blessings, balance, stamina, skill_points, skill_points_total, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing FROM players WHERE id = 0
Message: Unknown column 'skill_points_total' in 'field list'
[Error - IOLoginData::loadPlayer] no result

and on the website when viewing the character i get this.

Notice: Undefined index: group_id in C:\Users\aaron\Desktop\uniserv\UniServerZ\www\characterprofile.php on line 76
string(111) " SELECT id, owner, name, town_id AS town_id FROM houses WHERE owner = ; "
(query - SQL error)
Type: select_multi (select multiple rows from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3
 
Blez said:
I was able to create an account and character. now 2 things when i try and login it says that the character could not be loaded and i receive this error in the server log.
Message: Unknown column 'skill_points_total' in 'field list'
[Error - mysql_store_result] Query: SELECT id, name, group_id, account_id, level, max_level_reached, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, maglevel, mana, manamax, resets, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, skull, skulltime, lastlogout, blessings, balance, stamina, skill_points, skill_points_total, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing FROM players WHERE id = 0
Message: Unknown column 'skill_points_total' in 'field list'
[Error - IOLoginData::loadPlayer] no result

and on the website when viewing the character i get this.

Notice: Undefined index: group_id in C:\Users\aaron\Desktop\uniserv\UniServerZ\www\characterprofile.php on line 76
string(111) " SELECT id, owner, name, town_id AS town_id FROM houses WHERE owner = ; "
(query - SQL error)
Type: select_multi (select multiple rows from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3
Click to expand...

As mentioned above simply replace the text of the missing column

so
ALTER TABLE players ADD COLUMN skill_points_total int(10) DEFAULT 0;
Post automatically merged:

Here is working Empty MySQL Database

Make sure to run a query in MySQL

set global sql_mode='';

Before import the database in MySQL


Hope it helps
 

Attachments

Last edited:
I freaking love it! Is it possible to point me in the direction on witch AAC i can use for this one? Dose someone got an edited one? Thanks in advance :D
 
Last edited:
Just as a heads up, on trying to get the schema put into SQL it prompted me that
insert into `players`
Couldn't add "skill_points_total" into the table.

I simply copied the line for skill_points in the create query and made a new one with that but named skill_points_total.

`skill_points_total` int(10) UNSIGNED NOT NULL DEFAULT '10',

Seemed like a minor oversight. Not sure if the type is correct, but it let the import finish.
 
Hi, i'm new to this.

I manually created a character with the help from above. But now I am receiving, "Town ID 1 doesn't exist". I had it at default of 0 but that also returned the same error.

Where can I confirm these details to input the correct information when making players?

Thanks

EDIT: downloaded the Remere's map editor and I retrieved the IDs from there. so please ignore my question, thanks.
 
Last edited:
GoalTV said:
As mentioned above simply replace the text of the missing column

so
ALTER TABLE players ADD COLUMN skill_points_total int(10) DEFAULT 0;
Post automatically merged:

Here is working Empty MySQL Database

Make sure to run a query in MySQL

set global sql_mode='';

Before import the database in MySQL


Hope it helps
Click to expand...
TY BRO
 
Togu said:
The Forgotten Tibia

github.com

GitHub - GustavoContreiras/TheForgottenTibia: A free and open-source MMORPG written in C++ and Lua

A free and open-source MMORPG written in C++ and Lua - GustavoContreiras/TheForgottenTibia
github.com github.com

The Forgotten Tibia is a free and open-source MMORPG written in C++ and LUA.
It is a fork from the The Forgotten Server 1.3 (3b63f65) and OTClient (07b4b78) projects.

What makes it different from Tibia / The Forgotten Server 1.3?
  • There are no vocations
    Everyone starts as a normal human being with points to be distributed among the skills

  • There is no skill training
    Each level you advance ou receive points to be distributed among the skills. The more levels you get, less points you receive.

  • All clubs, swords and axes damage are based on Strenght

  • You can use two one-handed weapons at the same time
    Attack speed will increase and each weapon damage will decrease.

  • Distance weapons damage are based on Strenght and/or Dexterity

  • Two-handed melee weapons can do critical hit and bleeding effect

  • You don't need to open monsters to pickup loots while hunting
    Just need to select the item you want to loot and add to / remove from your loot list.

  • You don't need to refill ammunition when hunting with arrows or bolts
    Just need to use a quiver/container on the arrow slot.

  • Wands and Rods maximum damage can be increased
    When you advance your intelligence skill you increase your wand's maximum damage. Same thing works for faith and rods.

  • Access to spells are based on Faith and Intelligence
    There is no level or vocation requirement for spells. The more you raise faith and intelligence, more spells you get.

  • Access to runes and runes damage are based on Magic

  • The screen has one more tile
    It was added one more square meter to the screen.

  • You can set a title to your character
    If you have the requirements you can be a mage, a supporter, a knight or a ranger.
Skills
  • Magic
    Gives more spell power, more rune power and more mana.

  • Vitality
    Gives more health.

  • Strenght
    Gives more physical damage.

  • Defence
    Gives more resistance to phsycal attacks and more health.

  • Dexterity
    Gives more attack speed, walk speed and damage with distance weapons.

  • Intelligence
    Gives more mana and access to offensive spells and runes.

  • Faith
    Gives more mana and access to support spells and runes.

  • Endurance
    Gives more capacity and health.
Images

View attachment 34751
View attachment 34752
View attachment 34753
View attachment 34754
View attachment 34755

Getting Started
Issues

We use the issue tracker on GitHub. Keep in mind that everyone who is watching the repository gets notified by e-mail when there is activity, so be thoughtful and avoid writing comments that aren't meaningful for an issue (e.g. "+1"). If you'd like for an issue to be fixed faster, you should either fix it yourself and submit a pull request, or place a bounty on the issue.
Click to expand...


Hello,

Thats so nice to see projects like that! TYY!!


So, i have completed to compile it, but when i start the .exe file it just appears a black window and it turn off again...

exe.PNG

error.PNG
SOMETHING LIKE THAT
 

Similar threads

S
Landoria OTS - Development Thread
Replies
3
Views
645
sharinn
S
A
[Canada] [13.21] Elysiera | low-rate non-pvp | Global content with customizations
Replies
7
Views
992
Astalavista
A
imperianic
[US] [7.4] Imperianic - RARITY SYSTEM - PROXY - VOIP - ANDROID - [26/11/2023, Sunday, 20:00 UTC]
Replies
7
Views
1K
imperianic
imperianic
Xikini
  • Locked
  • Question
Lua Xikini's Free Scripting Service TFS 1.4.2
11 12 13
Replies
258
Views
20K
Xikini
Xikini
Olireyin
[Canada] [13.20] ReboOT started 15/07/2023
2
Replies
20
Views
2K
Olireyin
Olireyin
J
Team [tfs 1.5 - orts]Need testers for a 8.6 global map
Replies
2
Views
791
cs007
cs007
OldSchoolBoy
[Poland] [8.00] Treasura |Long term x1| Start 12/04/2024 at 18:00 CEST
2 3 4
Replies
64
Views
5K
highsanta
highsanta
G
[USA][CUSTOM - OTC] Zoltyum - Age of Cataclysm | Official First Season 11/24/2023 - 11A.M PT
Replies
16
Views
2K
lmaoxd
L
Back
Top