projects
/
xonotic
/
xonstatdb.git
/ shortlog
summary
| shortlog |
log
|
commit
|
commitdiff
|
tree
first ⋅ prev ⋅
next
xonotic/xonstatdb.git
2017-11-08
Ant Zucaro
Update the refresh script for active servers.
top-servers
commit
|
commitdiff
|
tree
|
snapshot
2017-11-08
Ant Zucaro
Modify the sum type of the active servers MV.
commit
|
commitdiff
|
tree
|
snapshot
2017-10-17
Ant Zucaro
Merge branch 'frag-matrix'
commit
|
commitdiff
|
tree
|
snapshot
2017-10-17
Ant Zucaro
Use the plain JSON type, not JSONB due to PG9.3.
commit
|
commitdiff
|
tree
|
snapshot
2017-10-16
Ant Zucaro
Merge pull request #3 from antzucaro/frag-matrix
commit
|
commitdiff
|
tree
|
snapshot
2017-10-04
Ant Zucaro
Partition the frag matrix table.
frag-matrix
commit
|
commitdiff
|
tree
|
snapshot
2017-09-30
Ant Zucaro
Add the table to the build.
commit
|
commitdiff
|
tree
|
snapshot
2017-09-30
Ant Zucaro
Initial version of the player_game_frag_matrix table.
commit
|
commitdiff
|
tree
|
snapshot
2017-08-26
Ant Zucaro
Make mention of needing superuser for drop & load,...
commit
|
commitdiff
|
tree
|
snapshot
2017-05-13
Ant Zucaro
Add a pl/pgsql block to update the player_agg_stats_mv...
commit
|
commitdiff
|
tree
|
snapshot
2017-05-13
Ant Zucaro
Remove the trailing comma.
commit
|
commitdiff
|
tree
|
snapshot
2017-05-12
Ant Zucaro
Add the aggregate table to the build.
commit
|
commitdiff
|
tree
|
snapshot
2017-05-12
Ant Zucaro
Add a new 'mv' table for player aggregate stats.
commit
|
commitdiff
|
tree
|
snapshot
2017-04-30
Ant Zucaro
Add category to player_ranks and its history.
commit
|
commitdiff
|
tree
|
snapshot
2017-04-30
Ant Zucaro
Add elo categories to several tables.
commit
|
commitdiff
|
tree
|
snapshot
2017-04-22
Ant Zucaro
Add a SQL script to clean the DB.
commit
|
commitdiff
|
tree
|
snapshot
2017-04-03
Ant Zucaro
Add some additional IP address padding.
commit
|
commitdiff
|
tree
|
snapshot
2017-01-19
Ant Zucaro
Add a script to create a data snapshot of the DB.
commit
|
commitdiff
|
tree
|
snapshot
2016-11-25
Ant Zucaro
Insert a logging record to the merged_server table...
commit
|
commitdiff
|
tree
|
snapshot
2016-11-25
Ant Zucaro
Add the new table to the build script.
commit
|
commitdiff
|
tree
|
snapshot
2016-11-25
Ant Zucaro
Add a log table for merged servers.
commit
|
commitdiff
|
tree
|
snapshot
2016-11-25
Ant Zucaro
On second thought, let XonStat handle the attribute...
commit
|
commitdiff
|
tree
|
snapshot
2016-11-25
Ant Zucaro
Add a merge_servers function.
commit
|
commitdiff
|
tree
|
snapshot
2016-11-11
Ant Zucaro
Add an Elo indicator for turning off processing at...
commit
|
commitdiff
|
tree
|
snapshot
2016-03-29
Ant Zucaro
Add player_medals to the build.
commit
|
commitdiff
|
tree
|
snapshot
2016-03-29
Ant Zucaro
Add player_medals table.
commit
|
commitdiff
|
tree
|
snapshot
2016-03-17
Ant Zucaro
Fix typos.
commit
|
commitdiff
|
tree
|
snapshot
2016-02-04
Ant Zucaro
Give the active MVs primary keys.
commit
|
commitdiff
|
tree
|
snapshot
2016-02-02
Ant Zucaro
Add active maps MV to the build.
commit
|
commitdiff
|
tree
|
snapshot
2016-02-02
Ant Zucaro
Add a script to refresh active maps.
commit
|
commitdiff
|
tree
|
snapshot
2016-02-02
Ant Zucaro
Add an MV for active maps.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add active servers MV to the build.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add a script to refresh active servers.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add an MV for active servers.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Unify permissions on all the table scripts.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add active players MV to the build.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add script to refresh the active players MV.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-30
Ant Zucaro
Add an MV for active players.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-29
Ant Zucaro
Add script to refresh summary stats.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-29
Ant Zucaro
Add a create_dt to summary stats.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-29
Ant Zucaro
Add a summary stats "materialized view".
commit
|
commitdiff
|
tree
|
snapshot
2016-01-26
Ant Zucaro
Consolidate indexes for the games table.
commit
|
commitdiff
|
tree
|
snapshot
2016-01-21
Ant Zucaro
Exclude rankings for those at the Elo floor.
commit
|
commitdiff
|
tree
|
snapshot
2015-06-13
Ant Zucaro
Update the unique key on the player captimes table.
commit
|
commitdiff
|
tree
|
snapshot
2015-06-13
Ant Zucaro
The mod is 64 characters, not 30.
commit
|
commitdiff
|
tree
|
snapshot
2015-06-09
Ant Zucaro
Add the mod name to the captimes table to somewhat...
commit
|
commitdiff
|
tree
|
snapshot
2015-06-09
Ant Zucaro
Add a field to track the absolute number of impure...
commit
|
commitdiff
|
tree
|
snapshot
2015-04-22
Ant Zucaro
Add the Arc to the weapons table.
commit
|
commitdiff
|
tree
|
snapshot
2015-01-11
Ant Zucaro
Add primary keys using our naming scheme.
commit
|
commitdiff
|
tree
|
snapshot
2015-01-11
Rudolf Polzer
Create a game_id index, and put the gin(players) index...
commit
|
commitdiff
|
tree
|
snapshot
2014-12-24
Ant Zucaro
The games table gets a gin index on players.
commit
|
commitdiff
|
tree
|
snapshot
2014-12-16
Ant Zucaro
Store a list of player_ids in the games table.
commit
|
commitdiff
|
tree
|
snapshot
2014-12-13
Ant Zucaro
Add new weapons to the initial data set.
commit
|
commitdiff
|
tree
|
snapshot
2014-12-02
Ant Zucaro
Partition tables out to 2020, remove old ones.
commit
|
commitdiff
|
tree
|
snapshot
2014-11-30
Ant Zucaro
Add team_game_stats to the mix.
commit
|
commitdiff
|
tree
|
snapshot
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
next