diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_10_08_10_world_335.sql | 17 |
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); |