Idea: List of Jackpot Winners and those with the most Bells. Date: June 2016 Suggested by: AnnetteSR, GoldenCelebi, KingK Defined by: ACWWFreakazoid, AnnetteSR, GoldenCelebi, Hadger Coded by: AnnetteSR Released: March 2017 [Update 1.12.0]
Outline: ACC has a Treasure Hunt that replaces some adverts with Bells. The idea behind collecting Bells was to be able to spend them in a Bell Shop. Unfortunately, a Bell Shop can't be created until we've rewritten ACC - also referred to as ACC 2.0.
Despite the lack of Bell Shop, many Members find it fun to collect Bells and regularly keep an eye on who has the most, and whether they've managed to move up the list of Top Collectors. Also, people are curious about who has won the latest Jackpot, and who has won the most. AnnetteSR suggested that we not only give this information, but we also add in other pieces such as how many Bells have been missed. A more comprehensive outline of the feature can be found in the next post.
The Bell treasure hunt on ACC began in 2010. KingK made a TopBells ranking list outside of ACC quite a while ago, which was taken over by GoldenCelebi after KingK didn’t have time for its upkeep anymore. It was a popular feature, but getting it integrated into ACC allows for more functionality.
A new link has been added under "AC Community" in the left sidebar: Top Bells. This new feature shows a list of Bells found and missed and a list of all Jackpots found and missed. Additionally, the Top Bells rank number is shown next to the Bells under "My ACC" and in the profile. We’ve tried out adding the rank number to the Bells that are shown below every post, but the general consensus was that this was too much in your face, so it was removed again.
The Jackpots list is simply a list of all Jackpots found since the treasure hunt commenced in 2010. Whenever a Jackpot is found (or missed), the list is being updated. So, from now on, whenever the Jackpot is being found, we’ll know straightaway who the lucky finder is. If the list has been updated but no recent Jackpot is shown at the top, we’ll know someone missed the Jackpot - but it won’t show who, that would be too cruel.
Top Bells list
Above the Top Bells list, the user(s) who found and missed the most Bells are shown, your current rank is being displayed and the parameters that restrict the list are shown.
The Top Bells list shows all users with the number of Bells they’ve found and missed. The list has been sorted on total number of Bells found, so we can safely assume that Aurora6 will always be at the top of the list.
Keeping the Top Bells list manageable
Showing all ACC users will make the database explode isn’t possible, hence a way to restrict the number of users on the list had to be devised. The current parameters are shown above the Top Bells list.
The minimum number of Bells you need to have found to appear in the list is 100. So, if you’ve found no Bells yet, you won’t find yourself on the list.
If you haven’t logged in for more than 180 days, you will drop off the list. If you log in after this, you will reappear on the list after it has been updated the next day.
If you have found at least 1,000,000 Bells, you won’t ever drop off the list. You’ve earned yourself a permanent place and even if you wouldn’t login for ten years, you will still be listed. Not that you would know, but others will.
Using the above parameters, the list is long but still manageable.
Everybody who has found the same number of Bells, has the same rank. That’s the obvious bit. However, ranking can still be done in different ways. For Top Bells, "Dense ranking" is being used. An example should explain it all:
The difference between Ranking and Dense ranking is that Dense ranking has no gaps in the ranks and Ranking has. Ranking will give a better idea how many users are in the list, but it won’t be perfect either, because there are many users with 100 Bells.
Within a group with the same rank, users are ordered by UserID. This makes the long-time members be listed first; seniority gives perks.
Updating and changes
Besides ranking the users base on the number of Bells they’ve found, the Top Bells list also shows alterations, just like KingK’s and GoldenCelebi’s list did. Once per day, the list is being updated and compared with the list of the previous day. As a result, the user(s) who found and missed the most Bells between those last two updates are shown at the top of the page. Additionally, all individual changes are shown within the list.
The updating will be done by a scheduled job which runs at a set time every day. If the job hasn’t run for some reason, the updating can be done manually.
Tiptoe through the window, by the window, that is where I'll be
Come tiptoe through the tulips with me