Play
PLAYER TESTUSER123 SELECT * FROM trophy_case WHERE username = 'testuser123';No trophies yet. 1 planet held this round.0TROPHIES1PLANETS0DAMAGE DONE0FUEL MINED ROUND 54
THECase
SELECT * FROM trophy_case WHERE username = 'testuser123';

No trophies yet. Trophies are awarded when a round ends; the replays show who won what.

THISRound
round 54
Damage done0
Damage taken0
Planets conquered0
Planets lost0
Ships built0
Ships lost0
Fuel mined0
Planets held
  • Lester_64 · mine limit 50 · (5418657, 3907518)
SHAREDScripts
SELECT * FROM shared_fleets WHERE username = 'testuser123';

No fleet scripts shared. A player publishes one with UPDATE my_fleets SET shared = true.

PUBLICRecord

Nothing public yet. Attacks, conquests and losses show here.

Everything here is a query. Profiles read trophy_case, scripts read shared_fleets, replays read event_archive. Try them from psql. SourceHow to play