aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKinzcool <kinzzcool@hotmail.com>2014-03-06 22:34:47 -0500
committerKinzcool <kinzzcool@hotmail.com>2014-03-06 22:34:47 -0500
commit3c1f635abd69eef5da5f264da34d96dc96880501 (patch)
tree462b10de2244fbf1e0f9973d9eb5161c528a9588
parentb8cfd275a65ecc811461e5a7452cb85f0ac83cd4 (diff)
Herman Walker, Grumman Slatefist and Shenarial are now officially battlemasters. Karg Skullgore & Sawemba have been reassigned to their duty of random BGs battlemasters.
-rw-r--r--sql/updates/world/2014_03_06_02_world_battlemaster_entry.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_03_06_02_world_battlemaster_entry.sql b/sql/updates/world/2014_03_06_02_world_battlemaster_entry.sql
new file mode 100644
index 00000000000..47a679c2c80
--- /dev/null
+++ b/sql/updates/world/2014_03_06_02_world_battlemaster_entry.sql
@@ -0,0 +1,6 @@
+UPDATE `creature_template` SET `npcflag`=`npcflag`|0x100000 WHERE `entry` IN (16711, 17506, 17507);
+
+DELETE FROM `battlemaster_entry` WHERE `entry` IN (34955, 35008);
+INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
+(34955, 32),
+(35008, 32);