Very nice, I'm guessing the different colors are supposed to mean Gold and Silver or first and second places?
I'm also guessing the awards currently displayed are not for a full week's play, because some of those weapon kills seem pretty low then again most of us using the website are all vets who, for good reason, don't use the failgun.
Take into account when stats were started for individual people, see previous post of mine :P
EDIT: Just went digging through the database and searched your id, we started tracking you 2010-08-22 16:00:09, so you're missing about 16 hours worth of numbers on sunday that wasn't tracked.
Aside from that, I don't know when they count their own start/stop to a week. Could be their local time, the servers local time, or GMT but it wouldn't cause much difference as it would only be a few hours.
EDIT EDIT: Re-went through the code today - some may have noticed a lot of gibberish on the page for a few hours - and trimmed it up/re-worked things. Loads quicker now heh.
Other things to keep in mind is that personal player data is only collected every 4 hours, so technically anything done right near the end of the day will be attributed to the next day at 00:00 hours give or take a minute as everyones stuff is collected in order.
FM's stats may be instant and thus a touch more accurate timewise, but I'm not going to kill their server by requesting data every minute for dozens of player id's with a few dozen categories within each heh.
Last edited by LoganDougall; 09-04-2010 at 05:20 PM.
ah, stats for players were not even being collected the last little bit due to adding in code to collect kill types - tank shot, headshot etc - and forgetting a single semi-colon lol. That may explain this weeks missing amounts for some ppl. It'll fix itself in a bit when they're updated at the next 4 hour slot.
I don't normally edit that file often so it's not something I check often.....have to add in a debug trigger or something to save the extra work.
Last edited by LoganDougall; 09-04-2010 at 07:04 PM.
....yay for sql injection...someones an ass.... [thumbdown]
I'll need to have a few things added in otherwise I figure they'll just keep doing it. Soooo, db names have been scrambled to try and avoid it in the meantime and player stats are being re-collected again. I didn't really plan on doing anything to the site today but that's now changed.
EDIT: I may have to do all the security checks for my import functions as well, just kinda occurred to me while I was working on real-life stuff that I don't sanitize names too much when importing player info...could have been done via a changed name sadly enough.
Last edited by LoganDougall; 09-04-2010 at 10:50 PM.
If you need some help, let me know. I've got a php/sql savant that I'm just trying to keep busy right now until I need him to do our back-end. Should have made him contract, he's costing me a lot for a few hours of coding per day. Unfortunately he knows all the code and db's and been with me since day 1. Can't afford to lose him.
Oh.... good job!
Last edited by mobo57; 09-06-2010 at 06:30 AM.