More trades routes (with the civic "foreign trade")

[Misplay]

Hi folks!
The civic "Foreign trade" provides 1 trade route. How can I increase this number?

EDIT: Here's the solution. Add a "." between "foreigntrade" and "modinfo"/"sql". And delete ".txt".

 

[gyogen2]

I believe it's here:

<Row>
            <ModifierId>CIVIC_GRANT_ONE_TRADE_ROUTE</ModifierId>
            <Name>Amount</Name>
            <Value>1</Value>
        </Row>

in civics.xml

 

[Horem]

In SQL:

UPDATE ModifierArguments SET Value = '2' WHERE ModifierId = 'CIVIC_GRANT_ONE_TRADE_ROUTE' AND Name = 'Amount';

Set Value to whatever you desire.

 

[Misplay]

Thx a lot guys!
@ Horem: I will use your code.

I never learnt to code, but I'm curious. Here's the code I tried:

    <Civics>
       <Update>
           <Where ModifierId="CIVIC_GRANT_ONE_TRADE_ROUTE" />
           <Set Value="X" />
       </Update>
   </Civics>

It's messy and doesn't work.

Questions:
> What should I write after the "<Where "?
> WHat's wrong with this try?

 

[gyogen2]

You're updating the wrong table. It is ModifierAruguments

 

[Misplay]

1. The sql is working. I'll update the first post asap.
2. Xml file:

<GameInfo>
   <Civics>
       <Update>
           <Where ModifierArguments="CIVIC_GRANT_ONE_TRADE_ROUTE" />
           <Set Value="2" />
       </Update>
   </Civics>
</GameInfo>

Right?

 

[thecrazyscot]

No, the XML would need to look like this:

<GameInfo>
     <ModifierArguments>
          <Update>
               <Where ModifierId="CIVIC_GRANT_ONE_TRADE_ROUTE" Name="Amount"/>
               <Set Value="2"/>
          </Update>
     </ModifierArguments>
</GameInfo>

The ModifierArguments table is separate from the Civics table.

 

[Misplay]

Ha!
Thx a lot Thecrazyscot!