diff options
| author | Naddley <64811442+Naddley@users.noreply.github.com> | 2022-09-29 09:02:48 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2022-09-29 09:04:40 +0200 |
| commit | e0b7dfbecb46e5c040691a05aaba9933535145e6 (patch) | |
| tree | 73391510297829ff42114117cba990d4a04e212e | |
| parent | 5c5446d63e91f506534c65f7fa5cd036296ccb30 (diff) | |
DB/Phase: Add PhaseId to Portal to Oribos in Stormwind
Closes #28292
| -rw-r--r-- | sql/updates/world/master/2022_09_29_00_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_09_29_00_world.sql b/sql/updates/world/master/2022_09_29_00_world.sql new file mode 100644 index 00000000000..bcbce8771c6 --- /dev/null +++ b/sql/updates/world/master/2022_09_29_00_world.sql @@ -0,0 +1,17 @@ +-- Update PhaseID +UPDATE `creature` SET `PhaseId` = 16826 WHERE `guid` IN (850207, 850208); +UPDATE `gameobject` SET `PhaseId` = 16826 WHERE `guid` = 500400; + +-- Phase +DELETE FROM `phase_area` WHERE `AreaId` = 10523 AND `PhaseId` = 16826; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(10523, 16826, 'See Portal to Oribos in Wizards Sanctum'); + +DELETE FROM `phase_name` WHERE `ID` = 16826; +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(16826, 'See Portal to Oribos in Wizards Sanctum'); + +-- Condition +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 16826 AND `SourceEntry` = 10523); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 16826, 10523, 0, 0, 47, 0, 60151, 2 | 8 | 64, 0, 0, 'Apply Phase 16826 If Quest 60151 IS in Progress | complete | rewarded'); |