DB/Misc: Fix and update Battlemasters

For 3.3.5 only

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_08_10_world_335.sql b/sql/updates/world/3.3.5/2018_10_08_10_world_335.sql
new file mode 100644
index 00000000000..7d2d86babac
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_08_10_world_335.sql
@@ -0,0 +1,17 @@
+-- 
+UPDATE `creature` SET `id`=30231 WHERE `id`=19855;
+UPDATE `creature_template` SET `npcflag`=1048577 WHERE `entry` IN (347,857,907,2302,2804, 3890,5118, 7410,7427, 10360,12197,12198,14942,14981,14982,15006,15007,15008,16694,16695,16696,18895,19855,19858,19859,19905,19906,19907,19908,19909,19910,19911,19912,19915,19923,19925,20002,20118,20119,20120,20269,20271,20272,20273,20274,20276,20362,20374,20381,20382,20383,20384,20385,20386,20388,20390,20497,20499,21235,16711,17506,17507,25991,30586,30587,30231,29533,29568,30578,30579,30580,30581,30582,30583,30584,30590,30610,32330,32332,32333,34989,34988,35002,35001,34999,35000,34986,34997,34998,34983,34985,34991,35007,35023,35024,35026,35022,35008,34955,35017,35025,34987,34976,34978,34972,34973,35020,35019,35021,34971,34895,34993,40413,35027);
+UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry` IN (347,857,907,2302,2804, 3890,5118, 7410,7427, 10360,12197,12198,14942,14981,14982,15006,15007,15008,16694,16695,16696,20118,20119,20120,20269,20271,20272,20273,20274,20276,20362,20374,20381,20382,20383,20384,20385,20386,20388,20390,16711,17506,17507,30586,30587,30578,30579,30580,30581,30582,30583,30584,30590,34989,34988,35002,35001,34999,35000,34986,34997,34998,34983,34985,34991,35007,35023,35024,35026,35022,35008,34955,35017,35025,34987,34976,34978,34972,34973,35020,35019,35021,34971,34993,40413,35027);
+
+DELETE FROM `battlemaster_entry` WHERE `entry` IN (34971,34972,34895,34976,34993);
+INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
+(34971,32),(34972,32),(34895,32),(34976,32),(34993,32);
+
+UPDATE `battlemaster_entry` SET `bg_template`=32 WHERE `entry` IN (34998, 34997, 34986, 35000, 34999, 35001, 35002, 34988, 34989, 34985, 34993, 34895, 34971, 34991, 35007, 35008, 34955, 40413, 34973, 34972, 34978, 34976, 34987, 34983);
+
+UPDATE `creature_template` SET `gossip_menu_id`=8218 WHERE `entry` IN (19859,29533,29568,30610);
+UPDATE `creature_template` SET `gossip_menu_id`=8104 WHERE `entry` IN (20385,20388,20384);
+UPDATE `creature_template` SET `gossip_menu_id`=10605 WHERE `entry` IN (34971,34976,34972,35001,35002,35008);
+UPDATE `creature_template` SET `gossip_menu_id`=9981 WHERE `entry` IN (34993);
+UPDATE `creature_template` SET `gossip_menu_id`=8105 WHERE `entry` IN (20374,20381,20362);
+UPDATE `creature_template` SET `gossip_menu_id`=10606 WHERE `entry` IN (34986,35000);