diff options
| -rw-r--r-- | sql/updates/world/2012_02_11_01_world_creature.sql | 14 |
1 files changed, 14 insertions, 0 deletions
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; |