[Release] Rappelz RDB Tool with tabs

[Sandro1029]

Originally Posted by chet108

any one here share dbo.SkillResource6.2 or 6.3

Send the table struct

[SilentWisdom]

tableName = "SkillResource"
fileName = "db_skill(ascii).rdb"

fields = 
{
	{ "id", INT32 },
	{ "text_id", INT32 },
	{ "is_valid", BYTE },
	{ "elemental", BYTE },
	{ "is_passive", BYTE },
	{ "is_physical_act", BYTE },
	{ "is_harmful", BYTE },
	{ "is_need_target", BYTE },
	{ "is_corpse", BYTE },
	{ "is_toggle", BYTE },
	{ "casting_type", BYTE },
	{ "casting_level", BYTE },
	{ "u1", BYTE, show=0  },
	{ "u2", BYTE, show=0  },
	{ "toggle_group", INT32 },
	{ "cast_range", INT32 },
	{ "valid_range", INT32 },
	{ "cost_hp", INT32 },
	{ "cost_hp_per_skl", INT32 },
	{ "cost_mp", INT32 },
	{ "cost_mp_per_skl", INT32 },
	{ "cost_mp_per_enhance", INT32 },
	{ "cost_hp_per", SINGLE },
	{ "cost_hp_per_skl_per", SINGLE },
	{ "cost_mp_per", SINGLE },
	{ "cost_mp_per_skl_per", SINGLE },
	{ "cost_havoc", INT32 },
	{ "cost_havoc_per_skl", INT32 },
	{ "cost_energy", SINGLE },
	{ "cost_energy_per_skl", SINGLE },
	{ "cost_exp", INT32 },
	{ "cost_exp_per_enhance", INT32 },
	{ "cost_jp", INT32 },
	{ "cost_jp_per_enhance", INT32 },
	{ "cost_item", INT32 },
	{ "cost_item_count", INT32 },
	{ "cost_item_count_per_skl", INT32 },
	{ "need_level", INT32 },
	{ "need_hp", INT32 },
	{ "need_mp", INT32 },
	{ "need_havoc", INT32 },
	{ "need_havoc_burst", INT32 },
	{ "need_state_id", INT32 },
	{ "need_state_level", BYTE },
	{ "need_state_exhaust", BYTE },
	{ "vf_one_hand_sword", BYTE },
	{ "vf_two_hand_sword", BYTE },
	{ "vf_double_sword", BYTE },
	{ "vf_dagger", BYTE },
	{ "vf_double_dagger", BYTE },
	{ "vf_spear", BYTE },
	{ "vf_axe", BYTE },
	{ "vf_one_hand_axe", BYTE },
	{ "vf_double_axe", BYTE },
	{ "vf_one_hand_mace", BYTE },
	{ "vf_two_hand_mace", BYTE },
	{ "vf_lightbow", BYTE },
	{ "vf_heavybow", BYTE },
	{ "vf_crossbow", BYTE },
	{ "vf_one_hand_staff", BYTE },
	{ "vf_two_hand_staff", BYTE },
	{ "vf_shield_only", BYTE },
	{ "vf_is_not_need_weapon", BYTE },
	{ "delay_cast", DECIMAL },
	{ "delay_cast_per_skl", DECIMAL },
	{ "delay_cast_mode_per_enhance", SINGLE },
	{ "delay_common", DECIMAL },
	{ "delay_cooltime", DECIMAL },
	{ "delay_cooltime_mode_per_enhance", SINGLE },
	{ "cool_time_group_id", INT32 },
	{ "uf_self", BYTE },
	{ "uf_party", BYTE },
	{ "uf_guild", BYTE },
	{ "uf_neutral", BYTE },
	{ "uf_purple", BYTE },
	{ "uf_enemy", BYTE },
	{ "tf_avatar", BYTE },
	{ "tf_summon", BYTE },
	{ "tf_monster", BYTE },
	{ "u3", BYTE, show=0  },
	{ "target", INT16 },
	{ "effect_type", INT16 },
	{ "u4", INT16, show=0  },
	{ "state_id", INT32 },
	{ "state_level_base", INT32 },
	{ "state_level_per_skl", SINGLE },
	{ "state_level_per_enhance", SINGLE },
	{ "state_second", DECIMAL },
	{ "state_second_per_level", DECIMAL },
	{ "state_second_per_enhance", DECIMAL },
	{ "state_type", BYTE },
	{ "u5", BYTE, length=3, show=0  },
	{ "probability_on_hit", INT32 },
	{ "probability_inc_by_slv", INT32 },
	{ "hit_bonus", INT16 },
	{ "hit_bonus_per_enhance", INT16 },
	{ "percentage", INT16 },
	{ "u6", INT16, show=0  },
	{ "hate_mod", SINGLE },
	{ "hate_basic", INT32 },
	{ "hate_per_skl", SINGLE },
	{ "hate_per_enhance", SINGLE },
	{ "unknown6", BYTE, length=8, show=0 },
	{ "var1", SINGLE },
	{ "var2", SINGLE },
	{ "var3", SINGLE },
	{ "var4", SINGLE },
	{ "var5", SINGLE },
	{ "var6", SINGLE },
	{ "var7", SINGLE },
	{ "var8", SINGLE },
	{ "var9", SINGLE },
	{ "var10", SINGLE },
	{ "var11", SINGLE },
	{ "var12", SINGLE },
	{ "var13", SINGLE },
	{ "var14", SINGLE },
	{ "var15", SINGLE },
	{ "var16", SINGLE },
	{ "var17", SINGLE },
	{ "var18", SINGLE },
	{ "var19", SINGLE },
	{ "var20", SINGLE },
	{ "jp_01", INT32 },
	{ "jp_02", INT32 },
	{ "jp_03", INT32 },
	{ "jp_04", INT32 },
	{ "jp_05", INT32 },
	{ "jp_06", INT32 },
	{ "jp_07", INT32 },
	{ "jp_08", INT32 },
	{ "jp_09", INT32 },
	{ "jp_10", INT32 },
	{ "jp_11", INT32 },
	{ "jp_12", INT32 },
	{ "jp_13", INT32 },
	{ "jp_14", INT32 },
	{ "jp_15", INT32 },
	{ "jp_16", INT32 },
	{ "jp_17", INT32 },
	{ "jp_18", INT32 },
	{ "jp_19", INT32 },
	{ "jp_20", INT32 },	
	{ "jp_21", INT32 },
	{ "jp_22", INT32 },
	{ "jp_23", INT32 },
	{ "jp_24", INT32 },
	{ "jp_25", INT32 },
	{ "jp_26", INT32 },
	{ "jp_27", INT32 },
	{ "jp_28", INT32 },
	{ "jp_29", INT32 },
	{ "jp_30", INT32 },	
	{ "jp_31", INT32 },
	{ "jp_32", INT32 },
	{ "jp_33", INT32 },
	{ "jp_34", INT32 },
	{ "jp_35", INT32 },
	{ "jp_36", INT32 },
	{ "jp_37", INT32 },
	{ "jp_38", INT32 },
	{ "jp_39", INT32 },
	{ "jp_40", INT32 },	
	{ "jp_41", INT32 },
	{ "jp_42", INT32 },
	{ "jp_43", INT32 },
	{ "jp_44", INT32 },
	{ "jp_45", INT32 },
	{ "jp_46", INT32 },
	{ "jp_47", INT32 },
	{ "jp_48", INT32 },
	{ "jp_49", INT32 },
	{ "jp_50", INT32 },	
	{ "desc_id", BYTE },
	{ "u7", BYTE, length=3, show=0  },
	{ "tooltip_id", INT32 },
	{ "icon_id", INT32 },
	{ "icon_file_name", STRING, length=256 },
	{ "is_projectile", BYTE },
	{ "u8", BYTE, length=3, show=0 },
	{ "projectile_speed", SINGLE },
	{ "projectile_acceleration", SINGLE }
}

-- Use DISCTINT keyword to avoid duplicates left by gala
selectStatement = "SELECT DISTINCT [id],[text_id],[is_valid],[elemental],[is_passive],[is_physical_act],[is_harmful],[is_need_target],[is_corpse],[is_toggle],[toggle_group],[casting_type],[casting_level],[cast_range],[valid_range],[cost_hp],[cost_hp_per_skl],[cost_mp],[cost_mp_per_skl],[cost_mp_per_enhance],[cost_hp_per],[cost_hp_per_skl_per],[cost_mp_per],[cost_mp_per_skl_per],[cost_havoc],[cost_havoc_per_skl],[cost_energy],[cost_energy_per_skl],[cost_exp],[cost_exp_per_enhance],[cost_jp],[cost_jp_per_enhance],[cost_item],[cost_item_count],[cost_item_count_per_skl],[need_level],[need_hp],[need_mp],[need_havoc],[need_havoc_burst],[need_state_id],[need_state_level],[need_state_exhaust],[vf_one_hand_sword],[vf_two_hand_sword],[vf_double_sword],[vf_dagger],[vf_double_dagger],[vf_spear],[vf_axe],[vf_one_hand_axe],[vf_double_axe],[vf_one_hand_mace],[vf_two_hand_mace],[vf_lightbow],[vf_heavybow],[vf_crossbow],[vf_one_hand_staff],[vf_two_hand_staff],[vf_shield_only],[vf_is_not_need_weapon],[delay_cast],[delay_cast_per_skl],[delay_cast_mode_per_enhance],[delay_common],[delay_cooltime],[delay_cooltime_mode_per_enhance],[cool_time_group_id],[uf_self],[uf_party],[uf_guild],[uf_neutral],[uf_purple],[uf_enemy],[tf_avatar],[tf_summon],[tf_monster],[target],[effect_type],[state_id],[state_level_base],[state_level_per_skl],[state_level_per_enhance],[state_second],[state_second_per_level],[state_second_per_enhance],[state_type],[probability_on_hit],[probability_inc_by_slv],[hit_bonus],[hit_bonus_per_enhance],[percentage],[hate_mod],[hate_basic],[hate_per_skl],[hate_per_enhance],[critical_bonus],[critical_bonus_per_skl],[var1],[var2],[var3],[var4],[var5],[var6],[var7],[var8],[var9],[var10],[var11],[var12],[var13],[var14],[var15],[var16],[var17],[var18],[var19],[var20],[jp_01],[jp_02],[jp_03],[jp_04],[jp_05],[jp_06],[jp_07],[jp_08],[jp_09],[jp_10],[jp_11],[jp_12],[jp_13],[jp_14],[jp_15],[jp_16],[jp_17],[jp_18],[jp_19],[jp_20],[jp_21],[jp_22],[jp_23],[jp_24],[jp_25],[jp_26],[jp_27],[jp_28],[jp_29],[jp_30],[jp_31],[jp_32],[jp_33],[jp_34],[jp_35],[jp_36],[jp_37],[jp_38],[jp_39],[jp_40],[jp_41],[jp_42],[jp_43],[jp_44],[jp_45],[jp_46],[jp_47],[jp_48],[jp_49],[jp_50],[desc_id],[tooltip_id],[icon_id],[icon_file_name],[is_projectile],[projectile_speed],[projectile_acceleration] FROM dbo.SkillResource s LEFT JOIN dbo.SkillJpResource sj ON sj.skill_id = s.id"

SkillResource63 for Grimoire, otherwise its a simple conversion for glandu2 tool.

[king1king]

Null

[Masumichan]

Originally Posted by king1king

can i convert item9.7.rdb dumped from client to item 9.1 with model name instead of model number by glandue tool ? with privte view?
If possible, I want to help

Also to my knowledge you cannot do this in Glandu's tool or Grimiore ( although I could be wrong )

However I do have a 9.7 Item Dbo converted to 9.1 maybe you could add me on discord and we'll see how we go about compensation
( quick note, Some items use new effect types so might not work correctly in 9.1 )

Discord: Lyza#5923

[king1king]

null

[king1king]

dose enyone have 9.7 charactermotion.lua ?

[Masumichan]

Originally Posted by king1king

dose enyone have 9.7 charactermotion.lua ?

Have you tried using the Monstermotion 9.5.2 structure? since for me it works, If you want I could send it to you if you add me on discord
Aerichy#5923

[hassuny]

guys, I need Lua structures for 9.5.2, please upload