From e47b4f24ef6a762537eb207656b50a8b1328e545 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 29 Apr 2017 02:17:12 +0200 Subject: Rename sql/updates/world/4.3.4/2017_04_29_00_world.sql to sql/updates/world/master/2017_04_29_00_world.sql --- sql/updates/world/4.3.4/2017_04_29_00_world.sql | 13 ------------- sql/updates/world/master/2017_04_29_00_world.sql | 13 +++++++++++++ 2 files changed, 13 insertions(+), 13 deletions(-) delete mode 100644 sql/updates/world/4.3.4/2017_04_29_00_world.sql create mode 100644 sql/updates/world/master/2017_04_29_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/4.3.4/2017_04_29_00_world.sql b/sql/updates/world/4.3.4/2017_04_29_00_world.sql deleted file mode 100644 index f88378a5e88..00000000000 --- a/sql/updates/world/4.3.4/2017_04_29_00_world.sql +++ /dev/null @@ -1,13 +0,0 @@ --- Fix several quest gameobjects in Coldridge Valley -UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry` IN (201608,201609,201610,201611,201704,201705,201706); - --- Scripts -UPDATE `creature_template` SET `ScriptName`= 'npc_wounded_coldridge_mountaineer' WHERE `entry`=37080; -UPDATE `creature_template` SET `ScriptName`= 'npc_wounded_milita' WHERE `entry`=44405; -UPDATE `creature_template` SET `ScriptName`= 'npc_milos_gyro' WHERE `entry`=37198; - -DELETE FROM `spell_script_names` WHERE `spell_id` IN (70046,70047,76143); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(70046, 'spell_a_trip_to_ironforge_quest_complete'), -(70047, 'spell_follow_that_gyrocopter_quest_start'), -(76143, 'spell_low_health'); diff --git a/sql/updates/world/master/2017_04_29_00_world.sql b/sql/updates/world/master/2017_04_29_00_world.sql new file mode 100644 index 00000000000..f88378a5e88 --- /dev/null +++ b/sql/updates/world/master/2017_04_29_00_world.sql @@ -0,0 +1,13 @@ +-- Fix several quest gameobjects in Coldridge Valley +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry` IN (201608,201609,201610,201611,201704,201705,201706); + +-- Scripts +UPDATE `creature_template` SET `ScriptName`= 'npc_wounded_coldridge_mountaineer' WHERE `entry`=37080; +UPDATE `creature_template` SET `ScriptName`= 'npc_wounded_milita' WHERE `entry`=44405; +UPDATE `creature_template` SET `ScriptName`= 'npc_milos_gyro' WHERE `entry`=37198; + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (70046,70047,76143); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(70046, 'spell_a_trip_to_ironforge_quest_complete'), +(70047, 'spell_follow_that_gyrocopter_quest_start'), +(76143, 'spell_low_health'); -- cgit v1.2.3