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 @ to create a SQL view to merge db_item.rdb and db_item.ref:
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.
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
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
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.
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 to convert from hex to float/double.
Using these methods, I got the following description file in attachment.
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 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.
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 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.
rdb.convertData = function (dst, mode, row, rowNum)
if mode == DCT_Read and dst == DF_RDB then
row.desc_id = 0
end
end
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.
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.
rdb.convertData = function (dst, mode, row, rowNum)
if mode == DCT_Read and dst == DF_RDB then
row.desc_id = 0
end
end
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.
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.
In game, change didn't apply, the level did not change from the client.
[Release]Shiva-Rappelz GM-Tool V1 04/22/2023 - Rappelz Private Server - 9 Replies Download
VirusTotal
GM-Tool not update since the first post, you can update it easily with your Arcadia.
[Release]e*PvP - Rappelz Section Tool 09/15/2012 - Rappelz Private Server - 14 Replies Well,
here is the tool to make accessing/using this board easier a LOT!
It has many functions, which i will put SS and explain about each one ( and its everything is explained in the tool too)
http://i.epvpimg.com/1hExc.png
here, u can write the thing your searching for in the text box, then click the search button so it searches for it in epvp search engine (Whole Epvp Search Engine And Not Only Rappelz)
and you can also click the logo to be directed to the main rappelz-private-server...
![[Release] Rappelz RDB Tool with tabs](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/release-rappelz-rdb-tool-tabs_ltr.gif){kind=small}
to create a SQL view to merge db_item.rdb and db_item.ref:
. As 5.2 they don't have the JP in the skillresource. 
