Mittens 2018 will be in Boston this September. There are three spaces left, so check out the thread for details!

Author Topic: Editor usage stats page is missing all the stats  (Read 402 times)

This seems to be broken:
http://www.adventuregamestudio.co.uk/stats.php
Code: Adventure Game Studio
  1. <html>
  2. <head>
  3.         <title>AGS Editor Version Stats</title>
  4. </head>
  5.  
  6. <body>
  7.  
  8. <h2>Total Unique Users: 0</h2>
  9. </body>

AGA

  • Adventure Game Aficionado
  • Administrator
  • Mittens Deity
  • ¡Qué alí­vio!
    • Lifetime Achievement Award Winner
    •  
    • AGA worked on a game that was nominated for an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #1 on: 07 Apr 2018, 22:37 »
It works if you pass parameters: http://www.adventuregamestudio.co.uk/stats.php?start=2018-01&end=2018-05.  There's a lot of data in there (228,697 rows at time of posting), so your browser would probably explode if it tried to return all results.

Re: Editor usage stats page is missing all the stats
« Reply #2 on: 07 Apr 2018, 23:56 »
Thanks for clarifying. :)
What would be the initial start date for the data, if I wanted to go from the beginning?

cat

  • Mittens Baronet
  • AGS Baker
  • Can you write alcohol in Japanese?
    • cat worked on a game that was nominated for an AGS Award!
      cat worked on a game that won an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #3 on: 08 Apr 2018, 08:09 »
Wow, I think the number of users is amazing! I didn't know that AGS is that popular. Thanks to all editor and engine developers for making and maintaining a tool that is used by so many people.

Crimson Wizard

  • AGS Project Tracker Admins
    • Best Innovation Award Winner 2013, for spearheading the AGS 3.3.0 project
    •  
    • Lifetime Achievement Award Winner
    •  
    • Crimson Wizard worked on a game that was nominated for an AGS Award!
      Crimson Wizard worked on a game that won an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #4 on: 08 Apr 2018, 10:16 »
Hi AGA, would it be possible to add a table line which shows total users per version? (Unless I did not notice one)

(Currently one could rely on .NET Version table, because it usually has small number of entries)

EDIT: Also... newest 3.4.2 alpha either does not report .NET version correctly, or the server does not get reported value correctly.
I recall something was changed in there.
« Last Edit: 08 Apr 2018, 10:20 by Crimson Wizard »

AGA

  • Adventure Game Aficionado
  • Administrator
  • Mittens Deity
  • ¡Qué alí­vio!
    • Lifetime Achievement Award Winner
    •  
    • AGA worked on a game that was nominated for an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #5 on: 09 Apr 2018, 21:55 »
So it turns out that the logic I used previously might not have been entirely accurate (elevating the user numbers a bit).  Still a decent number in total, but not as high as it might have appeared.  Also note that it's per IP per version, so if one IP used multiple versions, that person is of course counted multiple times.

Thanks for clarifying. :)
What would be the initial start date for the data, if I wanted to go from the beginning?

2008-07.  Although the parameters are parsed in such a way that you could probably enter 0001-01 and it'd return the same results.

Hi AGA, would it be possible to add a table line which shows total users per version? (Unless I did not notice one)

(Currently one could rely on .NET Version table, because it usually has small number of entries)

EDIT: Also... newest 3.4.2 alpha either does not report .NET version correctly, or the server does not get reported value correctly.
I recall something was changed in there.

Done. 

The .NET versions are being stored as zero for that version, but not sure why, or whether the script is actually receiving zeroes...  The datatype was set to decimal 20,0 (length 20, but zero after the point), but that shouldn't really cause zeroes to be stored.  If you want, I can just store the versions as varchars, so the exact x.y.z version of the framework is stored, rather than losing precision.

Re: Editor usage stats page is missing all the stats
« Reply #6 on: 09 Apr 2018, 22:09 »
Is there any chance of getting a copy of the database?

AGA

  • Adventure Game Aficionado
  • Administrator
  • Mittens Deity
  • ¡Qué alí­vio!
    • Lifetime Achievement Award Winner
    •  
    • AGA worked on a game that was nominated for an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #7 on: 10 Apr 2018, 06:01 »
You'd have to have the database without the IP addresses, which would remove the unique identifiers, making it harder to use...

Re: Editor usage stats page is missing all the stats
« Reply #8 on: 10 Apr 2018, 17:37 »
Could you hash the addresses with a random salt and let the webserver return the original data plus the hash (rather than only a count summary). It would be slow too do this hash dynamically, but since all data except the current month is not going to change you could just process offline and serve static files.

AGA

  • Adventure Game Aficionado
  • Administrator
  • Mittens Deity
  • ¡Qué alí­vio!
    • Lifetime Achievement Award Winner
    •  
    • AGA worked on a game that was nominated for an AGS Award!
Re: Editor usage stats page is missing all the stats
« Reply #9 on: 10 Apr 2018, 19:31 »
http://www.adventuregamestudio.co.uk/userstats.rar <- CSV of all records to date with IPs hashed, with uniqueness preserved.

Re: Editor usage stats page is missing all the stats
« Reply #10 on: 10 Apr 2018, 20:15 »
That's great, thanks. I've downloaded a copy.