[Release] Rappelz RDB Tool with tabs

Page 21 of 27 « First 111920 21 2223 Last »
09/20/2017 12:49 ThunderNikk#301
Do you have another browser you could try?
09/21/2017 19:03 king1king#302
iam try ..error agine
10/28/2017 17:23 Dr.GosT04#303
We need a program to read ref files
10/31/2017 01:38 glandu2#304
A new version of RappelzRDBTool v3.1.0 to support ref files.

Changes:
  • LUA: Support both integers and boolean value for bits and int fields in convertData
  • LUA: Fix various differences between lua and c++ DLL
  • Support .ref files: The field must be a TYPE_CHAR one with a size equal or above the string size inside the .ref file. I think it will be always a size of 52 bytes but not sure. The max field size is set inside the lua description.
  • Add ItemRef94Database.lua to handle db_item.ref
  • Support default filename with extension to override the default ".rdb" (used for "db_item.ref")

I don't put database descriptions in dll format anymore (.dll and .cpp), tell me if someone need them. (They are still supported).

You can use tips from @[Only registered and activated users can see links. Click Here To Register...] to create a SQL view to merge db_item.rdb and db_item.ref:
[Only registered and activated users can see links. Click Here To Register...]
10/31/2017 09:17 Gangor#305
You got one small error in lua of ItemRef.
Id start by 0.

Line 12
Code:
		row.id = rowNum + 1
to
		row.id = rowNum
If we want this work with my view using attached file.
03/27/2018 20:50 Rappelz-Zesua#306
Thank you for the tool and the constant updates. I appreciate your time and dedication.

I have a question, i noticed for example if the decimal(10, 2) in the SQL then it becomes a TYPE_DECIMAL, MAKEINDEXEDVAR(2, 1) in the lua. I read the sample and as I understand that 2 is the 2 digits after the decimal dot. And the 1 is always 1 as it represents a number.

What i didn't understand is if the SQL column is decimal(12, 4) would that mean TYPE_DECIMAL, MAKEINDEXEDVAR(4, 1)? and how do you convert them. Like the 10.2 became 2.1.

Thank you once again.
03/27/2018 22:02 glandu2#307
decimal columns are always created with decimal(10,X) where X is the number inside MAKEINDEXEDVAR(X, 1)

Is decimal(10,x) too small ?
03/27/2018 22:18 Rappelz-Zesua#308
Thank you for the follow up.

No the decimal(10,x) isn't too small. But what I am referring to is why its 2,1 in the LUA when its 10,2 in the SQL column. Trying to figure the theory behind it. Because I spent 4 hours creating an rdb file for the skillresource of 5.2 server it success and all is good. However when running the game, the entire skills are black boxes. So I figure its due some of the columns in the LUA that aren't adding up, which why I wanted to know the theory behind what made it to 2,1 in the lua when its 10,2 in the SQL.

For example the way you made the SkillResource for the 8.1

In the lua its

While in the SQL its

Have tried to use TYPE_FLOAT32 in the LUA where in SQL is decimal(12, 4) and same result.

Sorry my explanation isn't the best.
03/27/2018 23:26 thefear511#309
Quote:
Originally Posted by Rappelz-Zesua View Post
Thank you for the follow up.

No the decimal(10,x) isn't too small. But what I am referring to is why its 2,1 in the LUA when its 10,2 in the SQL column. Trying to figure the theory behind it. Because I spent 4 hours creating an rdb file for the skillresource of 5.2 server it success and all is good. However when running the game, the entire skills are black boxes. So I figure its due some of the columns in the LUA that aren't adding up, which why I wanted to know the theory behind what made it to 2,1 in the lua when its 10,2 in the SQL.

For example the way you made the SkillResource for the 8.1

In the lua its

While in the SQL its

Have tried to use TYPE_FLOAT32 in the LUA where in SQL is decimal(12, 4) and same result.

Sorry my explanation isn't the best.
if you're referring to skillresource converting the table to rdb and hashing it correctly, I have a solution its kinda complicated one but does the job for all epics.
if its the issue ill post a topic about it.
03/28/2018 00:14 glandu2#310
Use the existing skillresource 5.2 table to find which column to keep and then compare read data from the 5.2 RDB file with the data in the 5.2 skillresource table to find which column is not correctly mapped.

Also use an hex editor and if yours don't have a way to show data value as int / float, you can use windows calculator to convert from hex to decimal and [Only registered and activated users can see links. Click Here To Register...] to convert from hex to float/double.

Using these methods, I got the following description file in attachment.
03/29/2018 08:34 RappelzUnited#311
Quote:
Originally Posted by glandu2 View Post
Use the existing skillresource 5.2 table to find which column to keep and then compare read data from the 5.2 RDB file with the data in the 5.2 skillresource table to find which column is not correctly mapped.

Also use an hex editor and if yours don't have a way to show data value as int / float, you can use windows calculator to convert from hex to decimal and [Only registered and activated users can see links. Click Here To Register...] to convert from hex to float/double.

Using these methods, I got the following description file in attachment.
You need to combine skillresource + skilljpresource in one table and convert it to rdb to have new skills working correctly.
However to get data from both tables into one is the fix you need to come up with.
04/04/2018 23:08 Rappelz-Zesua#312
Quote:
Originally Posted by glandu2 View Post
Use the existing skillresource 5.2 table to find which column to keep and then compare read data from the 5.2 RDB file with the data in the 5.2 skillresource table to find which column is not correctly mapped.

Also use an hex editor and if yours don't have a way to show data value as int / float, you can use windows calculator to convert from hex to decimal and [Only registered and activated users can see links. Click Here To Register...] to convert from hex to float/double.

Using these methods, I got the following description file in attachment.
Thank you for the advice, I will give it a try. But the file you've attached is more like 9.1 version :). As 5.2 they don't have the JP in the skillresource.



This what I used with lot of changes in the types like TYPE_DECIMAL, MAKEINDEXEDVAR(2, 1)}, to float and so on with different attempts. And always resulted into messing up the skills to be blank boxes.
04/05/2018 09:10 thefear511#313
Quote:
Originally Posted by Rappelz-Zesua View Post
Thank you for the advice, I will give it a try. But the file you've attached is more like 9.1 version :). As 5.2 they don't have the JP in the skillresource.



This what I used with lot of changes in the types like TYPE_DECIMAL, MAKEINDEXEDVAR(2, 1)}, to float and so on with different attempts. And always resulted into messing up the skills to be blank boxes.
you're not getting the point, it does not matter which types you are using execute skill resource table as schema and copy the types from there.
after that, you need to merge jp with it. I know 5.2 doesn't have jp columns but that's the same way in 7.2 too.
05/18/2018 16:09 squall14000#314
Hello guys, i got a problem with resources.

I got 9.4 server (english client) and executed the RDB tool (last version), then loaded from the sql database "Monster9.1Database.lua", changed a value (level) and finally saved to file (hashed) into the resources folder.

[Only registered and activated users can see links. Click Here To Register...]

In game, change didn't apply, the level did not change from the client.

[Only registered and activated users can see links. Click Here To Register...]


What is wrong ?

Thanks for working and helping ^^
05/18/2018 18:18 ThunderNikk#315
You are running in English so make sure the name was hashed (ascii)
Page 21 of 27 « First 111920 21 2223 Last »