Creates an sqlite3 database from Xonotic game server databases (server.db) using Python3.
Only Python3 and standard libraries.
python main.py [output.db] [server.db]
python main.py -f [output.db] [server.db]
The output database will contain three tables,
Id2Alias. These are based strictly on the game server’s database schema for details see
queries/ contains sample queries for the database.
queries/mleaderboard.sql, given a map name, retrieves rank, player public key, and time record.
queries/mplayers.sql, given a map name, retrieves rank, player public key, and player alias.
queries/mranks.sql, for all maps, retrieves map name, number of records, best time, and alias of player with the best time.
queries/rplayers.sql, given a player public key, retrieves alias, map name, and given player’s rank.