[GS] The use of Delete

[Riker13]

Hi All,
I don't want the Submarine to have <Row Type="UNIT_SUBMARINE" Tag="CLASS_NAVAL_RANGED"/>
Is it the Delete function I use and if so how?

Regards
Riker13

 

[Laurana Kanan]

DELETE FROM TypeTags WHERE Type = 'UNIT_SUBMARINE' AND Tag = 'CLASS_NAVAL_RANGED';

 

[Riker13]

Excellent, thanks Laurana.

 

[Riker13]

It don't seem to be working the Sub is still able to fire ranged.
I added the sql under <InGameActions> and </UpdateDatabase> in .modinfo, is that correct?

 

[Laurana Kanan]

So you just want to eliminate it's ranged attack? For that you'll need to update the Units table.

UPDATE Units SET RangedCombat = 0, Range = 0 WHERE UnitType = 'UNIT_SUBMARINE';

You'll probably also want to throw a LoadOrder that's greater than 300 or so on the UpdateDatabase action as well to ensure it loads after all base game files.

<UpdateDatabase id="XXXX">
   <Properties>
      <LoadOrder>300</LoadOrder>
   </Properties>
   <File>XXXX.sql</File>
</UpdateDatabase>

 

[Riker13]

Thanks again, will try this out in the morning.
All the best.