TarcisioCM's Civilizations

Tarmont · Feb 11, 2015

Natan35 said:
Any plans for new updates?
Please?

U-uupdates?

Spoiler :

I wish I had motivation to learn how to mod the graphical interface but oh well. I'll probably just focus instead on updating the Ptolemies and Bactria first. I've got a new leaderscreen for Ptolemy ready for so long that I think its ugly now. Specially the ship he's on, just random planks connected in what I can only conclude to be non-euclidean geometry.

On other news, I have two civs basically done already, but I'm super-hyper-mega lazy when it comes to adding decisions, even though it's not hard at all.

Natan35 · Feb 11, 2015

Then don't be.
(The Israelcubes clan supports you)

Danmacsch · Feb 11, 2015

Noticed that your civs doesn't support the maps added in JFD's YnAEMP patch.

Since I'm too frustrated to pinpoint an error in the Event code for The Nuraghians,

crazyeye

, I decided to play a TSL game with, among others, the Iberians, the Alans and Rome (Aurelian). But unfortunately this wasn't possible on the Giant Europe map or the Mediterranean map, since there was no TSL support for these maps.

Decided to take matters into my own hands:

Spoiler :

The Iberians:

Spoiler :

Code:

--==========================================================================================================================
-- Civilizations_YagemStartPosition (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YagemStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	12,		58,		null,	null);
--==========================================================================================================================
-- Civilizations_YahemStartPosition (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	57,		54,		null,	null);
--==========================================================================================================================
-- Civilizations_CordiformStartPosition (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_CordiformStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	33,		24,		null,	null);
--==========================================================================================================================
-- Civilizations_GreatestEarthStartPosition (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_GreatestEarthStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	40,		39,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroLargeStartPosition (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroLargeStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	24,		30,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroGiantStartPosition (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroGiantStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	29,		34,		null,	null);
--==========================================================================================================================
-- Civilizations_MediterraneanStartPosition (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_MediterraneanStartPosition
			(Type, 									X, Y, AltX, AltY)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',		21,		42,		null,	null);
--==========================================================================================================================
-- Civilizations_GreatestEarthRequestedResource (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_GreatestEarthRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_YagemRequestedResource (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YagemRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_YahemRequestedResource (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YahemRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_CordiformRequestedResource (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_CordiformRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_EuroLargeRequestedResource (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroLargeRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_EuroGiantRequestedResource (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroGiantRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
-- Civilizations_MediterraneanRequestedResource (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_MediterraneanRequestedResource
			(Type, 								Req1,           Yield1, Req2,            Req3)
VALUES		('CIVILIZATION_TCM_THE_IBERIANS',	'RESOURCE_IRON', 4,     'RESOURCE_GOLD', 'RESOURCE_SILVER');
--==========================================================================================================================
--==========================================================================================================================

Rome (Aurelian):

Spoiler :

Code:

--==========================================================================================================================
-- Civilizations_YagemStartPosition (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YagemStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_YagemStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_YahemStartPosition (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_YahemStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_CordiformStartPosition (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_CordiformStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_CordiformStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_GreatestEarthStartPosition (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_GreatestEarthStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_GreatestEarthStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroLargeStartPosition (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroLargeStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_EuroLargeStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroGiantStartPosition (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroGiantStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_EuroGiantStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_MediterraneanStartPosition (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_MediterraneanStartPosition
			(Type, 									X, Y, AltX, AltY)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	X, Y, AltX, AltY
FROM Civilizations_MediterraneanStartPosition WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_GreatestEarthRequestedResource (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_GreatestEarthRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_GreatestEarthRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_YagemRequestedResource (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YagemRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YagemRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_YahemRequestedResource (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YahemRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YahemRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_CordiformRequestedResource (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_CordiformRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_CordiformRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroLargeRequestedResource (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroLargeRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroLargeRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroGiantRequestedResource (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroGiantRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroGiantRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_MediterraneanRequestedResource (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_MediterraneanRequestedResource
			(Type, 									Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_AURELIAN_ROME'),	Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_MediterraneanRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
--==========================================================================================================================

Danmacsch · Feb 11, 2015

.. and since it couldn't fit in one post, here's a couple more

:

Spoiler :

The Alans:

Spoiler :

Code:

--==========================================================================================================================
-- Civilizations_YagemStartPosition (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YagemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	42,		66,		null,	null);
--==========================================================================================================================
-- Civilizations_YahemStartPosition (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	74,		58,		null,	null);
--==========================================================================================================================
-- Civilizations_CordiformStartPosition (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	47,		29,		null,	null);
--==========================================================================================================================
-- Civilizations_GreatestEarthStartPosition (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_GreatestEarthStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	64,		49,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroLargeStartPosition (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroLargeStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	66,		40,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroGiantStartPosition (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroGiantStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	134,		63,		null,	null);
--==========================================================================================================================
-- Civilizations_MediterraneanStartPosition (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_MediterraneanStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_ALAN',	21,		42,		null,	null);
--==========================================================================================================================
-- Civilizations_YagemRequestedResource (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YagemRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YagemRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_YahemRequestedResource (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YahemRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YahemRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_GreatestEarthRequestedResource (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_GreatestEarthRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_GreatestEarthRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_CordiformRequestedResource (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_CordiformRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_CordiformRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_EuroLargeRequestedResource (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroLargeRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroLargeRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_EuroGiantRequestedResource (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroGiantRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroGiantRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
-- Civilizations_MediterraneanRequestedResource (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_MediterraneanRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_ALAN'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_MediterraneanRequestedResource WHERE Type = 'CIVILIZATION_HUNS';
--==========================================================================================================================
--==========================================================================================================================

Sicily:

Spoiler :

Code:

--==========================================================================================================================
-- Civilizations_YagemStartPosition (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YagemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	20,		53,		null,	null);
--==========================================================================================================================
-- Civilizations_YahemStartPosition (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	60,		51,		null,	null);
--==========================================================================================================================
-- Civilizations_CordiformStartPosition (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_YahemStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	36,		21,		null,	null);
--==========================================================================================================================
-- Civilizations_GreatestEarthStartPosition (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_GreatestEarthStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	49,		38,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroLargeStartPosition (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroLargeStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	36,		25,		null,	null);
--==========================================================================================================================
-- Civilizations_EuroGiantStartPosition (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_EuroGiantStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	64,		21,		null,	null);
--==========================================================================================================================
-- Civilizations_MediterraneanStartPosition (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_MediterraneanStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	44,		30,		null,	null);
--==========================================================================================================================
-- Civilizations_ApennineStartPosition (Apennine)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_ApennineStartPosition(Type, X, Y, AltX, AltY);
INSERT INTO Civilizations_ApennineStartPosition
			(Type,							X,		Y,		AltX,	AltY)
VALUES		('CIVILIZATION_TCM_SICILY',	32,		12,		null,	null);
--==========================================================================================================================
-- Civilizations_YagemRequestedResource (Earth Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YagemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YagemRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YagemRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_YahemRequestedResource (Earth Huge)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_YahemRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_YahemRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_YahemRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_GreatestEarthRequestedResource (Earth Greatest)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_GreatestEarthRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_GreatestEarthRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_GreatestEarthRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_CordiformRequestedResource (Earth Standard)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_CordiformRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_CordiformRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_CordiformRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroLargeRequestedResource (Europe Large)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroLargeRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroLargeRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroLargeRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_EuroGiantRequestedResource (Europe Giant)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_EuroGiantRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_EuroGiantRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_EuroGiantRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_MediterraneanRequestedResource (Mediterranean)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_MediterraneanRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_MediterraneanRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_MediterraneanRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
-- Civilizations_ApennineRequestedResource (Apennine)
--==========================================================================================================================
CREATE TABLE IF NOT EXISTS Civilizations_ApennineRequestedResource(Type, Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4);
INSERT INTO Civilizations_ApennineRequestedResource
			(Type, 										Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4)
SELECT		('CIVILIZATION_TCM_SICILY'),				Req1, Yield1, Req2, Yield2, Req3, Yield3, Req4, Yield4
FROM Civilizations_ApennineRequestedResource WHERE Type = 'CIVILIZATION_ROME';
--==========================================================================================================================
--==========================================================================================================================

Tarmont · Feb 11, 2015

Thx based dane, I should probably add support for the easy stuff in my old mods already... But that involves me... doing something...

Tarmont · Feb 12, 2015

This land has been conquered by the Khan of Khans. Send tributes or die!
I've added the WW1 civs that I've done with Viregel to the map too, hope he doesn't mind. All anschluss is good anschluss.

Direct Download | Steam Workshop
Includes support for: Exploration Continued Expanded | Civ IV traits in Civ V | Cultural Diversity | Ethnic Units | Events and Decisions | Map Labels | Piety and Prestige | Unique Cultural Influence | Yet Not Another Earth Map Pack

Look out for dem bugs

Natan35 · Feb 12, 2015

Yes!
Hail the khan! Hail the ExCE support!

Kerfuffle · Feb 12, 2015

Awesome, a new Steppe civ! We could always do with (even) more of them

bouncymischa · Feb 12, 2015

Ooooh, an interesting looking civ! I look forwards to picking through the code to see how you implemented some of those uniques, particularly with the "can't build the UI adjacent to the city" part.

Tarmont · Feb 12, 2015

bouncymischa said:
Ooooh, an interesting looking civ! I look forwards to picking through the code to see how you implemented some of those uniques, particularly with the "can't build the UI adjacent to the city" part.

Don't get your hopes high, I used a "fake" button for the Yurt Camp improvement, so I could do anything I wanted with it.

also my code is ugly pls no see

Natan35 · Feb 12, 2015

tarcisiocm said:
Don't get your hopes high, I used a "fake" button for the Yurt Camp improvement, so I could do anything I wanted with it.

also my code is ugly pls no see

Oh you sound like my father now...

How can a code be ugly?!

bouncymischa · Feb 12, 2015

tarcisiocm said:
Don't get your hopes high, I used a "fake" button for the Yurt Camp improvement, so I could do anything I wanted with it.

also my code is ugly pls no see

Aaaaaaah that code really is ugly! XD

(Okay, it really isn't that ugly, but I was amused to see all the lua and sql files mixed up together...)

But it was actually in an interesting tidbit of code. I'm really not familiar with UI coding, so I didn't fully understand it, but overriding the button itself was an interesting idea. As far as I know, there's been no way to restrict the 'build improvement' action itself (unlike CanConstruct or CanTrain), but overriding the button function with additional checks offers some potential. I'm not entirely sure if it'd work for the AI, though... but it's worth exploring.

I was also quite amused at the events and decisions for the civ... Never expected to see the word 'mitochonrdia' there. Now I'm having flashbacks to Parasite Eve...

Viregel · Feb 12, 2015

Aw, I missed the Anschluss discussion. I hate it when that happens.

ps u wanna do sum other ww1 civs

Tarmont · Feb 12, 2015

Viregel said:
Aw, I missed the Anschluss discussion. I hate it when that happens.

ps u wanna do sum other ww1 civs

Spoiler :

Viregel · Feb 12, 2015

That's JFD's territory

Tarmont · Feb 12, 2015

Viregel said:
That's JFD's territory

If only the Austro-Hungarians were more like you...

Viregel · Feb 12, 2015

Rip in peace Austria-Hungary 1867 - 1918
"We probably shouldn't have invaded Serbia" - like everyone ever

Natan35 · Feb 12, 2015

Viregel said:
Rip in peace Austria-Hungary 1867 - 1918
"We probably shouldn't have invaded Serbia" - like everyone ever

RIP in peace...
Also, the Serbians started it(!).

Kujarim_Wuniver · Feb 12, 2015

Natan35 said:
RIP in peace...
Also, the Serbians started it(!).

It was Austria-Hungary that declared war on Serbia and then immediately started bombarding Belgrade. So... nope

Reedstilt · Feb 12, 2015

Please, everyone knows the Ottomans started it.

In 1453.

TarcisioCM's Civilizations

Empress

Mayor of St. Natansburg

Geheimekabinetsminister

Geheimekabinetsminister

Empress

Empress

Mayor of St. Natansburg

King of the Whale Sharks

Synthetic Genie

Empress

Mayor of St. Natansburg

Synthetic Genie

, The Rt. Hon.

Empress

, The Rt. Hon.

Empress

, The Rt. Hon.

Mayor of St. Natansburg

Chieftain

Prince

Similar threads