Per SQL Befehl:
Variante pro Era
Die Zahlen 1-3 sind Platzhalter, du kannst die Werte nach belieben anpassen.
Code:
-----------------------------------------------
-- GreatPerson cost
-----------------------------------------------
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*1 WHERE EraType ='ERA_ANCIENT'; -- just for reference
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*1.2 WHERE EraType ='ERA_CLASSICAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*1.4 WHERE EraType ='ERA_MEDIEVAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*1.7 WHERE EraType ='ERA_RENAISSANCE';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*2.0 WHERE EraType ='ERA_INDUSTRIAL';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*2.3 WHERE EraType ='ERA_MODERN';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*2.6 WHERE EraType ='ERA_ATOMIC';
UPDATE Eras SET GreatPersonBaseCost = GreatPersonBaseCost*3.0 WHERE EraType ='ERA_INFORMATION';
Variante universell:
Hier ist x der Platzhalter
Code:
UPDATE Eras Set GreatPersonBaseCost = GreatPersonBaseCost*x