GPuzzle's Civs

GPuzzle · Jun 4, 2015

I'll probably just use the Vanilla Rome E&D for now, and when the time is right I'll actually come up with some good ideas and implement them.

DoctorMcGann · Jun 4, 2015

Slightly modified the nose, removed pylons. I think it's good enough now.

Spoiler :

Full res version

GPuzzle · Jun 4, 2015

So I'm having a few troubles...

Initially, it was working, but the names of the UAs weren't showing. Change some things, suddenly there's a single problem on the log, but Augustus is working. Change that problem, 4 other problems appear, and now neither is working.

What the hell?

Natan35 · Jun 4, 2015

I think that nose is big... On the other hand, I'm a Jew.

That's some LS, Doc McStuff.

SnowyNix · Jun 4, 2015

Natan35 said:
I think that nose is big... On the other hand, I'm a Jew.
That's some LS, Doc McStuff.

Self-aware racist humour, I wasn't expecting that from you Natan

Natan35 · Jun 4, 2015

That's because in have a (pretty) small nose...

DoctorMcGann · Jun 4, 2015

Natan, the dude had a big nose.

GPuzzle · Jun 4, 2015

Oh, Gods...

Apparently a single syntax error I cannot identify is screwing up the entire system and causing it to not work. Also, the CIV Traits support seems to have some trouble working.

[7384.750] near "Yield": syntax error
[7384.750] near ",": syntax error

How the hell do I find that one?

DoctorMcGann · Jun 4, 2015

Why don't you post your built mod and see if someone can figure it out? As LeeS says, there's no way anyone can help you if they can't see what you need help with.

GPuzzle · Jun 4, 2015

The main code.

Spoiler :

Code:

--==========================================================================================================================	
-- BuildingClasses
--==========================================================================================================================	
INSERT INTO BuildingClasses 	
			(Type, 						 		DefaultBuilding, 					Description)
VALUES		('BUILDINGCLASS_GPUZ_PRAETOR', 		'BUILDING_GPUZ_PRAETOR', 			'TXT_KEY_BUILDING_GPUZ_PRAETOR');
--==========================================================================================================================	
-- Buildings
--==========================================================================================================================	
INSERT INTO Buildings 	
			(Type, 						BuildingClass, FreeBuilding,				 PrereqTech, Cost, GoldMaintenance, MinAreaSize, Description, 						Civilopedia, 							Help, 									Strategy,									ArtDefineTag, PortraitIndex, 	IconAtlas)
SELECT		('BUILDING_GPUZ_FORUM'),	BuildingClass, ('BUILDINGCLASS_COURTHOUSE'), PrereqTech, Cost, GoldMaintenance, MinAreaSize, ('TXT_KEY_BUILDING_GPUZ_FORUM'), 	('TXT_KEY_CIV5_GPUZ_FORUM_TEXT'),		('TXT_KEY_BUILDING_GPUZ_FORUM_HELP'), 	('TXT_KEY_BUILDING_GPUZ_FORUM_STRATEGY'),	ArtDefineTag, 31, 				('GPUZ_NEWROME_ATLAS')
FROM Buildings WHERE Type = 'BUILDING_MARKET';		

INSERT INTO Buildings 	
			(Type, 						 	BuildingClass, 					GoldenAgeModifier, NoOccupiedUnhappiness,	GreatWorkCount, Cost,		 FaithCost,  PrereqTech,						Description, 						Help)
VALUES		('BUILDING_GPUZ_PRAETORIUM', 	'BUILDINGCLASS_GPUZ_PRAETOR',	10,				   0,						-1, 				-1,				-1, 		 null, 		 'TXT_KEY_BUILDING_GPUZ_PRAETOR', 	'TXT_KEY_BUILDING_GPUZ_PRAETOR_HELP'),
			('BUILDING_GPUZ_RENDER_CAESAR', 'BUILDINGCLASS_GPUZ_PRAETOR',	0,				   1,						-1, 				-1,				-1, 		 null, 		 'TXT_KEY_BUILDING_GPUZ_PRAETOR', 	'TXT_KEY_BUILDING_GPUZ_PRAETOR_HELP'),
			('BUILDING_GPUZ_ROME_GOLD',		'BUILDINGCLASS_GPUZ_PRAETOR',	0,				   0,						-1, 				-1,				-1, 		 null, 		 'TXT_KEY_BUILDING_GPUZ_PRAETOR', 	'TXT_KEY_BUILDING_GPUZ_PRAETOR_HELP');
--==========================================================================================================================	
-- Building_YieldChanges
--==========================================================================================================================	
INSERT INTO Building_YieldChanges 	
			(BuildingType, 			YieldType, Yield)
VALUES		('BUILDING_GPUZ_FORUM',	'YIELD_GOLD', 1);

INSERT INTO Building_YieldChanges 	
			(BuildingType, 				YieldType, Yield)
VALUES		('BUILDING_GPUZ_ROME_GOLD',	'YIELD_GOLD', 2);	
--==========================================================================================================================	
-- Building_Flavors
--==========================================================================================================================	
INSERT INTO Building_Flavors 	
			(BuildingType, 				FlavorType, Flavor)
SELECT		('BUILDING_GPUZ_FORUM'),	FlavorType, Flavor
FROM Building_Flavors WHERE BuildingType = 'BUILDING_MARKET';

INSERT INTO Building_Flavors
			(BuildingType,			FlavorType,			Flavor)
VALUES		('BUILDING_GPUZ_FORUM',	'FLAVOR_HAPPINESS',	60);
--==========================================================================================================================	
-- Building_YieldModifiers
--==========================================================================================================================	
INSERT INTO Building_YieldModifiers
			(BuildingType,			YieldType,		Yield)
VALUES		('BUILDING_GPUZ_FORUM',	'YIELD_GOLD',	25);
--==========================================================================================================================	
-- Building_YieldChangesPerPops
--==========================================================================================================================	
INSERT INTO Building_YieldChangesPerPop
			(BuildingType,					YieldType,			Yield)
VALUES		('BUILDING_GPUZ_RENDER_CAESAR',	'YIELD_PRODUCTION',	50);
--==========================================================================================================================	
-- Colors
--==========================================================================================================================			
INSERT OR REPLACE INTO Colors 
			(Type, 									Red, 	Green, 	Blue, 	Alpha)
VALUES		('COLOR_PLAYER_GPUZ_ROME_ICON', 		0.643, 	0.505, 	0.207, 	1),
			('COLOR_PLAYER_GPUZ_ROME_BACKGROUND',	0.533,	0,		0, 		1);
--==========================================================================================================================	
-- PlayerColors
--==========================================================================================================================					
INSERT OR REPLACE INTO PlayerColors 
			(Type, 						PrimaryColor, 					SecondaryColor, 						TextColor)
VALUES		('PLAYERCOLOR_GPUZ_ROME',	'COLOR_PLAYER_GPUZ_ROME_ICON',	'COLOR_PLAYER_GPUZ_ROME_BACKGROUND', 	'COLOR_PLAYER_WHITE_TEXT');
--==========================================================================================================================
-- UnitPromotions
--==========================================================================================================================	
INSERT INTO UnitPromotions 
			(Type, 							Description, 							Help, 										Sound, 				CannotBeChosen, PortraitIndex, 	IconAtlas, 			PediaType, 			PediaEntry)
VALUES		('PROMOTION_GPUZ_PRAETORIUM', 	'TXT_KEY_PROMOTION_GPUZ_PRAETORIUM',	'TXT_KEY_PROMOTION_GPUZ_PRAETORIUM_HELP', 	'AS2D_IF_LEVELUP', 	1, 				59, 			'ABILITY_ATLAS', 	'PEDIA_ATTRIBUTES', 'TXT_KEY_PROMOTION_GPUZ_PRAETORIUM');
--==========================================================================================================================	
-- Traits
--==========================================================================================================================	
INSERT INTO Traits 
			(Type, 							Description, 						ShortDescription)
VALUES		('TRAIT_GPUZ_ROME_REPUBLIC', 	'TXT_KEY_TRAIT_GPUZ_ROME_REPUBLIC', 'TXT_KEY_TRAIT_GPUZ_ROME_REPUBLIC_SHORT');

INSERT INTO Traits 
			(Type, 							Description, 						ShortDescription,							CapitalBuildingModifier)
VALUES		('TRAIT_GPUZ_ROME_EMPIRE', 		'TXT_KEY_TRAIT_GPUZ_ROME_EMPIRE', 	'TXT_KEY_TRAIT_GPUZ_ROME_EMPIRE_SHORT',		 25);
--==========================================================================================================================	
-- Trait_ImprovementYieldChanges
--==========================================================================================================================
INSERT INTO Traits_ImprovementYieldChanges
			(TraitType, 					ImprovementType, 			YieldType			Yield)
VALUES		('TRAIT_GPUZ_ROME_EMPIRE',		'IMPROVEMENT_PLANTATION',	'YIELD_PRODUCTION',	2),
			('TRAIT_GPUZ_ROME_EMPIRE', 		'IMPROVEMENT_PLANTATION', 	'YIELD_GOLD',		1);
--==========================================================================================================================	
-- Leader_Traits
--==========================================================================================================================	
DELETE FROM Leader_Traits WHERE LeaderType = 'LEADER_AUGUSTUS';
INSERT INTO Leader_Traits
			(LeaderType,		TraitType),
VALUES		('LEADER_AUGUSTUS', 'TRAIT_GPUZ_ROME_EMPIRE');
--==========================================================================================================================
-- Units
--==========================================================================================================================	
INSERT INTO Units 	
			(Type, 					 Class, Cost, Moves,	FaithCost,	CivilianAttackPriority, Special, MoveAfterPurchase, Domain, DefaultUnitAI, Description, 					Civilopedia, 						Help, 								Strategy,								AdvancedStartCost,	WorkRate,	CombatLimit, UnitArtInfoEraVariation, UnitArtInfo, 						UnitFlagIconOffset,	UnitFlagAtlas,	MoveRate, PortraitIndex, 	IconAtlas)
SELECT		('UNIT_GPUZ_PRAETOR'),	 Class, Cost, Moves,	FaithCost,	CivilianAttackPriority, Special, MoveAfterPurchase,	Domain, DefaultUnitAI, ('TXT_KEY_UNIT_GPUZ_PRAETOR'), 	('TXT_KEY_CIV5_GPUZ_PRAETOR_TEXT'), ('TXT_KEY_UNIT_GPUZ_PRAETOR_HELP'), ('TXT_KEY_UNIT_GPUZ_PRAETOR_STRATEGY'),	AdvancedStartCost, 	100,		CombatLimit, 0,						  ('ART_DEF_UNIT_GREAT_GENERAL'),	0,					UnitFlagAtlas,	MoveRate, 1, 				('GPUZ_NEWROME_ATLAS')
FROM Units WHERE (Type = 'UNIT_GREAT_GENERAL');	
--==========================================================================================================================
-- UnitGameplay2DScripts
--==========================================================================================================================	
INSERT INTO UnitGameplay2DScripts 	
			(UnitType, 				SelectionSound, FirstSelectionSound)
SELECT		('UNIT_GPUZ_PRAETOR'), 	SelectionSound, FirstSelectionSound
FROM UnitGameplay2DScripts WHERE (UnitType = 'UNIT_GREAT_GENERAL');	
--==========================================================================================================================
-- Unit_AITypes
--==========================================================================================================================	
INSERT INTO Unit_AITypes 	
			(UnitType, 				UnitAIType)
SELECT		('UNIT_GPUZ_PRAETOR'), 	UnitAIType
FROM Unit_AITypes WHERE (UnitType = 'UNIT_GREAT_GENERAL');
--==========================================================================================================================
-- Unit_Flavors
--==========================================================================================================================
INSERT INTO Unit_Flavors 	
			(UnitType, 				FlavorType, Flavor)
SELECT		('UNIT_GPUZ_PRAETOR'), 	FlavorType, Flavor
FROM Unit_Flavors WHERE (UnitType = 'UNIT_GREAT_GENERAL');
--==========================================================================================================================
-- Unit_Builds
--==========================================================================================================================
INSERT INTO Unit_Builds 	
			(UnitType, 				BuildType)
SELECT		('UNIT_GPUZ_PRAETOR'), 	BuildType
FROM Unit_Builds WHERE (UnitType = 'UNIT_GREAT_GENERAL');
--==========================================================================================================================
-- Unit_FreePromotions
--==========================================================================================================================	
INSERT INTO Unit_FreePromotions 
			(UnitType, 				PromotionType)
VALUES		('UNIT_GPUZ_PRAETOR', 	'PROMOTION_GPUZ_PRAETORIUM');

INSERT INTO Unit_FreePromotions 	
			(UnitType, 				UnitType)
SELECT		('UNIT_GPUZ_PRAETOR'),  UnitType
FROM Unit_FreePromotions WHERE (UnitType = 'UNIT_GREAT_GENERAL');
--==========================================================================================================================
-- Unit_UniqueNames
--==========================================================================================================================
INSERT INTO Unit_UniqueNames 
			(UnitType, 					UniqueName)
VALUES		('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_1'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_2'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_3'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_4'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_5'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_6'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_7'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_8'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_9'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_10'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_11'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_12'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_13'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_14'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_15'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_16'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_17'),
			('UNIT_GPUZ_PRAETOR', 		'TXT_KEY_GREAT_PERSON_GPUZ_PRAETOR_18');
--==========================================================================================================================	
-- Unit_FreePromotions 
--==========================================================================================================================	
INSERT INTO Unit_FreePromotions 
			(UnitType, 					PromotionType)
VALUES		('UNIT_ROMAN_BALLISTA', 	'PROMOTION_INDIRECT_FIRE');		
--==========================================================================================================================
-- Leaders
--==========================================================================================================================		
INSERT INTO Leaders 
			(Type, 					Description, 					Civilopedia, 							CivilopediaTag, 							ArtDefineTag, 				VictoryCompetitiveness, WonderCompetitiveness, 	MinorCivCompetitiveness, 	Boldness, 	DiploBalance, 	WarmongerHate, 	DenounceWillingness, 	DoFWillingness, Loyalty, 	Neediness, 	Forgiveness, 	Chattiness, Meanness, 	IconAtlas, 			PortraitIndex)
VALUES		('LEADER_GPUZ_JULIUS', 	'TXT_KEY_LEADER_GPUZ_JULIUS', 	'TXT_KEY_LEADER_GPUZ_JULIUS_PEDIA', 	'TXT_KEY_CIVILOPEDIA_LEADERS_GPUZ_JULIUS', 	'JuliusScene.xml',	9, 						4, 						4, 							5, 			5, 				3, 				5, 						8, 				6, 			4, 			8, 				2, 			6, 			'GPUZ_ROME_ATLAS', 	1);
--==========================================================================================================================
-- Leader_MajorCivApproachBiases
--==========================================================================================================================					
INSERT INTO Leader_MajorCivApproachBiases 
			(LeaderType, 			MajorCivApproachType, 				Bias)
VALUES		('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_WAR', 			9),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_HOSTILE', 		5),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_DECEPTIVE', 	6),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_GUARDED', 		2),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_AFRAID', 		3),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_FRIENDLY', 		6),
			('LEADER_GPUZ_JULIUS', 	'MAJOR_CIV_APPROACH_NEUTRAL', 		2);
--==========================================================================================================================
-- Leader_MajorCivApproachBiases
--==========================================================================================================================					
INSERT INTO Leader_MinorCivApproachBiases 
			(LeaderType, 			MinorCivApproachType, 				Bias)
VALUES		('LEADER_GPUZ_JULIUS', 	'MINOR_CIV_APPROACH_IGNORE', 		2),
			('LEADER_GPUZ_JULIUS', 	'MINOR_CIV_APPROACH_FRIENDLY', 		9),
			('LEADER_GPUZ_JULIUS', 	'MINOR_CIV_APPROACH_PROTECTIVE', 	6),
			('LEADER_GPUZ_JULIUS', 	'MINOR_CIV_APPROACH_CONQUEST', 		4),
			('LEADER_GPUZ_JULIUS', 	'MINOR_CIV_APPROACH_BULLY', 		4);
--==========================================================================================================================
-- Leader_Flavors
--==========================================================================================================================					
INSERT INTO Leader_Flavors 
			(LeaderType, 				FlavorType, 						Flavor)
VALUES		('LEADER_GPUZ_JULIUS', 	'FLAVOR_OFFENSE', 					9),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_DEFENSE', 					5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_CITY_DEFENSE', 				4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_MILITARY_TRAINING', 		8),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_RECON', 					4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_RANGED', 					7),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_MOBILE', 					2),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_NAVAL', 					6),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_NAVAL_RECON', 				8),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_NAVAL_GROWTH', 				12),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_NAVAL_TILE_IMPROVEMENT', 	6),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_AIR', 						4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_EXPANSION', 				7),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_GROWTH', 					7),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_TILE_IMPROVEMENT', 			6),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_INFRASTRUCTURE', 			12),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_PRODUCTION', 				6),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_GOLD', 						4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_SCIENCE', 					8),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_CULTURE', 					8),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_HAPPINESS', 				6),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_GREAT_PEOPLE', 				5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_WONDER', 					5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_RELIGION', 					3),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_DIPLOMACY', 				4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_SPACESHIP', 				9),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_WATER_CONNECTION', 			5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_NUKE', 						3),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_USE_NUKE', 					3),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_ESPIONAGE', 				4),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_AIRLIFT', 					2),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_I_TRADE_DESTINATION', 		5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_I_TRADE_ORIGIN', 			5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_I_SEA_TRADE_ROUTE', 		9),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_I_LAND_TRADE_ROUTE', 		5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_ARCHAEOLOGY', 				5),
			('LEADER_GPUZ_JULIUS', 	'FLAVOR_AIR_CARRIER', 				5);
--==========================================================================================================================
-- Leader_Traits
--==========================================================================================================================					
INSERT INTO Leader_Traits 
			(LeaderType, 			TraitType)
VALUES		('LEADER_GPUZ_JULIUS', 	'TRAIT_GPUZ_ROME_REPUBLIC');
--==========================================================================================================================	
-- Diplomacy_Responses
--==========================================================================================================================	
INSERT INTO Diplomacy_Responses (LeaderType, ResponseType, Response, Bias) VALUES ('LEADER_GPUZ_JULIUS','RESPONSE_FIRST_GREETING',	'TXT_KEY_LEADER_GPUZ_JULIUS_FIRSTGREETING','500');
INSERT INTO Diplomacy_Responses (LeaderType, ResponseType, Response, Bias) VALUES ('LEADER_GPUZ_JULIUS','RESPONSE_DEFEATED',		'TXT_KEY_LEADER_GPUZ_JULIUS_DEFEATED','500');
--==========================================================================================================================
-- Civilizations
--==========================================================================================================================			
INSERT INTO Civilizations 	
			(Type, 							Description, 	ShortDescription, 	Adjective, Civilopedia, 	CivilopediaTag, 		DefaultPlayerColor, 		ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, IconAtlas, 			 AlphaIconAtlas, 		    PortraitIndex,	SoundtrackTag, 	MapImage, 	DawnOfManQuote, 						DawnOfManImage)
SELECT		('CIVILIZATION_GPUZ_ROME'), 	Description, 	ShortDescription, 	Adjective, Civilopedia,		CivilopediaTag, 		('PLAYERCOLOR_GPUZ_ROME'),  ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, ('GPUZ_ROME_ATLAS'), ('GPUZ_ROME_ALPHA_ATLAS'), 0, 				SoundtrackTag, 	MapImage, 	('TXT_KEY_CIV5_DOM_GPUZ_JULIUS_TEXT'), 	('JuliusLeaderscene.dds')
FROM Civilizations WHERE (Type = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_CityNames
--==========================================================================================================================
INSERT INTO Civilization_CityNames 
			(CivilizationType, 				CityName),
SELECT		('CIVILIZATION_GPUZ_ROME'), 	CityName
FROM Civilizations WHERE (Type = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_FreeBuildingClasses
--==========================================================================================================================		
INSERT INTO Civilization_FreeBuildingClasses 
			(CivilizationType, 				BuildingClassType)
SELECT		('CIVILIZATION_GPUZ_ROME'), 	BuildingClassType
FROM Civilization_FreeBuildingClasses WHERE (CivilizationType = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_FreeTechs
--==========================================================================================================================	
INSERT INTO Civilization_FreeTechs 
			(CivilizationType, 				TechType)
SELECT		('CIVILIZATION_GPUZ_ROME'), 	TechType
FROM Civilization_FreeTechs WHERE (CivilizationType = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_FreeUnits
--==========================================================================================================================	
INSERT INTO Civilization_FreeUnits 
			(CivilizationType, 				UnitClassType, Count, UnitAIType)
SELECT		('CIVILIZATION_GPUZ_ROME'), 	UnitClassType, Count, UnitAIType
FROM Civilization_FreeUnits WHERE (CivilizationType = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_Leaders
--==========================================================================================================================		
INSERT INTO Civilization_Leaders 
			(CivilizationType, 				LeaderheadType)
VALUES		('CIVILIZATION_GPUZ_ROME',		'LEADER_GPUZ_JULIUS');
--==========================================================================================================================
-- Civilization_BuildingClassOverrides 
--==========================================================================================================================	
INSERT INTO Civilization_BuildingClassOverrides 
			(CivilizationType, 				BuildingClassType, 				BuildingType)
VALUES		('CIVILIZATION_ROME',			'BUILDINGCLASS_MARKET', 		'BUILDING_GPUZ_FORUM');
--==========================================================================================================================
-- Civilization_UnitClassOverrides 
--==========================================================================================================================	
DELETE FROM Civilization_UnitClassOverrides WHERE CivilizationType = 'CIVILIZATION_ROME';
INSERT INTO Civilization_UnitClassOverrides 
			(CivilizationType, 				UnitClassType, 					UnitType)
VALUES		('CIVILIZATION_GPUZ_ROME', 		'UNITCLASS_GREAT_GENERAL', 		'UNIT_GPUZ_PRAETOR'),
			('CIVILIZATION_GPUZ_ROME', 		'UNITCLASS_CATAPULT', 			'UNIT_ROMAN_BALLISTA'),
			('CIVILIZATION_ROME', 			'UNITCLASS_SWORDSMAN', 			'UNIT_ROMAN_LEGION');
--==========================================================================================================================
-- Civilization_Religions
--==========================================================================================================================	
INSERT INTO Civilization_Religions
			(CivilizationType, 				ReligionType)
VALUES		('CIVILIZATION_GPUZ_ROME',		'RELIGION_CHRISTIANITY');
--==========================================================================================================================
-- Civilization_SpyNames
--==========================================================================================================================	
INSERT INTO Civilization_SpyNames 
			(CivilizationType, 			SpyName)
SELECT		('CIVILIZATION_GPUZ_ROME'), SpyName	
FROM Civilizations WHERE (Type = 'CIVILIZATION_ROME');
--==========================================================================================================================
-- Civilization_Start_Region_Priority
--==========================================================================================================================	
INSERT INTO Civilization_Start_Region_Priority 
			(CivilizationType, 			RegionType)
VALUES		('CIVILIZATION_GPUZ_ROME', 	'REGION_HILLS');
--==========================================================================================================================	
--==========================================================================================================================

The log:

Spoiler :

Yeah, it's getting on my nerves.

JFD · Jun 4, 2015

Install SQLite Manager and run all your SQL through that until you find the error, instead of combing it over with your weak, human eyes.

GPuzzle · Jun 7, 2015

Damnit, damnit, damnit. My Lua has a tendency to on paper be 100% correct and should work without issue.

Hop in-game, test it out - lolno.

After trying one too many times I think that I'm unable to come up with a working Lua, so I just scrapped the majority of the ideas I had. One day I'll figure out how to get the Lua working, because I seem to be failing to enable it and also seem to be unable to figure out.

Julius should be out today, and due to my inexperience with Lua it will be much simpler, and boring, then what I want it to be.

Julius Caesar

UA: Render Unto Caesar: Free Courthouse in Conquered Cities. Improvements are built 25% faster.

UU: Ballista: Base Game Ballista.

UU: Praetor: Great General replacement. Reduces the Combat Strength of enemies within 3 tiles by 15%. May be used to start a Golden Age.

Augustus Caesar:

UA: The Glory of Rome: +25% Production towards buildings already built in the Capital. +2 Production and +1 Gold from Plantations.

UU: Legion. Base game.

UB: Forum. Market replacement. Doesn't provide +1 Gold per turn - instead, provides +1 Gold per turn for every 2 Citiziens in the city.

I'll definetively go back and get the old design working as soon as I figure out how to make Lua actually work and not go "lolwut" for no reason. Right now I just want to release this Civ.

GPuzzle · Jun 7, 2015

Ok, so I've reached the point of mental ******ation as I was telling the SDK to go InGameUIAddin and searching the Lua files rather than the opposite.

It's all good, back to the old design.

Natan35 · Jun 7, 2015

If you don't mind me saying... Those designs look terribly Boring in my opinion. No offence...
(Shouldn't a unique swordsman capable of building improvements be in the design with the "build improvement faster" design? And that plantation thing has nothing to do with the rest of the design...)

GPuzzle · Jun 7, 2015

It was scrapped because I finally figured out my stupidity with Lua.

Right now, as it stands:

UA: Render Unto Caesar: Capturing an enemy Capital triggers a Golden Age. During Golden Ages, cities suffer no Occupied Unhappiness.

UU: Praetor: Great General replacement. When Garrisoned on a city, Golden Ages are 10% longer.

UU: Ballista: Same as main game.

UA: The Glory of Rome: +25% Production towards Buildings already built in the Capital. +2 Production and +1 Gold from Plantations.

UU: Legion: Same as main game.

UB: Forum: Market replacement. Doesn't provide +1 Gold per turn - instead, provides +1 Gold per turn for every 2 Citiziens in the city.

Yes, it's terribly boring according to you. I'll probably revisit it at some point in the future.

Natan35 · Jun 7, 2015

First part UA= Tomatekh's Goths, Just FYI.

I'd suggest a WLtKD...

SnowyNix · Jun 7, 2015

Link to video.

GPuzzle · Jun 7, 2015

After much headbutting and discussion with several members of this community, I finally have released a Civ!

Direct Link and Steam Workshop Link

Julius Caesar:

UA: Render Unto Caesar: A Golden Age begins upon capturing a foreign Capital. During Golden Ages, cities suffer no occupied unhappiness, and Great Person generation is increased by 25%.

UU: Ballista: the main game Ballista.

UU: Praetor: Great General replacement. May be used to start a Golden Age.

Augustus Caesar:

UA: The Glory of Rome: +25% Production towards buildings already built in the capital. +2 Production and +1 Gold from Plantations.

UU: Legion: the main game Legion.

UB: Forum: Market replacement. Does not provide +1 Gold - instead, provides +1 Gold for every 2 Citiziens in a city.

SnowyNix · Jun 7, 2015

CHOOOO CHOOOO

The hype train has arrived at its final station

Hoop Thrower · Jun 7, 2015

BRB, must write civilopedias NAO

GPuzzle's Civs

Available in wax cylinder!

Emperor

Available in wax cylinder!

Mayor of St. Natansburg

At Least I Can Talk

Mayor of St. Natansburg

Emperor

Available in wax cylinder!

Emperor

Available in wax cylinder!

Kathigitarkh

Available in wax cylinder!

Available in wax cylinder!

Mayor of St. Natansburg

Available in wax cylinder!

Mayor of St. Natansburg

At Least I Can Talk

Available in wax cylinder!

At Least I Can Talk

Cyberbolivarian Inkarri

Similar threads