From 4dc91429dd2158c75679d07c34a18a2e12b4ef7a Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 28 Jan 2018 14:03:43 +0100 Subject: DB/Quest: Freedom to Ruul Closes #7262 --- sql/updates/world/3.3.5/2018_01_28_02_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_01_28_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_01_28_02_world.sql b/sql/updates/world/3.3.5/2018_01_28_02_world.sql new file mode 100644 index 00000000000..280591c87ec --- /dev/null +++ b/sql/updates/world/3.3.5/2018_01_28_02_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `creature_text` WHERE `CreatureID`=12818; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(12818, 0, 0, "Thank you for freeing me. Speak with my sister in Splintertree. I... I must find a place to rest...", 12, 0, 100, 0, 10000, 0, 8265, 0, "Ruul Snowhoof"); + +DELETE FROM `script_waypoint` WHERE `entry`=12818 AND `pointid`>20; +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(12818, 21, 3484.2211, -489.7181, 182.391, 0, ""), +(12818, 22, 3454.7424, -476.7681, 170.161, 0, ""), +(12818, 23, 3381.2749, -428.4134, 149.411, 0, ""), +(12818, 24, 3323.4501, -446.5041, 150.590, 0, ""), +(12818, 25, 3302.2722, -485.8791, 153.285, 0, ""), +(12818, 26, 3287.0722, -519.1887, 154.622, 0, ""), +(12818, 27, 3249.5512, -531.9198, 151.633, 5000, "The end"), +(12818, 28, 3249.5512, -531.9198, 151.633, 0, "The end"); -- cgit v1.2.3