diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-08-31 12:39:15 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-08-31 12:39:15 +0100 |
| commit | 9070d433c25a8df3d2495adde735c2e01b2231c7 (patch) | |
| tree | 088c418670cc780ef8cf420c740387987cd5836c /sql | |
| parent | 0be9565950568356d5904f011d35226074319680 (diff) | |
DB/Misc: Random fixes
A few random fixes,
* Manaforge Coruu Credit
* Summon time for creatures summoned at at to prevent premature despawn (occured only with tirion on 3rd set of wp)
* Script for Destroy the Forges, closes #12825
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_08_31_01_world_misc.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_31_01_world_misc.sql b/sql/updates/world/2014_08_31_01_world_misc.sql new file mode 100644 index 00000000000..cf2645d772b --- /dev/null +++ b/sql/updates/world/2014_08_31_01_world_misc.sql @@ -0,0 +1,14 @@ +UPDATE `smart_scripts` SET `id`=15 WHERE `entryorguid`=20417 AND `source_type`=0 AND `id`=13 AND `link`=0; +UPDATE `smart_scripts` SET `event_param1`=9, `event_param2`=9 WHERE `entryorguid`=20417 AND `source_type`=0 AND `id`=4 AND `link`=5; +UPDATE `smart_scripts` SET `action_param1`=9, `action_param2`=9 WHERE `entryorguid`=18395600 AND `source_type`=9 AND `id`=10 AND `link`=0; +UPDATE `creature_summon_groups` SET `summonTime`=900000 WHERE `summonerId`=35501; + +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN(30209,30211,30212); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(30209,30211,30212) AND `source_type`=0; + +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 +(30209, 0, 0, 0, 8, 0, 100, 0, 56275, 0, 0, 0, 33, 30209, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'North Lightning Forge - On Spellhit "Bouldercrags Bomb" - Give Kill Credit'), +(30211, 0, 0, 0, 8, 0, 100, 0, 56275, 0, 0, 0, 33, 30211, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Central Lightning Forge - On Spellhit "Bouldercrags Bomb" - Give Kill Credit'), +(30212, 0, 0, 0, 8, 0, 100, 0, 56275, 0, 0, 0, 33, 30212, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'South Lightning Forge - On Spellhit "Bouldercrags Bomb" - Give Kill Credit'); + +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `guid` IN(95645,96491,96864); |