From a3657794e8e92282f7362f613c6876f6c9b9f851 Mon Sep 17 00:00:00 2001 From: teacher Date: Wed, 13 Jan 2010 09:46:19 +0100 Subject: world.sql finally updated to current rev. Finished renaming single sql update files. --HG-- branch : trunk --- sql/updates/6922_world_scriptname.sql | 1 + sql/updates/6922_world_scriptnames.sql | 1 - sql/updates/6941_world_spell_linked_spell.sql | 2 +- sql/updates/6945_world_scriptnames.sql | 1 - sql/updates/6947_world_scriptname.sql | 1 + sql/updates/6953_world_trinity_string.sql | 1 - sql/updates/6960_characters_character_aura.sql | 2 ++ sql/updates/6960_characters_pet_aura.sql | 2 ++ sql/updates/6962_characters_character_aura.sql | 2 -- sql/updates/6962_characters_pet_aura.sql | 2 -- 10 files changed, 7 insertions(+), 8 deletions(-) create mode 100644 sql/updates/6922_world_scriptname.sql delete mode 100644 sql/updates/6922_world_scriptnames.sql delete mode 100644 sql/updates/6945_world_scriptnames.sql create mode 100644 sql/updates/6947_world_scriptname.sql create mode 100644 sql/updates/6960_characters_character_aura.sql create mode 100644 sql/updates/6960_characters_pet_aura.sql delete mode 100644 sql/updates/6962_characters_character_aura.sql delete mode 100644 sql/updates/6962_characters_pet_aura.sql diff --git a/sql/updates/6922_world_scriptname.sql b/sql/updates/6922_world_scriptname.sql new file mode 100644 index 00000000000..54b9e8f735a --- /dev/null +++ b/sql/updates/6922_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='boss_mr_smite' WHERE `entry`=646; diff --git a/sql/updates/6922_world_scriptnames.sql b/sql/updates/6922_world_scriptnames.sql deleted file mode 100644 index 54b9e8f735a..00000000000 --- a/sql/updates/6922_world_scriptnames.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_mr_smite' WHERE `entry`=646; diff --git a/sql/updates/6941_world_spell_linked_spell.sql b/sql/updates/6941_world_spell_linked_spell.sql index d7e583b70b3..10c7144911a 100644 --- a/sql/updates/6941_world_spell_linked_spell.sql +++ b/sql/updates/6941_world_spell_linked_spell.sql @@ -1,3 +1,3 @@ DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 19263 AND `spell_effect` = 67801; INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES -( 19263, 67801, 2, 'Deterrence'); \ No newline at end of file +( 19263, 67801, 2, 'Deterrence'); diff --git a/sql/updates/6945_world_scriptnames.sql b/sql/updates/6945_world_scriptnames.sql deleted file mode 100644 index 1de4fa2218e..00000000000 --- a/sql/updates/6945_world_scriptnames.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_fezzix_geartwist' WHERE `entry`=25849; diff --git a/sql/updates/6947_world_scriptname.sql b/sql/updates/6947_world_scriptname.sql new file mode 100644 index 00000000000..1de4fa2218e --- /dev/null +++ b/sql/updates/6947_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_fezzix_geartwist' WHERE `entry`=25849; diff --git a/sql/updates/6953_world_trinity_string.sql b/sql/updates/6953_world_trinity_string.sql index aa6dede9ec5..c2e6f5f21df 100644 --- a/sql/updates/6953_world_trinity_string.sql +++ b/sql/updates/6953_world_trinity_string.sql @@ -1,3 +1,2 @@ DELETE FROM `trinity_string` WHERE `entry`=5021; INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES (5021, 'Armor: %u'); - diff --git a/sql/updates/6960_characters_character_aura.sql b/sql/updates/6960_characters_character_aura.sql new file mode 100644 index 00000000000..3122a6bf8c5 --- /dev/null +++ b/sql/updates/6960_characters_character_aura.sql @@ -0,0 +1,2 @@ +DELETE FROM `character_aura` WHERE `spell` IN (61248, 58105, 61251); + \ No newline at end of file diff --git a/sql/updates/6960_characters_pet_aura.sql b/sql/updates/6960_characters_pet_aura.sql new file mode 100644 index 00000000000..84884134c37 --- /dev/null +++ b/sql/updates/6960_characters_pet_aura.sql @@ -0,0 +1,2 @@ +DELETE FROM `pet_aura` WHERE `spell` IN (61248, 58105, 61251); + \ No newline at end of file diff --git a/sql/updates/6962_characters_character_aura.sql b/sql/updates/6962_characters_character_aura.sql deleted file mode 100644 index 3122a6bf8c5..00000000000 --- a/sql/updates/6962_characters_character_aura.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `character_aura` WHERE `spell` IN (61248, 58105, 61251); - \ No newline at end of file diff --git a/sql/updates/6962_characters_pet_aura.sql b/sql/updates/6962_characters_pet_aura.sql deleted file mode 100644 index 84884134c37..00000000000 --- a/sql/updates/6962_characters_pet_aura.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `pet_aura` WHERE `spell` IN (61248, 58105, 61251); - \ No newline at end of file -- cgit v1.2.3