elitepvpers - Was habt ihr als letztes kopiert?

-- Devas First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1005

-- Devas Feather Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1006
-- Go to an Elementary Tutor --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602506,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1007

-- Asuras First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1WHERE id = 1008

-- Asuras Claw Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1009

-- Gaias First Hunt (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603001,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 106101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1010

-- Gaias Feather Collection (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 603002,
default_reward_level = 1,
default_reward_quantity = 3,
optional_reward_id1 = 107101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102101,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1011

-- Achieve Job Level 3 --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 602503,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1
WHERE id = 1012

-- A Skilled Deva --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 220101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 220102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1013

-- A Skilled Asura --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 230101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 230102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1014

-- A Skilled Gaia --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 540099,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 240101,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 240102,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1015

-- Talk to Gildas --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 10
WHERE id = 1016

-- Item Upgrade (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602504,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 602505,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 602503,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 602506,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1017

-- Herb Collecting (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 12,
optional_reward_id1 = 602505,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 602503,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 602506,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1019

-- First Class Transfer --UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602501,
default_reward_level = 1,
default_reward_quantity = 10,
optional_reward_id1 = 609077,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 609086,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1023

-- Catch Anatema --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 609077,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 609086,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1026

-- Gain 1 Lak --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690201,
default_reward_level = 1,
default_reward_quantity = 30,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30
WHERE id = 1032

-- Demonstrate Your Skill --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30,
optional_reward_id2 = 690101,
optional_reward_level2 = 1,
optional_reward_quantity2 = 30
WHERE id = 1034

-- Go to Lak Trader --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 403101,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1037

-- Screening --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 305201,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 2900500,
optional_reward_level1 = 1,
optional_reward_quantity1 = 2
WHERE id = 1040

-- Attack of the Worm Piranhas! --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602001,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 690001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 30
WHERE id = 1041

-- Wanted --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 303202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 304202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 432102,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1042

-- Learn creature summoning --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1900001,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 540014,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 540015,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 540016,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1043

-- Brighton's Calling: Dawn --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690201,
default_reward_level = 1,
default_reward_quantity = 30
WHERE id = 1236

-- Brighton's Calling: Dusk (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 690441,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 106202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 103202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 101202,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1237

-- Integra's Words: Glory --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602301,
default_reward_level = 1,
default_reward_quantity = 2,
optional_reward_id1 = 602304,
optional_reward_level1 = 1,
optional_reward_quantity1 = 2,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1239

-- Integra's Words: Revelation --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 602304,
default_reward_level = 1,
default_reward_quantity = 3
WHERE id = 1238

-- Voice of Truth --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 910049,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 910047,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 910043,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1
WHERE id = 1240

-- Earrings of the Witch --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000075,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1246

-- Entering Navislamia --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000076,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1243

-- Glorious First Steps --
UPDATE Arcadia.dbo.QuestResource
SET optional_reward_id1 = 602001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 602201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1049

-- Navislamia's Final Voyage (Missing Opts) --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 2900500,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 107202,
optional_reward_level1 = 1,
optional_reward_quantity1 = 1,
optional_reward_id2 = 104202,
optional_reward_level2 = 1,
optional_reward_quantity2 = 1,
optional_reward_id3 = 102202,
optional_reward_level3 = 1,
optional_reward_quantity3 = 1
WHERE id = 1241

-- Reporting first job transfer to Gildas --
UPDATE Arcadia.dbo.QuestResourceSET
default_reward_id = 900012,
default_reward_level = 1,
default_reward_quantity = 1,
optional_reward_id1 = 900011,
optional_reward_level1 = 1,
optional_reward_quantity1 = 3
WHERE id = 1197

-- The Zombie Crew --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 608301,
default_reward_level = 1,
default_reward_quantity = 5,
optional_reward_id1 = 608001,
optional_reward_level1 = 1,
optional_reward_quantity1 = 5,
optional_reward_id2 = 608201,
optional_reward_level2 = 1,
optional_reward_quantity2 = 5
WHERE id = 1242

-- Witch's Pendant --
UPDATE Arcadia.dbo.QuestResource
SET default_reward_id = 1000068,
default_reward_level = 1,
default_reward_quantity = 1
WHERE id = 1248

USE [Arcadia]
GO
/****** Object: Table [dbo].[ItemResource] Script Date: 11/05/2011 01:16:30 ******/
INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [endurance], [material], [summon_id], [flag_cashitem], [flag_wear], [flag_use], [flag_target_use], [flag_duplicate], [flag_drop], [flag_trade], [flag_sell], [flag_storage], [flag_overweight], [flag_riding], [flag_move], [flag_sit], [flag_enhance], [flag_quest], [flag_raid], [flag_secroute], [flag_eventmap], [flag_huntaholic], [flag_huntaholic_usable_only], [available_period], [decrease_type], [throw_range], [distribute_type], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [state_type], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [Description]) VALUES (2012064, 12012064, 22012064, 1, 8, 260, 7, 0, 0, 7, 1, 0, 0, 0, N'1', N'1', N'1', N'1', N'1', N'1', N'1', 150, 0, 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(30.00 AS Decimal(10, 2)), 125000000, 0, CAST(0.000 AS Numeric(18, 3)), 12, 0, N'1', N'1', N'0', N'0', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', 0, 0, CAST(0.00 AS Decimal(10, 2)), N'0', 15, CAST(46.00 AS Decimal(12, 2)), CAST(0.80 AS Decimal(12, 2)), 16, CAST(69.00 AS Decimal(12, 2)), CAST(1.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, 15, CAST(1.30 AS Decimal(10, 2)), CAST(1.50 AS Decimal(10, 2)), CAST(1.90 AS Decimal(10, 2)), CAST(2.40 AS Decimal(10, 2)), 16, CAST(2.00 AS Decimal(10, 2)), CAST(2.30 AS Decimal(10, 2)), CAST(2.80 AS Decimal(10, 2)), CAST(3.50 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'dem_mantle_astinwhisper', N'def_mantle_astinwhisper', N'def_mantle_astinwhisper', N'def_mantle_astinwhisper', N'asm_mantle_astinwhisper', N'asm_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'asf_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gam_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'gaf_mantle_astinwhisper', N'0', N'drop_wear_armor', 0, N'icon_mantle_astinwhisper', N'', N'R7 Cape')
INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [endurance], [material], [summon_id], [flag_cashitem], [flag_wear], [flag_use], [flag_target_use], [flag_duplicate], [flag_drop], [flag_trade], [flag_sell], [flag_storage], [flag_overweight], [flag_riding], [flag_move], [flag_sit], [flag_enhance], [flag_quest], [flag_raid], [flag_secroute], [flag_eventmap], [flag_huntaholic], [flag_huntaholic_usable_only], [available_period], [decrease_type], [throw_range], [distribute_type], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [state_type], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [Description]) VALUES (2012062, 12012062, 22012062, 1, 110, 607, 21, 0, 0, 1, 1, 0, 0, 0, N'1', N'1', N'1', N'1', N'1', N'1', N'1', 150, 0, 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(1.00 AS Decimal(10, 2)), 10, 0, CAST(0.000 AS Numeric(18, 3)), 3, 0, N'1', N'1', N'0', N'0', N'0', N'1', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'0', 0, 0, CAST(0.00 AS Decimal(10, 2)), N'0', 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 98, CAST(8255.00 AS Decimal(12, 2)), CAST(0.04 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), 0, CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_mmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'shoulder_deco_fmidasheirloom', N'0', N'drop_etc_pouch', 0, N'icon_shoulder_deco_midasheirloom', N'', N'Gilded Wings')
INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [endurance], [material], [summon_id], [flag_cashitem], [flag_wear], [flag_use], [flag_target_use], [flag_duplicate], [flag_drop], [flag_trade], [flag_sell], [flag_storage], [flag_overweight], [flag_riding], [flag_move], [flag_sit], [flag_enhance], [flag_quest], [flag_raid], [flag_secroute], [flag_eventmap], [flag_huntaholic], [flag_huntaholic_usable_only], [available_period], [decrease_type], [throw_range], [distribute_type], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [state_type], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [Description]) VALUES (2012063, 12012063, 22012063, 1, 8, 260, 7, 0, 0, 7, 1, 0, 0, 0, N'1', N'1', N'1', N'1', N'1', N'1', N'1', 150, 0, 0, 0, CAST(0.00 AS Decimal(10, 2)), CAST(30.00 AS Decimal(10, 2)), 125000000, 0, CAST(0.000 AS Numeric(18, 3)), 12, 0, N'1', N'1', N'0', N'0', N'0', N'1', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', 0, 0, CAST(0.00 AS Decimal(10, 2)), N'0', 15, CAST(46.00 AS Decimal(12, 2)), CAST(0.80 AS Decimal(12, 2)), 16, CAST(69.00 AS Decimal(12, 2)), CAST(1.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, 15, CAST(1.30 AS Decimal(10, 2)), CAST(1.50 AS Decimal(10, 2)), CAST(1.90 AS Decimal(10, 2)), CAST(2.40 AS Decimal(10, 2)), 16, CAST(2.00 AS Decimal(10, 2)), CAST(2.30 AS Decimal(10, 2)), CAST(2.80 AS Decimal(10, 2)), CAST(3.50 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'dem_mantle_jericotears', N'dem_mantle_jericotears', N'dem_mantle_jericotears', N'def_mantle_jericotears', N'def_mantle_jericotears', N'def_mantle_jericotears', N'asm_mantle_jericotears', N'asm_mantle_jericotears', N'asm_mantle_jericotears', N'asf_mantle_jericotears', N'asf_mantle_jericotears', N'asf_mantle_jericotears', N'gam_mantle_jericotears', N'gam_mantle_jericotears', N'gam_mantle_jericotears', N'gaf_mantle_jericotears', N'gaf_mantle_jericotears', N'gaf_mantle_jericotears', N'0', N'drop_wear_armor', 0, N'icon_mantle_jericotears', N'', N'R7 Cape 2')