I am trying to make an rdb file for my server, I edited some quests and tried to export some recourse to see the effects in the game,
I downloaded RDB Tool and copied QuestResource from 7.1 and made some tweaks to it, but once I try to "Load from SQL" RDB Tool crashes, no error massages appears.
This is the script file:
Code:
rdb.fields = {
{"id", TYPE_INT32},
{"text_id_quest", TYPE_INT32},
{"text_id_summary", TYPE_INT32},
{"text_id_status", TYPE_INT32},
{"limit_begin_time", TYPE_INT32},
{"limit_end_time", TYPE_INT32},
{"limit_level", TYPE_INT32},
{"limit_job_level", TYPE_INT32},
{"limit_max_level", TYPE_INT32},
{"limit_max_job_level", TYPE_INT32},
{"limit_deva", TYPE_BIT},
{"limit_asura", TYPE_BIT},
{"limit_gaia", TYPE_BIT},
{"limit_fighter", TYPE_BIT},
{"limit_hunter", TYPE_BIT},
{"limit_magician", TYPE_BIT},
{"limit_summoner", TYPE_BIT},
{"limit_job", TYPE_INT32},
{"limit_favor_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
{"limit_favor", TYPE_INT32},
{"repeatable", TYPE_INT32},
{"invoke_condition", TYPE_INT32},
{"invoke_value", TYPE_INT32},
{"time_limit_type", TYPE_INT16},
{"time_limit", TYPE_INT32},
{"type", TYPE_INT32},
{"value1", TYPE_INT32},
{"value2", TYPE_INT32},
{"value3", TYPE_INT32},
{"value4", TYPE_INT32},
{"value5", TYPE_INT32},
{"value6", TYPE_INT32},
{"value7", TYPE_INT32},
{"value8", TYPE_INT32},
{"value9", TYPE_INT32},
{"value10", TYPE_INT32},
{"value11", TYPE_INT32},
{"value12", TYPE_INT32},
{"drop_group_id", TYPE_INT32},
{"quest_difficulty", TYPE_INT32},
{"favor_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
{"hate_group_id", TYPE_INT32 | TYPE_RDBIGNORE},
{"favor", TYPE_INT32},
{"exp", TYPE_INT32},
{"jp", TYPE_INT32},
{"holicpoint", TYPE_INT32},
{"gold", TYPE_INT32},
{"default_reward_id", TYPE_INT32},
{"default_reward_level", TYPE_INT32},
{"default_reward_quantity", TYPE_INT32},
{"optional_reward_id1", TYPE_INT32},
{"optional_reward_level1", TYPE_INT32},
{"optional_reward_quantity1", TYPE_INT32},
{"optional_reward_id2", TYPE_INT32},
{"optional_reward_level2", TYPE_INT32},
{"optional_reward_quantity2", TYPE_INT32},
{"optional_reward_id3", TYPE_INT32},
{"optional_reward_level3", TYPE_INT32},
{"optional_reward_quantity3", TYPE_INT32},
{"optional_reward_id4", TYPE_INT32},
{"optional_reward_level4", TYPE_INT32},
{"optional_reward_quantity4", TYPE_INT32},
{"optional_reward_id5", TYPE_INT32},
{"optional_reward_level5", TYPE_INT32},
{"optional_reward_quantity5", TYPE_INT32},
{"optional_reward_id6", TYPE_INT32},
{"optional_reward_level6", TYPE_INT32},
{"optional_reward_quantity6", TYPE_INT32},
{"forequest1", TYPE_INT32},
{"forequest2", TYPE_INT32},
{"forequest3", TYPE_INT32},
{"or_flag", TYPE_INT8},
{"script_start_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
{"script_end_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
{"script_text", TYPE_VARCHAR_STR, MAKEINDEXEDVAR(0, 512)},
}
rdb.convertData = function (dst, mode, row, rowNum)
if mode == DCT_Read and dst ~= DF_RDB then
local id = row.id;
row.limit_favor_group_id = 0
row.favor_group_id = 999
if id >= 3600 and id <= 3611 and id ~= 3610 then
row.hate_group_id = 1
else
row.hate_group_id = 0
end
end
end
This is the table exported from SQL Studio:
Code:
USE [Arcadia] GO /****** Object: Table [dbo].[QuestResource] Script Date: 3/7/2019 7:11:01 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[QuestResource]( [id] [int] NOT NULL, [text_id_quest] [int] NOT NULL, [text_id_summary] [int] NOT NULL, [text_id_status] [int] NOT NULL, [limit_begin_time] [int] NOT NULL, [limit_end_time] [int] NOT NULL, [limit_level] [int] NOT NULL, [limit_job_level] [int] NOT NULL, [limit_max_level] [int] NOT NULL, [limit_max_job_level] [int] NOT NULL, [limit_deva] [char](1) NOT NULL, [limit_asura] [char](1) NOT NULL, [limit_gaia] [char](1) NOT NULL, [limit_fighter] [char](1) NOT NULL, [limit_hunter] [char](1) NOT NULL, [limit_magician] [char](1) NOT NULL, [limit_summoner] [char](1) NOT NULL, [limit_job] [int] NOT NULL, [limit_favor_group_id] [int] NOT NULL, [limit_favor] [int] NOT NULL, [repeatable] [char](1) NOT NULL, [invoke_condition] [int] NOT NULL, [invoke_value] [int] NOT NULL, [time_limit_type] [char](10) NOT NULL, [time_limit] [int] NOT NULL, [type] [int] NOT NULL, [value1] [int] NOT NULL, [value2] [int] NOT NULL, [value3] [int] NOT NULL, [value4] [int] NOT NULL, [value5] [int] NOT NULL, [value6] [int] NOT NULL, [value7] [int] NOT NULL, [value8] [int] NOT NULL, [value9] [int] NOT NULL, [value10] [int] NOT NULL, [value11] [int] NOT NULL, [value12] [int] NOT NULL, [drop_group_id] [int] NOT NULL, [quest_difficulty] [int] NOT NULL, [favor_group_id] [int] NOT NULL, [hate_group_id] [int] NOT NULL, [favor] [int] NOT NULL, [exp] [bigint] NOT NULL, [jp] [int] NOT NULL, [holicpoint] [int] NOT NULL, [gold] [int] NOT NULL, [default_reward_id] [int] NOT NULL, [default_reward_level] [int] NOT NULL, [default_reward_quantity] [int] NOT NULL, [optional_reward_id1] [int] NOT NULL, [optional_reward_level1] [int] NOT NULL, [optional_reward_quantity1] [int] NOT NULL, [optional_reward_id2] [int] NOT NULL, [optional_reward_level2] [int] NOT NULL, [optional_reward_quantity2] [int] NOT NULL, [optional_reward_id3] [int] NOT NULL, [optional_reward_level3] [int] NOT NULL, [optional_reward_quantity3] [int] NOT NULL, [optional_reward_id4] [int] NOT NULL, [optional_reward_level4] [int] NOT NULL, [optional_reward_quantity4] [int] NOT NULL, [optional_reward_id5] [int] NOT NULL, [optional_reward_level5] [int] NOT NULL, [optional_reward_quantity5] [int] NOT NULL, [optional_reward_id6] [int] NOT NULL, [optional_reward_level6] [int] NOT NULL, [optional_reward_quantity6] [int] NOT NULL, [forequest1] [int] NOT NULL, [forequest2] [int] NOT NULL, [forequest3] [int] NOT NULL, [or_flag] [char](1) NOT NULL, [script_start_text] [varchar](512) NULL, [script_end_text] [varchar](512) NULL, [script_text] [varchar](512) NULL ) ON [PRIMARY] GO
I use Revo 7.2 files.
If there were error messages I might be able to get it to work myself, but unfortunately it does not show any errors, so I need some help here.
Thanks.
