[R&F] Moving a unit to another Tech.

[Cordell]

Hello
Sorry english is not my mother tongue. Hope i am understandable.
And my skills for coding are very limited.
(a noob if u want but editing text is not that hard when u spent time to it)
Using notepad++ , i manage to deeply change the techtree, and it's working perfectly.well.
But i have now a problem, i would like to Move Pike and Shoot unit from Metal Chasing to Siege tactics.
I tryied few tricks but it do not work yet.
Here my last attempt.(maybe not the best one)
Thanks for help.

<?xml version="1.0" encoding="utf-8"?>
<GameInfo>
    <Units>
        <Update>
            <Where Row UnitType="UNIT_PIKE_AND_SHOT" BaseMoves="2" Cost="250" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_PIKE_AND_SHOT_NAME" Description="LOC_UNIT_PIKE_AND_SHOT_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_ANTI_CAVALRY" Maintenance="4" Combat="55" PrereqTech="TECH_METAL_CASTING" MandatoryObsoleteTech="TECH_COMBINED_ARMS"/>
            <Set Row UnitType="UNIT_PIKE_AND_SHOT" BaseMoves="2" Cost="250" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_PIKE_AND_SHOT_NAME" Description="LOC_UNIT_PIKE_AND_SHOT_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_ANTI_CAVALRY" Maintenance="4" Combat="55" PrereqTech="TECH_SIEGE_TACTICS" MandatoryObsoleteTech="TECH_COMBINED_ARMS"/>
           
        </Update>
    </Units>
<GameInfo>

 

[Laurana Kanan]

Try this:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <Units>
        <Update>
            <Where UnitType="UNIT_PIKE_AND_SHOT"/>
            <Set PrereqTech="TECH_SIEGE_TACTICS"/>
        </Update>
    </Units>
</GameData>

Or, in SQL

UPDATE  Units
SET     PrereqTech = 'TECH_SIEGE_TACTICS'
WHERE   UnitType = 'UNIT_PIKE_AND_SHOT;

 

[Cordell]

Thanks a lot. It's working perfectly.
Is it better to use sql or xml for this kind of issue?

 

[Laurana Kanan]

Personally, I use SQL as much as I can. The syntax is much easier for me to understand what's going on and there are a couple additional benefits to using it over xml for most changes. You might check out this thread: SQL and/or XML and/or LUA ?

 

[Cordell]

Great ressource!
Thanks for all

 

[isau]

SQL is much better for editing files. I wish the entire community would abandon XML for SQL, at least for updating existing data. (Arguably SQL is useful for creating new data, but that's extremely debatable).

I recommend downloading a SQL tool that can hook to the database so you can query your code after injecting it with a mod.

 

[Cordell]

I found your tutorial, i ll give a look.
https://forums.civfanatics.com/threads/tutorial-modding-with-sqllite-studio-pc.608352/
According to both of you Sql syntax looks a bit simpler to understand.
Thanks for your advices.
(even if my relative will probably curse you now )