aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2023-05-11 10:23:04 +0200
committerGitHub <noreply@github.com>2023-05-11 10:23:04 +0200
commit467b717c5cd20151c4222b077c8af7a8e5d0e83d (patch)
tree6d972dc034e5158672323ad49e6394173abe6c00 /sql
parent083c655d423c4340481bdca6d93c61853f65beee (diff)
DB/Creature: Few updates in Dire Maul north
closes #28966 by CraftedRO
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2023_05_11_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2023_05_11_00_world.sql b/sql/updates/world/3.3.5/2023_05_11_00_world.sql
new file mode 100644
index 00000000000..cab83f5d0ab
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_05_11_00_world.sql
@@ -0,0 +1,9 @@
+-- Guard Slip'kik minor movement correction
+UPDATE `creature_template` SET `speed_walk`=2 WHERE `entry`=14323;
+
+UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry` IN (14323, 14321, 14326, 14327, 14325, 11501, 14324, 11488, 11486);
+
+UPDATE `creature` SET `equipment_id`=1 WHERE `guid`=56945 AND `id`=14324;
+DELETE FROM `creature_equip_template` WHERE `CreatureID`=14324 AND `ID`=1;
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
+(14324, 1, 2176, 0, 0, 0);