Remere
Suave developer
- Joined
- Oct 13, 2008
- Messages
- 53
- Reaction score
- 52
If you have a TFS or OTServ server which uses the incorrect OTB (and thus wrong item IDs), this small guide will help you convert the database to the proper format.
Posted this on OTFans as well, but since it mainly concerns TFS users I'll post it here too.
Step one
Start your server.
Step two
Open config.lua, find map_store_type and change it from binary to relational. If you are using TFS, instead change useHouseDataStorage = true to false
Step three
Login on the server with a gamemaster character and type /reload config, then type /save. This might take several minutes. Once it's done, shutdown the server. If you are kicked check the console windows for the "Server saved" text.
Step four
Download these two files:
NOTE: This is the OTServ items.xml file. There may be slight incompatibilities with TFS, until someone on the TFS teams converts their items.xml, you're stuck with this.
Step five
Download RME version 1.1.11 (or later), install it and open your map with the editor. It will say that the map needs to converted, click yes. Once it's done save the map.
Step six
Download this file (right click -> save as): http://remeresmapeditor.com/otdbconvert854.sql
Step seven
Step eight
Start your server again.
Step nine
Open config.lua, find "map_store_type" and change it from "relational" to "binary" (again, on TFS change useHouseDataStorage from false to true)
Step ten
Save your server again using /reload config, /save. Now your server should be converted to the new format!
Posted this on OTFans as well, but since it mainly concerns TFS users I'll post it here too.
Step one
Start your server.
Step two
Open config.lua, find map_store_type and change it from binary to relational. If you are using TFS, instead change useHouseDataStorage = true to false
Step three
Login on the server with a gamemaster character and type /reload config, then type /save. This might take several minutes. Once it's done, shutdown the server. If you are kicked check the console windows for the "Server saved" text.
Step four
Download these two files:
- http://opentibia.svn.sourceforge.net/viewvc/opentibia/data/trunk/items/items.otb?revision=5294
- http://opentibia.svn.sourceforge.net/viewvc/opentibia/data/trunk/items/items.xml?revision=5378
NOTE: This is the OTServ items.xml file. There may be slight incompatibilities with TFS, until someone on the TFS teams converts their items.xml, you're stuck with this.
Step five
Download RME version 1.1.11 (or later), install it and open your map with the editor. It will say that the map needs to converted, click yes. Once it's done save the map.
Step six
Download this file (right click -> save as): http://remeresmapeditor.com/otdbconvert854.sql
Step seven
Using phpMyAdmin
Now open phpMyAdmin. Click on your OT database, click on the "Import" tab.
Fill in the downloaded otdbconvert854.sql file into the form and click "Run"
This import may take a LONG time, be patient.
Now open phpMyAdmin. Click on your OT database, click on the "Import" tab.
Fill in the downloaded otdbconvert854.sql file into the form and click "Run"
This import may take a LONG time, be patient.
Using mysql directly
Open a terminal (console) window in the folder where otdbconvert.sql is (use shift-right click in Windows and select ("Open command window here")), type
Open a terminal (console) window in the folder where otdbconvert.sql is (use shift-right click in Windows and select ("Open command window here")), type
Code:
mysql -u root -p NAMEOFOTSERVDATABASE < otdbconvert.sql
Step eight
Start your server again.
Step nine
Open config.lua, find "map_store_type" and change it from "relational" to "binary" (again, on TFS change useHouseDataStorage from false to true)
Step ten
Save your server again using /reload config, /save. Now your server should be converted to the new format!
Last edited: