Are you referring to RappelzRDBTool? If so, I'm already using it to open rdb files. That's how I know that the columns are different.
I can update the table structure, but I don't think I can just prefill the new columns with 0 value.
Basically, the db_item.rdb from data.000 (client) has many more columns than the Arcadia (ItemResource) database (server).
Just to be clear, I grab the server files from here:
And the client:
UPDATE:
So I manage to duplicate existing item (but with diff stats) by updating both the server and client database separately.
I still don't understand why the client DB has many more columns (mainly those value_XX up to 20). Is it supposed to be like this? Or I'm using wrong Client/Server combination?
Then, I try to update the String. The data.*** has db_sting, db_string(ascii), db_string(windows-1252), and db_string. When using RappelzRDBTool String81 lua, I can only open the 1st one, db_sting.rdb, all other files will crash the Tools. Can someone tell me why there are 4 DBs and how they are being consumed by the Client? More importantly, how can I open these other 3 DBs?
I hope the experts in this forum would help me.
Final Update:
I'm able to update the icon by updating 02_item.spr, db_item.rdb, and db_item.ref, as well as the jpg, directly into data.***
And for the string, I grab server's StringResource_XX and replace the db_string.rdb in data.***, ignoring the three other string DBs. So far so good. Not sure if there will be side effects.