Remove / modify a bunch of SQL files that update template fields that should only be altered by database projects, or that just were blatant hacks. These "fixes" should be posted on the database project's forums.

--HG--
branch : trunk

5 files changed, 3 insertions, 12 deletions

diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql
index 7dff477ae98..e80dacc6eb3 100644
--- a/sql/FULL/world_scripts_full.sql
+++ b/sql/FULL/world_scripts_full.sql
@@ -1349,7 +1349,7 @@ UPDATE `creature_template` SET `ScriptName`='mob_ohgan' WHERE `entry`=14988;
 -- --------
 UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE entry IN (26796,26798,26929,26928,26930);
 DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (26796,26798,26929,26928,26930);
-UPDATE `creature_template` SET `ScriptName`='EventAI',`modelid1` = 16925,`modelid3` = 16925, `minmana` = 1000000,`maxmana` = 1000000, `unit_flags` = 33554434 WHERE `entry` IN(29998,33753,33752,33751,33750);
+UPDATE `creature_template` SET `ScriptName`='EventAI' WHERE `entry` IN(29998,33753,33752,33751,33750);
 DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (29998,33753,33752,33751,33750);
 INSERT INTO `creature_ai_scripts` VALUES 
 -- Commander Stoutbeard
@@ -1410,7 +1410,7 @@ INSERT INTO `creature_ai_scripts` (`creature_id`,`event_type`,`event_chance`,`ev
    (23035,6,100,6,34,2,3,'Anzu - Set Inst Data on Death');
 
 -- dk final quest
-UPDATE `creature_template` SET `unit_flags`=32768,`AIName`='EventAI' WHERE `entry` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181);
+UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181);
 DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181);
 INSERT INTO `creature_ai_scripts` VALUES
    (2919901,29199,0,0,100,3,10000,20000,10000,20000,11,52374,1,0,0,0,0,0,0,0,0,0,'Koltira Deathweaver - SPELL_BLOOD_STRIKE1'),
diff --git a/sql/updates/5866_gameobject_template.sql b/sql/updates/5866_gameobject_template.sql
deleted file mode 100644
index cc31e49aae8..00000000000
--- a/sql/updates/5866_gameobject_template.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-UPDATE `gameobject_template` SET `type`='10',`data0`='0',`ScriptName`='go_wg2voa_portal' WHERE (`entry`='190763');
-
diff --git a/sql/updates/6008_world.sql b/sql/updates/6008_world.sql
deleted file mode 100644
index 19a805660b8..00000000000
--- a/sql/updates/6008_world.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23537;
-UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23686;
-UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23758;
-UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=24034;
-UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23775;
\ No newline at end of file
diff --git a/sql/updates/6176_world_scripts.sql b/sql/updates/6176_world_scripts.sql
index 84b89fc172d..f88fbdfae72 100644
--- a/sql/updates/6176_world_scripts.sql
+++ b/sql/updates/6176_world_scripts.sql
@@ -1,4 +1,4 @@
-UPDATE `creature_template` SET `AIName` = 'AOEAI',`flags_extra` = '0',`minlevel` = '70',`maxlevel` = '70',`maxlevel` = '70',`faction_A` = '14',`faction_H` = '14' WHERE `entry` IN ('23336','23069','23259');
+UPDATE `creature_template` SET `AIName` = 'AOEAI' WHERE `entry` IN ('23336','23069','23259');
 UPDATE `creature_template` SET `spell1` = '40029' WHERE `entry` = 23069;
 UPDATE `creature_template` SET `spell1` = '40610' WHERE `entry` = 23259;
 UPDATE `creature_template` SET `spell1` = '40836' WHERE `entry` = 23336;
\ No newline at end of file
diff --git a/sql/updates/6186_world_scripts.sql b/sql/updates/6186_world_scripts.sql
deleted file mode 100644
index f8e91a7b019..00000000000
--- a/sql/updates/6186_world_scripts.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DELETE FROM `creature_template_addon` WHERE `entry` = 24895;
-UPDATE `creature_template` SET `unit_flags`='0' WHERE `entry`=24882;