From 27137ca06e99209bd1a47a0ff7082ff14fcae8c9 Mon Sep 17 00:00:00 2001 From: pete318 Date: Sun, 28 Dec 2014 18:42:52 +0000 Subject: Scripts/Quests: Fix Quest A Spirit Guide - Ensures rep adjustment buff is always applied (overrides evade, implements existing evade + re-apply buff) - Removes un-owned ravagers with incorrect faction from DB (the correct ones are spawned with their masters without the DB entries) - Create some extra steps in the wolf's waypoints in order to generate some AI events for the Ryga NPC. I think it's a bit of a dirty solution, but it seems to work with minimal changes. - Created RP series of events with Ryga NPC and Ancestral Wolf Spirit (Ryga Kneels, talks to wolf, then returns to spawn position after around a minute). Closes #13619 Fix #4028 (cherry picked from commit f2444eedf92fce39f7685eafead61d88d4ad89ef) Conflicts: sql/updates/world/2014_12_28_02_world.sql --- sql/updates/world/2014_12_28_03_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_12_28_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_12_28_03_world.sql b/sql/updates/world/2014_12_28_03_world.sql new file mode 100644 index 00000000000..bc44ddd1cd1 --- /dev/null +++ b/sql/updates/world/2014_12_28_03_world.sql @@ -0,0 +1,5 @@ +DELETE FROM `creature` WHERE `id`=19461; +DELETE FROM `script_waypoint` WHERE `entry`=17077 AND `pointid` IN (51, 52); +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(17077, 51, 519.146, 3886.7, 190.128, 10000, 'RYGA_WALK'), +(17077, 52, 519.146, 3886.7, 190.128, 1000, 'RYGA_RETURN'); -- cgit v1.2.3