The Sonic Center

Welcome Center => Information Kiosk => Topic started by: EngiNerd on December 12, 2007, 08:45:00 am

Title: AntiRecords
Post by: EngiNerd on December 12, 2007, 08:45:00 am

Just asking, I'm probably in the wrong place here, but I was glancing at my AntiRecords page.  How exactly are the AntiRecords sorted on that page?  There's been times that I've started at the top of that page and just tried destroying them all in succession.  It doesn't seem to do with rank....

I remember first looking at the AntiRecords and going, "woah, did they name a set of records after me?"  They probably did, and for good reason, but I'm not as proud of it anymore....

Title: Re: AntiRecords
Post by: GerbilSoft on December 12, 2007, 09:12:26 am

It's some weird algorithm that sorts it by "worst antirecord first". I'll look up the exact formula later and post it here.

Title: Re: AntiRecords
Post by: Zeupar on January 27, 2009, 09:47:41 pm

I am still curious about that formula.

Title: Re: AntiRecords
Post by: GerbilSoft on February 07, 2009, 06:15:26 pm

Here's the "ORDER BY" part of the SQL query:

Code: [Select]

ORDER BY r.rank / ( rs.ranksnap_size * 0.8 + 1 )
Basically, it divides your ranking on that chart by ((0.8 * number of players on the chart) + 1).