From 449d7c196a7bfdedbc94edbbfd3ace3a53d9fffe Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Wed, 10 Sep 2014 22:37:33 +0200 Subject: SQL: Fix wrong sql count order --- sql/updates/world/2014_09_10_00_world_misc.sql | 10 ---------- sql/updates/world/2014_09_10_01_world_locales_quest_335.sql | 7 ------- sql/updates/world/2014_09_10_01_world_misc.sql | 10 ++++++++++ sql/updates/world/2014_09_10_02_world_locales_quest_335.sql | 7 +++++++ 4 files changed, 17 insertions(+), 17 deletions(-) delete mode 100644 sql/updates/world/2014_09_10_00_world_misc.sql delete mode 100644 sql/updates/world/2014_09_10_01_world_locales_quest_335.sql create mode 100644 sql/updates/world/2014_09_10_01_world_misc.sql create mode 100644 sql/updates/world/2014_09_10_02_world_locales_quest_335.sql (limited to 'sql') diff --git a/sql/updates/world/2014_09_10_00_world_misc.sql b/sql/updates/world/2014_09_10_00_world_misc.sql deleted file mode 100644 index 0aaec188e09..00000000000 --- a/sql/updates/world/2014_09_10_00_world_misc.sql +++ /dev/null @@ -1,10 +0,0 @@ -UPDATE `creature_template` SET `AIName`='' WHERE `entry`=18490; -DELETE FROM `smart_scripts` WHERE `entryorguid`=18490 AND `source_type`=0; -UPDATE `creature_template` SET `unit_flags`=536871680, `unit_flags2`=2049, `dynamicflags`=0 WHERE `entry`=18490; -UPDATE `creature_template_addon` SET `auras`='29266 32423' WHERE `entry`=18490; - -DELETE FROM `spell_area` WHERE `spell`=32407; -INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES -(32407, 3674, 0, 0, 0, 0, 2, 1, 64, 11); - -UPDATE `smart_scripts` SET `action_param3`=1927115 WHERE `entryorguid`=19271 AND `source_type`=0 AND `id`=13; diff --git a/sql/updates/world/2014_09_10_01_world_locales_quest_335.sql b/sql/updates/world/2014_09_10_01_world_locales_quest_335.sql deleted file mode 100644 index bf532ef130a..00000000000 --- a/sql/updates/world/2014_09_10_01_world_locales_quest_335.sql +++ /dev/null @@ -1,7 +0,0 @@ -UPDATE `locales_quest` SET `Title_loc2` = REPLACE(`Title_loc2`, "[PÉRIMÉ 4.x]", ""); -UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED in 4.x] ", ""); -UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED 4.x] ", ""); -UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED in 4.x] ", ""); -UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED 4.x] ", ""); -UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED in 4.x] ", ""); -UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED 4.x] ", ""); diff --git a/sql/updates/world/2014_09_10_01_world_misc.sql b/sql/updates/world/2014_09_10_01_world_misc.sql new file mode 100644 index 00000000000..0aaec188e09 --- /dev/null +++ b/sql/updates/world/2014_09_10_01_world_misc.sql @@ -0,0 +1,10 @@ +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=18490; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18490 AND `source_type`=0; +UPDATE `creature_template` SET `unit_flags`=536871680, `unit_flags2`=2049, `dynamicflags`=0 WHERE `entry`=18490; +UPDATE `creature_template_addon` SET `auras`='29266 32423' WHERE `entry`=18490; + +DELETE FROM `spell_area` WHERE `spell`=32407; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(32407, 3674, 0, 0, 0, 0, 2, 1, 64, 11); + +UPDATE `smart_scripts` SET `action_param3`=1927115 WHERE `entryorguid`=19271 AND `source_type`=0 AND `id`=13; diff --git a/sql/updates/world/2014_09_10_02_world_locales_quest_335.sql b/sql/updates/world/2014_09_10_02_world_locales_quest_335.sql new file mode 100644 index 00000000000..bf532ef130a --- /dev/null +++ b/sql/updates/world/2014_09_10_02_world_locales_quest_335.sql @@ -0,0 +1,7 @@ +UPDATE `locales_quest` SET `Title_loc2` = REPLACE(`Title_loc2`, "[PÉRIMÉ 4.x]", ""); +UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED in 4.x] ", ""); +UPDATE `locales_quest` SET `Title_loc6` = REPLACE(`Title_loc6`, "[DEPRECATED 4.x] ", ""); +UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED in 4.x] ", ""); +UPDATE `locales_quest` SET `Title_loc7` = REPLACE(`Title_loc7`, "[DEPRECATED 4.x] ", ""); +UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED in 4.x] ", ""); +UPDATE `locales_quest` SET `Title_loc8` = REPLACE(`Title_loc8`, "[DEPRECATED 4.x] ", ""); -- cgit v1.2.3