[BNW] Having issues with a custom civilization. Can trade artwork for help!

Nickify · Oct 19, 2018

I've lurked on these forums for some time now. I've been using them as a resource to learn about the game and to start the process of making my own civilizations and mods for Civ V. Lately I've tried my hand at making custom civilizations for me and my friends to play with in our custom games. Currently I am working on a custom James K. Polk's USA civilization. I haven't designed any artwork for the civ other than this base pic because I'd like to get the coding out of the way first.

I've added my civ's UA, UU and UB. Because I'm new to this and their trait is 2-parter, I wanted to try and add one part before the other and then test it. I added a custom building to my civ called the Stockpile which provides +1 food from plains. Each city gets that building for free (I took a page out of Carthage's trait for this) upon founding. This works just fine as all plains give me the +1 food I was hoping for. I am unsure of how to code the 2nd part for the trait. It is supposed to grant +1 food per city connected to the capital. Similar to the pantheon belief Messenger of the Gods which grants +2 science in cities connected to the capital. I tried pouring through the game files to find how they coded these beliefs, but wasn't able to find anything. Any help here is appreciated.

The UU should be an easy fix after test playing, so my next focus is regarding the Fort for my civ. I built walls in my test city and upon completion, it bricked my game. Here's my Fire Tuner error code:

Runtime Error: Assets\DLC\Expansion2\UI\InGame\InfoTooltipInclude.lua:277: attempt to compare number with nil

Spoiler Screenshot :

I looked into the Database.log and am absolutely clueless as to how to proceed. If you have experience coding this game, I don't mind working out some kind of deal. I do a lot of graphic design work on the side and can possibly design you some artwork for your own stuff as a form of payment for your time. This isn't the only civilization I hope to create, but I'd like to use the experience gained from making this one, in making others. Below are the XML files that I used.

Spoiler Trait.xml :

Spoiler Units.xml :

Spoiler Civilization.xml :

Spoiler Buildings.xml :

Spoiler Plains.xml :

Spoiler Leader.xml :

Spoiler Database.log :

Enginseer · Oct 19, 2018

Umm you're supposed to turn that into a mod, not put files inside a DLC.

Or maybe I misread it.

Either way, you have a lot of dangling xml columns which you are just supposed to omit it as you can see in other people's civ mods because omitting it and leaving it to be defaulted is better than defining it and leaving it blank.

Your first part of the UA is doable. Just need to see if I remember the code for city connections now...

Nickify · Oct 19, 2018

Enginseer said:
Umm you're supposed to turn that into a mod, not put files inside a DLC.

Or maybe I misread it.

Either way, you have a lot of dangling xml columns which you are just supposed to omit it as you can see in other people's civ mods because omitting it and leaving it to be defaulted is better than defining it and leaving it blank.

Your first part of the UA is doable. Just need to see if I remember the code for city connections now...

The reason I had everything lumped into my DLC folder, was because I found out on some forum that by linking .xml files in Expansion2.Civ5Pkg the game recognizes it add additional stuff to load. Most anything you add can be played without mods. You can host a multiplayer game assuming the others in your game have the same files as you and their linked in the Civ5Pkg file. Since that's what I'm trying to do with this once it's finished I'm testing it there.

I'm really clueless on how coding works I just sorta went "monkey see, monkey do" when making it. I copy stuff from other civs and tweak it for my own use. I'm not quite sure what you mean by dangling xml columns, but I think I follow you. My issue is that aside from the obvious ones to remove, I'm not sure which lines are unnecessary. I'll take a thorough look and clean up as much as I can and then test it again. Thanks for taking the time to reply!

LeeS · Oct 19, 2018

You will need to use the MP workaround method to convert an actual mod into a "fake" DLC in order to get this to work. Simply plopping files into the DLC folder will not work properly.

These error lines in Database.log

Code:

[771825.227] no such table: IconTextureAtlases
 [771825.227] In Query - insert into IconTextureAtlases('Atlas', 'IconSize', 'Filename', 'IconsPerRow', 'IconsPerColumn') values (?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table IconTextureAtlases from file Assets\DLC\Expansion2\Polk USA\XML\PolkAtlas.xml.
 [771825.227] no such table: Buildings
[771825.227] 
 [771825.227] In XMLSerializer while updating table Buildings from file Assets\DLC\Expansion2\Polk USA\XML\PolkBuildings.xml.
 [771825.227] no such table: Civilizations
 [771825.227] In Query - insert into Civilizations('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'Strategy', 'Playable', 'AIPlayable', 'ShortDescription', 'Adjective', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'DerivativeCiv', 'PortraitIndex', 'IconAtlas', 'AlphaIconAtlas', 'MapImage', 'DawnOfManQuote', 'DawnOfManImage', 'DawnOfManAudio', 'SoundtrackTag') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Civilizations from file Assets\DLC\Expansion2\Polk USA\XML\PolkCivilization.xml.
 [771825.227] no such table: Leaders
 [771825.227] In Query - insert into Leaders('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'ArtDefineTag', 'VictoryCompetitiveness', 'WonderCompetitiveness', 'MinorCivCompetitiveness', 'Boldness', 'DiploBalance', 'WarmongerHate', 'WorkAgainstWillingness', 'WorkWithWillingness', 'DenounceWillingness', 'DoFWillingness', 'Loyalty', 'Neediness', 'Forgiveness', 'Chattiness', 'Meanness', 'PortraitIndex', 'IconAtlas') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Leaders from file Assets\DLC\Expansion2\Polk USA\XML\PolkLeader.xml.
 [771825.227] no such table: BuildingClasses
 [771825.227] In Query - insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);
 [771825.227] In XMLSerializer while updating table BuildingClasses from file Assets\DLC\Expansion2\Polk USA\XML\PolkPlains.xml.
 [771825.227] no such table: Traits
 [771825.227] In Query - insert into Traits('Type', 'Description', 'ShortDescription', 'FreeBuilding') values (?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Traits from file Assets\DLC\Expansion2\Polk USA\XML\PolkTrait.xml.
 [771825.227] no such table: Units
 [771825.227] 
 [771825.227] In XMLSerializer while updating table Units from file Assets\DLC\Expansion2\Polk USA\XML\PolkUnits.xml.

Indicate that your files are loading before the game has a chance to load the base XML files that define tables "IconTextureAtlases", "Buildings", etc. Hence the errors:

Code:

[771825.227] no such table: IconTextureAtlases
 [771825.227] no such table: Buildings
[771825.227] no such table: Civilizations
 [771825.227] no such table: Leaders
[771825.227] no such table: BuildingClasses
 [771825.227] no such table: Traits
 [771825.227] no such table: Units

You are likely getting incomplete information loaded into the game's database, which is almost certainly the root cause of the error being reported in the lua log, and the lock-up of the UI and therefore the game.

----------------------

You also have references to CIVILATION_CARTHAGE remaining in your code, and an attempt to do this

Code:

[771840.093] column UnitType is not unique
 [771840.093] While executing - 'insert into UnitGameplay2DScripts('UnitType', 'SelectionSound', 'FirstSelectionSound') values (?, ?, ?);'
 [771840.093] In XMLSerializer while inserting row into table insert into UnitGameplay2DScripts('UnitType', 'SelectionSound', 'FirstSelectionSound') with values (UNIT_CELT_PICTISH_WARRIOR, AS2D_SELECT_SWORDSMAN, AS2D_BIRTH_SWORDSMAN, ).
 [771840.093] In XMLSerializer while updating table UnitGameplay2DScripts from file Assets\DLC\Expansion2\Polk USA\XML\PolkUnits.xml.
 [771840.093] column UnitType is not unique

Which is saying there is a repeat-attempt to add a row in table "UnitGameplay2DScripts" with a non-unique designation for the "UnitType" column: UNIT_CELT_PICTISH_WARRIOR. The game already has this information so you cannot attempt to add it a second time. This error is being encountered within file "PolkUnits.xml" and will cause the game to reject the entire contents of the file where this error occurs.

Second, by making the Settler Replacement not available until Tech Navigation you are essentially lobotomizing the civ by not making it able to create settlers until the game is half over.

LeeS · Oct 19, 2018

Messenger to the Gods uses the following to create its effect:

Code:

	<Belief_YieldChangeTradeRoute>
		<Row>
			<BeliefType>BELIEF_MESSENGER_GODS</BeliefType>
			<YieldType>YIELD_SCIENCE</YieldType>
			<Yield>2</Yield>
		</Row>
	</Belief_YieldChangeTradeRoute>

This won't be usable in creating the UA.

The Traits Schame of tables has nothing specific to cities connected to the capital. Neither of these two tables are for city-connections to the capital:

Code:

	<Table name="Trait_YieldChangesPerTradePartner">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>
	<Table name="Trait_YieldChangesIncomingTradeRoute">
		<Column name="TraitType" type="text" reference="Traits(Type)"/>
		<Column name="YieldType" type="text" reference="Yields(Type)"/>
		<Column name="Yield" type="integer"/>
	</Table>

As they are relating to trading-partner civilizations and incoming trade routes (Caravan and Cargo Ship) from other civs.

Nickify · Oct 19, 2018

LeeS said:

You will need to use the MP workaround method to convert an actual mod into a "fake" DLC in order to get this to work. Simply plopping files into the DLC folder will not work properly.

These error lines in Database.log

Code:

[771825.227] no such table: IconTextureAtlases
 [771825.227] In Query - insert into IconTextureAtlases('Atlas', 'IconSize', 'Filename', 'IconsPerRow', 'IconsPerColumn') values (?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table IconTextureAtlases from file Assets\DLC\Expansion2\Polk USA\XML\PolkAtlas.xml.
 [771825.227] no such table: Buildings
[771825.227]
 [771825.227] In XMLSerializer while updating table Buildings from file Assets\DLC\Expansion2\Polk USA\XML\PolkBuildings.xml.
 [771825.227] no such table: Civilizations
 [771825.227] In Query - insert into Civilizations('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'Strategy', 'Playable', 'AIPlayable', 'ShortDescription', 'Adjective', 'DefaultPlayerColor', 'ArtDefineTag', 'ArtStyleType', 'ArtStyleSuffix', 'ArtStylePrefix', 'DerivativeCiv', 'PortraitIndex', 'IconAtlas', 'AlphaIconAtlas', 'MapImage', 'DawnOfManQuote', 'DawnOfManImage', 'DawnOfManAudio', 'SoundtrackTag') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Civilizations from file Assets\DLC\Expansion2\Polk USA\XML\PolkCivilization.xml.
 [771825.227] no such table: Leaders
 [771825.227] In Query - insert into Leaders('Type', 'Description', 'Civilopedia', 'CivilopediaTag', 'ArtDefineTag', 'VictoryCompetitiveness', 'WonderCompetitiveness', 'MinorCivCompetitiveness', 'Boldness', 'DiploBalance', 'WarmongerHate', 'WorkAgainstWillingness', 'WorkWithWillingness', 'DenounceWillingness', 'DoFWillingness', 'Loyalty', 'Neediness', 'Forgiveness', 'Chattiness', 'Meanness', 'PortraitIndex', 'IconAtlas') values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Leaders from file Assets\DLC\Expansion2\Polk USA\XML\PolkLeader.xml.
 [771825.227] no such table: BuildingClasses
 [771825.227] In Query - insert into BuildingClasses('Type', 'DefaultBuilding', 'Description') values (?, ?, ?);
 [771825.227] In XMLSerializer while updating table BuildingClasses from file Assets\DLC\Expansion2\Polk USA\XML\PolkPlains.xml.
 [771825.227] no such table: Traits
 [771825.227] In Query - insert into Traits('Type', 'Description', 'ShortDescription', 'FreeBuilding') values (?, ?, ?, ?);
 [771825.227] In XMLSerializer while updating table Traits from file Assets\DLC\Expansion2\Polk USA\XML\PolkTrait.xml.
 [771825.227] no such table: Units
 [771825.227]
 [771825.227] In XMLSerializer while updating table Units from file Assets\DLC\Expansion2\Polk USA\XML\PolkUnits.xml.

Indicate that your files are loading before the game has a chance to load the base XML files that define tables "IconTextureAtlases", "Buildings", etc. Hence the errors:

Code:

[771825.227] no such table: IconTextureAtlases
 [771825.227] no such table: Buildings
[771825.227] no such table: Civilizations
 [771825.227] no such table: Leaders
[771825.227] no such table: BuildingClasses
 [771825.227] no such table: Traits
 [771825.227] no such table: Units

You are likely getting incomplete information loaded into the game's database, which is almost certainly the root cause of the error being reported in the lua log, and the lock-up of the UI and therefore the game.

----------------------

You also have references to CIVILATION_CARTHAGE remaining in your code, and an attempt to do this

Code:

[771840.093] column UnitType is not unique
 [771840.093] While executing - 'insert into UnitGameplay2DScripts('UnitType', 'SelectionSound', 'FirstSelectionSound') values (?, ?, ?);'
 [771840.093] In XMLSerializer while inserting row into table insert into UnitGameplay2DScripts('UnitType', 'SelectionSound', 'FirstSelectionSound') with values (UNIT_CELT_PICTISH_WARRIOR, AS2D_SELECT_SWORDSMAN, AS2D_BIRTH_SWORDSMAN, ).
 [771840.093] In XMLSerializer while updating table UnitGameplay2DScripts from file Assets\DLC\Expansion2\Polk USA\XML\PolkUnits.xml.
 [771840.093] column UnitType is not unique

Which is saying there is a repeat-attempt to add a row in table "UnitGameplay2DScripts" with a non-unique designation for the "UnitType" column: UNIT_CELT_PICTISH_WARRIOR. The game already has this information so you cannot attempt to add it a second time. This error is being encountered within file "PolkUnits.xml" and will cause the game to reject the entire contents of the file where this error occurs.

Second, by making the Settler Replacement not available until Tech Navigation you are essentially lobotomizing the civ by not making it able to create settlers until the game is half over.

Thank you for taking the time to reply. There's a lot to go over, but I appreciate your help. I know you submitted multiple replies, I'll do my best to address those issues you brought up. The coding for this is incredibly sloppy. I'm doing my best to tidy it up, I feel bad asking for help and having this many careless errors in my files. I'm browsing the MPPatch and MPMPM pages on the forum in order to change the way my files are added to the database.

I also wanted to try and clarify a little. My original intention was to have the Wagon Train be an upgraded settler for this civ. My coding is just garbage though. Because I'm not entirely sure how to add an entirely separate unit, I'll add a base settler to my Units.xml and set the obsolete tech to Navigation and then have the Wagon Train be available after that point with the added benefits I had hoped for. If you think this might be bad coding or you have an alternative suggestion to this, please let me know. I'll plug away through the night and try my best to correct the issues you've highlighted.

As far as the 2nd part of the UA is concerned, I'll try and browse the mod workshop in hopes that another civ has a similar feature. If not, I can always tweak my UA a little.

[BNW] Having issues with a custom civilization. Can trade artwork for help!

Nickify

Chieftain

Enginseer

Salientia of the Community Patch

Nickify

Chieftain

LeeS

Imperator

LeeS

Imperator

Nickify

Chieftain

Similar threads