diff options
| author | Aqua Deus <95978183+aquadeus@users.noreply.github.com> | 2025-08-31 10:26:25 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-08-31 10:26:25 +0200 |
| commit | 4d73fcd56340db4a5924518bde8bf8c3527a9d84 (patch) | |
| tree | 498c036d8733ef1d6c678c002285e6484da05cf3 /sql | |
| parent | de90cf03bd6b3aa4b0af52cee117a5c0882da48c (diff) | |
Scripts/Draenor: Implement Establish your Garrison (34378) (#28219)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_08_31_03_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
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); |