From abbdd3f17e510586bfebc79cc48dbebd7cc207ad Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Wed, 4 Nov 2009 13:04:00 +0100 Subject: 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 --- sql/updates/5866_gameobject_template.sql | 2 -- sql/updates/6008_world.sql | 5 ----- sql/updates/6176_world_scripts.sql | 2 +- sql/updates/6186_world_scripts.sql | 2 -- 4 files changed, 1 insertion(+), 10 deletions(-) delete mode 100644 sql/updates/5866_gameobject_template.sql delete mode 100644 sql/updates/6008_world.sql delete mode 100644 sql/updates/6186_world_scripts.sql (limited to 'sql/updates') 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; -- cgit v1.2.3