[R&F] Specific Wonders for specific Civs

Nahimi

Chieftain
Joined
Feb 13, 2018
Messages
17
I am trying to make a mod based on the steam workshop mod: Civ Specific Wonders (Which is only available on the steam Workshop). But I need help creating it :3
---------
The mod should disable wonders to certain civs that do not reflect real history. Ej: France cannot build the Stonehenge, only England. The Statue of Liberty can only be built by France and the US etc...
I've heard that is not very hard to code but I'm a complete noob.
---------


Workshop mod by ceddybearrr: https://steamcommunity.com/sharedfiles/filedetails/?id=1185917191
 
You can do this with Traits. Create a Trait that represents the ability to build each Wonder you want to restrict in this way. Then in the Buildings table, list that Trait. Then assign the Trait to each Leader or Civ who should be able to build that building.

One thing to note: If you do this, all the Wonders that leader/civ can build will be listed on the leader select and level loading screens.
 
You can do this with Traits. Create a Trait that represents the ability to build each Wonder you want to restrict in this way. Then in the Buildings table, list that Trait. Then assign the Trait to each Leader or Civ who should be able to build that building.

One thing to note: If you do this, all the Wonders that leader/civ can build will be listed on the leader select and level loading screens.

I have found this, but it does not work because it is outdated and does not support Rise and Fall and I have no idea how to make it support Rise and Fall...

INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_STONEHENGE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_BIG_BEN', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_OXFORD_UNIVERSITY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_PYRAMIDS', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_GREAT_LIGHTHOUSE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_GREAT_LIBRARY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_MONT_ST_MICHEL', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_EIFFEL_TOWER', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_STATUE_LIBERTY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_ST_BASILS_CATHEDRAL', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_HERMITAGE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_BOLSHOI_THEATRE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_RUHR_VALLEY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_TEMPLE_ARTEMIS', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_ORACLE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_COLOSSUS', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_CRISTO_REDENTOR', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_ESTADIO_DO_MARACANA', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_MAHABODHI_TEMPLE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_TAJ_MAHAL', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_TERRACOTTA_ARMY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_FORBIDDEN_CITY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_POTALA_PALACE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_ALHAMBRA', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_CASA_DE_CONTRATACION', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_COLOSSEUM', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_PETRA', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_BROADWAY', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_AMUNDSEN_SCOTT_RESEARCH_STATION', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_KOTOKU_IN', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_HANGING_GARDENS', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_VENETIAN_ARSENAL', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_CHICHEN_ITZA', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_GREAT_ZIMBABWE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_HAGIA_SOPHIA', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_KILWA_KISIWANI', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_SYDNEY_OPERA_HOUSE', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_HUEY_TEOCALLI', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_ANGKOR_WAT', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_JEBEL_BARKAL', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_HALICARNASSUS_MAUSOLEUM', 'KIND_TRAIT') ;
INSERT INTO Types (Type, Kind) VALUES ('C_TRAIT_BUILDING_APADANA', 'KIND_TRAIT') ;

INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_STONEHENGE', 'English Unique Wonder', 'Unlocks building the Stonehenge wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_BIG_BEN', 'English Unique Wonder', 'Unlocks building the Big Ben wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_OXFORD_UNIVERSITY', 'English Unique Wonder', 'Unlocks building the Oxford University wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_PYRAMIDS', 'Egyptian Unique Wonder', 'Unlocks building the Pyramids wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_GREAT_LIGHTHOUSE', 'Unique Wonder', 'Unlocks building the Great Lighthouse wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_GREAT_LIBRARY', 'Unique Wonder', 'Unlocks building the Great Library wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_MONT_ST_MICHEL', 'French Unique Wonder', 'Unlocks building the Mont Saint-Michel wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_EIFFEL_TOWER', 'French Unique Wonder', 'Unlocks building the Eiffel Tower wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_STATUE_LIBERTY', 'Unique Wonder', 'Unlocks building the Statue of Liberty wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_ST_BASILS_CATHEDRAL', 'Russian Unique Wonder', 'Unlocks building the Cathedral of St. Basil wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_HERMITAGE', 'Russian Unique Wonder', 'Unlocks building the Hermitage wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_BOLSHOI_THEATRE', 'Russian Unique Wonder', 'Unlocks building the Bolshoi Theatre wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_RUHR_VALLEY', 'German Unique Wonder', 'Unlocks building the Ruhr Valley wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_TEMPLE_ARTEMIS', 'Greek Unique Wonder', 'Unlocks building the Temple of Artemis wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_ORACLE', 'Greek Unique Wonder', 'Unlocks building the Oracle wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_COLOSSUS', 'Greek Unique Wonder', 'Unlocks building the Colossus wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_CRISTO_REDENTOR', 'Brazilian Unique Wonder', 'Unlocks building the Cristo Redentor wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_ESTADIO_DO_MARACANA', 'Brazilian Unique Wonder', 'Unlocks building the Estádio do Maracanã wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_MAHABODHI_TEMPLE', 'Indian Unique Wonder', 'Unlocks building the Mahabodhi Temple wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_TAJ_MAHAL', 'Indian Unique Wonder', 'Unlocks building the Taj Mahal wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_TERRACOTTA_ARMY', 'Chinese Unique Wonder', 'Unlocks building the Terracotta Army wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_FORBIDDEN_CITY', 'Chinese Unique Wonder', 'Unlocks building the Forbidden City wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_POTALA_PALACE', 'Chinese Unique Wonder', 'Unlocks building the Potala Palace wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_ALHAMBRA', 'Spanish Unique Wonder', 'Unlocks building the Alhambra wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_CASA_DE_CONTRATACION', 'Spanish Unique Wonder', 'Unlocks building the Casa de Contratción wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_COLOSSEUM', 'Roman Unique Wonder', 'Unlocks building the Colosseum wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_PETRA', 'Arabian Unique Wonder', 'Unlocks building the Petra wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_BROADWAY', 'American Unique Wonder', 'Unlocks building the Broadway wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_AMUNDSEN_SCOTT_RESEARCH_STATION', 'American Unique Wonder', 'Unlocks building the Amundsen-Scott Research Station wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_KOTOKU_IN', 'Japanese Unique Wonder', 'Unlocks building the K?toku-in wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_HANGING_GARDENS', 'Unique Wonder', 'Unlocks building the Hanging Gardens wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_CHICHEN_ITZA', 'Unique Wonder', 'Unlocks building the Chichen Itza wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_GREAT_ZIMBABWE', 'Unique Wonder', 'Unlocks building the Great Zimbabwe wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_HAGIA_SOPHIA', 'Unique Wonder', 'Unlocks building the Hagia Sophia wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_VENETIAN_ARSENAL', 'Unique Wonder', 'Unlocks building the Venetian Arsenal wonder') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_KILWA_KISIWANI', 'Unique Wonder', 'Unlocks building the Kilwa Kisiwani wonder') ;;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_SYDNEY_OPERA_HOUSE', 'Australian Unique Wonder', 'Unlocks building the Sydney Opera House') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_HUEY_TEOCALLI', 'Aztec Unique Wonder', 'Unlocks building the Huey Teocalli') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_ANGKOR_WAT', 'Khmer Unique Wonder', 'Unlocks building the Angkor Wat') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_JEBEL_BARKAL', 'Nubia Unique Wonder', 'Unlocks building the Jebel Barkal') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_HALICARNASSUS_MAUSOLEUM', 'Persian Unique Wonder', 'Unlocks building the Mausoleum at Halicarnassus') ;
INSERT INTO Traits (TraitType, Name, Description) VALUES ('C_TRAIT_BUILDING_APADANA', 'Persian Unique Wonder', 'Unlocks building the Apadana') ;

INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ENGLAND', 'C_TRAIT_BUILDING_STONEHENGE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ENGLAND', 'C_TRAIT_BUILDING_BIG_BEN') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ENGLAND', 'C_TRAIT_BUILDING_OXFORD_UNIVERSITY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_EGYPT', 'C_TRAIT_BUILDING_PYRAMIDS') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_EGYPT', 'C_TRAIT_BUILDING_GREAT_LIGHTHOUSE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_EGYPT', 'C_TRAIT_BUILDING_GREAT_LIBRARY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_FRANCE', 'C_TRAIT_BUILDING_MONT_ST_MICHEL') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_FRANCE', 'C_TRAIT_BUILDING_EIFFEL_TOWER') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_FRANCE', 'C_TRAIT_BUILDING_STATUE_LIBERTY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_RUSSIA', 'C_TRAIT_BUILDING_ST_BASILS_CATHEDRAL') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_RUSSIA', 'C_TRAIT_BUILDING_HERMITAGE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_RUSSIA', 'C_TRAIT_BUILDING_BOLSHOI_THEATRE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GERMANY', 'C_TRAIT_BUILDING_RUHR_VALLEY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GREECE', 'C_TRAIT_BUILDING_TEMPLE_ARTEMIS') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GREECE', 'C_TRAIT_BUILDING_ORACLE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GREECE', 'C_TRAIT_BUILDING_COLOSSUS') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GREECE', 'C_TRAIT_BUILDING_GREAT_LIGHTHOUSE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_GREECE', 'C_TRAIT_BUILDING_GREAT_LIBRARY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_BRAZIL', 'C_TRAIT_BUILDING_CHICHEN_ITZA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_BRAZIL', 'C_TRAIT_BUILDING_CRISTO_REDENTOR') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_BRAZIL', 'C_TRAIT_BUILDING_ESTADIO_DO_MARACANA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_INDIA', 'C_TRAIT_BUILDING_MAHABODHI_TEMPLE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_INDIA', 'C_TRAIT_BUILDING_TAJ_MAHAL') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_CHINA', 'C_TRAIT_BUILDING_TERRACOTTA_ARMY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_CHINA', 'C_TRAIT_BUILDING_FORBIDDEN_CITY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_CHINA', 'C_TRAIT_BUILDING_POTALA_PALACE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_SPAIN', 'C_TRAIT_BUILDING_ALHAMBRA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_SPAIN', 'C_TRAIT_BUILDING_CASA_DE_CONTRATACION') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ROME', 'C_TRAIT_BUILDING_COLOSSEUM') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ROME', 'C_TRAIT_BUILDING_HAGIA_SOPHIA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ROME', 'C_TRAIT_BUILDING_VENETIAN_ARSENAL') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_ARABIA', 'C_TRAIT_BUILDING_PETRA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_AMERICA', 'C_TRAIT_BUILDING_STATUE_LIBERTY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_AMERICA', 'C_TRAIT_BUILDING_BROADWAY') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_AMERICA', 'C_TRAIT_BUILDING_AMUNDSEN_SCOTT_RESEARCH_STATION') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_JAPAN', 'C_TRAIT_BUILDING_KOTOKU_IN') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_SUMERIA', 'C_TRAIT_BUILDING_HANGING_GARDENS') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_KONGO', 'C_TRAIT_BUILDING_GREAT_ZIMBABWE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) VALUES ('CIVILIZATION_KONGO', 'C_TRAIT_BUILDING_KILWA_KISIWANI') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_AUSTRALIA', 'C_TRAIT_BUILDING_SYDNEY_OPERA_HOUSE' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_AUSTRALIA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_AZTEC', 'C_TRAIT_BUILDING_HUEY_TEOCALLI' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_AZTEC') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_AZTEC', 'C_TRAIT_BUILDING_CHICHEN_ITZA' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_AZTEC') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_KHMER', 'C_TRAIT_BUILDING_ANGKOR_WAT' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_KHMER') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_NUBIA', 'C_TRAIT_BUILDING_JEBEL_BARKAL' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_NUBIA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_PERSIA', 'C_TRAIT_BUILDING_HALICARNASSUS_MAUSOLEUM' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_PERSIA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_PERSIA', 'C_TRAIT_BUILDING_APADANA' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_PERSIA') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_MACEDON', 'C_TRAIT_BUILDING_GREAT_LIGHTHOUSE' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_MACEDON') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_MACEDON', 'C_TRAIT_BUILDING_GREAT_LIBRARY' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_MACEDON') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_MAPUCHE', 'C_TRAIT_BUILDING_CHICHEN_ITZA' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_MAPUCHE') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_ZULU', 'C_TRAIT_BUILDING_KILWA_KISIWANI' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_ZULU') ;
INSERT INTO CivilizationTraits (CivilizationType, TraitType) SELECT 'CIVILIZATION_ZULU', 'C_TRAIT_BUILDING_GREAT_ZIMBABWE' WHERE EXISTS (SELECT * FROM CivilizationLeaders WHERE CivilizationType = 'CIVILIZATION_ZULU') ;

--England--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_STONEHENGE' where BuildingType='BUILDING_STONEHENGE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_BIG_BEN' where BuildingType='BUILDING_BIG_BEN' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_OXFORD_UNIVERSITY' where BuildingType='BUILDING_OXFORD_UNIVERSITY' ;

--Egypt--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_PYRAMIDS' where BuildingType='BUILDING_PYRAMIDS' ;

--France--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_MONT_ST_MICHEL' where BuildingType='BUILDING_MONT_ST_MICHEL' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_EIFFEL_TOWER' where BuildingType='BUILDING_EIFFEL_TOWER' ;

--Russia--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_ST_BASILS_CATHEDRAL' where BuildingType='BUILDING_ST_BASILS_CATHEDRAL' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_HERMITAGE' where BuildingType='BUILDING_HERMITAGE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_BOLSHOI_THEATRE' where BuildingType='BUILDING_BOLSHOI_THEATRE' ;

--Germany--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_RUHR_VALLEY' where BuildingType='BUILDING_RUHR_VALLEY' ;

--Greece--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_TEMPLE_ARTEMIS' where BuildingType='BUILDING_TEMPLE_ARTEMIS' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_ORACLE' where BuildingType='BUILDING_ORACLE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_COLOSSUS' where BuildingType='BUILDING_COLOSSUS' ;


--Brazil--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_CRISTO_REDENTOR' where BuildingType='BUILDING_CRISTO_REDENTOR' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_ESTADIO_DO_MARACANA' where BuildingType='BUILDING_ESTADIO_DO_MARACANA' ;

--India--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_MAHABODHI_TEMPLE' where BuildingType='BUILDING_MAHABODHI_TEMPLE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_TAJ_MAHAL' where BuildingType='BUILDING_TAJ_MAHAL' ;

--China--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_TERRACOTTA_ARMY' where BuildingType='BUILDING_TERRACOTTA_ARMY' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_FORBIDDEN_CITY' where BuildingType='BUILDING_FORBIDDEN_CITY' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_POTALA_PALACE' where BuildingType='BUILDING_POTALA_PALACE' ;

--Spain--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_ALHAMBRA' where BuildingType='BUILDING_ALHAMBRA' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_CASA_DE_CONTRATACION' where BuildingType='BUILDING_CASA_DE_CONTRATACION' ;

--Rome--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_COLOSSEUM' where BuildingType='BUILDING_COLOSSEUM' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_HAGIA_SOPHIA' where BuildingType='BUILDING_HAGIA_SOPHIA' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_VENETIAN_ARSENAL' where BuildingType='BUILDING_VENETIAN_ARSENAL' ;

--Arabia--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_PETRA' where BuildingType='BUILDING_PETRA' ;

--America--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_BROADWAY' where BuildingType='BUILDING_BROADWAY' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_AMUNDSEN_SCOTT_RESEARCH_STATION' where BuildingType='BUILDING_AMUNDSEN_SCOTT_RESEARCH_STATION' ;

--Japan--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_KOTOKU_IN' where BuildingType='BUILDING_KOTOKU_IN' ;

--Sumeria--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_HANGING_GARDENS' where BuildingType='BUILDING_HANGING_GARDENS' ;

--Aztec--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_HUEY_TEOCALLI' where BuildingType='BUILDING_HUEY_TEOCALLI' ;

--Khmer--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_ANGKOR_WAT' where BuildingType='BUILDING_ANGKOR_WAT' ;

--Nubia--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_JEBEL_BARKAL' where BuildingType='BUILDING_JEBEL_BARKAL' ;

--Australia--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_SYDNEY_OPERA_HOUSE' where BuildingType='BUILDING_SYDNEY_OPERA_HOUSE' ;

--Persia--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_HALICARNASSUS_MAUSOLEUM' where BuildingType='BUILDING_HALICARNASSUS_MAUSOLEUM' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_APADANA' where BuildingType='BUILDING_APADANA' ;

--Shared--
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_GREAT_LIGHTHOUSE' where BuildingType='BUILDING_GREAT_LIGHTHOUSE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_GREAT_LIBRARY' where BuildingType='BUILDING_GREAT_LIBRARY' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_STATUE_LIBERTY' where BuildingType='BUILDING_STATUE_LIBERTY' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_GREAT_ZIMBABWE' where BuildingType='BUILDING_GREAT_ZIMBABWE' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_CHICHEN_ITZA' where BuildingType='BUILDING_CHICHEN_ITZA' ;
UPDATE Buildings SET TraitType='C_TRAIT_BUILDING_KILWA_KISIWANI' where BuildingType='BUILDING_KILWA_KISIWANI' ;
 
Top Bottom