aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2023-05-09 09:25:50 +0200
committerGitHub <noreply@github.com>2023-05-09 09:25:50 +0200
commit6f310e9810f89c83fca5dc360370e538aef3e16b (patch)
tree97000394f2efc6254223b1f2dfbb9b3328411719 /sql
parent3993c45a040c01a6708850adfb014489b0e0ed8d (diff)
DB/Creature: Add missing aura to Avenging Spirit ghosts in Utgarde Pinnacle
Closes #28963 by CraftedRO
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2023_05_09_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2023_05_09_00_world.sql b/sql/updates/world/3.3.5/2023_05_09_00_world.sql
new file mode 100644
index 00000000000..1c90a3d9897
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_05_09_00_world.sql
@@ -0,0 +1,5 @@
+-- Avenging spirits Wither aura
+DELETE FROM `creature_template_addon` WHERE `entry` IN (27386, 30756);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(27386, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584"),
+(30756, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584");