[rev80 / dev rev] extracters, converters, admin guide

Tools for osRose and osiRose will be placed in here, as well as Rose file formats.

Please PM rl2171 or lmame to get them added to the list.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

[rev80 / dev rev] extracters, converters, admin guide

Postby lmame on Thu Mar 19, 2009 1:51 pm

Hi :)

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.
19-03-2009 13-47-27.png



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,
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Fri Mar 20, 2009 8:12 am

Note:
1°) skills_data.sql:
In ths skill file (skills_data.sql) you got this as first lines:
  1. #WARNING, multiple skillID detected !! 2987
  2. #WARNING, multiple skillID detected !! 321
  3. #WARNING, multiple skillID detected !! 5587
  4. #Don t forget to enter the good values for fields script, value1, gm_aoe


This means there are several skills with the same skillID. It's taken from the STB so what you need to do is to remove some skills that have the same skillID in a way that only one should remain.
Once it's done, delete those lines:
  1. #WARNING, multiple skillID detected !! 2987
  2. #WARNING, multiple skillID detected !! 321
  3. #WARNING, multiple skillID detected !! 5587
  4. #Don t forget to enter the good values for fields script, value1, gm_aoe


And use Navicat (or phpmyadmin or whatever) to execute the .sql file.

For rev80:
3°) Be sure to check those two threads for bug fixes in case you got those bugs:
[Rev80 Bug Fix] dual scratch disconnects client
[Rev80 Bug Fix] can't learn skill OR crash at startup...
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Fri Mar 20, 2009 9:32 am

Here is an example on how to update a .sql file with navicat.

Once you got your NEW .sql file (let's say here it's "list_npcs.sql"), you need to IMPORT it in your mysql database.

So launch navicat:
SNAG2G-real_0000.png


Right click in your database name and click "execute batch file":
SNAG2G-real_0001.png
SNAG2G-real_0001.png (6.2 KiB) Viewed 37027 times


Select the "list_npcs.sql" file:
SNAG2G-real_0002.png
SNAG2G-real_0002.png (7.24 KiB) Viewed 37028 times

SNAG2G-real_0003.png


And click "start":
SNAG2G-real_0004.png
SNAG2G-real_0004.png (8.85 KiB) Viewed 37022 times


Oups, error... Why? Let's scroll up:
SNAG2G-real_0005.png
SNAG2G-real_0005.png (12.73 KiB) Viewed 37019 times


It's because the mysql table "list_npcs" already exists!
SNAG2G-real_0006.png


So we need to DELETE the old one.
Select "list_npcs" mysql table in Navicat, right click and select "delete":
SNAG2G-real_0008.png


Confirm:
SNAG2G-real_0009.png
SNAG2G-real_0009.png (3.38 KiB) Viewed 37009 times


And do the "execute batch file" step again, this time it works ;)
SNAG2G-real_0010.png
SNAG2G-real_0010.png (4.66 KiB) Viewed 36999 times
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Mon Apr 13, 2009 12:27 pm

Converter for respawnareas updated, one respawn for Junon added.
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Sun May 03, 2009 11:52 am

Extract data from the client:
All the files are stored in the VFS files. STB, AIP, QSD, IFO, all the files in 3DDATA folder are in the VFS so you need to extract them first.

To do this, use a vfs extract tool, for example this one.
Unzip it where you installed Rose Online, next to the .vfs files.
Image

Launch the software and choose "File->extract all" and choose a folder where all the data will go.
Image

Now wait...

In your destination folder, you have now all the files, extracted and you can use the tools on them.
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Wed Jun 17, 2009 12:48 am

IFONPCDumper.exe updated to handle dev rev 343+ and narose client 228+ (list_telegates.sql).
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters and converters (.sql, .csv)

Postby lmame on Sat Aug 01, 2009 12:52 pm

There was a problem in list_objects.sql with IFONPCDumper.exe (thanks to bladefinor).

Edit:
Adding extra_param field, will be used in next rev (361+),
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters, converters, admin guide

Postby lmame on Mon May 17, 2010 10:00 am

Spawn_dev tool has been updated to 1.0.2 so it handles new and old Adv plain map since naRose uses the "old" back again.

Use it if your new players just spawn in Junon Polis instead of Adv Plain. It'll recreate the correct "list_respawnzones.sql" file.
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [rev80 / dev rev] extracters, converters, admin guide

Postby observe on Mon Jun 28, 2010 10:55 am

ok i've tried this for list_mobgroups & list_respawnareas

but when i delete the old table and import the new one's it says duplicate entry for key 0
when i check the sql file there are a lot if zero's as id. so it cant be unputted correctly.

it works for the other sql files but just those 2 wont work
htf

Regards
Observe
observe
osRose dev
osRose dev
 
Posts: 194
Joined: Thu Sep 17, 2009 10:28 am
Location: The Netherlands

Re: [rev80 / dev rev] extracters, converters, admin guide

Postby lmame on Mon Jun 28, 2010 11:12 am

It's not possible since there is an "auto increment" in list_mobgroups so 0 is automatically changed to something else anyway.
What's your Mysql server version?

  1. CREATE TABLE `list_mobgroups` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `map` int(11) NOT NULL,
  4. `x` float NOT NULL,
  5. `y` float NOT NULL,
  6. `range` int(11) NOT NULL,
  7. `respawntime` int(11) NOT NULL,
  8. `limit` int(11) NOT NULL,
  9. `tacticalpoints` int(11) NOT NULL,
  10. `moblist` varchar(1024) DEFAULT NULL,
  11. `daynight` int(11) NOT NULL DEFAULT 0,
  12. `isactive` int(11) NOT NULL DEFAULT 1,
  13. `whatisit` varchar(20) DEFAULT NULL,
  14. PRIMARY KEY  (`id`)
  15. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Next

Return to Tools and File Format

Who is online

Users browsing this forum: No registered users and 12 guests

cron