diff options
| author | Malcrom <malcromdev@gmail.com> | 2023-12-31 22:38:43 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-01 03:38:43 +0100 |
| commit | 42c5338a6339ebdd593959fe64a938351d832c31 (patch) | |
| tree | 813ab892e52d52ac3c6e5f320693a303d28da0b8 /sql/updates | |
| parent | e2e2357b0088a3955e941e8807fab002f51eca61 (diff) | |
Scripts/DunMorogh: Implemented Rockjaw Invader spawning for Joren Ironstock (#29519)
Co-authored-by: ModoX <moardox@gmail.com>
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2024_01_01_01_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_01_01_world.sql b/sql/updates/world/master/2024_01_01_01_world.sql new file mode 100644 index 00000000000..e054e010b82 --- /dev/null +++ b/sql/updates/world/master/2024_01_01_01_world.sql @@ -0,0 +1,15 @@ +-- Delete all existing Rockjaw Invader spawns +DELETE FROM `creature` WHERE `id`=37070; +-- Add coin to Rockjaw Invader +UPDATE `creature_template_difficulty` SET `GoldMin`=1, `GoldMax`=7 WHERE `Entry`=37070; +-- Prevent Coldridge Mountaineer from entering combat with Rockjaw Invaders +UPDATE `creature_template` SET `flags_extra`=2 WHERE `entry`=853; +-- Add Script to Joren Ironstock +UPDATE `creature_template` SET `ScriptName`='npc_joren_ironstock' WHERE `entry`=37081; + +-- Add spairing to Rockjaw Invaders, Coldridge Defenders, and Joren Ironstock +DELETE FROM `creature_template_sparring` WHERE `Entry` IN (37070,37177,37081); +INSERT INTO `creature_template_sparring` (`Entry`,`NoNPCDamageBelowHealthPct`) VALUES +(37070,85), +(37177,85), +(37081,85); |