diff options
| author | Aokromes <jipr@hotmail.com> | 2013-11-04 16:29:09 +0100 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2013-11-04 16:29:09 +0100 |
| commit | b857567d85999a40e36b0302365de6fde322fb42 (patch) | |
| tree | 18744d6ae3160e4028b07045e78312401c1afdb7 | |
| parent | f771ff15e5a9887c487e4535b90be70987ff1130 (diff) | |
DB/Misc: Get Stefan Vadu to reset quests for Drakuru's task when Sabotage, So Far So Bad, Hazardous Materials and Infilltrating Voltarus are taken
by dr-j, closes #11170
| -rw-r--r-- | sql/updates/world/2013_11_04_06_world_misc.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_04_06_world_misc.sql b/sql/updates/world/2013_11_04_06_world_misc.sql new file mode 100644 index 00000000000..982cd82a91f --- /dev/null +++ b/sql/updates/world/2013_11_04_06_world_misc.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=28518 AND `source_type`=0 AND `id` BETWEEN 5 AND 8; + +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 +(28518, 0, 5, 0, 19, 0, 100, 0, 12676, 0, 0, 0, 85, 55413, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Stefan Vadu - On quest accept (Sabotage) - Cast Clearquest'), +(28518, 0, 6, 0, 19, 0, 100, 0, 12669, 0, 0, 0, 85, 55411, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Stefan Vadu - On quest accept (So Far, So Bad) - Cast Clearquest'), +(28518, 0, 7, 0, 19, 0, 100, 0, 12677, 0, 0, 0, 85, 55412, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Stefan Vadu - On quest accept (Hazardous Materials) - Cast Clearquest'), +(28518, 0, 8, 0, 19, 0, 100, 0, 12661, 0, 0, 0, 85, 55410, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Stefan Vadu - On quest accept (Infiltrating Voltarus) - Cast Clearquests'); |