Repairing

If you leave a ship with zero health for 60 tics, the ship will be marked as destroyed and will no longer function. Repair a ship to keep it in the game!

A ship's ability to repair will improved by upgrading the engineering skill.

The Repair Process

When your ship executes the REPAIR( ) function during a tic, as long as it is within range of the target ship, the repair process takes place instantly. A ship can repair itself.

The amount that will be repaired is the exact value of the ships engineering skill.

All repairs done are stored in a ships future_health which is commited to current_health at the end of a tic.

The REPAIR(Ship ID, Ship ID) Function

The REPAIR( ) function can be called on its own or used in-line with any more complex query. Consider the following examples:

Ship #101 repairing itself
SELECT REPAIR(101, 101);

All Ships named "Home Defender" repairing injured defender #105
SELECT REPAIR(id, 105) FROM my_ships WHERE name='Home Defender';

Using Ship State to REPAIR Continuesly

While the REPAIR function must be called every tic, if you plan for this same action to occur each tic you can use the ship's state to define that action. A ships stateful action must still meet all normal requirements including that a ship can only perform on action per tic and it must be within range of the other ship.

Ship #101 repairing itself Continuesly
UPDATE my_ships SET action='REPAIR', action_target_id=id WHERE id=101;

All Ships named "Home Defender" continuesly repairing Ship #105 after a battle
UPDATE my_ships SET action='REPAIR', action_target_id=105 WHERE name='Home Defender';