Page 2 of 3
Re: HLStats
Posted: Tue May 05, 2009 11:16 am
by BBloke
Stats updated to v 1.5.5. Any probs just shout up!
Re: HLStats
Posted: Tue May 05, 2009 12:36 pm
by DragoonKnight
BBloke wrote:Stats updated to v 1.5.5. Any probs just shout up!
the pictures look very nice on the stats
Re: HLStats
Posted: Tue May 05, 2009 1:11 pm
by Anubis
Re: HLStats
Posted: Tue May 05, 2009 3:08 pm
by Fester
top job Bloke but would you go buy yourself some weed and sit back and relax
Re: HLStats
Posted: Tue May 05, 2009 3:24 pm
by BBloke
Fester wrote:top job Bloke but would you go buy yourself some weed and sit back and relax
LOL.. I'm on work avoidance mode. Didn't want to be in today so I'm passing my time expanding my knowledge in updating SQL databases.
Would love some weed tho
Re: HLStats
Posted: Tue May 05, 2009 6:45 pm
by infidel
batch based instead of realtime?
I aksy cos me statsy no updatey
Re: HLStats
Posted: Tue May 05, 2009 6:46 pm
by BBloke
Possible stat reader crash. I've just noticed the stats prog wasn't running!!!
Re: HLStats
Posted: Wed May 06, 2009 12:01 am
by BBloke
Yep.. stats keep crashing. ActivePerl needs changing.. That should hopefully settle the stats down.
Re: HLStats
Posted: Wed May 06, 2009 11:11 am
by Anubis
press on your name from daily achivments and see where u get
then pick your name from "players" button in hlstat and see what u get ...
2 DB's ?
or the "last 28 days" DB is rested and not synched with the "general history" DB ?
Re: HLStats
Posted: Wed May 06, 2009 1:08 pm
by BBloke
I've just checked on the data and for some reason there are entries with Steam ID preceded with STEAM and some without. This has created duplicates within the database.
I can waste time finding the duplicates and create scripts to eradicate the data but to be quite honest a simply stat reset would probably be far more beneficial (from my perspective anyway).
I'm not a stat fan per say and it would be a lot to loose but it's just more efficient than trying to rejig a database to eliminate duplicates for it to quite possibly fall over and need to be reset anyway.
Just to help with any possibly confusion. I've checked the database prior to the upgrade and the duplicates existed then.. looks like it's just something that's happened.
I've put a poll up in the Members Area regarding a stat reset.