diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2016_04_10_10_world.sql | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_10_10_world.sql b/sql/updates/world/2016_04_10_10_world.sql new file mode 100644 index 00000000000..8ed1aaebaff --- /dev/null +++ b/sql/updates/world/2016_04_10_10_world.sql @@ -0,0 +1,61 @@ +-- +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=48963; +UPDATE `creature_template` SET `MinLevel`=19, `MaxLevel`=19, `mechanic_immune_mask`=8388624 WHERE `entry`=47143; +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=20574; +UPDATE `creature_template` SET `faction`=1878 WHERE `entry`=21943; +UPDATE `creature_template` SET `npcflag`=3715 WHERE `entry`=12096; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=13180; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=13441; +UPDATE `creature_template` SET `npcflag`=4194307 WHERE `entry` IN (13616, 13617, 22551, 22577, 31991, 37310, 32105, 37426); +UPDATE `creature_template` SET `gossip_menu_id`=9821 WHERE `entry` IN (13616, 22551, 31991, 37310); +UPDATE `creature_template` SET `gossip_menu_id`=5283 WHERE `entry` IN (13617, 22577, 32105, 37426); +UPDATE `creature_template` SET `family`=42 WHERE `entry`=29601; +UPDATE `creature_template` SET `type`=10 WHERE `entry`=16297; +UPDATE `creature_template` SET `faction`=24 WHERE `entry`=20574; +UPDATE `creature_template` SET `family`=126 WHERE `entry`=20184; +UPDATE `creature_template` SET `type`=10 WHERE `entry`=20254; +UPDATE `creature_template` SET `type`=6 WHERE `entry`=20316; +UPDATE `creature_template` SET `faction`=1878 WHERE `entry`=21943; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=21601; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=21600; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=21599; +UPDATE `creature_template` SET `type`=4 WHERE `entry`=22632; +UPDATE `creature_template` SET `type`=4 WHERE `entry`=32055; +UPDATE `creature_template` SET `type`=4 WHERE `entry`=37376; +UPDATE `creature_template` SET `exp`=1, `type`=1 WHERE `entry`=20171; +UPDATE `creature_template` SET `npcflag`=641 WHERE `entry`=30797; +UPDATE `creature_template` SET `family`=126 WHERE `entry`=22300; +UPDATE `creature_template` SET `npcflag`=641 WHERE `entry`=30796; +UPDATE `creature_template` SET `npcflag`=2177 WHERE `entry`=30792; +UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=24857; +UPDATE `creature_template` SET `family`=53 WHERE `entry`=25388; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=25388; +UPDATE `creature_template` SET `family`=53 WHERE `entry`=25389; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=25389; +UPDATE `creature_template` SET `faction`=1892 WHERE `entry`=26099; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=30794; +UPDATE `creature_template` SET `family`=35 WHERE `entry`=30521; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=30521; +UPDATE `creature_template` SET `family`=11 WHERE `entry`=31341; +UPDATE `creature_template` SET `type`=5 WHERE `entry`=31384; +UPDATE `creature_template` SET `type`=5 WHERE `entry`=31538; +UPDATE `creature_template` SET `npcflag`=16777216 WHERE `entry`=31749; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=34332; +UPDATE `creature_template` SET `type`=9 WHERE `entry`=33995; +UPDATE `creature_template` SET `type`=4 WHERE `entry`=33789; +UPDATE `creature_template` SET `type`=4 WHERE `entry`=34152; +UPDATE `creature_template` SET `faction`=1732 WHERE `entry`=34793; +UPDATE `creature_template` SET `npcflag`=0 WHERE `entry` IN (35617, 36084, 35572, 36089, 34701); +UPDATE `creature_template` SET `type`=7 WHERE `entry`=35447; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=35448; +UPDATE `creature_template` SET `type`=7 WHERE `entry`=35449; +UPDATE `creature_template` SET `faction`=1735 WHERE `entry`=34775; +UPDATE `creature_template` SET `type`=6 WHERE `entry`=37564; +UPDATE `creature_template` SET `type`=2 WHERE `entry`=37626; +UPDATE `creature_template` SET `family`=42 WHERE `entry`=38168; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=38168; +UPDATE `creature_template` SET `family`=42 WHERE `entry`=38726; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=38726; +UPDATE `creature_template` SET `family`=42 WHERE `entry`=38736; +UPDATE `creature_template` SET `type`=1 WHERE `entry`=38736; +UPDATE `creature_template` SET `faction`=103 WHERE `entry`=40142; |