Core/Scripts: Dwarf Start Area scripts

By Malcrom

1 files changed, 13 insertions, 0 deletions

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
new file mode 100644
index 00000000000..f88378a5e88
--- /dev/null
+++ b/sql/updates/world/4.3.4/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');