search

jmh9072 / ustalk

Automatically exported from code.google.com/p/ustalk
0 stars 0 forks source link

Stalking Statistics #7

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be nice to have a page with statistics. This could include

    * Most-stalked people
    * A way to query for the number of users stalking you, as well as their uStalk UIDs and (if given permission) their username.
    * Bungie.net users online currently

Original issue reported on code.google.com by jmh9072 on 13 Sep 2010 at 7:39

GoogleCodeExporter commented 9 years ago 
A couple useful queries:

#Most stalked users:
SELECT `bid`,COUNT(`bid`) FROM `uwatch` GROUP BY `bid` ORDER BY COUNT(`bid`) 
DESC

I'm starting to think probably we shouldn't post these constantly/just have a 
list on the website as there is nothing good that could particularly come of it 
(people making alts to get themselves up in the meaningless rankings). Rather, 
it might just be interesting to post a couple of the interesting tidbits in the 
uStalk thread for people to look at. I was thinking number of stalkers, number 
of stalkees, 5 most popular stalkees (bid=0 excluded), top stalkers as denoted 
by the number of people they stalk (modstalk/employee stalk excluded).

Original comment by Firebird347 on 22 Dec 2010 at 10:32