forums

The new (Firefox) build calculator and the hall of fame pages have been integrated into the new layout. This means that user and guest tracking (the stuff the appears at the bottom of each page) is now enabled for these pages.

Additionally, I refactored the entire hall of fame code. Six months ago, I posted about how I had optimized the hall of fame schema (as well as some other tables). This was only one half of the puzzle of making the hall of fame faster. The other half is the actual code that manipulates this data to come up with how many levels each person gained in the past 3 days, how much monthly cs each person has gained in the past 6 hours, etc. Being as though that was some of the very first code I wrote for this site, it was extremely inefficient. So the hall of fame pages should now be extremely fast - just as fast as the other pages of the site.

The actual hall of fame interface was also improved. You can now select exact dates instead of clicking the yesterday/tomorrow links (or editing the url). You actually couldn't look at old monthly cs records at all before, but they are now all accessible.

And the actual tables that hold the data are now sortable. Just click the headings to sort as you would any other table that appears on this site. Some of you had requested this feature in the past. Now you can easily see who got the most cs in the past hour, past 6 hours, etc.

Oh and you can see how many queries were used to generate each page now at the bottom of each page. If you run across a slow page, check that stat and let me know if you think it's too high. Server latency I can't do much about, but slow queries I can. Most pages should load within well under 0.10 seconds, while some of the more data intensive pages like the hall of fame and clan rankings could take up to 0.50 seconds if the results aren't cached. No set of queries should take more than 1 second.

So as you can tell, I've obviously been in the mood to code lately. If there's something you've wanted to see added for awhile, now is the time to ask.

It just occurred to me that monthly cs only started being collected hourly on May 17, 2007. This means that if you try to lookup the data for a date before that at some random time of the day, it won't load. You can still get to the old data by setting the time to 12am on those dates. Obviously the lowest resolution for the historical gains in those ranges will be 1 day.

Okay I changed it so that it automatically switches to 12am if you choose a date before data was collected hourly, so no need to worry about what I said in the last post.

And I switched over to hourly collection on May 11 actually if anyone is curious. I guess it just took me a few days to post the news item.

I updated the display for the monthly cs table to make sure it doesn't try to show how much cs you've gained in the past 3 days on day 2 of the month, how much cs you've gained in the past 2 weeks after 1 week has passed, etc.

I also put in a new feature that fades rows where the bot did not gain any of that stat in the smallest window shown. For example, in the level hall of fame, this would be whether the bot gained a level in the past day or not. In the monthly cs hall of fame, this would be whether the bot gained any cs in the past hour or not. The caveat is that this doesn't work in some browsers (namely IE...I know, surprising eh?). I was able to find a cross-browser solution, but the performance tradeoff required with that particular implementation was not worth it in my opinion.

And on an unrelated note, I removed the "last page" thing from user profiles.

(quadruple posting ftw)

Forgot to mention in the last post that I put previous/next day/hour links above the table too, along with the date of the history you're currently looking at.

(quintuple?)

http://edmazur.com/bots/userlookup.php
should be able to be sorted. so u can see how much cs u have gotten in an hour.
only that though. i dont need to sort the dates or nothing :)

also...
u should be able to unsort on the HoF.
like first click - lowest to highest
next click - highest to lowest
third - unsort it. so its back to like nothing happened.

i think u shold be able to multi sort things still.
sort it by most in an hour, monthly cs etc.
like everything could me sorted. :)

maybe ... an average cs per hour for that hour. take all monthly cs bots.
add them / 100.

-Alan :)

Yeah the user lookup page was one of the next on the list, so there's a strong possibility of that being revamped. The current way the data is shown doesn't scale very well as becomes apparent when you're looking at a bot with 10,000+ data points.

As for unsorting, that's unlikely to change. I'm pretty sure every table has a default sort (hall of fame - overall, weapons - total damage, armors - defense, etc.), so if you want to restore the original order, you can always click that column or even reload the page.

The multi sort (breaking ties with a secondary column I assume you mean) is a good idea and there have certainly been times when I wish I could do that. That being said however, I do not see a clean way of making the interface to do that. The current way is very clean and simple - you click the column heading to sort, click it again to reverse, etc. Putting in the functionality to multi sort would require additional UI components and I just don't see how to cleanly put that into every page.

The last suggestion of the average cs per hour would be more appropriate on the user lookup page. If I were to revamp that, it would include more stats than it currently includes and I imagine this would be a part of it.