diff options
| author | Naddley <NaddleyTC@gmail.com> | 2023-05-29 18:19:39 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2023-05-29 18:19:39 +0200 |
| commit | a2cba46e641c85db4baa863d3cd50bbc0918708f (patch) | |
| tree | c53a3e5a6c8dfea79cde4b63691bc11b9a9ab0c6 | |
| parent | c4aa4d4b5371af440b9fce2bb0866b90a50750f6 (diff) | |
DB/NPE: Handle phase for Horde Populated Camp
| -rw-r--r-- | sql/updates/world/master/2023_05_29_00_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_05_29_00_world.sql b/sql/updates/world/master/2023_05_29_00_world.sql new file mode 100644 index 00000000000..eb157a33540 --- /dev/null +++ b/sql/updates/world/master/2023_05_29_00_world.sql @@ -0,0 +1,17 @@ +-- Phase +DELETE FROM `phase_name` WHERE `ID` = 15330; +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(15330, 'Cosmetic - 9.0 NPE - Horde Populated Camp'); + +-- Phase for Clientside GameObjects +DELETE FROM `phase_area` WHERE (`AreaId` IN (10529, 10588, 10527) AND `PhaseId` = 15330); +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(10529, 15330, 'Cosmetic - 9.0 NPE - Horde Populated Camp'), -- Ogre Ruins +(10588, 15330, 'Cosmetic - 9.0 NPE - Horde Populated Camp'), -- Darkmaul Plains +(10527, 15330, 'Cosmetic - 9.0 NPE - Horde Populated Camp'); -- Hruns Barrows + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15330 AND `SourceEntry` IN (10529, 10588, 10527)); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 15330, 10529, 0, 0, 47, 0, 59942, 64, 0, 0, 'Apply Phase 15330 if Quest 59942 is rewarded'), -- Ogre Ruins +(26, 15330, 10588, 0, 0, 47, 0, 59942, 64, 0, 0, 'Apply Phase 15330 if Quest 59942 is rewarded'), -- Darkmaul Plains +(26, 15330, 10527, 0, 0, 47, 0, 59942, 64, 0, 0, 'Apply Phase 15330 if Quest 59942 is rewarded'); -- Hruns Barrows |