- #WARNING, multiple skillID detected !! 2987
- #WARNING, multiple skillID detected !! 321
- #WARNING, multiple skillID detected !! 5587
- #Don t forget to enter the good values for fields script, value1, gm_aoe
Here are the "official" conversion tools for osRose rev 80 and osRose dev rev (previous rev 81).
Note:
There are also other documents on the SVN, admin's guide and so on, take a look at it
You must download them via the svn:
https://osrose-svn.cvsdude.com/toolsrelease
login: beta81
password: beta81
How to install?:
The .exe are to be in the 3DDATA folder of your extracted client, then launch one exe or the file "make_csv_sql.bat" to run them all. Just hit space when it tells you it's in pause, you'll have to do it until it tells you it's done.
Important notes:
-> Those converters converts STB and IFO files for rev80 and rev81 to create .sql and .csv files,
-> Most of them create the csv and sql files in the "/data/" folder (see screenshot) you'll have to create first in 3DDATA folder (though, some tools, like NPCToCSV.exe create it for you).
-> Only the converters "IFONPCDumper.exe" and "spawn_dev.exe" export the .sql files in 3DDATA folder.
-> on the server:
--> the .csv files are to be in "/binary/data/",
--> the .sql in "/database", of course, IMPORT those new .sql files with Navicat or PhpMyAdmin to update your server,
----> Perhaps you'll have to delete the according table before importing the new data, see the mysql errors if any,
-> some files (.sql and .csv) are outdated for rev81 since we read most of them directly through STB now,
Here are the tools that are in this svn, please refer to the color code to see if you need the .csv or .sql file:
-> rev80+dev rev,
-> rev80 ONLY,
-> dev rev only,
-> dev rev outdated,
-> NOT to be used (not useful),
Tool_name (extracted files):
NPCToCSV.exe (npc_data.csv, npc_data.sql, npc_data_sell.sql),
breakToCSV.exe (break_data.csv, chest_data.sql),
DropToCSV.exe (drops_data.csv),
EquipToCSV.exe (equip_data.csv),
IFONPCDumper.exe (list_mobgroups.sql, list_objects.sql, list_telegates.sql, list_npcs.sql),
JemToCSV.exe (jemitem_data.csv),
NaturalToCSV.exe (natural_data.csv),
PatToCSV.exe (pat_data.csv),
ProductToCSV.exe (product_data.csv),
SellToCSV.exe (sell_data.csv),
SkillToCSV.exe (skills_data.csv, skills_data.sql),
spawn_dev.exe (list_respawnzones.sql)
UseToCSV.exe (useitem_data.csv), don't use this one!
UseToCSV81.exe (useitem_data_80.csv, useitem_data_81.csv),
ZoneToCSV.exe (zone_data.csv),
Special instructions if you got rev80:
-> Rename the file useitem_data_80.csv to useitem_data.csv,
-> npc_data_sell.sql is NOT needed anymore,