From c63ad4ccfa6b0ba008f473636fc63145e38a0b56 Mon Sep 17 00:00:00 2001
From: MitchesD <majklprofik@seznam.cz>
Date: Fri, 10 Oct 2014 14:42:06 +0200
Subject: DB/Creature: fixed issue when Valkyrs (Argent Tournament) could kill
 their guards and players in combat distance.

---
 sql/updates/world/2014_10_10_00_world.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 sql/updates/world/2014_10_10_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_10_10_00_world.sql b/sql/updates/world/2014_10_10_00_world.sql
new file mode 100644
index 00000000000..3ac4e678fec
--- /dev/null
+++ b/sql/updates/world/2014_10_10_00_world.sql
@@ -0,0 +1,5 @@
+UPDATE `creature_template` SET `unit_flags`=320, `flags_extra`=2 WHERE `entry` IN(36065,36066); 
+DELETE FROM `creature_template_addon` WHERE `entry` IN(36066, 36065);
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
+(36066, 0, 0x2000000, 0x1, ''),
+(36065, 0, 0x2000000, 0x1, '');
-- 
cgit v1.2.3