projects
/
xonotic
/
xonstatdb.git
/ shortlog
summary
| shortlog |
log
|
commit
|
commitdiff
|
tree
first ⋅ prev ⋅
next
xonotic/xonstatdb.git
2014-11-19
Ant Zucaro
Add indexes. Rename to reflect its purpose.
commit
|
commitdiff
|
tree
|
snapshot
2014-11-18
Ant Zucaro
Add table definitions.
commit
|
commitdiff
|
tree
|
snapshot
2014-11-18
Ant Zucaro
Complete trigger definition.
commit
|
commitdiff
|
tree
|
snapshot
2014-11-18
Ant Zucaro
Rule generator for partitions. Incomplete.
commit
|
commitdiff
|
tree
|
snapshot
2014-07-12
Ant Zucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2014-07-12
Ant Zucaro
Take the greatest Elo per gametype in merges.
commit
|
commitdiff
|
tree
|
snapshot
2014-06-16
Ant Zucaro
Add groups table for admin functionality.
commit
|
commitdiff
|
tree
|
snapshot
2014-06-13
Ant Zucaro
Add email address to the players table (for admins...
commit
|
commitdiff
|
tree
|
snapshot
2014-05-28
Ant Zucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2014-05-28
Ant Zucaro
Add script to purge anticheat logs.
commit
|
commitdiff
|
tree
|
snapshot
2014-05-28
Ant Zucaro
Add an anticheat log table.
commit
|
commitdiff
|
tree
|
snapshot
2014-02-10
Ant Zucaro
Playing one Elo game type in the past 30 days will...
commit
|
commitdiff
|
tree
|
snapshot
2013-10-02
Ant Zucaro
Fix date range for q4 partition.
commit
|
commitdiff
|
tree
|
snapshot
2013-08-17
antzucaro
Damn off-by-one errors. *shakes fist*
commit
|
commitdiff
|
tree
|
snapshot
2013-08-17
antzucaro
Add Elo rot analysis query.
commit
|
commitdiff
|
tree
|
snapshot
2013-08-17
antzucaro
Use a new Elo rot scheme.
commit
|
commitdiff
|
tree
|
snapshot
2013-08-11
Ant Zucaro
Add drop and load convenience script.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Various typos on Q4.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Partition player weapon stats through 2014.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Partition player game stats through 2014.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Partition games through 2014.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
You know what? We don't need tables for the past!
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Configure partitions through 2014.
commit
|
commitdiff
|
tree
|
snapshot
2013-05-23
Ant Zucaro
Add rounds, caps fields.
commit
|
commitdiff
|
tree
|
snapshot
2013-04-21
Ant Zucaro
Add team scores table. Partition till 2015.
commit
|
commitdiff
|
tree
|
snapshot
2013-02-05
Ant Zucaro
Add port to servers table
commit
|
commitdiff
|
tree
|
snapshot
2013-02-05
Ant Zucaro
Add mod string to games table
commit
|
commitdiff
|
tree
|
snapshot
2013-02-01
Ant Zucaro
Identify games with bad ranks.
commit
|
commitdiff
|
tree
|
snapshot
2013-01-25
Ant Zucaro
Modify column structure for better reuse.
commit
|
commitdiff
|
tree
|
snapshot
2013-01-16
Ant Zucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2013-01-16
Ant Zucaro
Add teamrank and scoreboardpos fields.
commit
|
commitdiff
|
tree
|
snapshot
2013-01-02
antzucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2013-01-02
antzucaro
Use greatest instead of least.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-31
Ant Zucaro
Add win ratio query
commit
|
commitdiff
|
tree
|
snapshot
2012-12-31
Ant Zucaro
Add player retention query
commit
|
commitdiff
|
tree
|
snapshot
2012-12-15
Ant Zucaro
Add primary key to summary stats. SQLAlchemy requires it.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-15
Ant Zucaro
Remove the commit. It is redundant.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-15
Ant Zucaro
Add a small script to update the summary stats table.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-15
Ant Zucaro
Add the summary stats table to the build.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-15
Ant Zucaro
Add support for summary statistics.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-02
Ant Zucaro
Put a blurb about the misc functions into the README.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-02
Ant Zucaro
Add elo rot script.
commit
|
commitdiff
|
tree
|
snapshot
2012-12-02
Ant Zucaro
Add an update_dt to the player_elos table.
commit
|
commitdiff
|
tree
|
snapshot
2012-10-29
Ant Zucaro
Fix merge.
commit
|
commitdiff
|
tree
|
snapshot
2012-10-29
Ant Zucaro
Add captimes table to the build.
commit
|
commitdiff
|
tree
|
snapshot
2012-10-29
Ant Zucaro
Add indexes to the game and weapon stats tables. Store...
commit
|
commitdiff
|
tree
|
snapshot
2012-08-24
Ant Zucaro
Merge branch 'master' of ssh://push.git.xonotic.org...
commit
|
commitdiff
|
tree
|
snapshot
2012-08-24
Ant Zucaro
Index game_id and player_id for performance (and badges).
commit
|
commitdiff
|
tree
|
snapshot
2012-08-21
Ant Zucaro
Add players to ladder associative table, with ranks.
commit
|
commitdiff
|
tree
|
snapshot
2012-08-21
Ant Zucaro
Change title to name.
commit
|
commitdiff
|
tree
|
snapshot
2012-08-21
Ant Zucaro
Add the ladder code table.
commit
|
commitdiff
|
tree
|
snapshot
2012-06-11
Ant Zucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2012-06-11
Ant Zucaro
Add an active indicator to player_elo.
commit
|
commitdiff
|
tree
|
snapshot
2012-04-27
antzucaro
Merge pull request #1 from nyov/master
commit
|
commitdiff
|
tree
|
snapshot
2012-04-27
nyov
Modified Readme
commit
|
commitdiff
|
tree
|
snapshot
2012-04-21
Ant Zucaro
Default games to 1 in another place.
commit
|
commitdiff
|
tree
|
snapshot
2012-04-21
Ant Zucaro
Default total games to 1 and also print who we are...
commit
|
commitdiff
|
tree
|
snapshot
2012-04-21
Ant Zucaro
Do a weighted average instead of picking the max.
commit
|
commitdiff
|
tree
|
snapshot
2012-03-20
Ant Zucaro
Damn you, pgadmin!
commit
|
commitdiff
|
tree
|
snapshot
2012-03-20
Ant Zucaro
Adding yo dawg, just for the hell of it.
commit
|
commitdiff
|
tree
|
snapshot
2012-03-20
Ant Zucaro
Merge branch 'master' of github.com:antzucaro/xonstatdb
commit
|
commitdiff
|
tree
|
snapshot
2012-03-20
Ant Zucaro
A simple dashboard report for providing high level...
commit
|
commitdiff
|
tree
|
snapshot
2012-03-01
Ant Zucaro
Get rid of bad header chars in the file. All else is...
commit
|
commitdiff
|
tree
|
snapshot
2012-02-29
Ant Zucaro
Add advanced elo checks in the merge. We want an optimi...
commit
|
commitdiff
|
tree
|
snapshot
2012-02-29
Ant Zucaro
Function to merge two players.
commit
|
commitdiff
|
tree
|
snapshot
2012-02-20
Ant Zucaro
Support deactivating players.
commit
|
commitdiff
|
tree
|
snapshot
2012-02-20
Ant Zucaro
Change game type codes to match new gametypes abbreviat...
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Add rank history to the build.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Whoops, add the 32 game req.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Save rank history and also do not generate ranks if...
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Add rank history table.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Add elos and ranks to the build file.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Fix player_ranks.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Small transaction to regenerate ranks.
commit
|
commitdiff
|
tree
|
snapshot
2012-01-22
Ant Zucaro
Add ranks table for batch purposes.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-31
Ant Zucaro
Add player Elo support.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-15
Ant Zucaro
Fix unique key definition on games.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-15
Ant Zucaro
Add the duel game type.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-13
Ant Zucaro
The match_id is now a varchar.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-05
Ant Zucaro
Add a unique constraint on server_id/match_id.
commit
|
commitdiff
|
tree
|
snapshot
2011-12-01
Ant Zucaro
Add a match_id to each games row.
commit
|
commitdiff
|
tree
|
snapshot
2011-11-20
Ant Zucaro
Revert the functional index on players table. It won...
commit
|
commitdiff
|
tree
|
snapshot
2011-11-20
Ant Zucaro
Revert the functional index on stripped_nick. Searches...
commit
|
commitdiff
|
tree
|
snapshot
2011-11-20
Ant Zucaro
Add stripped_nick and indexes for it.
commit
|
commitdiff
|
tree
|
snapshot
2011-11-17
Ant Zucaro
Add default to the create_dt of player game stats.
commit
|
commitdiff
|
tree
|
snapshot
2011-11-16
Ant Zucaro
Use UTC timestamps instead of local timestamps.
commit
|
commitdiff
|
tree
|
snapshot
2011-11-16
antzucaro
Change to unix encoding.
commit
|
commitdiff
|
tree
|
snapshot
2011-11-16
antzucaro
Add stripped nick to the players table to support futur...
commit
|
commitdiff
|
tree
|
snapshot
2011-11-09
Ant Zucaro
Fix the triggers for partitioning.
commit
|
commitdiff
|
tree
|
snapshot
2011-10-31
Ant Zucaro
Get rid of the hashkeys table. It is not needed.
commit
|
commitdiff
|
tree
|
snapshot
2011-10-31
Ant Zucaro
Make the server hashkey an attribute instead of its...
commit
|
commitdiff
|
tree
|
snapshot
2011-10-28
Ant Zucaro
Ensure that the hashkeys for player and server are...
commit
|
commitdiff
|
tree
|
snapshot
2011-10-25
Ant Zucaro
Add server hashkey table
commit
|
commitdiff
|
tree
|
snapshot
2011-10-25
Ant Zucaro
Clean up cd_mutator stuff.
commit
|
commitdiff
|
tree
|
snapshot
2011-10-21
Ant Zucaro
We no longer need the mutator table or the game types...
commit
|
commitdiff
|
tree
|
snapshot
2011-10-17
Ant Zucaro
Allow up to 128 characters in the player nick
commit
|
commitdiff
|
tree
|
snapshot
2011-10-10
antzucaro
Add nick history table.
commit
|
commitdiff
|
tree
|
snapshot
2011-10-10
antzucaro
Remove unique constraint on pgstats that prevents multi...
commit
|
commitdiff
|
tree
|
snapshot
2011-10-10
antzucaro
Make directory location more clear.
commit
|
commitdiff
|
tree
|
snapshot
2011-10-10
antzucaro
Fix typo on language command.
commit
|
commitdiff
|
tree
|
snapshot
next