diff options
| author | Kandera <KanderaDev@gmail.com> | 2012-06-13 10:34:29 -0400 |
|---|---|---|
| committer | Kandera <KanderaDev@gmail.com> | 2012-06-13 10:34:29 -0400 |
| commit | 39a46e6ef16ea1f53feea9b0eb18247cf3ec3d6b (patch) | |
| tree | 67277e7cd5011a1c8c9aa9b2851acd7b8fcd9f76 | |
| parent | ca85c03afdc6cff71a5991b1a091e4eb0262e9f7 (diff) | |
DB/Spawns: correct spawn for Lok'lira the Crone. add the quest invisibility 2 aura to her creature_template_addon. give the player the see quest invisibility 2 aura once Change of Scenery has been accepted. Closes #1292
| -rw-r--r-- | sql/updates/world/2012_06_13_01_world_creature.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_06_13_01_world_creature.sql b/sql/updates/world/2012_06_13_01_world_creature.sql new file mode 100644 index 00000000000..5ba3e0d34a2 --- /dev/null +++ b/sql/updates/world/2012_06_13_01_world_creature.sql @@ -0,0 +1,11 @@ +DELETE FROM `creature_template_addon` WHERE `entry` = 29975; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(29975, 0, 0x10000, 0x1, 54503); -- Lok'lira the Crone - Quest Invisibility 2 + +DELETE FROM `creature` WHERE `id` = 29975 OR `guid` = 2593; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(2593, 29975, 571, 1, 1, 6922.175, -1534.575, 836.1568, 4.276057, 120, 0, 0); -- Lok'lira the Crone (Area: Brunnhildar Village) + +DELETE FROM `spell_area` WHERE `spell` = 54504; +INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_start_active`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) VALUES +(54504,4422,12921,1,0,0,0,2,1); -- cast see quest invisibility 2 after accepting the quest from lok'lira. |