DB/creature: Fix up Shadowmoon Harbinger

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/2012_06_03_05_world_creature.sql b/sql/updates/world/2012_06_03_05_world_creature.sql
new file mode 100644
index 00000000000..c5bccdbf33c
--- /dev/null
+++ b/sql/updates/world/2012_06_03_05_world_creature.sql
@@ -0,0 +1,7 @@
+-- Fix up Shadowmoon Harbinger
+SET @ENTRY := 21795;
+UPDATE `creature` SET `spawndist`=5,`MovementType`=1,`curhealth`=1,`curmana`=0 WHERE `id`=@ENTRY;
+UPDATE `creature_template` SET `AIName`='' WHERE `entry`=@ENTRY;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
+DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY;
+INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES (@ENTRY,1,'37467 37509');