[Release] Rappelz RDB Tool with tabs

[glandu2]

Originally Posted by Mslolita

I need some help after importing item_rdb with correct item81database.dll
everything seems to work fine reading importing to sql database.

but after starting captainherlockserver it crashes?
any idea what cause this ?

post some details here about the log:

What's the operation you have done ?

Use item81database.dll,
read db_item.rdb from the 8.1 client,
write to sql (Arcadia.dbo.ItemResource)
?

Also, provide the result of (replace Arcadia by your database name if different):

USE [Arcadia]
GO
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;

(you can put the result in a text file and attach it the the post also, or put it in a spoiler)

Or post here the column difference between your original dbo.ItemResource that was working and the table created by my tool.

[Mslolita]

Before: Working (Royal Repack)

 Spoiler

Arcadia dbo ItemResource id 1 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource name_id 2 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource tooltip_id 3 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource type 4 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource group 5 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource class 6 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource wear_type 7 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource set_id 8 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource set_part_flag 9 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource grade 10 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource rank 11 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource level 12 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance 13 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource socket 14 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource status_flag 15 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_deva 16 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource limit_asura 17 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource limit_gaia 18 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource job_depth 19 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_fighter 20 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource limit_hunter 21 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource limit_magician 22 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource limit_summoner 23 NULL NO char 1 1 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource use_min_level 24 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource use_max_level 25 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource target_min_level 26 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource target_max_level 27 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource range 28 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource weight 29 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource price 30 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource huntaholic_point 31 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource arena_point 32 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource ethereal_durability 33 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource endurance 34 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource material 35 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource summon_id 36 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource item_use_flag 37 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource available_period 38 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource decrease_type 39 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource throw_range 40 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_0 41 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_0 42 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_0 43 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_1 44 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_1 45 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_1 46 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_2 47 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_2 48 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_2 49 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_3 50 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_3 51 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_3 52 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_0 53 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_0 54 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_0 55 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_1 56 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_1 57 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_1 58 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_2 59 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_2 60 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_2 61 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_3 62 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_3 63 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_3 64 NULL NO decimal NULL NULL 12 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource effect_id 65 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_id 66 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_01 67 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_02 68 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_03 69 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_04 70 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_id 71 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_01 72 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_02 73 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_03 74 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_04 75 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource skill_id 76 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_id 77 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_level 78 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_time 79 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource cool_time 80 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource cool_time_group 81 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_dem 82 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_def 83 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_asm 84 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_asf 85 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_gam 86 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_gaf 87 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource deco_model_change 88 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_00 89 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_01 90 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_02 91 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_03 92 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_04 93 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_05 94 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_06 95 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_07 96 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_08 97 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_09 98 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_10 99 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_11 100 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_12 101 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_13 102 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_14 103 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_15 104 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_16 105 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_17 106 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource texture_filename 107 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource drop_type 108 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource icon_id 109 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource icon_file_name 110 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource script_text 111 NULL NO varchar 512 512 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL

After: Not working (did all the steps read imported succesfully Herlock Crash

 Spoiler

Arcadia dbo ItemResource id 1 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource name_id 2 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource tooltip_id 3 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource type 4 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource group 5 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource class 6 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource wear_type 7 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource set_id 8 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource set_part_flag 9 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource grade 10 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource rank 11 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource level 12 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance 13 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource socket 14 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource status_flag 15 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_deva 16 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_asura 17 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_gaia 18 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource job_depth 19 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_fighter 20 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_hunter 21 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_magician 22 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource limit_summoner 23 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource use_min_level 24 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource use_max_level 25 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource target_min_level 26 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource target_max_level 27 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource range 28 NULL NO decimal NULL NULL 10 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource weight 29 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource price 30 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource huntaholic_point 31 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource ethereal_durability 32 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource endurance 33 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource material 34 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource summon_id 35 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource item_use_flag 36 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource available_period 37 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource decrease_type 38 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource throw_range 39 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_0 40 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_0 41 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_0 42 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_1 43 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_1 44 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_1 45 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_2 46 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_2 47 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_2 48 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_type_3 49 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var1_3 50 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource base_var2_3 51 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_0 52 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_0 53 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_0 54 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_1 55 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_1 56 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_1 57 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_2 58 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_2 59 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_2 60 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_type_3 61 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var1_3 62 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource opt_var2_3 63 NULL NO float NULL NULL 53 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource effect_id 64 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_id 65 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_01 66 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_02 67 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_03 68 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_0_04 69 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_id 70 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_01 71 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_02 72 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_03 73 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource enhance_1_04 74 NULL NO real NULL NULL 24 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource skill_id 75 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_id 76 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_level 77 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource state_time 78 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource cool_time 79 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource cool_time_group 80 NULL NO smallint NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_dem 81 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_def 82 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_asm 83 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_asf 84 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_gam 85 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_type_gaf 86 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource deco_model_change 87 NULL NO tinyint NULL NULL 3 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource model_00 88 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_01 89 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_02 90 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_03 91 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_04 92 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_05 93 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_06 94 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_07 95 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_08 96 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_09 97 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_10 98 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_11 99 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_12 100 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_13 101 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_14 102 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_15 103 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_16 104 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource model_17 105 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource texture_filename 106 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource drop_type 107 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource icon_id 108 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Arcadia dbo ItemResource icon_file_name 109 NULL NO varchar 256 256 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL
Arcadia dbo ItemResource script_text 110 NULL NO varchar 512 512 NULL NULL NULL NULL NULL NULL cp1256 NULL NULL Arabic_CI_AS NULL NULL NULL

Originally Posted by glandu2

What's the operation you have done ?

Use item81database.dll,
read db_item.rdb from the 8.1 client,
write to sql (Arcadia.dbo.ItemResource)
?

Also, provide the result of (replace Arcadia by your database name if different):

USE [Arcadia]
GO
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;

(you can put the result in a text file and attach it the the post also, or put it in a spoiler)

Or post here the column difference between your original dbo.ItemResource that was working and the table created by my tool.

[glandu2]

Ok I see what's wrong, the column arena_points is in the 8.1 db too, not only in the 8.3 one. In attachment a fixed version of Item81Database.dll, you can replace the old one with it. The next RappelzRDBTool version I will release will have this fix too.

[Mslolita]

I must say Thank you very much!

Originally Posted by glandu2

Ok I see what's wrong, the column arena_points is in the 8.1 db too, not only in the 8.3 one. In attachment a fixed version of Item81Database.dll, you can replace the old one with it. The next RappelzRDBTool version I will release will have this fix too.

[Mslolita]

It seems like the monster81database.dll is incorrect to, after importing to database it bugs the monsters ingame (string error).

I like to ask what program you use to edit these .dll files so i can work on editing them to.

Originally Posted by glandu2

Ok I see what's wrong, the column arena_points is in the 8.1 db too, not only in the 8.3 one. In attachment a fixed version of Item81Database.dll, you can replace the old one with it. The next RappelzRDBTool version I will release will have this fix too.

[glandu2]

Originally Posted by Mslolita

It seems like the monster81database.dll is incorrect to, after importing to database it bugs the monsters ingame (string error).

I like to ask what program you use to edit these .dll files so i can work on editing them to.

I use msvc2010 (aka visual studio 2010)

So for building SkillTree81Database.cpp (having other files from RappelzRDBTool-dev.zip in the same directory), use this:

cl.exe -D_CRT_SECURE_NO_WARNINGS -DBUILDING_DATABASE /DWIN32 /D_WINDOWS /W3 /Zm1000 /EHsc /GR /MD /O2 /Ob2 /D NDEBUG SkillTreeDisplay81Database.cpp RpzRdbBase.lib /link /DLL /OUT:SkillTreeDisplay81Database.dll

And it should work. Replace SkillTreeDisplay81Database.cpp and SkillTreeDisplay81Database.dll by the files you want.


For Monster81Database, also post the columns description as for skilltreedatabase

[Mslolita]

about the item81database.dll the range calculation is not correct take a look at this:

Correct example weapon Range:

 Spoiler

101301 10101301 20101301 1 1 101 0 0 0 0 3 1 0 2 0 1 1 1 15 1 1 1 1 0 0 0 0 0.62 108 621000 4000 0 0 0 3 0 16777216 0 0 0 11 154 11 0 0 0 14 -5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 5.8 6.8 8.2 10.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 0 drop_weapon_sword 0 icon_weapon_0041

Incorrect weapon Range (importing with the tool):

 Spoiler

101301 10101301 20101301 1 1 101 0 0 0 0 3 1 0 2 0 1 1 1 15 1 1 1 1 0 0 0 0 11204034.56 108 621000 4000 0 0 0 3 0 16777216 0 0 0 11 154 11 0 0 0 14 -5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 5.8 6.8 8.2 10.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 0 drop_weapon_sword 0 icon_weapon_0041

Difference:
Correct : 0.62
Incorrect Tool output: 11204034.56

(about the visual studio 2010 i don't understand c# c++ yet i stil need your help with this)

P.s it seems like more .dll are not functioning correctly i'm using ....81.dll ones
Not working skill81database.dll importing db_skill.rdb
Not Working skilltree81database.dll importing db_skilltree.rdb
Monster81database.dll issue importing

Originally Posted by glandu2

I use msvc2010 (aka visual studio 2010)

So for building SkillTree81Database.cpp (having other files from RappelzRDBTool-dev.zip in the same directory), use this:

cl.exe -D_CRT_SECURE_NO_WARNINGS -DBUILDING_DATABASE /DWIN32 /D_WINDOWS /W3 /Zm1000 /EHsc /GR /MD /O2 /Ob2 /D NDEBUG SkillTreeDisplay81Database.cpp RpzRdbBase.lib /link /DLL /OUT:SkillTreeDisplay81Database.dll

And it should work. Replace SkillTreeDisplay81Database.cpp and SkillTreeDisplay81Database.dll by the files you want.


For Monster81Database, also post the columns description as for skilltreedatabase

[Ne0@NCarbon]

I just try with 2 others rdb tools and same result so it's not the dll but probably the rdb you read.

[Mslolita]

I just tried 2 rdb same result there is someting wrong in the coding of .dll that calculates wrong range value

Originally Posted by Ne0@NCarbon

I just try with 2 others rdb tools and same result so it's not the dll but probably the rdb you read.

[Ne0@NCarbon]

Nothing wrong in the code, i just try with a fresh db_item.rdb from a fresh 8.1 US client and it's ok so definitely it's yours rdb sources which are bad.
Try reading your rdb with another tool like raskim database manager 2013 and you will see same value as with glandu2 tool

[rz-crazyfun]

NpcDatabase 8_1 does not work ((

[glandu2]

New release, changes:

• Add missing arena_points column in Item81Database
• Fix bugs on various database formats
• Handle NaN and non-normal float values correctly (SQL Server does not support them)
• Correct default database names
• In SQL Options dialogbox, the Data source name is now a combobox which list registered DSN in ODBC

[edit]: there was a bug with float values with version 2.4.1: there are all read as 0 from a RDB files. The attached files are fixed with the correction.

[glandu2]

Originally Posted by rz-crazyfun

NpcDatabase 8_1 does not work ((

Originally Posted by Mslolita

about the item81database.dll the range calculation is not correct take a look at this:

Correct example weapon Range:

 Spoiler

101301 10101301 20101301 1 1 101 0 0 0 0 3 1 0 2 0 1 1 1 15 1 1 1 1 0 0 0 0 0.62 108 621000 4000 0 0 0 3 0 16777216 0 0 0 11 154 11 0 0 0 14 -5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 5.8 6.8 8.2 10.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 0 drop_weapon_sword 0 icon_weapon_0041

Incorrect weapon Range (importing with the tool):

 Spoiler

101301 10101301 20101301 1 1 101 0 0 0 0 3 1 0 2 0 1 1 1 15 1 1 1 1 0 0 0 0 11204034.56 108 621000 4000 0 0 0 3 0 16777216 0 0 0 11 154 11 0 0 0 14 -5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 5.8 6.8 8.2 10.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 sword006 0 drop_weapon_sword 0 icon_weapon_0041

Difference:
Correct : 0.62
Incorrect Tool output: 11204034.56

(about the visual studio 2010 i don't understand c# c++ yet i stil need your help with this)

P.s it seems like more .dll are not functioning correctly i'm using ....81.dll ones
Not working skill81database.dll importing db_skill.rdb
Not Working skilltree81database.dll importing db_skilltree.rdb
Monster81database.dll issue importing

Explain what's not working, what you tried to do, your expected result and the actual result for more details
Also, for Mslolita, post the db_item.rdb with wrong range values here to see what's wrong with it

[glandu2]

New minor version:

• Add a checkbox when saving to SQL table to reuse it's schema (IE: use TRUNCATE instead of DROP & CREATE to keep the same columns. All columns of the RDB file MUST exist in the target table. This feature will evolve to allow writing 8.3 database to a 8.1 table by writing only already existing columns)
• Rename arena_points to arena_point in Item8xDatabase (the original column name has no 's')

I also updated the first post:

• Updated the screenshot and some of the text
• Updated the changes log and a link to the post where the release is (and also updated the attachment of the first post to the latest release)

[glandu2]

A new major version: 2.5.0

• Fix crash when loading non existant CSV file
• Fix possible crash when loading CSV for db_string or db_banwords
• Fix rounding with negative DECIMAL values
• Show messagebox when an error occur while reading or writing
• Fix unknown errors that might appear with RDB that does not have the expected format
• Fix possible crashes when loading LowQualityWater from SQL or CSV
• Display correct messages when loading from SQL (wrong table columns and non existent table)
• When reusing the target SQL table, allow to save only a subset of columns (ie: allow saving 8.3 database into 8.1 table by ignoring new columns). It's not possible to save with this feature when there is a column in the target table that is not in the database to save
• Better handling of COMMIT/ROLLBACK in case of errors when creating or truncating the target SQL table (keep the old one with all it's data)
• Add new database descriptions: db_aniinfo.rdb, db_decompose.rdb, db_fieldtypematerial.rdb, db_texture.rdb
• Fix errors when loading from official SQL tables (8.1 official tables from Strange2010's repack)
• Correct other invalid default names
• GUI: Correctly remove all selected lines in Db description DLL manage dialog and Hash / Name file renamer dialog
• GUI: Add alternate colors in tables for easier reading
• GUI: Add progress bar for file renamer (this feature actually copy files with the converted filename as the new filename and keep original ones)
• GUI: Don't remove non existent files in file to rename list at startup
• GUI: When editing the database, don't save invalid values in memory as 0 (keep the old one instead) (like putting a too big number in a 8 bit integer column)
• GUI: When renaming filenames in Hash / Name dialogbox, select lines in the files to rename list that have been correctly copied with the target name

Note: Database description DLLs for the previous version that was working with 2.4.x still work.

The Skill81Database.dll will use SkillFullResource as default SQL table name. The table contains both data of SkillResource and SkillJPResource.

Here are SQL scripts that create views to handle that difference (these views are like tables, but instead use a query from other table)

This script create SkillResource view that use data from SkillFullResource:

 Spoiler

CREATE VIEW [dbo].[SkillResource]
AS
SELECT        id, text_id, desc_id, tooltip_id, is_valid, elemental, is_passive, is_physical_act, is_harmful, is_need_target, is_corpse, is_toggle, toggle_group, 
                         casting_type, casting_level, cast_range, valid_range, cost_hp, cost_hp_per_skl, cost_mp, cost_mp_per_skl, cost_mp_per_enhance, cost_hp_per, 
                         cost_hp_per_skl_per, cost_mp_per, cost_mp_per_skl_per, cost_havoc, cost_havoc_per_skl, cost_energy, cost_energy_per_skl, cost_exp, 
                         cost_exp_per_enhance, cost_jp, cost_jp_per_enhance, cost_item, cost_item_count, cost_item_count_per_skl, need_level, need_hp, need_mp, need_havoc, 
                         need_havoc_burst, need_state_id, need_state_level, need_state_exhaust, vf_one_hand_sword, vf_two_hand_sword, vf_double_sword, vf_dagger, 
                         vf_double_dagger, vf_spear, vf_axe, vf_one_hand_axe, vf_double_axe, vf_one_hand_mace, vf_two_hand_mace, vf_lightbow, vf_heavybow, vf_crossbow, 
                         vf_one_hand_staff, vf_two_hand_staff, vf_shield_only, vf_is_not_need_weapon, delay_cast, delay_cast_per_skl, delay_cast_mode_per_enhance, 
                         delay_common, delay_cooltime, delay_cooltime_per_skl, delay_cooltime_mode_per_enhance, cool_time_group_id, uf_self, uf_party, uf_guild, uf_neutral, 
                         uf_purple, uf_enemy, tf_avatar, tf_summon, tf_monster, skill_lvup_limit, target, effect_type, skill_enchant_link_id, state_id, state_level_base, 
                         state_level_per_skl, state_level_per_enhance, state_second, state_second_per_level, state_second_per_enhance, probability_on_hit, 
                         probability_inc_by_slv, hit_bonus, hit_bonus_per_enhance, percentage, hate_mod, hate_basic, hate_per_skl, hate_per_enhance, critical_bonus, 
                         critical_bonus_per_skl, var1, var2, var3, var4, var5, var6, var7, var8, var9, var10, var11, var12, var13, var14, var15, var16, var17, var18, var19, var20, 
                         icon_id, icon_file_name, is_projectile, projectile_speed, projectile_acceleration
FROM            dbo.SkillFullResource

GO

This script create SkillJPResource view that use data from SkillFullResource too:

 Spoiler

CREATE VIEW [dbo].[SkillJPResource]
AS
SELECT        id AS skill_id, jp_01, jp_02, jp_03, jp_04, jp_05, jp_06, jp_07, jp_08, jp_09, jp_10, jp_11, jp_12, jp_13, jp_14, jp_15, jp_16, jp_17, jp_18, jp_19, jp_20, jp_21, 
                         jp_22, jp_23, jp_24, jp_25, jp_26, jp_27, jp_28, jp_29, jp_30, jp_31, jp_32, jp_33, jp_34, jp_35, jp_36, jp_37, jp_38, jp_39, jp_40, jp_41, jp_42, jp_43, jp_44, 
                         jp_45, jp_46, jp_47, jp_48, jp_49, jp_50
FROM            dbo.SkillFullResource

GO

This script create SkillFullResource2 view which use both SkillResource and SkillJPResource. The table can be used by my tool to read db_skill.rdb data from SQL. This view act like a merge of SkillResource and SkillJPResource and should only be used with SkillResource and SkillJPResource as real table. The tool can update the official SkillResource by using the "reuse existing table schema" option (but not SkillJPResource because of it's skill_id column)

 Spoiler

CREATE VIEW [dbo].[SkillFullResource2] AS

SELECT DISTINCT(id) [id]
	,[text_id]
	,[desc_id]
	,[tooltip_id]
	,[is_valid]
	,[elemental]
	,[is_passive]
	,[is_physical_act]
	,[is_harmful]
	,[is_need_target]
	,[is_corpse]
	,[is_toggle]
	,[toggle_group]
	,[casting_type]
	,[casting_level]
	,[cast_range]
	,[valid_range]
	,[cost_hp]
	,[cost_hp_per_skl]
	,[cost_mp]
	,[cost_mp_per_skl]
	,[cost_mp_per_enhance]
	,[cost_hp_per]
	,[cost_hp_per_skl_per]
	,[cost_mp_per]
	,[cost_mp_per_skl_per]
	,[cost_havoc]
	,[cost_havoc_per_skl]
	,[cost_energy]
	,[cost_energy_per_skl]
	,[cost_exp]
	,[cost_exp_per_enhance]
	,[cost_jp]
	,[cost_jp_per_enhance]
	,[cost_item]
	,[cost_item_count]
	,[cost_item_count_per_skl]
	,[need_level]
	,[need_hp]
	,[need_mp]
	,[need_havoc]
	,[need_havoc_burst]
	,[need_state_id]
	,[need_state_level]
	,[need_state_exhaust]
	,[vf_one_hand_sword]
	,[vf_two_hand_sword]
	,[vf_double_sword]
	,[vf_dagger]
	,[vf_double_dagger]
	,[vf_spear]
	,[vf_axe]
	,[vf_one_hand_axe]
	,[vf_double_axe]
	,[vf_one_hand_mace]
	,[vf_two_hand_mace]
	,[vf_lightbow]
	,[vf_heavybow]
	,[vf_crossbow]
	,[vf_one_hand_staff]
	,[vf_two_hand_staff]
	,[vf_shield_only]
	,[vf_is_not_need_weapon]
	,[delay_cast]
	,[delay_cast_per_skl]
	,[delay_cast_mode_per_enhance]
	,[delay_common]
	,[delay_cooltime]
	,[delay_cooltime_per_skl]
	,[delay_cooltime_mode_per_enhance]
	,[cool_time_group_id]
	,[uf_self]
	,[uf_party]
	,[uf_guild]
	,[uf_neutral]
	,[uf_purple]
	,[uf_enemy]
	,[tf_avatar]
	,[tf_summon]
	,[tf_monster]
	,[skill_lvup_limit]
	,[target]
	,[effect_type]
	,[skill_enchant_link_id]
	,[state_id]
	,[state_level_base]
	,[state_level_per_skl]
	,[state_level_per_enhance]
	,[state_second]
	,[state_second_per_level]
	,[state_second_per_enhance]
	,[probability_on_hit]
	,[probability_inc_by_slv]
	,[hit_bonus]
	,[hit_bonus_per_enhance]
	,[percentage]
	,[hate_mod]
	,[hate_basic]
	,[hate_per_skl]
	,[hate_per_enhance]
	,[critical_bonus]
	,[critical_bonus_per_skl]
	,[var1]
	,[var2]
	,[var3]
	,[var4]
	,[var5]
	,[var6]
	,[var7]
	,[var8]
	,[var9]
	,[var10]
	,[var11]
	,[var12]
	,[var13]
	,[var14]
	,[var15]
	,[var16]
	,[var17]
	,[var18]
	,[var19]
	,[var20]
	,ISNULL(jp_01, 0) AS jp_01
	,ISNULL(jp_02, 0) AS jp_02
	,ISNULL(jp_03, 0) AS jp_03
	,ISNULL(jp_04, 0) AS jp_04
	,ISNULL(jp_05, 0) AS jp_05
	,ISNULL(jp_06, 0) AS jp_06
	,ISNULL(jp_07, 0) AS jp_07
	,ISNULL(jp_08, 0) AS jp_08
	,ISNULL(jp_09, 0) AS jp_09
	,ISNULL(jp_10, 0) AS jp_10
	,ISNULL(jp_11, 0) AS jp_11
	,ISNULL(jp_12, 0) AS jp_12
	,ISNULL(jp_13, 0) AS jp_13
	,ISNULL(jp_14, 0) AS jp_14
	,ISNULL(jp_15, 0) AS jp_15
	,ISNULL(jp_16, 0) AS jp_16
	,ISNULL(jp_17, 0) AS jp_17
	,ISNULL(jp_18, 0) AS jp_18
	,ISNULL(jp_19, 0) AS jp_19
	,ISNULL(jp_20, 0) AS jp_20
	,ISNULL(jp_21, 0) AS jp_21
	,ISNULL(jp_22, 0) AS jp_22
	,ISNULL(jp_23, 0) AS jp_23
	,ISNULL(jp_24, 0) AS jp_24
	,ISNULL(jp_25, 0) AS jp_25
	,ISNULL(jp_26, 0) AS jp_26
	,ISNULL(jp_27, 0) AS jp_27
	,ISNULL(jp_28, 0) AS jp_28
	,ISNULL(jp_29, 0) AS jp_29
	,ISNULL(jp_30, 0) AS jp_30
	,ISNULL(jp_31, 0) AS jp_31
	,ISNULL(jp_32, 0) AS jp_32
	,ISNULL(jp_33, 0) AS jp_33
	,ISNULL(jp_34, 0) AS jp_34
	,ISNULL(jp_35, 0) AS jp_35
	,ISNULL(jp_36, 0) AS jp_36
	,ISNULL(jp_37, 0) AS jp_37
	,ISNULL(jp_38, 0) AS jp_38
	,ISNULL(jp_39, 0) AS jp_39
	,ISNULL(jp_40, 0) AS jp_40
	,ISNULL(jp_41, 0) AS jp_41
	,ISNULL(jp_42, 0) AS jp_42
	,ISNULL(jp_43, 0) AS jp_43
	,ISNULL(jp_44, 0) AS jp_44
	,ISNULL(jp_45, 0) AS jp_45
	,ISNULL(jp_46, 0) AS jp_46
	,ISNULL(jp_47, 0) AS jp_47
	,ISNULL(jp_48, 0) AS jp_48
	,ISNULL(jp_49, 0) AS jp_49
	,ISNULL(jp_50, 0) AS jp_50
	,[icon_id]
	,[icon_file_name]
	,[is_projectile]
	,[projectile_speed]
	,[projectile_acceleration]
	,'0' AS [unknownValue0]
FROM dbo.SkillResource s LEFT JOIN dbo.SkillJPResource sjp ON s.id = sjp.skill_id;

GO

So either have:
- SkillFullResource as a view and SkillResource & SkillJPResource as tables
or
- SkillFullResource as a table and SkillResource & SkillJPResource as views

(The GS won't make any difference if SkillResource or SkillJPResource are views instead of tables)

Here is a small screenshot of the Hash / Name dialog box: