diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-03-15 00:15:34 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-03-15 00:15:34 +0100 |
| commit | 6f39c2572d83ecb80ed562cc19ea312d88d69685 (patch) | |
| tree | 624cfc57de0432afa27f2dca4b8b76a815929895 | |
| parent | 0d1c26237dcf01032c7badafa3043dfe11a811a3 (diff) | |
Update 2024_03_14_00_world.sql
| -rw-r--r-- | sql/updates/world/3.3.5/2024_03_14_00_world.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/updates/world/3.3.5/2024_03_14_00_world.sql b/sql/updates/world/3.3.5/2024_03_14_00_world.sql index 92b793d1fa7..95e68da6591 100644 --- a/sql/updates/world/3.3.5/2024_03_14_00_world.sql +++ b/sql/updates/world/3.3.5/2024_03_14_00_world.sql @@ -1,12 +1,12 @@ -- Cast aura 70193 on player if one of the following conditions are meet DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceGroup` = 0 AND `SourceEntry` = 70193; INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES -(17, 0, 70193, 0, 1, 8, 0, 24480, 0, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest The Halls Of Reflection (A) rewarded"), -(17, 0, 70193, 0, 2, 47, 0, 24522, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Journey To The Sunwell (A) progress | completed | rewarded"), -(17, 0, 70193, 0, 3, 47, 0, 24535, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Thalorien Dawnseeker (A) progress | completed | rewarded"), -(17, 0, 70193, 0, 4, 8, 0, 24561, 0, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest The Halls Of Reflection (H) rewarded"), -(17, 0, 70193, 0, 5, 47, 0, 24562, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Journey To The Sunwell (H) progress | completed | rewarded"), -(17, 0, 70193, 0, 6, 47, 0, 24563, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Thalorien Dawnseeker (H) progress | completed | rewarded"); +(17, 0, 70193, 0, 1, 8, 0, 24480, 0, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest The Halls Of Reflection Alliance rewarded"), +(17, 0, 70193, 0, 2, 47, 0, 24522, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Journey To The Sunwell Alliance progress, completed or rewarded"), +(17, 0, 70193, 0, 3, 47, 0, 24535, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Thalorien Dawnseeker Alliance progress, completed or rewarded"), +(17, 0, 70193, 0, 4, 8, 0, 24561, 0, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest The Halls Of Reflection Horde rewarded"), +(17, 0, 70193, 0, 5, 47, 0, 24562, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Journey To The Sunwell Horde progress, completed or rewarded"), +(17, 0, 70193, 0, 6, 47, 0, 24563, 74, 0, 0, 0, 0, '', "Cast aura 70193 on player only if quest Thalorien Dawnseeker Horde progress, completed or rewarded"); -- DELETE FROM `spell_area` WHERE `spell`=70193 AND `quest_start` IN (24535,24563); |