[Release] Rappelz RDB Tool with tabs

Page 8 of 27

04/21/2014 20:56 eziorav#106

That's impressive Glandu :) !

04/25/2014 19:23 eziorav#107

Quote:

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

05/23/2014 20:58 MrStubborn#108

Great futures

06/08/2014 21:05 Amaady#109

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 .

06/08/2014 22:53 glandu2#110

the changing values are in which columns ?

06/09/2014 10:52 Amaady#111

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

06/09/2014 11:27 malaysiawap#112

update for epic 9.1 please :D .

06/11/2014 19:21 glandu2#113

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

06/12/2014 02:13 mlejnek2#114

so how do I make the .dlls?

06/12/2014 19:37 glandu2#115

although the post is a bit old, you can see there for what to compile: [Only registered and activated users can see links. Click Here To Register...]

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:
[Only registered and activated users can see links. Click Here To Register...]

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):
[Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...] (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)

06/15/2014 12:33 Amaady#116

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 ^.^

06/15/2014 23:44 glandu2#117

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

Code:

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

10/21/2014 01:43 c1ph3r#118

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...

10/22/2014 12:16 aMipRoDiGy#119

Hi everyone, here i share plugin item 9.1 that i edit myself..
[Only registered and activated users can see links. Click Here To Register...]

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.. :)

11/03/2014 19:32 Laladumdum#120

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

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

Page 8 of 27

« First

Last »