Was habt ihr als letztes kopiert?

11/05/2011 02:20 .vistalu#7171
11/05/2011 08:53 Obilee#7172
[Only registered and activated users can see links. Click Here To Register...]
11/05/2011 08:56 Clype.'#7173
[Only registered and activated users can see links. Click Here To Register...]
11/05/2011 09:22 AlphaZerο#7174
11/05/2011 11:16 Yunchen#7175
11/05/2011 14:44 ATx4EVA#7176
11/05/2011 17:02 Yunchen#7177
11/05/2011 17:52 DOODLE ™#7178
11/05/2011 19:46 Niceguyy#7179
[Only registered and activated users can see links. Click Here To Register...]
11/05/2011 19:48 FiireLove#7180
eine 4GB GDDR5 AMD Radeon HD 6990
11/05/2011 20:26 ImbaMagican#7181
-- 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
11/05/2011 21:19 Wingardium#7182
11/05/2011 21:28 Yunchen#7183
11/05/2011 22:04 Chazen#7184
[Only registered and activated users can see links. Click Here To Register...]

puh, zum glück habe ich den thread später entdeckt sonst gäbts nackte haut zu sehn
[Only registered and activated users can see links. Click Here To Register...]
11/05/2011 23:05 Yunchen#7185