From 4d73fcd56340db4a5924518bde8bf8c3527a9d84 Mon Sep 17 00:00:00 2001
From: Aqua Deus <95978183+aquadeus@users.noreply.github.com>
Date: Sun, 31 Aug 2025 10:26:25 +0200
Subject: Scripts/Draenor: Implement Establish your Garrison (34378) (#28219)

---
 sql/updates/world/master/2025_08_31_03_world.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 sql/updates/world/master/2025_08_31_03_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2025_08_31_03_world.sql b/sql/updates/world/master/2025_08_31_03_world.sql
new file mode 100644
index 00000000000..add5c66d31d
--- /dev/null
+++ b/sql/updates/world/master/2025_08_31_03_world.sql
@@ -0,0 +1,17 @@
+UPDATE `gameobject_template` SET `scriptname` = 'go_master_surveyor' WHERE `entry` = 233664;
+
+-- Condition
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 25 AND `SourceGroup` = 0 AND `SourceEntry` = 1152;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(25, 0, 1152, 0, 0, 47, 0, 36793, 66, 0, 0, 'TerrainSwap to 1152 if Quest: 36793 is complete/rewarded');
+
+-- Spawntracking
+DELETE FROM `spawn_tracking` WHERE `SpawnTrackingId`=920544;
+INSERT INTO `spawn_tracking` (`SpawnTrackingId`, `SpawnType`, `SpawnId`, `QuestObjectiveIds`) VALUES
+(920544, 1, 395673, '272928');
+
+DELETE FROM `spawn_tracking_state` WHERE `SpawnType`=1 AND `SpawnId`=920544;
+INSERT INTO `spawn_tracking_state` (`SpawnType`, `SpawnId`, `State`, `Visible`, `StateSpellVisualId`, `StateAnimId`, `StateAnimKitId`, `StateWorldEffects`) VALUES
+(1, 920544, 0, 0, NULL, NULL, NULL, NULL),
+(1, 920544, 1, 1, NULL, NULL, NULL, NULL),
+(1, 920544, 2, 0, NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3