Code:
-- 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 = 10WHERE 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
