DB/Creature: Fix some DB errors

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;