From bef81c9e5530aff7ae11e7d5fd433f0aa23b3138 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Wed, 3 Dec 2014 17:28:35 +0000 Subject: DB/Quest: What the Soul sees Fix script on ancient orc ancestor previous script was taking scenic route to script this quest ie running script on spellhit which killed self and then had event to spawn the darkened spirit on death (I have redudced 7 lines of sai to 3 and lost nothing in process) Also ninja fix the mammoth issue Closes #13656 Closes #13655 --- sql/updates/world/ 2014_12_03_00_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/ 2014_12_03_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/ 2014_12_03_00_world.sql b/sql/updates/world/ 2014_12_03_00_world.sql new file mode 100644 index 00000000000..c6a38c49220 --- /dev/null +++ b/sql/updates/world/ 2014_12_03_00_world.sql @@ -0,0 +1,9 @@ +DELETE FROM `smart_scripts` WHERE `entryorguid`=18688 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=1868800 AND `source_type`=9; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(18688, 0, 0, 1, 8, 0, 100, 0, 34063, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ancient Orc Ancestor - On Spellhit "Soul Mirror" - Say Line 1'), +(18688, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 36, 19480, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ancient Orc Ancestor - On Spellhit "Soul Mirror" - Change Entry to Darkened Spirit'), +(18688, 0, 2, 0, 0, 0, 100, 0, 20000, 40000, 60000, 180000, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ancient Orc Ancestor - In Combat - Say Line 0 (Phase 1) (No Repeat)'); + +UPDATE `vehicle_template_accessory` SET `minion`=0 WHERE `entry` IN(32640,32633); -- cgit v1.2.3