Help with mod + A question

OTiger

Warlord
Joined
Aug 26, 2012
Messages
178
1.) I've been making a mod recently and I'm been trying to make the Civ's Unique Unit to not replace any unit. I've got problems making it work. I looked into the database logs and it looks like I messed up.

I can't upload my mod, so here's a link from Mediafire.

http://www.mediafire.com/download/j3i3c07scfucciu/Spongebob_Squarepants_Plankton_and_the_Chum_Bucket_Civilization_(v_1).rar

2.) I'm thinking to add a new part to my Civ's Unique Trait. Is it possible to increase spying effectiveness by XML or with a dummy building? I'm not a expert with Lua, btw.

Database:
Spoiler :
[17667.394] columns StrategicViewType, TileType are not unique
[17667.394] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[17671.387] no such table: ContentPackage.LocalizedText
[17671.387] no such table: ContentPackage.LocalizedText
[17671.387] no such table: ContentPackage.LocalizedText
[17673.446] no such table: ContentPackage.LocalizedText
[17676.223] columns StrategicViewType, TileType are not unique
[17676.223] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
[17677.502] no such table: ContentPackage.LocalizedText
[17677.502] no such table: ContentPackage.LocalizedText
[17677.502] no such table: ContentPackage.LocalizedText
[17685.895]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8555088 78221896
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8133216 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[17686.784]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8556264 78221896
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8134392 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[17771.150] table Units has no column named UnitClassType
[17771.150]
[17771.150] In XMLSerializer while updating table Units from file XML/Units.xml.
[17773.739]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8640968 78221896
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8214360 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
------------------------------
[17792.272] no such column: Type
[17792.272] In Query - select * from Natural_Wonder_Placement where Type = ? LIMIT 1

XML:
Spoiler :
[17685.022] *** SKIPPING Game Database Validation. ****
[17685.022] You can enable it by setting 'ValidateGameDatabase = 1' in config.ini
[17685.895] **** Validating Prefetch Process *****
[17685.895] **** Validation Success *****
[17685.895] SetGlobalActionInfo
[17685.895]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8555088 78221896
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8133216 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[17685.942] *** SKIPPING Game Database Validation. ****
[17685.942] You can enable it by setting 'ValidateGameDatabase = 1' in config.ini
[17686.784] **** Validating Prefetch Process *****
[17686.784] **** Validation Success *****
[17686.784] SetGlobalActionInfo
[17686.784]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8556264 78221896
PageCache: 6 12
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8134392 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 6
------------------------------
[17772.835] *** SKIPPING Game Database Validation. ****
[17772.835] You can enable it by setting 'ValidateGameDatabase = 1' in config.ini
[17773.739] **** Validating Prefetch Process *****
[17773.739] **** Validation Success *****
[17773.739] SetGlobalActionInfo
[17773.739]
-- SQLite Memory Statistics --
Memory Usage:
[Cur] [Max]
Malloc: 8640968 78221896
PageCache: 7 13
LookAside: 0 0
Scratch: 0 1

Static Buffer Overflows:
[TooLarge] [NoSpace]
PageCache: 8214360 65347968
Scratch: 0 0

Largest Allocations:
Malloc: 262144
PageCache: 1172
Scratch: 6664

Prepared Statements:
Current: 8
------------------------------
 
1st: You want <Class>, not <UnitClassType> in the <Units> table.

Haven't looked at the mod as yet for other errors, if any. I may edit this post later.

.............................................................................................................................................


Code:
    <File md5="30C1780A3F9B1B47D402635DFD1FE34B" import="0">Art/Plankton.dds</File>
DDS files are always "Import Into VFS="true" in ModBuddy.

.............................................................................................................................................

Blue for Good, Red for Bad. Can't have the same file "entered" into the game in two different and conflicting ways. Leaderscene XML files are always set as "Import Into VFS=true" and never as "OnModActivated".
Spoiler :
Code:
    [COLOR="Blue"]<File md5="6085067610065FF1403C74D02A8D1126" import="1">XML/Plankton_Scene.xml</File>[/COLOR]
    <File md5="2C1595D4A4A9DE6EA4D6E87570A16AF5" import="0">XML/Sounds.xml</File>
    <File md5="EB7AE4723A60729C89D98C86E644AD23" import="0">XML/Promotions.xml</File>
    <File md5="BCCA1460F8BF8513F52D078585AF79C7" import="0">XML/Leader.xml</File>
    <File md5="1C53D6A412CFD079F687326D1FA62D87" import="0">XML/Trait.xml</File>
    <File md5="FC82BFA3FF7C3EA1CC3A757F055AACEC" import="0">XML/Units.xml</File>
  </Files>
  <Actions>
    <OnModActivated>
      <UpdateDatabase>XML/Buildings.xml</UpdateDatabase>
      <UpdateDatabase>XML/Civilization.xml</UpdateDatabase>
      <UpdateDatabase>XML/DiplomacyResponses.xml</UpdateDatabase>
      <UpdateDatabase>XML/Leader.xml</UpdateDatabase>
      <UpdateDatabase>XML/Trait.xml</UpdateDatabase>
      <UpdateDatabase>XML/Units.xml</UpdateDatabase>
      <UpdateDatabase>XML/Promotions.xml</UpdateDatabase>
      <UpdateDatabase>XML/Sounds.xml</UpdateDatabase>
      <UpdateDatabase>XML/CIV5IconTextureAtlases_Plankton.xml</UpdateDatabase>
      [COLOR="Red"]<UpdateDatabase>XML/Plankton_Scene.xml</UpdateDatabase>[/COLOR]
    </OnModActivated>
  </Actions>

.............................................................................................................................................

Code:
	<Building_ClassesNeededInCity>
		<Row>
			<BuildingType>BUILDING_HOSPITAL</BuildingType>
			<BuildingClassType>BUILDINGCLASS_AQUEDUCT</BuildingClassType>
		</Row>
	</Building_ClassesNeededInCity>
needs to be
Code:
	<Building_ClassesNeededInCity>
		<Row>
			<BuildingType>BUILDING_CHUM_BUCKET</BuildingType>
			<BuildingClassType>BUILDINGCLASS_AQUEDUCT</BuildingClassType>
		</Row>
	</Building_ClassesNeededInCity>

.............................................................................................................................................

not sure if there are any other errors.
 
1. Your code for the Plankton Mech has an error. The first line says:

Code:
<UnitClassType>UNITCLASS_PLANKTON_MECH</UnitClassType>

It should be:

Code:
<Class>UNITCLASS_PLANKTON_MECH</Class>

To make it unique to your civ, you would either have it replace a standard unit, or change UNITCLASS_PLANKTON_MECH to have no default unit.

2. You could use a free or dummy building to promote all of your spies, similar to the way the National Intelligence Agency works.
 
Top Bottom