diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-07-10 12:18:43 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-05 16:34:56 +0100 |
| commit | fcbda4c83ba22a8f376f42a068c74ba94cda6713 (patch) | |
| tree | 3ffd486ee3fea54cc703e8eb0297cbfc435d4b4b | |
| parent | c016de4d149910e288b2fa8b2b6464af1be34fe8 (diff) | |
DB/SAI: improvements for quest "Verog the Dervish"
Change despawn type, prevent duplicates, and increase chance of spawn. Taken from Wowhead comments
(cherry picked from commit 439ec8835440fbe322f4dcd901924d40e699ef40)
| -rw-r--r-- | sql/updates/world/master/2017_02_05_07_world_2016_07_10_05_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_05_07_world_2016_07_10_05_world.sql b/sql/updates/world/master/2017_02_05_07_world_2016_07_10_05_world.sql new file mode 100644 index 00000000000..46d0cd341fe --- /dev/null +++ b/sql/updates/world/master/2017_02_05_07_world_2016_07_10_05_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=3397 AND `SourceGroup`=3; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 3, 3397, 0, 0, 29, 0, 3395, 200, 0, 1, 0, 0, "", "Prevent summoning creature Verog the Dervish if already summoned"); + +UPDATE `smart_scripts` SET `action_param2`=6, `action_param3`=20000 WHERE `source_type`=0 AND `entryorguid`=3397 AND `id`=3; +UPDATE `smart_scripts` SET `event_chance`=20 WHERE `source_type`=0 AND `entryorguid`=3397 AND `id`=2; |