Vault of Archavon

public sql v1 · immutable
#1528135
·published 2009-08-13 15:32 UTC
-- Link correct heroic entry to Emalon the Storm WatcherUPDATE `creature_template` SET `heroic_entry` = '33994' WHERE `entry` = '33993';-- Make bosses in Vault of Archavon in Normal and Heroic bind players to instanceUPDATE `creature_template` set `flags_extra` = `flags_extra`|1 WHERE `entry` IN (31125, 31722, 33993, 33994); -- Loot from Archavon the Stone Watcher HeroicDELETE FROM `creature_loot_template` WHERE (`entry`=31722);INSERT INTO `creature_loot_template` VALUES (31722,42004,0,1,1,1,0,0,0),(31722,41204,0,1,1,1,0,0,0),(31722,41766,0,1,1,1,0,0,0),(31722,40496,0,1,1,1,0,0,0),(31722,40503,0,1,1,1,0,0,0),(31722,40504,0,1,1,1,0,0,0),(31722,41086,0,1,1,1,0,0,0),(31722,40784,0,1,1,1,0,0,0),(31722,40786,0,1,1,1,0,0,0),(31722,40845,0,1,1,1,0,0,0),(31722,40806,0,1,1,1,0,0,0),(31722,40804,0,1,1,1,0,0,0),(31722,40417,0,1,1,1,0,0,0),(31722,41142,0,2,1,1,0,0,0),(31722,40506,0,2,1,1,0,0,0),(31722,41997,0,2,1,1,0,0,0),(31722,40415,0,2,1,1,0,0,0),(31722,40423,0,2,1,1,0,0,0),(31722,40422,0,2,1,1,0,0,0),(31722,40844,0,2,1,1,0,0,0),(31722,42016,0,2,1,1,0,0,0),(31722,41970,0,2,1,1,0,0,0),(31722,40500,0,2,1,1,0,0,0),(31722,41951,0,2,1,1,0,0,0),(31722,40495,0,2,1,1,0,0,0),(31722,41654,0,2,1,1,0,0,0),(31722,41649,0,2,1,1,0,0,0),(31722,40846,0,3,1,1,0,0,0),(31722,40575,0,3,1,1,0,0,0),(31722,40570,0,3,1,1,0,0,0),(31722,40785,0,3,1,1,0,0,0),(31722,40567,0,3,1,1,0,0,0),(31722,40805,0,3,1,1,0,0,0),(31722,40563,0,3,1,1,0,0,0),(31722,40905,0,3,1,1,0,0,0),(31722,40926,0,3,1,1,0,0,0),(31722,40938,0,3,1,1,0,0,0),(31722,41286,0,3,1,1,0,0,0),(31722,41858,0,3,1,1,0,0,0),(31722,41863,0,3,1,1,0,0,0),(31722,41873,0,3,1,1,0,0,0),(31722,41939,0,3,1,1,0,0,0),(31722,41958,0,3,1,1,0,0,0),(31722,40559,0,3,1,1,0,0,0),(31722,40556,0,3,1,1,0,0,0),(31722,40468,0,3,1,1,0,0,0),(31722,40458,0,3,1,1,0,0,0),(31722,40525,0,3,1,1,0,0,0),(31722,40527,0,3,1,1,0,0,0),(31722,40529,0,3,1,1,0,0,0),(31722,40544,0,3,1,1,0,0,0),(31722,40457,0,3,1,1,0,0,0),(31722,40449,0,3,1,1,0,0,0),(31722,40418,0,3,1,1,0,0,0),(31722,40552,0,3,1,1,0,0,0),(31722,40550,0,3,1,1,0,0,0),(31722,40445,0,3,1,1,0,0,0),(31722,40448,0,3,1,1,0,0,0),(31722,40547,0,3,1,1,0,0,0),(31722,40545,0,3,1,1,0,0,0),(31722,41660,0,4,1,1,0,0,0),(31722,40469,0,4,1,1,0,0,0),(31722,41315,0,4,1,1,0,0,0),(31722,41309,0,4,1,1,0,0,0),(31722,41303,0,4,1,1,0,0,0),(31722,41297,0,4,1,1,0,0,0),(31722,40471,0,4,1,1,0,0,0),(31722,41292,0,4,1,1,0,0,0),(31722,40463,0,4,1,1,0,0,0),(31722,41666,0,4,1,1,0,0,0),(31722,40454,0,4,1,1,0,0,0),(31722,41926,0,4,1,1,0,0,0),(31722,41920,0,4,1,1,0,0,0),(31722,40460,0,4,1,1,0,0,0),(31722,40462,0,4,1,1,0,0,0),(31722,40466,0,4,1,1,0,0,0),(31722,41772,0,4,1,1,0,0,0),(31722,40472,0,4,1,1,0,0,0),(31722,41198,0,4,1,1,0,0,0),(31722,40493,0,4,1,1,0,0,0),(31722,40515,0,4,1,1,0,0,0),(31722,40517,0,4,1,1,0,0,0),(31722,40520,0,4,1,1,0,0,0),(31722,40522,0,4,1,1,0,0,0),(31722,40523,0,4,1,1,0,0,0),(31722,40583,0,4,1,1,0,0,0),(31722,40580,0,4,1,1,0,0,0),(31722,40579,0,4,1,1,0,0,0),(31722,40574,0,4,1,1,0,0,0),(31722,40572,0,4,1,1,0,0,0),(31722,40577,0,4,1,1,0,0,0),(31722,40514,0,4,1,1,0,0,0),(31722,40512,0,4,1,1,0,0,0),(31722,41136,0,4,1,1,0,0,0),(31722,40508,0,4,1,1,0,0,0),(31722,41080,0,4,1,1,0,0,0),(31722,41032,0,4,1,1,0,0,0),(31722,41026,0,4,1,1,0,0,0),(31722,41006,0,4,1,1,0,0,0),(31722,41000,0,4,1,1,0,0,0),(31722,40991,0,4,1,1,0,0,0),(31722,40990,0,4,1,1,0,0,0),(31722,40509,0,4,1,1,0,0,0),(31722,40569,0,4,1,1,0,0,0),(31722,40753,100,0,2,2,0,0,0);-- Loot Archavon the Stone Watcher NormalDELETE FROM `creature_loot_template` WHERE (`entry`=31125);INSERT INTO `creature_loot_template` VALUES (31125, 39492, 0, 2, 1, 1, 0, 0, 0),(31125, 39493, 0, 2, 1, 1, 0, 0, 0),(31125, 39495, 0, 2, 1, 1, 0, 0, 0),(31125, 39497, 0, 2, 1, 1, 0, 0, 0),(31125, 39498, 0, 2, 1, 1, 0, 0, 0),(31125, 39500, 0, 2, 1, 1, 0, 0, 0),(31125, 39515, 0, 2, 1, 1, 0, 0, 0),(31125, 39517, 0, 2, 1, 1, 0, 0, 0),(31125, 39519, 0, 2, 1, 1, 0, 0, 0),(31125, 39523, 0, 2, 1, 1, 0, 0, 0),(31125, 39528, 0, 2, 1, 1, 0, 0, 0),(31125, 39530, 0, 2, 1, 1, 0, 0, 0),(31125, 39539, 0, 2, 1, 1, 0, 0, 0),(31125, 39544, 0, 2, 1, 1, 0, 0, 0),(31125, 39546, 0, 2, 1, 1, 0, 0, 0),(31125, 39554, 0, 2, 1, 1, 0, 0, 0),(31125, 39555, 0, 2, 1, 1, 0, 0, 0),(31125, 39558, 0, 2, 1, 1, 0, 0, 0),(31125, 39560, 0, 2, 1, 1, 0, 0, 0),(31125, 39564, 0, 2, 1, 1, 0, 0, 0),(31125, 39579, 0, 2, 1, 1, 0, 0, 0),(31125, 39580, 0, 2, 1, 1, 0, 0, 0),(31125, 39582, 0, 2, 1, 1, 0, 0, 0),(31125, 39589, 0, 2, 1, 1, 0, 0, 0),(31125, 39591, 0, 2, 1, 1, 0, 0, 0),(31125, 39593, 0, 2, 1, 1, 0, 0, 0),(31125, 39603, 0, 2, 1, 1, 0, 0, 0),(31125, 39606, 0, 2, 1, 1, 0, 0, 0),(31125, 39607, 0, 2, 1, 1, 0, 0, 0),(31125, 39609, 0, 2, 1, 1, 0, 0, 0),(31125, 39611, 0, 2, 1, 1, 0, 0, 0),(31125, 39612, 0, 2, 1, 1, 0, 0, 0),(31125, 39617, 0, 2, 1, 1, 0, 0, 0),(31125, 39620, 0, 2, 1, 1, 0, 0, 0),(31125, 39622, 0, 2, 1, 1, 0, 0, 0),(31125, 39623, 0, 2, 1, 1, 0, 0, 0),(31125, 39624, 0, 2, 1, 1, 0, 0, 0),(31125, 39626, 0, 2, 1, 1, 0, 0, 0),(31125, 39630, 0, 2, 1, 1, 0, 0, 0),(31125, 39636, 0, 2, 1, 1, 0, 0, 0),(31125, 39638, 0, 2, 1, 1, 0, 0, 0),(31125, 39639, 0, 2, 1, 1, 0, 0, 0),(31125, 40752, 100, 0, 2, 2, 0, 0, 0),(31125, 40781, 0, 1, 1, 1, 0, 0, 0),(31125, 40782, 0, 1, 1, 1, 0, 0, 0),(31125, 40783, 0, 1, 1, 1, 0, 0, 0),(31125, 40801, 0, 1, 1, 1, 0, 0, 0),(31125, 40802, 0, 1, 1, 1, 0, 0, 0),(31125, 40803, 0, 1, 1, 1, 0, 0, 0),(31125, 40840, 0, 1, 1, 1, 0, 0, 0),(31125, 40841, 0, 1, 1, 1, 0, 0, 0),(31125, 40842, 0, 1, 1, 1, 0, 0, 0),(31125, 40904, 0, 1, 1, 1, 0, 0, 0),(31125, 40925, 0, 1, 1, 1, 0, 0, 0),(31125, 40937, 0, 1, 1, 1, 0, 0, 0),(31125, 40988, 0, 1, 1, 1, 0, 0, 0),(31125, 40989, 0, 1, 1, 1, 0, 0, 0),(31125, 41005, 0, 1, 1, 1, 0, 0, 0),(31125, 41031, 0, 1, 1, 1, 0, 0, 0),(31125, 41079, 0, 1, 1, 1, 0, 0, 0),(31125, 41085, 0, 1, 1, 1, 0, 0, 0),(31125, 41135, 0, 1, 1, 1, 0, 0, 0),(31125, 41141, 0, 1, 1, 1, 0, 0, 0),(31125, 41203, 0, 1, 1, 1, 0, 0, 0),(31125, 41284, 0, 1, 1, 1, 0, 0, 0),(31125, 41308, 0, 1, 1, 1, 0, 0, 0),(31125, 41314, 0, 1, 1, 1, 0, 0, 0),(31125, 41648, 0, 1, 1, 1, 0, 0, 0),(31125, 41653, 0, 1, 1, 1, 0, 0, 0),(31125, 41659, 0, 1, 1, 1, 0, 0, 0),(31125, 41665, 0, 1, 1, 1, 0, 0, 0),(31125, 41765, 0, 1, 1, 1, 0, 0, 0),(31125, 41771, 0, 1, 1, 1, 0, 0, 0),(31125, 41857, 0, 1, 1, 1, 0, 0, 0),(31125, 41862, 0, 1, 1, 1, 0, 0, 0),(31125, 41872, 0, 1, 1, 1, 0, 0, 0),(31125, 41919, 0, 1, 1, 1, 0, 0, 0),(31125, 41925, 0, 1, 1, 1, 0, 0, 0),(31125, 41938, 0, 1, 1, 1, 0, 0, 0),(31125, 41950, 0, 1, 1, 1, 0, 0, 0),(31125, 41957, 0, 1, 1, 1, 0, 0, 0),(31125, 41969, 0, 1, 1, 1, 0, 0, 0),(31125, 42001, 0, 2, 1, 1, 0, 0, 0),(31125, 42003, 0, 2, 1, 1, 0, 0, 0),(31125, 42015, 0, 2, 1, 1, 0, 0, 0);