diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-01-11 13:55:29 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2015-01-11 13:55:29 +0000 |
| commit | 97d415d1b2a429557f667f9c30e8577ab89e6434 (patch) | |
| tree | 2e598bcfa601da5683f288312dc6b986425bb198 | |
| parent | fb1b7f66a5d959e4b080a8b25cd697c9764a098f (diff) | |
DB/Misc: Additions to https://github.com/TrinityCore/TrinityCore/commit/fb1b7f66a5d959e4b080a8b25cd697c9764a098f
* Prevent event from restarting if theres already an instance of either the Lich King, any of the 2 versions of vegard or the first 2 light's vengence objects already spawned
* Prevent further ghouls from being summoned by same npc if there is already ghoul summoned by that npc
| -rw-r--r-- | sql/updates/world/2015_01_11_01_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2015_01_11_01_world.sql b/sql/updates/world/2015_01_11_01_world.sql new file mode 100644 index 00000000000..dca46b515bc --- /dev/null +++ b/sql/updates/world/2015_01_11_01_world.sql @@ -0,0 +1,11 @@ +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=37826; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN(37832,37878); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 37832, 0, 0, 29, 1, 37857, 100, 0, 1, 0, 0, '', 'Lich King Stun Bunny only Trigger if there is no spawn of the Lich King within 100 Yards'), +(22, 1, 37832, 0, 0, 29, 1, 37893, 100, 0, 1, 0, 0, '', 'Lich King Stun Bunny only Trigger if there is no spawn of Vegard within 100 Yards'), +(22, 1, 37832, 0, 0, 29, 1, 37976, 100, 0, 1, 0, 0, '', 'Lich King Stun Bunny only Trigger if there is no spawn of Vegard within 100 Yards'), +(22, 1, 37832, 0, 0, 30, 1, 201922, 100, 0, 1, 0, 0, '', 'Lich King Stun Bunny only Trigger if there is no spawn of Lights Vengence within 100 Yards'), +(22, 1, 37832, 0, 0, 30, 1, 201844, 100, 0, 1, 0, 0, '', 'Lich King Stun Bunny only Trigger if there is no spawn of Lights Vengence within 100 Yards'), +(22, 1, 37878, 0, 0, 29, 1, 37881, 2, 0, 1, 0, 0, '', 'AOD Impact Bunny only Trigger if there is no spawn of Wrethed Ghoul within 2 yards'), +(22, 2, 37878, 0, 0, 29, 1, 37881, 2, 0, 1, 0, 0, '', 'AOD Impact Bunny only Trigger if there is no spawn of Wrethed Ghoul within 2 yards'); |