aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2016-01-17 12:16:39 +0000
committerDr-J <daniel.jarrott0@gmail.com>2016-01-17 12:16:39 +0000
commit6d10b920718fdbaf526254d74d906733edcb561d (patch)
tree64d02724820332103e7b93343f3593a295b57d3a
parent83efabefe896146cf6d55d0341abed2a47c7459f (diff)
DB/Quest: Nether Gas In a Fel Fire Engine
Update https://github.com/TrinityCore/TrinityCore/commit/01beba21b5210860ddd6a37471c6b2bea77a369e to more reliabily complete quest to actually allow quest to be returned rather than just been marked as complete in quest log and on map but quest giver still showing grey ? ad grey continue button.
-rw-r--r--sql/updates/world/2016_01_17_06_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_17_06_world.sql b/sql/updates/world/2016_01_17_06_world.sql
new file mode 100644
index 00000000000..659f146845a
--- /dev/null
+++ b/sql/updates/world/2016_01_17_06_world.sql
@@ -0,0 +1,5 @@
+UPDATE `smart_scripts` SET `id`=5 WHERE `source_type` = 9 AND `entryorguid` = 2229300 AND `id`=4 AND `action_type`=51;
+
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryorguid` = 2229300 AND `id`=4;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(2229300, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 38758, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Inactive Fel Reaver - Action list - Invoker Cast [PH] Quest reward: Nether Gas In a Fel Fire Engine');