Extra movement for all units

[Wolfdog]

Playing on a large map and finding that it is taking forever to move around the map so I am looking for a sql command that will add +2 movement to every unit.

I do not want to place an entry for every unit so will this work:
UPDATE Units SET Moves = Moves +2 WHERE Type = *

Thanks.

 

[Klisz]

You don't need the WHERE Type = * at all. Just

UPDATE Units SET Moves = Moves + 2;

should work fine.

 

[Wolfdog]

Thank you Kilsz.

 

[Nutty]

If you want to ensure compatibility with any other mods that add units that might be activated AFTER your mod in the load order, you want to also add a triggered version of the command after the regular one, i.e.:

UPDATE Units SET Moves = Moves + 2;
CREATE TRIGGER ExtraMovement AFTER INSERT ON Units
    BEGIN
    UPDATE Units SET NEW.Moves = NEW.Moves + 2;
    END;

 

[whoward69]

Should be Moves = Moves + 2 (not times), but the trigger is wrong, it should only update the newly added row, not all rows

Explorers move 2
Run SQL, explorers move 4
Mod X adds a new unit, all units get two more moves, explorers now move 6
Mod Y adds a new unit, all units get two more moves, explorers now move 8
etc

 

[Nutty]

Quite right. Updated.

...I was quite sleepy when I wrote that post...

 

[whoward69]

UPDATE Units SET NEW.Moves = NEW.Moves + 2;

will set ALL units to have 2 more moves than standard for the unit being added (or it might just be a syntax error)

UPDATE Units SET Moves = Moves + 2 WHERE ID=NEW.ID;