What rank are you?

[chillywilly]

854

So far I am the lowest out of all of you!

I play FFR the least which means I am the coolest. Respect, biatch.

8354! yep! that makes me 7500 more cooler than you!

[banditcom]

787 after 471 games... although in the last 125 games, I've only played about 20 real ones.. other ones were messing around with different things. :P

[Synthlight]

Nima,

You suggested the formula below. I will not even touch the results of such a formula as they may be fine.

((10000(or some other arbitary number))/(FFR rank on a certain song)) * (DIFFICULTY OF THE SONG) * ALL SONGS

Here is the problem with this though from a technical standpoint. You have somewhere between 70-100 songs in FFR depending on who you talk to. Now remember that anytime I have to fetch data from the database this takes up CPU time and hard drive time. To check your rank on each song I would have to look at the table for that song, find your name, calculate rank and then move onto the next song and do the same until we reach the end (lets say 80 songs).. So what this means is 80 queries that we must execute on the database compared to about 3-4 that are normally executed when you start FFR.

Now.. lets take 80 and multiple by the times FFR gets played in a single day. We are going to say an average of 130,000 times a day. That comes to somewhere around 12 million extra queries a day. That would probably bring us to the limit of this server. I have to be careful with these things and always think on a larger scale.

Now with that I am already thinking of some other ways to come to the same result without all the hard work. Maybe I make a new field in the database that holds peoples rankings, run a file late at night that generates the rankings and then every 12 or 24 hours after that it updates the rankings.. Just brainstorming.

Cheers,

Synthlight

[lightdarkness]

synth, your last part was my idea EXACTLY
run a query at 5am when the site is least populated,
see my post in the suggestion section

[plasmix]

I am #61.

[Gnik]

Nima,

You suggested the formula below. I will not even touch the results of such a formula as they may be fine.

((10000(or some other arbitary number))/(FFR rank on a certain song)) * (DIFFICULTY OF THE SONG) * ALL SONGS

Here is the problem with this though from a technical standpoint. You have somewhere between 70-100 songs in FFR depending on who you talk to. Now remember that anytime I have to fetch data from the database this takes up CPU time and hard drive time. To check your rank on each song I would have to look at the table for that song, find your name, calculate rank and then move onto the next song and do the same until we reach the end (lets say 80 songs).. So what this means is 80 queries that we must execute on the database compared to about 3-4 that are normally executed when you start FFR.

Now.. lets take 80 and multiple by the times FFR gets played in a single day. We are going to say an average of 130,000 times a day. That comes to somewhere around 12 million extra queries a day. That would probably bring us to the limit of this server. I have to be careful with these things and always think on a larger scale.

Now with that I am already thinking of some other ways to come to the same result without all the hard work. Maybe I make a new field in the database that holds peoples rankings, run a file late at night that generates the rankings and then every 12 or 24 hours after that it updates the rankings.. Just brainstorming.

Cheers,

Synthlight

Perhaps an easier way to do this would be to have a "total best score" variable saved for each player made up of all your high scores added together. After you calculated it the first time, when someone beat their previous record, you would just have to adjust the total by the difference, instead of recalculating the whole thing, and save the new value.
Every couple months you could retabulate it (and it has to be done once before it's implemented) and make sure it was accurate or something, but it's pretty hands off. If you tossed out the old "grand total score" the number of queries stays exacly the same.

[peregrine]

here's an idea I'm musing with... why not have some sort of seeding process (tournament, or current ranks) that people can opt to be in or not. Then just run a ladder-type competition with those ranks based on rank challenges. That will rank people according to skill (and occasionally luck on a song) and prevent some from playing say... halcyon (nothing against the song), 50 million times to get a higher score.

Also, only those who are concerned with their rank will be seeded/participate in the ladder, so it might actually save some CPU time due to massively reduced traffic.

Just a thought, some tweaking and it might work well.

[EDEdDNEdDYFaN]

157 ololol

[Jello]

Im 8th. thats all i gotta say and oh yea. damn cenright. to many points jesus. lol

[altairian]

cenright had 277 million... i have 680 million... he already explained the bug, try reading? =\

[chillywilly]

how about-- total points divided by total games

[alainbryden]

I'm 13th. And that won't work chilly, for reasons posted in the other topic like this one.

[AnythingCrimson]

Im 127 8)

[DreamSDK]

I'm 87th.

[Kilgamayan]

256, I think.

I'm not sure Total Points/Total games would work because none of the levels have the same AAA scores.