diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-01-17 12:16:39 +0000 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-03-22 23:09:03 +0100 |
| commit | ef2521637f0899df119a53749ad98a9d68eabeea (patch) | |
| tree | 52d2fad5272e47cf91793eee5c230fb3bad9d33a | |
| parent | 699ca8dd6537e69e9fb15035f035e5cad39b805c (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.
(cherry picked from commit 6d10b920718fdbaf526254d74d906733edcb561d)
| -rw-r--r-- | sql/updates/world/2016_03_22_15_world_2016_01_17_06_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_03_22_15_world_2016_01_17_06_world.sql b/sql/updates/world/2016_03_22_15_world_2016_01_17_06_world.sql new file mode 100644 index 00000000000..659f146845a --- /dev/null +++ b/sql/updates/world/2016_03_22_15_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'); |