TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system

[ForgottenNot]

Hello community
Have added multiworld system by aurelion into nekiro's 8.0 downgraded server. I have one edited database and the other which is not, in both of them i receive errors. Because the database that use aulerion is made for another protocol. Could somebody lend me a hand editing the unedited database which i have already in use(online) in order to add the requeried editions into the database. These are the errors displayed in the exe.

The Forgotten Server - Version 1.5 (Nekiro's 8.00 downgrade)

Compiled with Microsoft Visual C++ version 1933
Compiled on Jun 18 2023 11:20:11 for platform x64
Linked with LuaJIT 2.1.0-beta3 for Lua support

A server developed by Mark Samman
A server downgraded by Nekiro
Visit our forum for updates, support, and resources: https://otland.net/.

>> Loading config
>> Loading multiworld config...
>>>> World TestWorld (ID 0) - Loaded successfully.
>>>> World Second (ID 1) - Loaded successfully.
>> Loading RSA key
>> Establishing database connection... MySQL 3.3.1
>> Running database manager
>> Loading vocations
>> Loading items... OTB v1.3.50
>> Loading script systems
>> Using LuaJIT 2.1.0-beta3
>> Loading lua libs
> create_functions.lua [loaded]
> defaults_move_event.lua [loaded]
> event_callbacks.lua [loaded]
> helper_constructors.lua [loaded]
> register_monster_type.lua [loaded]
>> Loading lua scripts
> #dqh_walls.lua [disabled]
> #multiple_lever.lua [disabled]
> #onstep_in_out_tile.lua [disabled]
> #change_gold.lua [disabled]
> #dolls.lua [disabled]
> #doors 7.6 actualizado backup.lua [disabled]
> #doors.old.lua [disabled]
> #doors.rl by xikina.lua [disabled]
> #spellbook.lua [disabled]
> #transforms.lua [disabled]
> #vertical_horizontal_doors.lua [disabled]
> #voodoo_doll.lua [disabled]
> #gold_converter.lua [disabled]
> #saw.lua [disabled]
> #default_onDropLoot  original.lua [disabled]
> #vertical_horizontal_doors.lua [disabled]
> #example.lua [disabled]
> #example.lua [disabled]
>> ["others"]
> change_gold.lua [loaded]
> dolls.lua [loaded]
> doors.lua [loaded]
> voodoo_doll.lua [loaded]
>> ["actions"]
> spellbook.lua [loaded]
>> ["scripts"]
> bless_check.lua [loaded]
>> ["creaturescripts"]
> scarab_death.lua [loaded]
>> ["scripts"]
> ctf.lua [loaded]
>> ["monster"]
> default_onDropLoot.lua [loaded]
>> ["player"]
> default_onLook.lua [loaded]
> default_onLookInBattleList.lua [loaded]
> default_onMoveItem.lua [loaded]
> default_onReportBug.lua [loaded]
> default_onReportRuleViolation.lua [loaded]
>> ["scripts"]
> mana_stacables.lua [error]
^ ...\Documents\GitHub\pro-ot\data\scripts\mana_stacables.lua:30: 'end' expected (to close 'function' at line 3) near '<eof>'
>> ["movements"]
> closing_door.lua [loaded]
>> ["scripts"]
> onlosspremium.lua [loaded]
> sorcerer_guild_thais_step_in.lua [loaded]
>> ["talkactions"]
> notation_ban.lua [loaded]
> position.lua [loaded]
>> Loading monsters
>> Loading lua monsters
>> Loading outfits
>> Checking world type... PVP
>> Loading map
> Map size: 33500x33500.
> Map loading time: 3.902 seconds.
[Warning - Monsters::loadMonster] Cant load spell. data/monster/bosses/mahrdis.xml
[Error - mysql_real_query] Query: SELECT `data` FROM `tile_store` WHERE `world_id` = 0
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT `data` FROM `tile_store` WHERE `world_id` = 0
Message: Unknown column 'world_id' in 'where clause'
>> Initializing gamestate
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'motd_num'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'motd_num'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`world_id`, `config`, `value`) VALUES (0, 'motd_num', '0')
Message: Unknown column 'world_id' in 'field list'
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'motd_hash'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'motd_hash'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`world_id`, `config`, `value`) VALUES (0, 'motd_hash', '')
Message: Unknown column 'world_id' in 'field list'
[Error - mysql_real_query] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'players_record'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT `value` FROM `server_config` WHERE `world_id` = 0 AND `config` = 'players_record'
Message: Unknown column 'world_id' in 'where clause'
[Error - mysql_real_query] Query: INSERT INTO `server_config` (`world_id`, `config`, `value`) VALUES (0, 'players_record', '0')
Message: Unknown column 'world_id' in 'field list'
[Error - mysql_real_query] Query: TRUNCATE TABLE `players_online` WHERE `world_id` = 0
Message: 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 'WHERE `world_id` = 0' at line 1
[Error - mysql_real_query] Query: SELECT `id`, `world_id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `world_id` = 0 AND `bid_end` != 0 AND `bid_end` < 1687115028
Message: Unknown column 'world_id' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `world_id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `world_id` = 0 AND `bid_end` != 0 AND `bid_end` < 1687115028
Message: Unknown column 'world_id' in 'field list'
>> Loaded all modules, server starting up...

 

[lursky]

ALTER TABLE `server_config` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `tile_store` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `players_online` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `houses` ADD `world_id` int(11) NOT NULL;

And for any other table that world_id column is missing

 

[ForgottenNot]

ALTER TABLE `server_config` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `tile_store` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `players_online` ADD `world_id` int(11) NOT NULL;
ALTER TABLE `houses` ADD `world_id` int(11) NOT NULL;

And for any other table that world_id column is missing

Thank you man. it fixed almost every error in the console excluding this one, dont know why:

[Error - mysql_real_query] Query: TRUNCATE TABLE `players_online` WHERE `world_id` = 0
Message: 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 'WHERE `world_id` = 0' at line 1
>> Loaded all modules, server starting up...

 

[lursky]

Change the query from “TRUNCATE TABLE” to “DELETE FROM”