DB/Creature: Few updates to Duggan Wildhammer

closes #30334
by CraftedRO

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2025_11_27_01_world.sql b/sql/updates/world/3.3.5/2025_11_27_01_world.sql
new file mode 100644
index 00000000000..4ecf0d687aa
--- /dev/null
+++ b/sql/updates/world/3.3.5/2025_11_27_01_world.sql
@@ -0,0 +1,9 @@
+-- Duggan Wildhammer faction
+UPDATE `creature_template` SET `faction`=1055 WHERE `entry`=10817;
+
+-- Duggan Wildhammer equipment
+UPDATE `creature_equip_template` SET `ItemID1`=12951, `VerifiedBuild`=0 WHERE `CreatureID`=10817 AND `ID`=1;
+
+-- Remove again event
+DELETE FROM `smart_scripts` WHERE `entryorguid`=10817 AND `source_type`=0 AND `id` > 2;
+DELETE FROM `creature_text` WHERE `CreatureID`=10817;