(Python3) Creates an sqlite3 database from Xonotic's game server database.
Du kannst nicht mehr als 25 Themen auswählen Themen müssen mit entweder einem Buchstaben oder einer Ziffer beginnen. Sie können Bindestriche („-“) enthalten und bis zu 35 Zeichen lang sein.
6fe717a453 Added note about version of Xonotic tested with vor 2 Jahren
modules Clean up - repo now contains only whats needed vor 3 Jahren
queries Extended mranks to include best time and by which player. vor 3 Jahren
.gitignore Added ignore file. vor 3 Jahren
LICENSE Added license vor 2 Jahren
README.md Added note about version of Xonotic tested with vor 2 Jahren
main.py Added option to export into sql query file vor 2 Jahren

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