From f9f72b53af271873b268d6d977bb3425d2c23970 Mon Sep 17 00:00:00 2001 From: teacher Date: Mon, 21 Jun 2010 09:34:38 +0200 Subject: Added missed sql update file for Rev 8613. Removed hackish non-TrinityCore related 8640_world_creature_template.sql. Proper fix can be found on forum (Accepted Fixes). Don't worry if you used it, it was a harmless hotfix and it will not cause any issue when using proper fix from forum. Added to world_database missed changes updates. Minor sql standards cleanup. --HG-- branch : trunk --- sql/updates/8568_world_trinity_string.sql | 1 - sql/updates/8640_world_creature_template.sql | 1 - sql/updates/8658_world_spell_linked_spell.sql | 1 - sql/updates/8671_world_spell_linked_spell.sql | 6 ++++++ 4 files changed, 6 insertions(+), 3 deletions(-) delete mode 100644 sql/updates/8640_world_creature_template.sql create mode 100644 sql/updates/8671_world_spell_linked_spell.sql (limited to 'sql/updates') diff --git a/sql/updates/8568_world_trinity_string.sql b/sql/updates/8568_world_trinity_string.sql index 029966a4968..c4fdc2f8480 100644 --- a/sql/updates/8568_world_trinity_string.sql +++ b/sql/updates/8568_world_trinity_string.sql @@ -1,4 +1,3 @@ DELETE FROM trinity_string WHERE entry IN (210); INSERT INTO trinity_string VALUES (210,'Item \'%i\' (with extended cost %i) already in vendor list.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); - diff --git a/sql/updates/8640_world_creature_template.sql b/sql/updates/8640_world_creature_template.sql deleted file mode 100644 index 2b8e2327274..00000000000 --- a/sql/updates/8640_world_creature_template.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `modelid2` = 0, `WDBVerified` = -11723 WHERE `entry` = 17591; diff --git a/sql/updates/8658_world_spell_linked_spell.sql b/sql/updates/8658_world_spell_linked_spell.sql index a05895a955d..59e96ca2ac5 100644 --- a/sql/updates/8658_world_spell_linked_spell.sql +++ b/sql/updates/8658_world_spell_linked_spell.sql @@ -1,4 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=20066; INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (20066, -61840, 0, 'Repentance'); - diff --git a/sql/updates/8671_world_spell_linked_spell.sql b/sql/updates/8671_world_spell_linked_spell.sql new file mode 100644 index 00000000000..d2572727e59 --- /dev/null +++ b/sql/updates/8671_world_spell_linked_spell.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54861,55004)AND `spell_effect` IN (-23335,-23333); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(54861,-23335,0, 'Drop Flag on Nitro Boost WSG'), +(54861,-23333,0, 'Drop Flag on Nitro Boost WSG'), +(55004,-23335,0, 'Drop Flag on Nitro Boost WSG'), +(55004,-23333,0, 'Drop Flag on Nitro Boost WSG'); -- cgit v1.2.3