[R&F] Great Prophet Cost issue

Cordell

Chieftain
Joined
Mar 21, 2018
Messages
22
Hi, i am currently working on a personal mod aiming realistic historical Era ( Classic Era start around XII-X century/Middle Age around III-VII century/Renaissance XII-XIV/ Industrial XVI-XVIII/ Modern XIX and Atomic Mid XXth)
Works pretty nicely (Huge map-Normal speed/Emperor)
I made huge (but basic) change to tech tree and move few building/ressources/units.
I am yet stuck with one problem.
Greath Prophet arrival is to early
But if i change the Cost then the other GP came to late and are hard to get.
This is my actual Data, if someone as an elegant solution to suggest.
Code:
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*0.8 WHERE EraType = 'ERA_ANCIENT';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*0.8 WHERE EraType = 'ERA_CLASSICAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*1.5 WHERE EraType = 'ERA_MEDIEVAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*2.5 WHERE EraType = 'ERA_RENAISSANCE';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*3 WHERE EraType = 'ERA_INDUSTRIAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*4 WHERE EraType = 'ERA_MODERN';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*5 WHERE EraType = 'ERA_ATOMIC';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*6 WHERE EraType = 'ERA_INFORMATION';

Maybe something like this?

UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*6 WHERE GreatPersonClassType = 'GREAT_PERSON_CLASS_PROPHET';
 
Last edited:
I tried XML, no results for now
Code:
<?xml version="1.0" encoding="utf-8"?>
<GameInfo>
   <GreatPersonIndividuals>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST" Name="LOC_GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_CONFUCIUS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_CONFUCIUS" Name="LOC_GREAT_PERSON_INDIVIDUAL_CONFUCIUS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ZOROASTER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ZOROASTER" Name="LOC_GREAT_PERSON_INDIVIDUAL_ZOROASTER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA" Name="LOC_GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_LAOZI"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_LAOZI" Name="LOC_GREAT_PERSON_INDIVIDUAL_LAOZI_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
</Update>      
<Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIMON_PETER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIMON_PETER" Name="LOC_GREAT_PERSON_INDIVIDUAL_SIMON_PETER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_BODHIDHARMA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_BODHIDHARMA" Name="LOC_GREAT_PERSON_INDIVIDUAL_BODHIDHARMA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA" Name="LOC_GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="F"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO" Name="LOC_GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO" Name="LOC_GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_IRENAEUS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_IRENAEUS" Name="LOC_GREAT_PERSON_INDIVIDUAL_IRENAEUS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER" Name="LOC_GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI" Name="LOC_GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA" Name="LOC_GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS" Name="LOC_GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where= GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_HAJI_HUUD"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_HAJI_HUUD" Name="LOC_GREAT_PERSON_INDIVIDUAL_HAJI_HUUD_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
   </GreatPersonIndividuals>
</GameInfo>
 
Where= is a syntax error which should be showing up in Database.log

You want simply Where

So you want
Code:
<GameInfo>
   <GreatPersonIndividuals>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST"/>
          ...etc.....
But I am not sure what you are attempting will actually work once the syntax error issue is cured.
 
Yes thank you, i feel a bit stupid now! To confident with the notepad++ ^^
Syntax errors are cured and tracked (i found another one with a missing /update command)
but still no effect unfortunatly.
I ll continue to experiment. Maybe exploring the sql capabilities.
Spoiler :
Code:
<?xml version="1.0" encoding="utf-8"?>
<GameInfo>
   <GreatPersonIndividuals>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST" Name="LOC_GREAT_PERSON_INDIVIDUAL_JOHN_THE_BAPTIST_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_CONFUCIUS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_CONFUCIUS" Name="LOC_GREAT_PERSON_INDIVIDUAL_CONFUCIUS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ZOROASTER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ZOROASTER" Name="LOC_GREAT_PERSON_INDIVIDUAL_ZOROASTER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA" Name="LOC_GREAT_PERSON_INDIVIDUAL_SIDDHARTHA_GAUTAMA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_LAOZI"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_LAOZI" Name="LOC_GREAT_PERSON_INDIVIDUAL_LAOZI_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIMON_PETER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SIMON_PETER" Name="LOC_GREAT_PERSON_INDIVIDUAL_SIMON_PETER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_BODHIDHARMA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_BODHIDHARMA" Name="LOC_GREAT_PERSON_INDIVIDUAL_BODHIDHARMA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA" Name="LOC_GREAT_PERSON_INDIVIDUAL_ADI_SHANKARA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="F"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO" Name="LOC_GREAT_PERSON_INDIVIDUAL_SONGTSAN_GAMPO_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO" Name="LOC_GREAT_PERSON_INDIVIDUAL_O_NO_YASUMARO_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_IRENAEUS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_IRENAEUS" Name="LOC_GREAT_PERSON_INDIVIDUAL_IRENAEUS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_MEDIEVAL" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER" Name="LOC_GREAT_PERSON_INDIVIDUAL_MARTIN_LUTHER_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI" Name="LOC_GREAT_PERSON_INDIVIDUAL_FRANCIS_OF_ASSISI_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA" Name="LOC_GREAT_PERSON_INDIVIDUAL_MADHVA_ACHARYA_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS" Name="LOC_GREAT_PERSON_INDIVIDUAL_THOMAS_AQUINAS_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
       <Update>
           <Where GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_HAJI_HUUD"/>
           <Set GreatPersonIndividualType="GREAT_PERSON_INDIVIDUAL_HAJI_HUUD" Name="LOC_GREAT_PERSON_INDIVIDUAL_HAJI_HUUD_NAME" GreatPersonClassType="GREAT_PERSON_CLASS_PROPHET" EraType="ERA_RENAISSANCE" ActionCharges="0" Gender="M"/>
       </Update>
   </GreatPersonIndividuals>
</GameInfo>

Correction It's working fine! :)
 
Last edited:
Top Bottom