diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-11-01 11:17:04 +0000 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-11-26 16:10:20 +0100 |
| commit | cedc2644688a6338ea3510d24c35ce62212015ed (patch) | |
| tree | 5e586b0085435512e3796ee913ad17bb96037f73 | |
| parent | a2b8940aaa947e919446abef09714a7fc9cfdf54 (diff) | |
DB/Quest: Defenders of Darrowshire
1) Player no longer needs to make killing blow on ghouls for Darrowshire Spirit to spawn
2) Use correct server side spell to summon darroshire spirit
3) Add missing spirit particles and make it so the gossip is actually displayed rather than setting non selectable flags which causes gossip to immedietley close, in sniffs from 3.3.0 and 4.2.2 cant see any updates to unit flags and gossip is already in db.
Will remove core scripts later as want to try and convert the last cpp script in eastern plaguelands after these
(cherry picked from commit d308d471c1385dc06f8a63e4099c30f246af0fa8)
| -rw-r--r-- | sql/updates/world/master/2017_11_26_03_world_2016_11_01_00_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_11_26_03_world_2016_11_01_00_world.sql b/sql/updates/world/master/2017_11_26_03_world_2016_11_01_00_world.sql new file mode 100644 index 00000000000..63647bfdc2e --- /dev/null +++ b/sql/updates/world/master/2017_11_26_03_world_2016_11_01_00_world.sql @@ -0,0 +1,15 @@ +UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`IN(8530,8531,8532,11064); +-- UPDATE `spell_dbc` SET `Effect1`=28,`EffectMiscValueB1`=64 WHERE `Id`IN(17310); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(8530,8531,8532,11064); + +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 +(8530, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 11, 17310, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cannibal Ghoul - On Death - Cast Summon Darrowshire Spirit'), +(8531, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 11, 17310, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Gibbering Ghoul - On Death - Cast Summon Darrowshire Spirit'), +(8532, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 11, 17310, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Diseased Flayer - On Death - Cast Summon Darrowshire Spirit'), +(11064, 0, 0, 0, 1, 0, 100, 0, 60000, 60000, 60000, 60000, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - OOC - Despawn'), +(11064, 0, 1, 2, 11, 0, 100, 0, 0, 0, 0, 0, 11, 17321, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - On Reset - Cast Spirit Spawn-in'), +(11064, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 19, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - On Reset - Remove Unit Flag Not selectable'), +(11064, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 17327, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - On Reset - Cast Spirit Particles'), +(11064, 0, 4, 5, 64, 0, 100, 1, 0, 0, 0, 0, 33, 11064, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - On Gossip Hello - Kill Credit'), +(11064, 0, 5, 0, 61, 0, 100, 1, 0, 0, 0, 0, 41, 10000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Darrowshire Spirit - On Gossip Hello - Despawn after 10 seconds'); |