Opened 10 years ago

Last modified 19 months ago

#2448 new enhancement

Display gameplay statistics from the lobby on a website

Reported by: Josh Owned by:
Priority: If Time Permits Milestone: Backlog
Component: Multiplayer lobby Keywords: beta
Cc: scythetwirler, Andy Alt Patch:

Description (last modified by Andy Alt)

Currently at the end of rated games started through the lobby, a bunch of game statistics are sent back to XpartaMuPP and stored in an sqlite3 database (setup by this script).

It would be nice to make this data public in some infographics on a webpage (lobby.wildfiregames.com port 80 should work nicely).

As for the technical side, we could use Google Charts and some basic HTML/JS/CSS to display the data. To access the data we should either parse the database server-side to an intermediate format (like JSON) or just access it directly client-side.

Change History (12)

comment:1 by Josh, 10 years ago

#2463 mentioned it might be nice to show currently running games as well (should not be too hard as XpartaMuPP keeps a running list).

comment:2 by scythetwirler, 10 years ago

In 15751:

Makes running games visible in the lobby. These will be colored in red. Refs #2463, #2448.

in reply to:  2 ; comment:3 by Josh, 10 years ago

Replying to scythetwirler:

In 15751:

Makes running games visible in the lobby. These will be colored in red. Refs #2463, #2448.

Why do we want this? Anyone who needs to see a game already can now. I didn't think we wanted observers joining and leaving mid-game without invitation.

You also didn't update the comment in lobby.js.

Last edited 10 years ago by Josh (previous) (diff)

comment:4 by Josh, 10 years ago

Cc: scythetwirler added

in reply to:  3 comment:5 by scythetwirler, 10 years ago

Replying to Josh:

Replying to scythetwirler:

In 15751:

Makes running games visible in the lobby. These will be colored in red. Refs #2463, #2448.

Why do we want this? Anyone who needs to see a game already can now. I didn't think we wanted observers joining and leaving mid-game without invitation.

You also didn't update the comment in lobby.js.

Oops, forgot about the comment.

Users still can't join a game that has already started (spectator or otherwise) unless they were there during the gamesetup phase.

I've seen a lot of players come into the lobby and leave because they think there are no servers available. Also, it's nice to be able to see who is in what game and who's playing who instead of a seemingly empty "all servers down-for-maintenance" look. :P

comment:6 by scythetwirler, 10 years ago

In 15753:

Updates a comment forgotten in r15751. Refs #2463, #2448.

comment:7 by Josh, 10 years ago

The games in progress should at least be sorted to the bottom, but I guess showing them is fine until we have a more active community.

comment:8 by scythetwirler, 10 years ago

Right, I'll update the sort function.

comment:9 by historic_bruno, 10 years ago

I like the idea, otherwise it looks too empty in the lobby.

comment:10 by scythetwirler, 10 years ago

In 15754:

Sorts games in gamesList by status, then name. Refs #2463, #2448.

comment:11 by scythetwirler, 7 years ago

Keywords: beta added

comment:12 by Andy Alt, 19 months ago

Cc: Andy Alt added
Description: modified (diff)
Owner: Josh removed
Note: See TracTickets for help on using tickets.