diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2021-12-01 02:48:45 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-23 00:12:24 +0100 |
| commit | 505bf6903a14592280e3fe2767c33c835da176b1 (patch) | |
| tree | 7f7d9fe482b8af52c78fd56e0ad7c564e8622439 | |
| parent | 1faa6722ab7e4851abb7bc6d99d4f5988ad500c5 (diff) | |
Scripts/ZG: Improve High Priestess Jeklik (#27274)
(cherry picked from commit 2779fb602f75226389c9b4caf1744c97d0591b83)
| -rw-r--r-- | sql/updates/world/master/2022_03_22_15_world_2021_12_01_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_22_15_world_2021_12_01_00_world.sql b/sql/updates/world/master/2022_03_22_15_world_2021_12_01_00_world.sql new file mode 100644 index 00000000000..b7f7e062ea1 --- /dev/null +++ b/sql/updates/world/master/2022_03_22_15_world_2021_12_01_00_world.sql @@ -0,0 +1,14 @@ +-- +UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 2.14286, `flags_extra` = `flags_extra`|512 WHERE `entry` = 14517; +UPDATE `creature_template_movement` SET `Flight` = 0 WHERE `CreatureId` = 14517; + +DELETE FROM `creature_text` WHERE `CreatureID` = 14517 AND `GroupID` IN (3,4); +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(14517,3,0,"%s emits a deafening shriek!",16,0,100,0,0,0,10370,0,"High Priestess Jeklik"), +(14517,4,0,"%s begins to cast a Great Heal!",16,0,100,0,0,0,10494,0,"High Priestess Jeklik"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 23974; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,23974,0,0,31,0,3,14758,0,0,0,0,"","Group 0: Spell 'Summon Frenzied Bloodseeker Bats' (Effect 0) targets creature 'Zul'Gurub Trigger'"); + +UPDATE `creature_template` SET `speed_walk` = 2, `speed_run` = 2.14286, `BaseAttackTime` = 1000, `ScriptName` = 'npc_frenzied_bloodseeker_bat' WHERE `entry` = 14965; |