aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2021-12-13 22:38:57 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-24 11:39:27 +0100
commit69ee7582fcb9b2cdf759fd5c29f3cc4f3d224288 (patch)
tree18c4e187e520fc57cba42e4dc5b68490d6466764 /sql/updates
parent0bb13b5dbdbe0d6af785c80b82a2c7b5e8a2ef57 (diff)
Scripts/MFF: Update Ahune's Ice Spear behavior (#27384)
(cherry picked from commit 751a8b9e17d2bd39785850295abb1d08917b0b24)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2022_03_24_05_world_2021_12_13_02_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_24_05_world_2021_12_13_02_world.sql b/sql/updates/world/master/2022_03_24_05_world_2021_12_13_02_world.sql
new file mode 100644
index 00000000000..a6bae8dfe74
--- /dev/null
+++ b/sql/updates/world/master/2022_03_24_05_world_2021_12_13_02_world.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `gameobject_template` SET `ScriptName` = 'go_ahune_ice_spear' WHERE `entry` = 188077;
+
+UPDATE `creature_template` SET `AIName` = '', `ScriptName` = 'npc_ahune_ice_spear_bunny' WHERE `entry` = 25985;
+UPDATE `creature_template` SET `unit_flags` = 33554432 WHERE `entry` IN (25985,26337);
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 25985 AND `source_type` = 0;