xonotic/xonstat.git
3 years agoConvert the server info to a class-based view callable. Add a dummy JSON view.
Ant Zucaro [Sun, 16 Oct 2016 15:25:41 +0000 (11:25 -0400)]
Convert the server info to a class-based view callable. Add a dummy JSON view.

3 years agoAdd docstrings.
Ant Zucaro [Sun, 16 Oct 2016 14:22:59 +0000 (10:22 -0400)]
Add docstrings.

3 years agoConvert the server index to a class-based view callable. Add a JSON view.
Ant Zucaro [Sun, 16 Oct 2016 13:50:51 +0000 (09:50 -0400)]
Convert the server index to a class-based view callable. Add a JSON view.

3 years agoUse pserve, not paster.
Ant Zucaro [Sun, 26 Jun 2016 16:41:25 +0000 (12:41 -0400)]
Use pserve, not paster.

3 years agoShow player medals on the player_info page.
Ant Zucaro [Tue, 29 Mar 2016 01:11:43 +0000 (21:11 -0400)]
Show player medals on the player_info page.

3 years agoAdd a simple form for the versus view.
Ant Zucaro [Sat, 12 Mar 2016 14:22:26 +0000 (09:22 -0500)]
Add a simple form for the versus view.

3 years agoInitial version of the "versus" view between two players.
Ant Zucaro [Sat, 12 Mar 2016 13:39:55 +0000 (08:39 -0500)]
Initial version of the "versus" view between two players.

4 years agoRename the "top" templates to match their views.
Ant Zucaro [Sat, 6 Feb 2016 21:28:13 +0000 (16:28 -0500)]
Rename the "top" templates to match their views.

4 years agoMake the active players/servers/maps use the cache.
Ant Zucaro [Sat, 6 Feb 2016 21:21:44 +0000 (16:21 -0500)]
Make the active players/servers/maps use the cache.

Instead of fetching from the base data, the active players/server/maps views
will fetch from the so-called "materialized view" tables instead. These tables
are precomputed and will be MUCH faster, performance-wise. Regular Beaker
caching remains the same for these, and the paginated pages now only support
clicking "more" until the list is exhausted. Perhaps in the future they will be
fetched via JSON and appended to the page in a "never-ending scroll" thing.

4 years agoMerge branch 'master' of github.com:antzucaro/XonStat
Ant Zucaro [Sun, 31 Jan 2016 14:56:04 +0000 (09:56 -0500)]
Merge branch 'master' of github.com:antzucaro/XonStat

4 years agoUse the summary_stats_mv instead of the full table.
Ant Zucaro [Sun, 31 Jan 2016 14:55:50 +0000 (09:55 -0500)]
Use the summary_stats_mv instead of the full table.

4 years agoForce create_dt to start_dt for games.
Ant Zucaro [Wed, 27 Jan 2016 01:16:57 +0000 (20:16 -0500)]
Force create_dt to start_dt for games.

There's some drift in the database between the two, when in actuality they
should only be milliseconds apart. The start_dt *was* being set via the
application and the create_dt with a database default. The values resulting
from the defaults were sometimes minutes earlier, which doesn't makes sense.
Until the true cause is identified I'll force the two to be the same.

4 years agoAdd another sorting option to player_captimes.
Ant Zucaro [Wed, 27 Jan 2016 01:10:28 +0000 (20:10 -0500)]
Add another sorting option to player_captimes.

You can now sort by two fields: most recent and fastest. This is done with a
line at the bottom of the table that allows you to toggle. Fixes #163.

4 years agoAdd a plus-sign link to the player_game_index.
Ant Zucaro [Mon, 25 Jan 2016 21:02:33 +0000 (16:02 -0500)]
Add a plus-sign link to the player_game_index.

4 years agoFix the navigation icons. Fixes #161.
Ant Zucaro [Sat, 23 Jan 2016 15:51:36 +0000 (10:51 -0500)]
Fix the navigation icons. Fixes #161.

For some reason the navigation links were still using the old "glyphicon" font
classes. This meant that the actual "previous" and "next" page links weren't
actually visible, leading to some navigation issues. Changing them to the
font-awesome classes makes them visible again!

4 years agoMake the rank index titles data-driven.
Ant Zucaro [Sat, 23 Jan 2016 15:40:50 +0000 (10:40 -0500)]
Make the rank index titles data-driven.

4 years agoWhitelist rank game types in the view. Fixes #162.
Ant Zucaro [Sat, 23 Jan 2016 15:08:41 +0000 (10:08 -0500)]
Whitelist rank game types in the view. Fixes #162.

The game types where you could view ranks were previously controlled by a
regular expression check within the route. This was completely NOT obvious to
troubleshoot. This moves them to within the view, which is much easier to
control. Additionally, a 404-check is added for malformed values.

4 years agoClean up the game info view.
Ant Zucaro [Sat, 23 Jan 2016 14:50:02 +0000 (09:50 -0500)]
Clean up the game info view.

4 years agoThe player JSON view should use to_dict() instead.
Ant Zucaro [Thu, 21 Jan 2016 02:46:22 +0000 (21:46 -0500)]
The player JSON view should use to_dict() instead.

4 years agoMake the game finder JSON-enabled.
Ant Zucaro [Thu, 21 Jan 2016 02:43:13 +0000 (21:43 -0500)]
Make the game finder JSON-enabled.

This allows applications to get "recent games" via an API.

4 years agoFoundation columns should add up to 12, not 13.
Ant Zucaro [Mon, 18 Jan 2016 22:22:45 +0000 (17:22 -0500)]
Foundation columns should add up to 12, not 13.

4 years agoReduce the number of fast caps shown on the map_info page.
Ant Zucaro [Sat, 16 Jan 2016 22:55:46 +0000 (17:55 -0500)]
Reduce the number of fast caps shown on the map_info page.

4 years agoAdd a link to view the fastest capture times on the map_info page.
Ant Zucaro [Sat, 16 Jan 2016 22:48:29 +0000 (17:48 -0500)]
Add a link to view the fastest capture times on the map_info page.

4 years agoMove MapCapTime and PlayerCapTime to models.
Ant Zucaro [Sat, 16 Jan 2016 22:36:56 +0000 (17:36 -0500)]
Move MapCapTime and PlayerCapTime to models.

The more I thought about it, the more I think that these two classes should
live inside the models module. They are nothing more than models for views. So
what if they aren't object-relational!

4 years agoThrow HTTP 404s if either the player or map do not exist.
Ant Zucaro [Sat, 16 Jan 2016 13:00:58 +0000 (08:00 -0500)]
Throw HTTP 404s if either the player or map do not exist.

4 years agoAllow fetching player captimes using the JSON endpoint.
Ant Zucaro [Sat, 16 Jan 2016 12:45:28 +0000 (07:45 -0500)]
Allow fetching player captimes using the JSON endpoint.

4 years agoFix the JSON view for map captimes.
Ant Zucaro [Sat, 16 Jan 2016 00:15:23 +0000 (19:15 -0500)]
Fix the JSON view for map captimes.

4 years agoClean up xs_submit.
Ant Zucaro [Sun, 29 Nov 2015 15:07:55 +0000 (10:07 -0500)]
Clean up xs_submit.

This was written when I didn't really know that much Golang. I know a little
bit more about it now, so I can at least format accordingly! Also I know how to
use a Scanner now. Shame on my past self...

4 years agoAdd ranks to the post-match template.
Ant Zucaro [Sun, 29 Nov 2015 15:06:27 +0000 (10:06 -0500)]
Add ranks to the post-match template.

4 years agoFetch ranks for the post-match report.
Ant Zucaro [Sun, 29 Nov 2015 15:05:08 +0000 (10:05 -0500)]
Fetch ranks for the post-match report.

The ranks are updated daily, so they don't change game-per-game for an
individual, but having the rank value still tells people how strong a player
is that they've been playing against.

4 years agoUse raw ID values, not URLs.
Ant Zucaro [Thu, 19 Nov 2015 13:21:47 +0000 (08:21 -0500)]
Use raw ID values, not URLs.

The game doesn't have clickable links anyway.

4 years agoRemove k-factor, score-per-second, and alivetime.
Ant Zucaro [Thu, 19 Nov 2015 03:09:13 +0000 (22:09 -0500)]
Remove k-factor, score-per-second, and alivetime.

The k-factor and score-per-second values don't have any use for the game UI and
the server already knows the alivetime values of all participants.

4 years agoProvide a plaintext response to stats submissions.
Ant Zucaro [Thu, 19 Nov 2015 01:29:07 +0000 (20:29 -0500)]
Provide a plaintext response to stats submissions.

For all of XonStat's history the POST requests sent in by servers had plain
HTTP responses. This begins to change with this commit, which responds back to
the Xonotic server with meaningful information about /what happened/ during the
match that was just submitted. Of particular importance are the player_ids and
elo delta values that were stored as a result of the game. The template
establishing the format for this is submit_stats.mako. It will be extended
after we decide what other things we want to include.

4 years agoRefactor the Elo processing code into EloProcessor.
Ant Zucaro [Sat, 14 Nov 2015 21:20:33 +0000 (16:20 -0500)]
Refactor the Elo processing code into EloProcessor.

Before, Elo processing was simply a couple of extra methods that mutated
PlayerGameStat and PlayerElo rows, adding them to a session for updating or
inserting later. In order to support an end-of-match game report, we now need
to hold onto to those intermediate values so they can be passed into a
template. To do this I created an EloProcessor class to perform all of the
computation and an EloWIP class to hold onto all of the intermediate values.
EloProcessor can be used to find out what changed during Elo calculations.

4 years agoGet rid of some commented, unused code.
Ant Zucaro [Sun, 8 Nov 2015 23:12:15 +0000 (18:12 -0500)]
Get rid of some commented, unused code.

4 years agoClean up the production configuration file.
Ant Zucaro [Sun, 8 Nov 2015 19:22:01 +0000 (14:22 -0500)]
Clean up the production configuration file.

This includes a little better organization of the production.ini file for
administrators. It includes comments on the different directives, better
indentation, and rotating log files of limited size using Python's
logging.handlers.RotatingFileHandler facility.

4 years agoDon't put anonymous players in games.players
Ant Zucaro [Sat, 7 Nov 2015 15:15:54 +0000 (10:15 -0500)]
Don't put anonymous players in games.players

The "games" table has a convenience, de-normalized column for storing the list
of player_ids who played in that game. This is intended for use in quick
searches. Since anonymous players (players having a player_id == 2) aren't
searchable, they don't need to be in this list. This should decrease the
overall size of the GIN index on that column over time.

4 years agoUse only one regex to identify bots
Ant Zucaro [Sat, 7 Nov 2015 15:09:57 +0000 (10:09 -0500)]
Use only one regex to identify bots

Two is wasteful.

4 years agoMerge pull request #22 from antzucaro/nvd3-v2
Ant Zucaro [Thu, 29 Oct 2015 00:55:11 +0000 (20:55 -0400)]
Merge pull request #22 from antzucaro/nvd3-v2

Go back to NVD3.js

4 years agoAdd nvd3 css, integrate charts in the player_info page. nvd3-v2
Ant Zucaro [Thu, 29 Oct 2015 00:49:19 +0000 (20:49 -0400)]
Add nvd3 css, integrate charts in the player_info page.

4 years agoAdd minified version of the weapon charts.
Ant Zucaro [Thu, 29 Oct 2015 00:48:24 +0000 (20:48 -0400)]
Add minified version of the weapon charts.

4 years agoChange margin of the weaponCharts.
Ant Zucaro [Thu, 29 Oct 2015 00:47:43 +0000 (20:47 -0400)]
Change margin of the weaponCharts.

4 years agoAdd NVD3.js to vendor.
Ant Zucaro [Mon, 26 Oct 2015 22:14:16 +0000 (18:14 -0400)]
Add NVD3.js to vendor.

4 years agoAdd D3.js to vendor.
Ant Zucaro [Mon, 26 Oct 2015 22:14:01 +0000 (18:14 -0400)]
Add D3.js to vendor.

4 years agoStore and show goals in the "caps" field of team scores. Fixes #155.
Ant Zucaro [Wed, 8 Jul 2015 11:02:15 +0000 (07:02 -0400)]
Store and show goals in the "caps" field of team scores. Fixes #155.

4 years agoOops, off-by-one error on the damageChart series.
Ant Zucaro [Sat, 13 Jun 2015 13:38:23 +0000 (09:38 -0400)]
Oops, off-by-one error on the damageChart series.

4 years agoStore player-to-map captimes by mod.
Ant Zucaro [Sat, 13 Jun 2015 13:23:10 +0000 (09:23 -0400)]
Store player-to-map captimes by mod.

4 years agoStore impure cvar changes, and use them to mark servers as pure or not.
Ant Zucaro [Sat, 13 Jun 2015 12:01:24 +0000 (08:01 -0400)]
Store impure cvar changes, and use them to mark servers as pure or not.

4 years agoMake valid NB games those w/ nonzero scores ONLY. Fixes #152.
Ant Zucaro [Sat, 6 Jun 2015 13:20:58 +0000 (09:20 -0400)]
Make valid NB games those w/ nonzero scores ONLY. Fixes #152.

4 years agoRemove the rifle from the damage and accuracy charts.
Ant Zucaro [Sat, 6 Jun 2015 13:13:46 +0000 (09:13 -0400)]
Remove the rifle from the damage and accuracy charts.

4 years agoMinify the new weaponCharts code.
Ant Zucaro [Sat, 6 Jun 2015 04:00:42 +0000 (00:00 -0400)]
Minify the new weaponCharts code.

4 years agoMerge branch 'master' of gitlab.com:xonotic/xonstat
Ant Zucaro [Fri, 5 Jun 2015 15:41:38 +0000 (11:41 -0400)]
Merge branch 'master' of gitlab.com:xonotic/xonstat

4 years agoAdd Arc to the damage chart.
Ant Zucaro [Fri, 5 Jun 2015 15:30:40 +0000 (11:30 -0400)]
Add Arc to the damage chart.

4 years agoMerge branch 'sev/unicode_mapping_fix' into 'master'
Ant Zucaro [Wed, 6 May 2015 02:38:26 +0000 (02:38 +0000)]
Merge branch 'sev/unicode_mapping_fix' into 'master'

Correct the mapping of the smiling emoticon

I noticed that one of my unicode mappings is incorrect. Sorry about that.
This branch changes U+1F60F (😏) to the correct U+1F603 (😃).

See merge request !2

4 years agoCorrect the mapping of the smiling emoticon
Severin Meyer [Mon, 4 May 2015 17:39:49 +0000 (19:39 +0200)]
Correct the mapping of the smiling emoticon

4 years agoUse class, not style. Doh!
Ant Zucaro [Wed, 29 Apr 2015 22:27:04 +0000 (18:27 -0400)]
Use class, not style. Doh!

4 years agoRemove spaces that cause offset issues on Chrome.
Ant Zucaro [Fri, 24 Apr 2015 12:18:25 +0000 (08:18 -0400)]
Remove spaces that cause offset issues on Chrome.

4 years agoAdd Arc to the accuracy table.
Ant Zucaro [Wed, 22 Apr 2015 11:00:07 +0000 (07:00 -0400)]
Add Arc to the accuracy table.

4 years agoClean up comments.
Ant Zucaro [Wed, 22 Apr 2015 10:52:21 +0000 (06:52 -0400)]
Clean up comments.

4 years agoRemove the join to game stats for accuracy data.
Ant Zucaro [Wed, 22 Apr 2015 10:48:25 +0000 (06:48 -0400)]
Remove the join to game stats for accuracy data.

This speeds up the game_info view considerably. On my local machine the
requests go from .62 to about .2 seconds! I believe the pgstat rows were
included in the response to show nicknames in the accuracy table.

I'll have to do further checks to ensure that if a pgstat row exists a
corresponding pwstat row exists as well.

4 years agoFix the machinegun sprite and sync CSS. Fixes #149.
Ant Zucaro [Sun, 19 Apr 2015 20:02:20 +0000 (16:02 -0400)]
Fix the machinegun sprite and sync CSS. Fixes #149.

4 years agoUse Luma game type icons on the player-recent-games view. Fixes #150.
Ant Zucaro [Sun, 19 Apr 2015 19:51:34 +0000 (15:51 -0400)]
Use Luma game type icons on the player-recent-games view. Fixes #150.

4 years agoThe game_index template has not been used in a long, long time.
Ant Zucaro [Sun, 19 Apr 2015 19:48:05 +0000 (15:48 -0400)]
The game_index template has not been used in a long, long time.

4 years agoCopy the mono icon for local reference.
Ant Zucaro [Sun, 19 Apr 2015 14:04:43 +0000 (10:04 -0400)]
Copy the mono icon for local reference.

4 years agoSet a color for the Arc. foundation
Ant Zucaro [Sun, 19 Apr 2015 12:38:25 +0000 (08:38 -0400)]
Set a color for the Arc.

4 years agoBundle in Luma.
Ant Zucaro [Sun, 19 Apr 2015 12:35:24 +0000 (08:35 -0400)]
Bundle in Luma.

4 years agoAdd combined CSS.
Ant Zucaro [Sun, 19 Apr 2015 12:32:13 +0000 (08:32 -0400)]
Add combined CSS.

4 years agoAdd more width to the grid.
Ant Zucaro [Sun, 19 Apr 2015 12:19:08 +0000 (08:19 -0400)]
Add more width to the grid.

4 years agoFix the display of the weapon icon on mobile.
Ant Zucaro [Sun, 19 Apr 2015 12:10:27 +0000 (08:10 -0400)]
Fix the display of the weapon icon on mobile.

4 years agoUse Luma throughout the site. Thank you, sev!
Ant Zucaro [Sun, 19 Apr 2015 12:06:49 +0000 (08:06 -0400)]
Use Luma throughout the site. Thank you, sev!

4 years agoAdd Luma font and styles.
Ant Zucaro [Sun, 19 Apr 2015 12:05:31 +0000 (08:05 -0400)]
Add Luma font and styles.

4 years agoFix the recent games table for the server info page.
Ant Zucaro [Sun, 12 Apr 2015 14:32:08 +0000 (10:32 -0400)]
Fix the recent games table for the server info page.

4 years agoMake the player game index page mobile-friendly.
Ant Zucaro [Sun, 12 Apr 2015 13:18:24 +0000 (09:18 -0400)]
Make the player game index page mobile-friendly.

4 years agoClean up the accuracy tables, make them mobile friendly.
Ant Zucaro [Sun, 12 Apr 2015 13:05:56 +0000 (09:05 -0400)]
Clean up the accuracy tables, make them mobile friendly.

4 years agoStyle the game table for keyhunt.
Ant Zucaro [Sun, 12 Apr 2015 01:36:38 +0000 (21:36 -0400)]
Style the game table for keyhunt.

4 years agoStyle the game table for ca, dm, duel, rune, and tdm.
Ant Zucaro [Sun, 12 Apr 2015 01:26:08 +0000 (21:26 -0400)]
Style the game table for ca, dm, duel, rune, and tdm.

4 years agoColor score cells yellow.
Ant Zucaro [Sun, 12 Apr 2015 01:18:48 +0000 (21:18 -0400)]
Color score cells yellow.

4 years agoFormat duel and ctf scoreboards.
Ant Zucaro [Sun, 12 Apr 2015 01:14:46 +0000 (21:14 -0400)]
Format duel and ctf scoreboards.

4 years agoUse all columns for mobile game tables.
Ant Zucaro [Sun, 12 Apr 2015 01:14:01 +0000 (21:14 -0400)]
Use all columns for mobile game tables.

4 years agoCustomize accordion behavior.
Ant Zucaro [Sat, 11 Apr 2015 00:26:15 +0000 (20:26 -0400)]
Customize accordion behavior.

4 years agoDefine a new block for Foundation customizations.
Ant Zucaro [Sat, 11 Apr 2015 00:26:00 +0000 (20:26 -0400)]
Define a new block for Foundation customizations.

4 years agoImproved accuracy tabs on the game page.
Ant Zucaro [Sat, 11 Apr 2015 00:21:04 +0000 (20:21 -0400)]
Improved accuracy tabs on the game page.

4 years agoAdd a hover style to table-hover TRs.
Ant Zucaro [Sat, 4 Apr 2015 17:34:55 +0000 (13:34 -0400)]
Add a hover style to table-hover TRs.

4 years agoProgress on the game info page.
Ant Zucaro [Sun, 29 Mar 2015 13:47:07 +0000 (09:47 -0400)]
Progress on the game info page.

4 years agoConvert the player_info page.
Ant Zucaro [Sat, 21 Mar 2015 19:40:09 +0000 (15:40 -0400)]
Convert the player_info page.

Geez that was a huge one. I'll have to refactor this one later. In particular
the tab content is long and convoluted. It is a good candidate for moving into
a separate template, which can then be used with a namespace.

4 years agoConvert the search page.
Ant Zucaro [Sat, 21 Mar 2015 00:42:55 +0000 (20:42 -0400)]
Convert the search page.

4 years agoRemove the border around fieldsets.
Ant Zucaro [Sat, 21 Mar 2015 00:42:41 +0000 (20:42 -0400)]
Remove the border around fieldsets.

4 years agoFix the mobile view of the map_info page.
Ant Zucaro [Sat, 21 Mar 2015 00:18:21 +0000 (20:18 -0400)]
Fix the mobile view of the map_info page.

4 years agoConvert the map_captimes view.
Ant Zucaro [Sat, 21 Mar 2015 00:15:55 +0000 (20:15 -0400)]
Convert the map_captimes view.

4 years agoConvert the map_info view.
Ant Zucaro [Fri, 20 Mar 2015 22:15:02 +0000 (18:15 -0400)]
Convert the map_info view.

4 years agoFix columns in the server_info view.
Ant Zucaro [Thu, 19 Mar 2015 22:40:07 +0000 (18:40 -0400)]
Fix columns in the server_info view.

4 years agoRemove missing views from the import list.
Ant Zucaro [Thu, 19 Mar 2015 22:36:34 +0000 (18:36 -0400)]
Remove missing views from the import list.

4 years agoInitial conversion of the server_info view.
Ant Zucaro [Wed, 18 Mar 2015 11:03:06 +0000 (07:03 -0400)]
Initial conversion of the server_info view.

4 years agoRemove the server_game_index view.
Ant Zucaro [Wed, 18 Mar 2015 10:43:02 +0000 (06:43 -0400)]
Remove the server_game_index view.

This view was replaced by the game_finder view. During that time I removed the
other views that implemented this functionality, but I must have missed this
one! It still had an active route mapping, although no other route used it.

4 years agoConvert the player_captimes view.
Ant Zucaro [Tue, 17 Mar 2015 22:26:07 +0000 (18:26 -0400)]
Convert the player_captimes view.

4 years agoConvert the player_game_index view.
Ant Zucaro [Tue, 17 Mar 2015 22:12:52 +0000 (18:12 -0400)]
Convert the player_game_index view.

4 years agoChange some of the 404 messages.
Ant Zucaro [Sat, 14 Mar 2015 11:31:31 +0000 (07:31 -0400)]
Change some of the 404 messages.

4 years agoRe-indent the 404 page.
Ant Zucaro [Sat, 14 Mar 2015 11:28:23 +0000 (07:28 -0400)]
Re-indent the 404 page.

4 years agoExpand the table width of all main index pages on mobile.
Ant Zucaro [Sat, 14 Mar 2015 02:20:46 +0000 (22:20 -0400)]
Expand the table width of all main index pages on mobile.

4 years agoFix the form submission field.
Ant Zucaro [Sat, 14 Mar 2015 02:15:15 +0000 (22:15 -0400)]
Fix the form submission field.