aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-07-15 23:04:54 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-05 19:59:25 +0100
commitc5c399e14fbb35398ab06563a6294d3d69fb7284 (patch)
treead22b3f83da6e0ef96c6e71bee45bcd7dd1c0b1c
parent0d7a49aa76c52a839482b924a4defc8c5057af5d (diff)
DB/Conditions: fix three spells that require a NPC to be nearby
Namely, the Venomhide Hatchling feeding quests (cherry picked from commit 55ba3bd012220b4b58793d8de5f90b1585c70a04)
-rw-r--r--sql/updates/world/master/2017_02_05_25_world_2016_07_15_11_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_05_25_world_2016_07_15_11_world.sql b/sql/updates/world/master/2017_02_05_25_world_2016_07_15_11_world.sql
new file mode 100644
index 00000000000..f0d5555af27
--- /dev/null
+++ b/sql/updates/world/master/2017_02_05_25_world_2016_07_15_11_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (65200, 65258, 65265);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(17, 0, 65200, 0, 0, 29, 0, 34320, 5, 0, 0, 0, 0, "", "Spell 'Feed Venomhide Hatchling' (used for quest 'Hungry, Hungry Hatchling') requires NPC 'Venomhide Hatchling' to be within 5 yards"),
+(17, 0, 65258, 0, 0, 29, 0, 34320, 5, 0, 0, 0, 0, "", "Spell 'Feed Venomhide Hatchling' (used for quest 'Gorishi Grub') requires NPC 'Venomhide Hatchling' to be within 5 yards"),
+(17, 0, 65265, 0, 0, 29, 0, 34320, 5, 0, 0, 0, 0, "", "Spell 'Feed Venomhide Hatchling' (used for quest 'Poached, Scrambled, Or Raw?') requires NPC 'Venomhide Hatchling' to be within 5 yards");