diff options
| author | Killyana <morphone1@gmail.com> | 2015-08-29 21:39:42 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-10-20 15:34:20 +0200 |
| commit | 5b4feb7ffdbf27ad697948d47e990389ee166b58 (patch) | |
| tree | 64a3cc91e6f187a602b9dff385e568f205d77d65 | |
| parent | d03ff1433f76008c1add502737b15afac4a168b3 (diff) | |
DB/Misc: Fix Rookery Whelp unit flag
Fix Crazed Mana Surge casting Loose Mana on death
Fix PrevQuest for Replenishing the Healing Crystals
Add some missing spawns to Ghostlands
Fix some issues on Utgarde Pinnacle
Disable health regen for Guard Roberts
Closes #15276
Closes #15286
Closes #15343
Closes #15348
Update #15362
Closes #15355
Thanks to @Pirricli @KiHeij @jududdar @pete318 @Tauriella @MrSmite
(cherry picked from commit aacd388e30500ff80566c912beaf63ba43639406)
| -rw-r--r-- | sql/updates/world/2015_10_20_00_world_2015_08_29_03.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/2015_10_20_00_world_2015_08_29_03.sql b/sql/updates/world/2015_10_20_00_world_2015_08_29_03.sql new file mode 100644 index 00000000000..e280faea4d1 --- /dev/null +++ b/sql/updates/world/2015_10_20_00_world_2015_08_29_03.sql @@ -0,0 +1,20 @@ +-- +DELETE FROM `creature` WHERE `guid`=126052; +DELETE FROM `creature_addon` WHERE `guid`=126052; +DELETE FROM `linked_respawn` WHERE `guid`=126052 AND `linkedGuid`=126103; +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (26668, 30810); +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid`=-126160 AND `id`=0; + +UPDATE `creature_template` SET `RegenHealth`=0 WHERE `entry`=12423; + +-- Set all of these creatures to roam 5 yards, and random movement type +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE id IN (16349,16352); + +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `id`=9369; + +UPDATE `creature_template` SET `unit_flags`=537166656, `unit_flags2`=2048 WHERE `entry` IN (26737); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26737) AND `source_type`=0 AND `id`=6; +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 +(26737,0,6,0,6,0,100,0,0,0,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crazed Mana-Surge - On Just Died - Remove unit flag immune to pc"); + +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=10161; |