Changing tech cost

[Jifanodd]

I'm trying to follow what PYITE advised in this thread about moving Astrology in tech tree:

...slight rearranging of the ancient tech tree to have Astrology be a leaf tech that requires writing and archery as a prerequisite...

• Astrology increased from 50 to 55 beakers (so it will go to the right of archery and writing)
• Astrology new prerequisites are writing and archery
• Astrology moved to UITreeRow="-1" (for positioning)

I can move Astrology up and down and connect it with writing and archery but when I try to change it's cost, the whole tech tree blows up and connections are messed up.

I tried with XML (also with GameInfo tag):
<GameData>

<Technologies>

<Update>
<WHERE TechnologyType="TECH_ASTROLOGY"/>
<Set Cost="60"/>
</Update>​

</Technologies>​

</GameData>"

and with SQL:
Update Technologies
Set Cost = "55"
WHERE TechnologyType = "TECH_ASTROLOGY";

I understod from here that the cost change is possible with similar code

I tested it:
1. Created a simple mod that increase for example tech cost.
Something like
UPDATE Technologies SET Cost = Cost*20

What goes wrong in mine?

Edit: Found it the minute I hit the post button; SQL value shouldn't be in quotes... something else wrong with my XML though...

 

[LeeS]

The spelling of "WHERE" in your XML file. "Where" is the required spelling in XML. Database log should have shown some sort of error for this mistake in your XML file.