Website CGI (or page generator) to display Race CTS leaderboards of a Xonotic server.

b182dd6dae Limited line width to 80 characters 7 anos atrás
doc 0a8611065b Limited line width to 80 characters 7 anos atrás
include f18aec4ff5 Revised repository organization 7 anos atrás
queries a9141fa394 Removed queries that aren't used in the program. 8 anos atrás
src f18aec4ff5 Revised repository organization 7 anos atrás
.gitignore 511d47e4a2 Added ignore file. 8 anos atrás
LICENSE dad86bc0f2 Added license file 7 anos atrás
Makefile f18aec4ff5 Revised repository organization 7 anos atrás
README.md 068c8462d7 Fixed formatting error (missing line break) 7 anos atrás

README.md

C CGI Xonotic DeFrag

A CGI program written in C to display data related to Race CTS leaderboards of Xonotic servers.

Requirements

  • SQLite3

Web Server Queries

  • (none)

    • Query file: queries/mranks.sql
    • Requests the maplist of the server and related data.
  • ?map=[map name]

    • Query file: queries/mleaderboard-ojoin.sql
    • Requests the leaderboard of the map.
  • ?player=[clientid]

    • Query file: queries/rplayers.sql
    • Requests a player's ranks for all maps leaderboards s/he is present on.

Game Versions Used Under:

  • Xonotic 0.8.1
  • Xonotic 0.8.2

Compilers

  • MinGW, GCC 4.7.1

This program uses an sqlite3 database file created from ~/.xonotic/data/data/server.db.

The database may be built using xonotic-py-sqlite3-defrag2db.