Ask Tass For Weird FFR Stat Information

[SpammyMcSquirrel]

Re: Ask Tass For Weird FFR Stat Information

How many McSquirrels are there total?

[Tasselfoot]

Re: Ask Tass For Weird FFR Stat Information

i already answered that in this thread. lol.

[SpammyMcSquirrel]

Re: Ask Tass For Weird FFR Stat Information

Lol sorry.
Too lazy to go search the pages. XD

EDIT: Nevermind, found it.
XD 46. Last Time I checked there were about 25.
and turned off colored text for LD.

[lightdarkness]

Re: Ask Tass For Weird FFR Stat Information

ughhhhhhh, colored text is so annoying

[Popmeister]

Re: Ask Tass For Weird FFR Stat Information

We have "number of times played" shown now, but is it possible to tell how many times it has taken a player to AAA/FC [insert song here] and when the scores were accomplished? If so, how many times has it taken me to
...AAA CI?
...AAA Gradeus and JRB after the avmiss fix?
...FC FotBB after the avmiss fix?
...FC LW4?

EDIT: Also, who out of those that AAA'd Kyuin made the most attempts?

[rauchster]

Re: Ask Tass For Weird FFR Stat Information

I spent a few minutes reading all these posts and a few more thinking just to make sure I asked a new question. Or two. Or several hundred.
Ones that haven't been asked before, and I think everyone would be curious to know. (except for the ones relating to just me)
And don't think I'm gonna make it easy on ya. :P

Instead of giving the most and least played songs.
Take the list of plays per song, and divide it by the days it has been out.
Then see which ones rank as most and least. Top 5 of each if possible. Or just send me the list of Total Numbers of Song Plays per Song and I'll do the math and post back.
(I'm pretty sure DotA will be #1 Most... but who knows)

I am curious to know the exact number of Perfect/Good/Avg/Miss/Boo I've gotten since I started this account. Since it's my only account, I'm curious to see how many Arrows I've hit.
If possible, get me the first month's totals and last month's totals as well. To see my progress.

How many arrows have been seen by any user since you started keeping track of stats? I.E. Every Perf/Good/Avg/Miss that has occurred.

How many keystrokes have been pressed?
I.E. Every Perf/Good/Avg/Boo that has occurred.

How many games are played a day? Arrows seen on a screen per day? Keystrokes pressed per day? Games Finished per day?

What is the total GTS of every player combined?

What is the Average - Average Rank?

What is the lowest possible Average Rank? (Someone who has the lowest possible score on every song)

How many of the (currently) 1,529,887 members are actually still active? (logged within a time-frame of your choosing)

How many of my 6,674 plays (currently) did not reach the end of the song, either due to Boo-Out or Fail?

How many of the total games played have not been finished, either to Boo-Out or Fail.

Who has the most songs unlocked of the current total of 660?(661? with new token on the first?) - (I'm assuming there might be a tie for this including MrRubix, Laggy, and a few others)

What is the total number of PM's sent in total?

What day did the first version of FFR go online?

Who was the first non-admin(past or present) to play FFR?

How many stepfiles have been submitted for use in FFR? How many rejected? How many pending?

What user has submitted the most stepfiles (not most in game)?

What user has had the most (number-wise) rejected?

What is the average MP Rank of those who have actually played an MP game?

What is the average Grand Total Score of all those who have played a game?

What is the average number of posts of those who have actually posted?

What is the average number of referred users of those who have at least 1?

What is the average number of profile views per profile?

Who has the most viewed profile? The least viewed?

What is the average number of comments per profile?

Who has the most commented profile?(there's a page for today's, but not overall)

How many (known) FFR widgets are out there?

Did you curse after reading all these? Laugh? What?
I probably deserve it.
Answer whenever you're done cursing me, if at all.

By the way, If you need help with SQL, I ran a database for quite a while and had a bunch of experience working with SQL, and creating stuff for a game (Knight Online). I know it's different, but I'm experienced with working with SQL Databases (using 2000 Enterprise Edition) and doing queries and the like.

[Tasselfoot]

Re: Ask Tass For Weird FFR Stat Information

We have "number of times played" shown now, but is it possible to tell how many times it has taken a player to AAA/FC [insert song here] and when the scores were accomplished? If so, how many times has it taken me to
...AAA CI?
...AAA Gradeus and JRB after the avmiss fix?
...FC FotBB after the avmiss fix?
...FC LW4?

EDIT: Also, who out of those that AAA'd Kyuin made the most attempts?

not possible to tell.... since there is no flag to say "oh, hey, this is when you got the AAA." BUT... we can tell when you most recently AAAd. So if you've only AAAd once, we could tell you when that is. But if you've AAAd more than once, it'd be the most recent. And it would be in Linux time, so you'd have to convert.

sc979 has played Kyuin the most times out of the 22 users who have AAAd... 487 times. Then dag12 at 244. Pop, you're 11th with 42 gameplays. Even Rubix has 21 plays on it. Least gameplays: HighAndr0id with 8, then ieat and laggy with 9 each... although Andr0id and Laggy are both post-avmiss fix, so it makes sense they have less plays on it.

Rauch: I'll get to your retardedly long list tomorrow. It's late.

[rauchster]

Re: Ask Tass For Weird FFR Stat Information

Rauch: I'll get to your retardedly long list tomorrow. It's late.

Sigged.

[Tasselfoot]

Re: Ask Tass For Weird FFR Stat Information

putting my responses inside your quote. too big of a pain otherwise.

I spent a few minutes reading all these posts and a few more thinking just to make sure I asked a new question. Or two. Or several hundred.
Ones that haven't been asked before, and I think everyone would be curious to know. (except for the ones relating to just me)
And don't think I'm gonna make it easy on ya. :P

Instead of giving the most and least played songs.
Take the list of plays per song, and divide it by the days it has been out.
Then see which ones rank as most and least. Top 5 of each if possible. Or just send me the list of Total Numbers of Song Plays per Song and I'll do the math and post back.
(I'm pretty sure DotA will be #1 Most... but who knows)

--We don't have exact release dates on every level... this would be a royal pain in the ass to calculate.

I am curious to know the exact number of Perfect/Good/Avg/Miss/Boo I've gotten since I started this account. Since it's my only account, I'm curious to see how many Arrows I've hit.
If possible, get me the first month's totals and last month's totals as well. To see my progress.

--We don't keep this data

How many arrows have been seen by any user since you started keeping track of stats? I.E. Every Perf/Good/Avg/Miss that has occurred.

--We don't keep this data

How many keystrokes have been pressed?
I.E. Every Perf/Good/Avg/Boo that has occurred.

--We don't keep this data

How many games are played a day? Arrows seen on a screen per day? Keystrokes pressed per day? Games Finished per day?

--From registered users only, there are 150,000-200,000 games played per day. Adding in unregistered gameplays, it's a lot more. And, we don't keep track of any of the other stuff.

What is the total GTS of every player combined?

--See the contest we ran last week

What is the Average - Average Rank?

--Probably close to 50,000. Since the ave rank for not playing a level is ~52,000 or so, and most people haven't played many games of FFR... ave ave rank will be very close to the unplayed ave rank.

What is the lowest possible Average Rank? (Someone who has the lowest possible score on every song)

--A hair over 52,000.

How many of the (currently) 1,529,887 members are actually still active? (logged within a time-frame of your choosing)

--Check the bottom of the forum... I think that that is active over the last 24 or 48 hours, something like that.

How many of my 6,674 plays (currently) did not reach the end of the song, either due to Boo-Out or Fail?

--We don't keep this data

How many of the total games played have not been finished, either to Boo-Out or Fail.

--We don't keep this data

Who has the most songs unlocked of the current total of 660?(661? with new token on the first?) - (I'm assuming there might be a tie for this including MrRubix, Laggy, and a few others)

--There are a decent number of users who have every song... but, you can only consider the users who have vROFL, which Laggy does not have (yet). 72 users have vROFL... but of those, at most 10 have every other song unlocked. Too lazy to go through and count up who has all of them. But probably 10 or less people. Definitely under 20.

What is the total number of PM's sent in total?

--No idea, but currently 9 users have 1000+ PMs stored (that's received and sent). Synth has about 6600, I've got about 5500, and Jason has about 4300.

What day did the first version of FFR go online?

--Sometime in August, 2002.

Who was the first non-admin(past or present) to play FFR?

spigot is the first registered user after Synth

How many stepfiles have been submitted for use in FFR? How many rejected? How many pending?

--A few thousand. All that aren't in-game / queue. There are about 30 songs in queue currently. Also, to put it in perspective... I've gotten about 10-12 GB worth of simfiles submitted to me.

What user has submitted the most stepfiles (not most in game)?

--Rebirth, hi19, or macgravel... Depends if you count widgets. Vote4Nixon has 32 (mostly widgets), SulferDragon has 41 (only 3 widget files), Rebirth has 70 (18 widgets), macgravel has 65 (59 widgets, lol), jimerax has 47 (4 widget), hi19 has 49 (0 widget).ElectricWerewolf has 69 (41 widget), dore has 44 (12 widget), Ben Speirs has 45 (33 widget)

What user has had the most (number-wise) rejected?

--Not sure. Maybe hi19, Sulfer, or CBR

What is the average MP Rank of those who have actually played an MP game?

--No idea

What is the average Grand Total Score of all those who have played a game?

--You have the data to figure it out yourself... use the overall GTS from the contest, and there have been about 1,150,000 users to have played at least 1 game.

What is the average number of posts of those who have actually posted?

--Who knows... too lazy to figure it out, and 1mil get kinda skews it.

What is the average number of referred users of those who have at least 1?

--Probably below 2

What is the average number of profile views per profile?

--Would need LD to calculate

Who has the most viewed profile? The least viewed?

--Synth. I'm sure there are hundreds of thousands with 0 views.

What is the average number of comments per profile?

--Threeve

Who has the most commented profile?(there's a page for today's, but not overall)

--I would assume Synth. Also one of the staff members is part of a token where you have to post a comment on their wall, so they may have a ton too.

How many (known) FFR widgets are out there?

--You can count the list up yourself, http://www.flashflashrevolution.com/widgets/

Did you curse after reading all these? Laugh? What?
I probably deserve it.
Answer whenever you're done cursing me, if at all.

--Not really anything... just a lot of stuff we don't keep track of.

By the way, If you need help with SQL, I ran a database for quite a while and had a bunch of experience working with SQL, and creating stuff for a game (Knight Online). I know it's different, but I'm experienced with working with SQL Databases (using 2000 Enterprise Edition) and doing queries and the like.

[TwilightPrincess]

Re: Ask Tass For Weird FFR Stat Information

If this hasn't been asked already, I'm sure that it has...

How many people are banned from FFR Forums/Site right now?

[Sk8IT]

Re: Ask Tass For Weird FFR Stat Information

How many users have sk8 In their Name.

[Tasselfoot]

Re: Ask Tass For Weird FFR Stat Information

Twilight: permabanned alone... there are about 20 pages of usernames, each page is 50 names, i think.

sk8... i'm not checking. anyone that has "sk8" in their username needs to be dragged out back and shot in the kneecap.

[TwilightPrincess]

Re: Ask Tass For Weird FFR Stat Information

Dear god...

50x20 = 1000, plus the people who aren't permabanned, that's...

Not what I expected. At all. I expected WAY more than that.

[.Mantis.]

Re: Ask Tass For Weird FFR Stat Information

can we get a list of all public song sorted by number of AAAs

from free ffr, excite bike 1000s all the way to the single digit AAA files
it will give a clear and interesting look about the players of this community

i think VC files has an average around 60-100
FMO - 15-25
C - 70-150
VD - 150-400

so a list of all the songs then i could also see the average aaas for every difficulty

[Tasselfoot]

Re: Ask Tass For Weird FFR Stat Information

y helo ther: http://www.flashflashrevolution.com/levelstats_ext.php

it's kinda FUBAR'd... but maybe LD will fix it someday.