[Release] Rappelz RDB Tool with tabs

Quote:

Originally Posted by solo69 does anyone have ItemResource 9.5 ?

Quote:

Originally Posted by InkDevil Well, if you're happy with it in sql-format, then here you are.

Quote:

Originally Posted by SilentWisdom What is your issue? @[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by AlNisr Can you communicate elsewhere? facebook or discord ! i can't talk here :(

Quote:

Originally Posted by SilentWisdom You can msg me on disc: ismokedrow#3102

• Add support for negative length strings. These are assumed to be 0 byte string. These negative length strings can be handled by LUA code to manage them. In db_string.rdb, this is used to retrieve referenced strings.
• Allow convertData function to set the string length (used to pad all string to be 4 bytes aligned)
• Add a new available function to set the RDB date: "getRdbDate". See implementation in String952Database.lua.

Quote:

Originally Posted by glandu2 @[Only registered and activated users can see links. Click Here To Register...] A new version of RappelzRDBTool v3.2.0 to support db_string.rdb from 9.5.2. Changes: Add support for negative length strings. These are assumed to be 0 byte string. These negative length strings can be handled by LUA code to manage them. In db_string.rdb, this is used to retrieve referenced strings. Allow convertData function to set the string length (used to pad all string to be 4 bytes aligned) Add a new available function to set the RDB date: "getRdbDate". See implementation in String952Database.lua.

#edit by: AlNisr
rdb.fields = {
	{"", TYPE_VARCHAR_SIZE | TYPE_SQLIGNORE, MAKEINDEXEDVAR(0, 1)},
	{"", TYPE_VARCHAR_SIZE | TYPE_SQLIGNORE, MAKEINDEXEDVAR(1, 1)},
	{"name", TYPE_VARCHAR_STR | TYPE_SQLIGNORE, MAKEINDEXEDVAR(0, 64)},
	{"value", TYPE_NVARCHAR_STR, MAKEINDEXEDVAR(1, 3999)},
	{"code", TYPE_INT32},
	{"group_id", TYPE_INT32},
	{"unknownValue0", TYPE_INT32 | TYPE_SQLIGNORE | TYPE_CSVIGNORE | TYPE_GUIIGNORE},
	{"unknownValue1", TYPE_INT32 | TYPE_SQLIGNORE | TYPE_CSVIGNORE | TYPE_GUIIGNORE},
	{"unknownValue2", TYPE_INT32 | TYPE_SQLIGNORE | TYPE_CSVIGNORE | TYPE_GUIIGNORE},
	{"unknownValue3", TYPE_INT32 | TYPE_SQLIGNORE | TYPE_CSVIGNORE | TYPE_GUIIGNORE},
}
rdb.defaultFileName = "db_string.rdb"
rdb.defaultTableName = "StringResource"

rdb.sqlColumnOrder = table.concat({
	"name\0",
	"group_id\0",
	"code\0",
	"value\0",
})

rdb.csvColumnOrder = table.concat({
	"code\0",
	"group_id\0",
	"name\0",
	"value\0",
})

rdb.convertData = function (dst, mode, row, rowNum)
	if mode == DCT_Read and dst ~= DF_RDB then
		row.name = "New Name"
		row.unknownValue0 = 0
		row.unknownValue1 = 0
		row.unknownValue2 = 0
		row.unknownValue3 = 0
	end
end