diff options
| author | teacher <none@none> | 2010-06-21 09:34:38 +0200 |
|---|---|---|
| committer | teacher <none@none> | 2010-06-21 09:34:38 +0200 |
| commit | f9f72b53af271873b268d6d977bb3425d2c23970 (patch) | |
| tree | 494d7103d67b226054213388c1df10dce108debb /sql/updates | |
| parent | f12131020dd38ed64e9aa5ca8998e6a4bb6ac34c (diff) | |
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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/8568_world_trinity_string.sql | 1 | ||||
| -rw-r--r-- | sql/updates/8640_world_creature_template.sql | 1 | ||||
| -rw-r--r-- | sql/updates/8658_world_spell_linked_spell.sql | 1 | ||||
| -rw-r--r-- | sql/updates/8671_world_spell_linked_spell.sql | 6 |
4 files changed, 6 insertions, 3 deletions
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'); |