From 1b8135d07d4dfbf0f24fcb4b7026a0c9a17a983d Mon Sep 17 00:00:00 2001 From: nelegalno Date: Sat, 11 Feb 2012 17:44:27 +0000 Subject: DB/NPCs: Spawn Elders also on heroic difficulty (spawnmask change) Closes #4976 --- sql/updates/world/2012_02_11_01_world_creature.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/2012_02_11_01_world_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2012_02_11_01_world_creature.sql b/sql/updates/world/2012_02_11_01_world_creature.sql new file mode 100644 index 00000000000..898e746d306 --- /dev/null +++ b/sql/updates/world/2012_02_11_01_world_creature.sql @@ -0,0 +1,14 @@ +-- Spawn Elder Ohanzee in Normal and Heroic modes of Gundrak and relocate near Drakkari Colossus (45.7,62) boss (v3.3.2 change). Coordinates are guessed based on https://www.youtube.com/watch?v=FRXgZthksN8 ( ~12min ) +UPDATE `creature` SET `spawnMask`=3,`position_x`=1697.94,`position_y`=752.121,`position_z`=142.765,`orientation`=3.78933 WHERE `guid`=200841; +-- Spawn Elder Kilias in Normal and Heroic modes of Drak'Tharon Keep +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200842; +-- Spawn Elder Nurgen in Normal and Heroic modes of Azjol-Nerub +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200843; +-- Spawn Elder Yurauk in Normal and Heroic modes of Halls of Stone +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200844; +-- Spawn Elder Jarten in Normal and Heroic modes of Utgarde Keep +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200845; +-- Spawn Elder Chogan'gada in Normal and Heroic modes of Utgarde Pinnacle +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200846; +-- Spawn Elder Igasho in Normal and Heroic modes of The Nexus +UPDATE `creature` SET `spawnMask`=3 WHERE `guid`=200847; -- cgit v1.2.3