[Release] Rappelz RDB Tool with tabs

[eziorav]

That's impressive Glandu !

[eziorav]

Originally Posted by bertie2008

This script create SkillResource view that use data from SkillFullResource:
Spoiler

Error I receive when I run the query:
Msg 208, Level 16, State 1, Procedure SkillResource, Line 16
Invalid object name 'dbo.SkillFullResource'.

I get the same error when running the: create SkillJPResource view that use data from SkillFullResource script

well if you have used your brain you could have changed the table name before exporting to database

[MrStubborn]

Great futures

[Amaady]

Hi Glandu2 >> I have been tried your program .

Amazing tool but I had an error when I reload a file from folder >> Some values in The DataGridview Changes With Every Loading .

I had the problem in : Huntaholic (Max_Point) and in SummonExp (Level)

PS: I'm Using 8.3 RDB Files !!

I hope you solve it in the next version . Have a nice day .

[glandu2]

the changing values are in which columns ?

[Amaady]

Table: Huntaholic >> Colmun: Max_Point, lobby_channel_id, lobby_x, lobby_y, dungeon_channel_id, dungeon_x, dungeon_y // Table: SummonExp >> Colmun: Level

[malaysiawap]

update for epic 9.1 please .

[glandu2]

sorry I don't have the time to check the layout of 9.1 rdb files, but you can yourself based on the source of database dlls (in RappelzRDBTool-2.5.0-db-src.zip and the header files + library is in RappelzRDBTool-2.5.0-dev.zip) with a c++ compiler

[mlejnek2]

so how do I make the .dlls?

[glandu2]

although the post is a bit old, you can see there for what to compile:

Just use files in RappelzRDBTool-2.5.0-db-src.zip and the header files + library in RappelzRDBTool-2.5.0-dev.zip instead

To do a Visual C++ project, create a unmanaged C++ DLL project and add all files in RappelzRDBTool-2.5.0-dev.zip (right click on project, add, existing files). You should have also only one .cpp file which contains your RDB description (like the files in RappelzRDBTool-2.5.0-db-src.zip).

Here an image to explain that:


The config should be that (inside the red rectangle, not tested other values for these parameters, it might still works, but I recommend to use these if you don't know. At least, Configuration type must be DLL):


Also compile for x86, not x64 else the DLL won't load in the RDB tool. The project solution of this example is in attachment. (target VS version is VS 2013)

To use a DLL made with VS 2013, ensure that (32 bits) is installed on the machine where you run the RDB tool.

You should use ItemTestDatabase_vs2013_vc120.zip project.
(ItemTestDatabase_vs2013.zip is the same but is set to use a VC2010 compiler)

[Amaady]

Hi Glandu2 !!

I found another error in table "MotionSet" .

The original type of most columns in this table is ("varchar") >> But your program uses column type ("int") , so this causes crash to "Captain Herlock" !!

So please check it out !!

Have a nice day bro ^.^

[glandu2]

New release 2.5.1 with bug fixes:

• Add TYPE_FLAG_SORT to sort rows when reading from SQL (used for jobresource and level tables) (xXExiledXx)
• Fix flags when reading from SQL db
• Fix random columns for Huntaholic and SummonExp (Amaady)
• Fix Item522Database for 5.2 client (db_item(ascii).rdb) (xXExiledXx)
• Add SkillTree52Database
• When failing at reading a RDB file, leave data in the table to see what's wrong (useful when reading a new RDB)
• The combobox with all database description DLLs is larger (display 20 items instead of 10)

I have never said before, but for most release before this one, the one who found bugs was Ne0, for this release, it's inline in the changelog (above)

For the last issue with MotionSet, my tool does not support converting data type, so you will have to use a SQL view to do the conversion from int to varchar
Here is an example: (empty values are left as '1')

 Spoiler

CREATE VIEW [dbo].[MotionSet_varchar]
AS
SELECT	id,
	string_id,
	CAST(deva_m_unarmored AS VARCHAR(64)) AS deva_m_unarmored,
	CAST(deva_m_one_hand_sword AS VARCHAR(64)) AS deva_m_one_hand_sword,
	CAST(deva_m_two_hand_sword AS VARCHAR(64)) AS deva_m_two_hand_sword,
	CAST(deva_m_double_sword AS VARCHAR(64)) AS deva_m_double_sword,
	CAST(deva_m_one_hand_dagger AS VARCHAR(64)) AS deva_m_one_hand_dagger,
	CAST(deva_m_double_dagger AS VARCHAR(64)) AS deva_m_double_dagger,
	CAST(deva_m_two_hand_spear AS VARCHAR(64)) AS deva_m_two_hand_spear,
	CAST(deva_m_one_hand_axe AS VARCHAR(64)) AS deva_m_one_hand_axe,
	CAST(deva_m_two_hand_axe AS VARCHAR(64)) AS deva_m_two_hand_axe,
	CAST(deva_m_double_axe AS VARCHAR(64)) AS deva_m_double_axe,
	CAST(deva_m_one_hand_staff AS VARCHAR(64)) AS deva_m_one_hand_staff,
	CAST(deva_m_two_hand_staff AS VARCHAR(64)) AS deva_m_two_hand_staff,
	CAST(deva_m_one_hand_mace AS VARCHAR(64)) AS deva_m_one_hand_mace,
	CAST(deva_m_two_hand_mace AS VARCHAR(64)) AS deva_m_two_hand_mace,
	CAST(deva_m_bow AS VARCHAR(64)) AS deva_m_bow,
	CAST(deva_m_cross_bow AS VARCHAR(64)) AS deva_m_cross_bow,
	CAST(deva_f_unarmored AS VARCHAR(64)) AS deva_f_unarmored,
	CAST(deva_f_one_hand_sword AS VARCHAR(64)) AS deva_f_one_hand_sword,
	CAST(deva_f_two_hand_sword AS VARCHAR(64)) AS deva_f_two_hand_sword,
	CAST(deva_f_double_sword AS VARCHAR(64)) AS deva_f_double_sword,
	CAST(deva_f_one_hand_dagger AS VARCHAR(64)) AS deva_f_one_hand_dagger,
	CAST(deva_f_double_dagger AS VARCHAR(64)) AS deva_f_double_dagger,
	CAST(deva_f_two_hand_spear AS VARCHAR(64)) AS deva_f_two_hand_spear,
	CAST(deva_f_one_hand_axe AS VARCHAR(64)) AS deva_f_one_hand_axe,
	CAST(deva_f_two_hand_axe AS VARCHAR(64)) AS deva_f_two_hand_axe,
	CAST(deva_f_double_axe AS VARCHAR(64)) AS deva_f_double_axe,
	CAST(deva_f_one_hand_staff AS VARCHAR(64)) AS deva_f_one_hand_staff,
	CAST(deva_f_two_hand_staff AS VARCHAR(64)) AS deva_f_two_hand_staff,
	CAST(deva_f_one_hand_mace AS VARCHAR(64)) AS deva_f_one_hand_mace,
	CAST(deva_f_two_hand_mace AS VARCHAR(64)) AS deva_f_two_hand_mace,
	CAST(deva_f_bow AS VARCHAR(64)) AS deva_f_bow,
	CAST(deva_f_cross_bow AS VARCHAR(64)) AS deva_f_cross_bow,
	CAST(asura_m_unarmored AS VARCHAR(64)) AS asura_m_unarmored,
	CAST(asura_m_one_hand_sword AS VARCHAR(64)) AS asura_m_one_hand_sword,
	CAST(asura_m_two_hand_sword AS VARCHAR(64)) AS asura_m_two_hand_sword,
	CAST(asura_m_double_sword AS VARCHAR(64)) AS asura_m_double_sword,
	CAST(asura_m_one_hand_dagger AS VARCHAR(64)) AS asura_m_one_hand_dagger,
	CAST(asura_m_double_dagger AS VARCHAR(64)) AS asura_m_double_dagger,
	CAST(asura_m_two_hand_spear AS VARCHAR(64)) AS asura_m_two_hand_spear,
	CAST(asura_m_one_hand_axe AS VARCHAR(64)) AS asura_m_one_hand_axe,
	CAST(asura_m_two_hand_axe AS VARCHAR(64)) AS asura_m_two_hand_axe,
	CAST(asura_m_double_axe AS VARCHAR(64)) AS asura_m_double_axe,
	CAST(asura_m_one_hand_staff AS VARCHAR(64)) AS asura_m_one_hand_staff,
	CAST(asura_m_two_hand_staff AS VARCHAR(64)) AS asura_m_two_hand_staff,
	CAST(asura_m_one_hand_mace AS VARCHAR(64)) AS asura_m_one_hand_mace,
	CAST(asura_m_two_hand_mace AS VARCHAR(64)) AS asura_m_two_hand_mace,
	CAST(asura_m_bow AS VARCHAR(64)) AS asura_m_bow,
	CAST(asura_m_cross_bow AS VARCHAR(64)) AS asura_m_cross_bow,
	CAST(asura_f_unarmored AS VARCHAR(64)) AS asura_f_unarmored,
	CAST(asura_f_one_hand_sword AS VARCHAR(64)) AS asura_f_one_hand_sword,
	CAST(asura_f_two_hand_sword AS VARCHAR(64)) AS asura_f_two_hand_sword,
	CAST(asura_f_double_sword AS VARCHAR(64)) AS asura_f_double_sword,
	CAST(asura_f_one_hand_dagger AS VARCHAR(64)) AS asura_f_one_hand_dagger,
	CAST(asura_f_double_dagger AS VARCHAR(64)) AS asura_f_double_dagger,
	CAST(asura_f_two_hand_spear AS VARCHAR(64)) AS asura_f_two_hand_spear,
	CAST(asura_f_one_hand_axe AS VARCHAR(64)) AS asura_f_one_hand_axe,
	CAST(asura_f_two_hand_axe AS VARCHAR(64)) AS asura_f_two_hand_axe,
	CAST(asura_f_double_axe AS VARCHAR(64)) AS asura_f_double_axe,
	CAST(asura_f_one_hand_staff AS VARCHAR(64)) AS asura_f_one_hand_staff,
	CAST(asura_f_two_hand_staff AS VARCHAR(64)) AS asura_f_two_hand_staff,
	CAST(asura_f_one_hand_mace AS VARCHAR(64)) AS asura_f_one_hand_mace,
	CAST(asura_f_two_hand_mace AS VARCHAR(64)) AS asura_f_two_hand_mace,
	CAST(asura_f_bow AS VARCHAR(64)) AS asura_f_bow,
	CAST(asura_f_cross_bow AS VARCHAR(64)) AS asura_f_cross_bow,
	CAST(gaia_m_unarmored AS VARCHAR(64)) AS gaia_m_unarmored,
	CAST(gaia_m_one_hand_sword AS VARCHAR(64)) AS gaia_m_one_hand_sword,
	CAST(gaia_m_two_hand_sword AS VARCHAR(64)) AS gaia_m_two_hand_sword,
	CAST(gaia_m_double_sword AS VARCHAR(64)) AS gaia_m_double_sword,
	CAST(gaia_m_one_hand_dagger AS VARCHAR(64)) AS gaia_m_one_hand_dagger,
	CAST(gaia_m_double_dagger AS VARCHAR(64)) AS gaia_m_double_dagger,
	CAST(gaia_m_two_hand_spear AS VARCHAR(64)) AS gaia_m_two_hand_spear,
	CAST(gaia_m_one_hand_axe AS VARCHAR(64)) AS gaia_m_one_hand_axe,
	CAST(gaia_m_two_hand_axe AS VARCHAR(64)) AS gaia_m_two_hand_axe,
	CAST(gaia_m_double_axe AS VARCHAR(64)) AS gaia_m_double_axe,
	CAST(gaia_m_one_hand_staff AS VARCHAR(64)) AS gaia_m_one_hand_staff,
	CAST(gaia_m_two_hand_staff AS VARCHAR(64)) AS gaia_m_two_hand_staff,
	CAST(gaia_m_one_hand_mace AS VARCHAR(64)) AS gaia_m_one_hand_mace,
	CAST(gaia_m_two_hand_mace AS VARCHAR(64)) AS gaia_m_two_hand_mace,
	CAST(gaia_m_bow AS VARCHAR(64)) AS gaia_m_bow,
	CAST(gaia_m_cross_bow AS VARCHAR(64)) AS gaia_m_cross_bow,
	CAST(gaia_f_unarmored AS VARCHAR(64)) AS gaia_f_unarmored,
	CAST(gaia_f_one_hand_sword AS VARCHAR(64)) AS gaia_f_one_hand_sword,
	CAST(gaia_f_two_hand_sword AS VARCHAR(64)) AS gaia_f_two_hand_sword,
	CAST(gaia_f_double_sword AS VARCHAR(64)) AS gaia_f_double_sword,
	CAST(gaia_f_one_hand_dagger AS VARCHAR(64)) AS gaia_f_one_hand_dagger,
	CAST(gaia_f_double_dagger AS VARCHAR(64)) AS gaia_f_double_dagger,
	CAST(gaia_f_two_hand_spear AS VARCHAR(64)) AS gaia_f_two_hand_spear,
	CAST(gaia_f_one_hand_axe AS VARCHAR(64)) AS gaia_f_one_hand_axe,
	CAST(gaia_f_two_hand_axe AS VARCHAR(64)) AS gaia_f_two_hand_axe,
	CAST(gaia_f_double_axe AS VARCHAR(64)) AS gaia_f_double_axe,
	CAST(gaia_f_one_hand_staff AS VARCHAR(64)) AS gaia_f_one_hand_staff,
	CAST(gaia_f_two_hand_staff AS VARCHAR(64)) AS gaia_f_two_hand_staff,
	CAST(gaia_f_one_hand_mace AS VARCHAR(64)) AS gaia_f_one_hand_mace,
	CAST(gaia_f_two_hand_mace AS VARCHAR(64)) AS gaia_f_two_hand_mace,
	CAST(gaia_f_bow AS VARCHAR(64)) AS gaia_f_bow,
	CAST(gaia_f_cross_bow AS VARCHAR(64)) AS gaia_f_cross_bow
FROM            dbo.MotionSet_int

[c1ph3r]

9.1 DLLs untested


These files will read 9.1 rdbs but there are some problems in inserting data into sql since a lot of columns are missing in item.rdb

so no proof that you are able to insert data into real 8.1 databases

Included files:
summon91Database.dll
item91Database.dll
pet91Database.dll
job91Database.dll

If one structure is missing or there a some problerms with the dlls just hit me a pm...

[aMipRoDiGy]

Hi everyone, here i share plugin item 9.1 that i edit myself..


Maybe not perfect but i Hope you guys can use and improve it more. Above already post, mine already test but some of data part enhance they split into other rdb, u guys need to create manually for that part to use in other Epic of rappelz. I also give the source file so u guys can edit and improve..

Thank You..

[Laladumdum]

Someone nows how to fix empty "script_on_dead" column in monster 8.1 rdb?

All entries are empty by loading MonsterResource from Arcadia ???????????????