You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
![]() |
5 years ago | |
---|---|---|
modules | ||
queries | ||
.gitignore | ||
LICENSE | 5 years ago | |
README.md | 5 years ago | |
main.py |
README.md
xonotic-py-sqlite3-defrag2db
Creates an sqlite3 database from Xonotic game server databases (server.db) using Python3.
Requirements
Only Python3 and standard libraries.
Usages
Creating a Database File from server.db
python main.py [output.db] [server.db]
Creating an SQL Query File from server.db
python main.py -f [output.db] [server.db]
Database Info
The output database will contain three tables, Cts_times
, Cts_ranks
, and Id2Alias
. These are based strictly on the game server's database schema for details see queries/schema.sql
.
Sample Queries
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.
Tested With
- Xonotic 0.8.1
- Xonotic 0.8.2