[R&F] Recreating the acropolis for a custom mod. Maybe a quick question and need moving?

hayling

Chieftain
Joined
Nov 23, 2018
Messages
8
EDIT: I'd forgotten parentheses. Added them in, and it still gives me an error prompt after trying to create a game. I should add, too, I'm looking to make the mod function both with and without R&F

I'm looking to recreate the acropolis district for a custom mod, and I've plugged in everything from the Districts.xml file. There's nothing in that file for the acropolis under requirements/modifier arguments and etc. Should there be?

That's all. I can *maybe* figure out what to put there, but I'm not totally sure.

Thanks!

Code:
--
--==========================================================================================================================
-- Districts
--==========================================================================================================================
-- Types
-----------------------------------------------------------------------------------  
INSERT INTO Types  
        (Type,                                    Kind)
VALUES    ('DISTRICT_ZZZ_HERITAGE',            'KIND_DISTRICT');
-----------------------------------------------------------------------------------
-- Districts
-----------------------------------------------------------------------------------
INSERT INTO Districts
            (DistrictType,                    Name,                                    Description,                                    TraitType,                                        Cost,        PrereqCivic,            Aqueduct,        PlunderType,        PlunderAmount,        AdvisorType,        CostProgressionModel,                            CostProgressionParam1,        Maintenance,    RequiresPlacement,        RequiresPopulation,        NoAdjacentCity,        InternalOnly,        ZOC,        CaptureRemovesBuildings,        CaptureRemovesCityDefenses,        MilitaryDomain,        Appeal,        CityStrengthModifier)
VALUES        ('DISTRICT_ZZZ_HERITAGE',        'LOC_DISTRICT_ZZZ_HERITAGE_NAME',        'LOC_DISTRICT_ZZZ_HERITAGE_DESCRIPTION',        'TRAIT_CIVILIZATION_DISTRICT_ZZZ_HERITAGE',        '27',        'CIVIC_DRAMA_POETRY',    'false',        'PLUNDER_CULTURE',    '25',                'ADVISOR_CULTURE',    'COST_PROGRESSION_NUM_UNDER_AVG_PLUS_TECH',        '40',                        '1',            'true',                    'true',                    'false',            'false',            'false',    'false',                        'false',                        'NO_DOMAIN',        '1',        '2');
-----------------------------------------------------------------------------------
-- DistrictReplaces
-----------------------------------------------------------------------------------
INSERT INTO DistrictReplaces
            (CivUniqueDistrictType,                    ReplacesDistrictType)
VALUES        ('DISTRICT_ZZZ_HERITAGE',                'DISTRICT_THEATER');
-----------------------------------------------------------------------------------
-- District_GreatPersonPoints
-----------------------------------------------------------------------------------
INSERT INTO District_GreatPersonPoints
            (DistrictType,                            GreatPersonClassType,            PointsPerTurn)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'GREAT_PERSON_CLASS_WRITER',    '1'),
            ('DISTRICT_ZZZ_HERITAGE',                'GREAT_PERSON_CLASS_ARTIST',    '1'),
            ('DISTRICT_ZZZ_HERITAGE',                'GREAT_PERSON_CLASS_MUSICIAN',    '1');
-----------------------------------------------------------------------------------
-- District_TradeRouteYields
-----------------------------------------------------------------------------------
INSERT INTO District_TradeRouteYields
            (DistrictType,                            YieldType,            YieldChangeAsOrigin,    YieldChangeAsDomesticDestination,    YieldChangeAsInternationalDestination)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'YIELD_FOOD',        '0',                    '1',                                '0'),
            ('DISTRICT_ZZZ_HERITAGE',                'YIELD_CULTURE',    '0',                    '0',                                '1');
-----------------------------------------------------------------------------------
-- District_ValidTerrains
-----------------------------------------------------------------------------------
INSERT INTO District_ValidTerrains
            (DistrictType,                            TerrainType)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'TERRAIN_GRASS_HILLS'),
            ('DISTRICT_ZZZ_HERITAGE',                'TERRAIN_PLAINS_HILLS'),
            ('DISTRICT_ZZZ_HERITAGE',                'TERRAIN_TUNDRA_HILLS'),
            ('DISTRICT_ZZZ_HERITAGE',                'TERRAIN_SNOW_HILLS'),
            ('DISTRICT_ZZZ_HERITAGE',                'TERRAIN_DESERT_HILLS');
-----------------------------------------------------------------------------------
-- District_Adjacencies
-----------------------------------------------------------------------------------
INSERT INTO District_Adjacencies
            (DistrictType,                            YieldChangeId)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'Wonder_Culture'),
            ('DISTRICT_ZZZ_HERITAGE',                'District_Culture_Standard'),
            ('DISTRICT_ZZZ_HERITAGE',                'District_Culture_City_Center');
-----------------------------------------------------------------------------------
-- District_CitizenYieldChanges
-----------------------------------------------------------------------------------
INSERT INTO District_CitizenYieldChanges
            (DistrictType,                            YieldType,            YieldChange)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'YIELD_CULTURE',    '2');
-----------------------------------------------------------------------------------
-- DistrictModifiers
-----------------------------------------------------------------------------------
INSERT INTO DistrictModifiers
            (DistrictType,                            ModifierId)
VALUES         ('DISTRICT_ZZZ_HERITAGE',                'CIVIC_AWARD_ONE_INFLUENCE_TOKEN');
--==========================================================================================================================
-- TraitModifiers
--==========================================================================================================================

--==========================================================================================================================
-- Modifiers
--==========================================================================================================================
-- Modifiers
-------------------------------------

-------------------------------------
-- ModifierArguments
-------------------------------------


--==========================================================================================================================
-- Requirements
--==========================================================================================================================
-- RequirementSets
-------------------------------------

-------------------------------------
-- RequirementSetRequirements
-------------------------------------

-------------------------------------
-- Requirements
-------------------------------------

-------------------------------------
-- RequirementArguments
-------------------------------------

--==========================================================================================================================
--==========================================================================================================================
 
Last edited:
Since CIVIC_AWARD_ONE_INFLUENCE_TOKEN is already defined and used by the game you will not need Modifiers, ModifierArguments, Requirements, RequirementSets, etc. Any that are needed are already pre-created within the game's base files. But you also will not be able to fine-tune under what conditions the extra 'token' is granted: you are stuck with the way the game implements this Modifier for the Acropolis and various Civics.

Also, there is no such thing as 'false' or 'true' in SQL. For Boolean columns in SQL you need to state numerical 0 for false and numerical 1 for true.

In SQL this is a text-string:
Code:
'1'
Whereas this is a number in SQL:
Code:
1
For columns where integer values are expected you should supply integer values as well instead of text-string values.
 
ahhh, you're very helpful, and i can't thank you enough!

so, I'll be replacing my integers with no-quoted numbers, and replacing my trues and falses with single-quoted '1' and '0' respectively? (I'll be trying this out shortly.)
 
Well, it's invisible, I should mention, but maybe I can figure that one out :crazyeye:
 
Invisible district means an incomplete or non-existent artdef, but I am as yet unworthy of providing any more guidance than that re artdefs

For true and false you want numerical 1 and 0, not text '1' and '0' as a general rule
 
Ah, thanks a million! You're both incredibly helpful. I'll be trying these things out.
 
Back
Top Bottom