--==========================================================================================================================
-- CONFIG DATA
--==========================================================================================================================
-- Players
--------------------------------------------------------------------------------------------------------------------------	
INSERT INTO Players	
		(CivilizationType,		Portrait,							PortraitBackground,			LeaderType,				LeaderName,						LeaderIcon,					LeaderAbilityName,								 LeaderAbilityDescription,								 LeaderAbilityIcon,			CivilizationName,	CivilizationIcon,						CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon)
SELECT	'CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY_NEUTRAL.dds',	'LEADER_HOJO_BACKGROUND',	'LEADER_JFD_PTOLEMY',	'LOC_LEADER_JFD_PTOLEMY_NAME',	'ICON_LEADER_JFD_PTOLEMY',	'LOC_TRAIT_LEADER_JFD_PEARL_MEDITERRANEAN_NAME', 'LOC_TRAIT_LEADER_JFD_PEARL_MEDITERRANEAN_DESCRIPTION', 'ICON_LEADER_JFD_PTOLEMY',	CivilizationName,	'ICON_CIVILIZATION_JFD_EGYPT_PTOLEMY',	CivilizationAbilityName, CivilizationAbilityDescription, 'ICON_CIVILIZATION_EGYPT_JFD_PTOLEMY'
FROM Players WHERE CivilizationType = 'CIVILIZATION_EGYPT' AND LeaderType= 'LEADER_CLEOPATRA' and Domain = 'Players:StandardPlayers'
AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_EGYPT_PTOLEMY' AND Value = 1);
--------------------------------------------------------------------------------------------------------------------------	
-- PlayerItems
--------------------------------------------------------------------------------------------------------------------------	
INSERT INTO PlayerItems		
		(CivilizationType,		LeaderType,				Domain, Type, Icon, Name, Description, SortIndex)
SELECT	'CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	Domain, Type, Icon, Name, Description, SortIndex
FROM PlayerItems WHERE CivilizationType = 'CIVILIZATION_EGYPT' AND LeaderType= 'LEADER_CLEOPATRA'
AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_EGYPT_PTOLEMY' AND Value = 1);

INSERT INTO PlayerItems	
		(CivilizationType,		LeaderType,				Type,				 		 Icon,								Name,								  Description,									SortIndex)
SELECT	'CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	'UNIT_JFD_TESSERAKONTERES',  'ICON_UNIT_JFD_TESSERAKONTERES',	'LOC_UNIT_JFD_TESSERAKONTERES_NAME',  'LOC_UNIT_JFD_TESSERAKONTERES_DESCRIPTION',	30
WHERE EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_EGYPT_PTOLEMY' AND Value = 1);
--------------------------------------------------------------------------------------------------------------------------	
-- MapSupportedValues
--------------------------------------------------------------------------------------------------------------------------	
--INSERT INTO MapSupportedValues	
--		(Value,						Domain, Map)
--SELECT	'LEADER_JFD_PTOLEMY',	Domain, Map
--FROM MapSupportedValues WHERE Value= 'LEADER_CLEOPATRA'
-- AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_NUBIA_PTOLEMY' AND Value = 1);
--==========================================================================================================================
--==========================================================================================================================