From 90ba061273109a33034eed715d34bf6a1a657eba Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 2 Dec 2012 14:43:36 -0500 Subject: [PATCH] Put a blurb about the misc functions into the README. --- README.md | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/README.md b/README.md index 4d17435..218be67 100644 --- a/README.md +++ b/README.md @@ -58,6 +58,30 @@ Now load the initial tables: And that's it! +Do note that there are a few maintenance scripts that can be used +once the database begins accumulating data. These can be found in +the scripts subdirectory. A summary of what they do follows: + + update\_elos.sql - will decrease player elo records by one point + day for every day after 30 days of inactivity + until they hit the elo "floor" of 100. This + prevents inactive players from staying on the + leaderboard/ranks for too long. + + update\_ranks.sql - will populate the player\_ranks table each day + according to the elo values when it is run. + +There is also a "merge players" function in the functions sub- +directory. This can be used to merge two players together into one +record in the presentation layer of XonStat. It can be run as follows: + + select merge\_players(winner\_player\_id, loser\_player\_id); + +The "winner" player ID is the account that remains active after the +transaction. + +Enjoy! + [xonotic]: http://www.xonotic.org/ [xonstat]: http://stats.xonotic.org/ -- 2.39.2