aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMitchesD <majklprofik@seznam.cz>2014-10-10 14:42:06 +0200
committerMitchesD <majklprofik@seznam.cz>2014-10-10 14:42:06 +0200
commitc63ad4ccfa6b0ba008f473636fc63145e38a0b56 (patch)
tree336e294bf2d232e1c29d15457001d14fb57923c7
parent67f9d916cbd920ee72b3e9036e13d0725b38566e (diff)
DB/Creature: fixed issue when Valkyrs (Argent Tournament) could kill their guards and players in combat distance.
-rw-r--r--sql/updates/world/2014_10_10_00_world.sql5
1 files changed, 5 insertions, 0 deletions
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, '');