[Release] Rappelz RDB Tool with tabs

Page 7 of 27

04/01/2014 13:23 glandu2#91

Quote:

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

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

Code:

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.

04/01/2014 13:44 Mslolita#92

Before: Working (Royal Repack)

Spoiler

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

Spoiler

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

04/01/2014 19:51 glandu2#93

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.

04/01/2014 21:11 Mslolita#94

I must say Thank you very much!

Quote:

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.

04/07/2014 14:47 Mslolita#95

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.

Quote:

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.

04/07/2014 19:36 glandu2#96

Quote:

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:

Code:

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

04/08/2014 12:52 Mslolita#97

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

Correct example weapon Range:

Spoiler

Incorrect weapon Range (importing with the tool):

Spoiler

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

Quote:
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:
Code:
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

04/08/2014 13:25 Ne0@NCarbon#98

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

04/08/2014 14:21 Mslolita#99

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

Quote:

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.

04/08/2014 14:59 Ne0@NCarbon#100

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 ;)

04/13/2014 23:58 rz-crazyfun#101

NpcDatabase 8_1 does not work ((

04/16/2014 00:05 glandu2#102

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.

04/16/2014 00:06 glandu2#103

Quote:

Originally Posted by rz-crazyfun

NpcDatabase 8_1 does not work ((

Quote:

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

04/19/2014 01:17 glandu2#104

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)

04/21/2014 18:54 glandu2#105

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

Code:

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

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

Code:

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

Page 7 of 27

« First

Last »