Play
PLAYER SHAIK SELECT * FROM trophy_case WHERE username = 'shaik';No trophies yet. 0 planets held this round.0TROPHIES0PLANETS0DAMAGE DONE0FUEL MINED ROUND 59
THECase
SELECT * FROM trophy_case WHERE username = 'shaik';

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

THISRound
round 59
Damage done0
Damage taken0
Planets conquered0
Planets lost1
Ships built0
Ships lost0
Fuel mined0
SHAREDScripts
SELECT * FROM shared_fleets WHERE username = 'shaik';

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

PUBLICRecord
  • R59 T1115 itwasnotme conquered Lester_104 from shaik
Everything here is a query. Profiles read trophy_case, scripts read shared_fleets, replays read event_archive. Try them from psql. SourceHow to play