• 📚 A new project from the admin: Check out PictureBooks.io, an AI storyteller that lets you create personalized picture books for kids in seconds. Give it a try and let me know what you think!

[solved] Help with coding

phaetom

Chieftain
Joined
Sep 11, 2025
Messages
7
I'm making a mod like Civ VII Civilization All Specific Wonders.
To do this in Civ7 I have the idea of delete every Wonder from common culture tree nodes, leaving just the unique civ nodes. After that I just need to add the other wonders to the civilizations specific nodes.
For an exemple:
Rome already has Colesseum in Senatus Populusque Romanus, but Mausoleum of Theodoric is also a roman wonder, so I try to add this to Legatus Pro Praetore civic, but I it doesn't work...

Spoiler The code: :

-- This part of code is not working
INSERT INTO ProgressionTreeNodeUnlocks
(ProgressionTreeNodeType, TargetKind, TargetType, UnlockDepth, AIIgnoreUnlockValue)
VALUES ('NODE_CIVIC_AQ_ROME_LEGATUS_PRO_PRAETORE', 'KIND_CONSTRUCTIBLE', 'WONDER_MAUSOLEUM_OF_THEODORIC', 1, 1);

-- This part is working
DELETE FROM ProgressionTreeNodeUnlocks
WHERE TargetType IN (
SELECT ConstructibleType
FROM Wonders
)
AND ProgressionTreeNodeType NOT IN (
SELECT a.ProgressionTreeNodeType
FROM ProgressionTreeNodes a
JOIN Civilizations b
ON a.ProgressionTree = b.UniqueCultureProgressionTree
);
 
Last edited:
I make it work! Instead of add to a new node I just changed the node, and it worked!

Spoiler :
UPDATE ProgressionTreeNodeUnlocks SET ProgressionTreeNodeType = 'NODE_CIVIC_AQ_ROME_SENATUS_POPULUSQUE_ROMANUS' WHERE TargetType = 'WONDER_MAUSOLEUM_OF_THEODORIC';
 
Back
Top Bottom