[Release] Rappelz RDB Tool with tabs

[ThunderNikk]

Did you import that db_string_rdb to the database with the database manager

[rcadil]

Originally Posted by thndr

Did you import that db_string_rdb to the database with the database manager

no :/

[glandu2]

Are you sure to use Arabic locale when importing data from the database ?

It seems that it's ok as you have correct characters in sframe. What's wrong in the screen ? the 0.00000Def 0.00000 .... ?
If you didn't find the problem until now, consider posting your SQL table and db_string.rdb as attachment (fo the sql table, export as a sql script preferably)

[.BlackCat.]

Thank you.
Just wanted to know is your ItemResource Saving/Reading bugged ?
I read ItemResource using Item83Database.dll & Saved to my Database , all looks fine.

After saving to RDB using your tool or Raskim tool => Items are not working at all. like potions,galactic stone etc ...

 Spoiler

[ismokedrow]

Most likely db related, if you sent from item_db directly to your db chances are there is blank data missing somewhere or quiet literally you have the columns in the wrong order, the GS loads using SELECT * FROM dbo.ItemResource WHERE

meaning it is expecting the data in a specific order, so try this:

1. Restore your original 8.2 Arcadia or 8.1 Arcadia (the one who works)

2. Now truncate it (TRUNCATE TABLE dbo.ItemResource)

3. Now rename it to dbo.ItemResourceWAIT

4. Now send the db_item.rdb (8.3) to the database

5. Right click on the new 8.3 itemresource and click Tasks>Generate Scripts make sure to click Advanced and set Schema Only to Schema + Data and then generate it to a new SQL Query Window

6. Now in the new query window drop the "CREATE TABLE" part and switch the dbo.ItemResource to dbo.ItemResourceWAIT and execute

7. Tell me what happens

[glandu2]

With my file, I have korean characters in drop_type column for several rows (although using the FR db_item.rdb file). I am using linux with freetds to do test, and it complain about not being able to convert these chars to target server charset (which is for me an arabic collation).
So I think I need to use utf16 too when writing varchar and char columns to prevents these problems ...

Anyway, for you it should not be the cause of your problem (or indirectly).
Can you add details to what you do to have this problem, is it:
- read rdb
- write sql

- read sql
- write rdb

?

The column order can be the issue, there is a new column in the rdb file (at the end of a record, which I have named unknownValue2.

But this column is at the end, so if the GS use SELECT * from ... and use index, it should just ignore the last one ?

Other columns seems to be the same as for 8.2 db_item.rdb, except unknownValue1 which has 0 now instead of 49

Also describe better what's wrong, I just see that you have an empty cell and potions are not stacked, that's all ? In that case, maybe there are new flags too

[.BlackCat.]

Originally Posted by glandu2

With my file, I have korean characters in drop_type column for several rows (although using the FR db_item.rdb file). I am using linux with freetds to do test, and it complain about not being able to convert these chars to target server charset (which is for me an arabic collation).
So I think I need to use utf16 too when writing varchar and char columns to prevents these problems ...

Anyway, for you it should not be the cause of your problem (or indirectly).
Can you add details to what you do to have this problem, is it:
- read rdb
- write sql

- read sql
- write rdb

?

1)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using Item83Database.dll
Results : NOT Even one Item working (no icons, no models , nothing)


2)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using ItemDatabase.dll
Results : Some items not working(if I have 10 Stamina for example , they are not stacked,no effects (EXP) etc ...)


3)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using Database Manager of Raskim
Results : Some items not working(same thing as case 2)

After removing the last column "UnknownValue2" , Game server wouldn't start for some reasons :x

EDIT : there "unknownValue1" ? where exactly ?
It's not new Item_use_flag since I checked with my Other Arcadia .

[glandu2]

unknownValue1 is not put as a column. So the GS dont even see the difference (value was 49 before, 0 now)

If your client is 8.1, It's normal that a 8.3 db_item.rdb will not work (exporting using item83database will make a 8.3 db_item.rdb) ^^ so no problem here

If you remove unknownValue2 column, you have the same columns than the old ItemResource table that was working ?

unknownValue1 is only used in the rdb file, it does not appear as a SQL column (and always have the value 49 for the 8.1 db_item.rdb, 0 for 8.3 one)

My tool and/or Raskim's one was working before ? Or it's the first time you try them ? (for exporting to RDB)

[.BlackCat.]

Yea , I guess its' wrong values from your program ... even when I use any Item I get in chat "string["2..]:an expected error..."

Edit : Never tried your program , Always use Raskim tools or mine . and working fine
wanted to try your since it's much much faster

[glandu2]

The sql table generated from the 8.3 db_item.rdb has the same columns + unknownValue2 than the original table that you were using ?

What data you have for the item with ID 900000 ? (stamina saver) For me, drop_type is drop_etc_potion_purple, icon_file_name is icon_item_etc_0108. And what have you for the drop_type for the ID 601100284 ?

I have the exact same values for a db_item.rdb of august 2013 and for the one up to date today (fr).

[.BlackCat.]

I found the issue , it was my mistake on Columns order , thanks

[ismokedrow]

[MrStubborn]

what about hashed names ?
the first letter from hashed name is always wrong
& thanks for useful tool.

[glandu2]

Originally Posted by MrStubborn

what about hashed names ?
the first letter from hashed name is always wrong
& thanks for useful tool.

For which name ? For me it works with db_string.rdb, it give me sdXwe'vmvdeHga$, db_item.rdb = U{W.Y(_ZdT!JV

You have an example with the name, the hashing result and the correct hash ?

[edit]
Indeed, the bug is random and I found the problem, it will be corrected in next version (which will be there in less than one week)

[glandu2]

A new version 2.3.6 with these changes (since 2.3.3):

• Support NVARCHAR column (for db_string) with unicode data (it's possible to store a french StringResource in an Arabic database along with the Arabic StringResource without character loss)
• Save to sql script: the table name is the filename without ".sql"
• Fixed hash conversion issue as discovered by MrStubborn
• Removed primary keys as official tables dont use them and sometime rows are duplicated
• I renamed all database description dll to have the epic number (I put 8.1 for all of them, them can work for older epic's still) (it's just to remember for which epic these dll were done, databases description dll without epic number still work)
• Always use dot as decimal separator in the GUI, CSV and SQL script
• The tool should not crash anymore when loading a non-rdb file as rdb (it will give "Invalid argument" in this cas)
• Updated and added some 8.3 rdb struct description dll (about npc and items)