From e0b7dfbecb46e5c040691a05aaba9933535145e6 Mon Sep 17 00:00:00 2001
From: Naddley <64811442+Naddley@users.noreply.github.com>
Date: Thu, 29 Sep 2022 09:02:48 +0200
Subject: DB/Phase: Add PhaseId to Portal to Oribos in Stormwind

Closes #28292
---
 sql/updates/world/master/2022_09_29_00_world.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 sql/updates/world/master/2022_09_29_00_world.sql

(limited to 'sql/updates')

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');
-- 
cgit v1.2.3