Stats stuff...
 

well for some reason the old (main) stats are all fucked up... it seems the script is acting all funky and not exiting properly

like if you look at this: http://stats.avamods.com/stats/imgse...hp?w=800&h=380
you can see the past week or so is like doubled or something

but technically thats ok lol, cause im working on getting the new ones going.. And to speed them up and avoid problems processing all the logs back to november 2005 i installed active perl and mysql on my pc and im doing all the updates locally (since i have all the logs files on one of my hard drives) ...only bitch is going to be migrating the database over to the web sql server (the db will probably be over a gig) but ill worry bout that when the time comes lol..

so you can see the new stats here: http://stats.avamods.com/
..but it will only work when i have the mysql server running on my pc otherwise it has nothing to connect to, and ive been messing with the theme here and there when im bored so if things look fucked up.. it'll get fixed

right now theyre up to like early 2007 i think, but im tempted to start them over cause i forgot to set up the weapon weights lol..


oh and buck, apparently the alias code is backwards and isnt going to work right for combining 3 ids to 1 till it gets updated lol.. but pretty sure it will work with 2 ids, so when i start them over.. ill just use the one old id of yours that has the most stats (i think that was the one with like 4500 bar kills..)

well i have the most bar kills on the new server :)

and the stats31 page hasnt updated its showing stats from like a year ago....

yay! ps remove the bar from both sides.. id rather not use it then have other kids take it on me and suck with it.

how bout you read before you post.. k thanks

verbaled lol

lol yeah and since im not a webserver and i have a bunch of torrents going.. dont expect it to load fast when it connects at all..

calm down....i didnt read the whole post no need for the attitude young man.

hah well i fucked up the server last night.. i accidently used an integer instead of a float in a plugin and it caused the server to crash everytime someone joined lol.. started around 530am i think.. and i didnt notice till i got up around noon today

so it basically put it in a reboot loop, which created like 900 log files lol.. of which the old stats already scanned and shit.. and since hl only allows 1000 logs per day.. i had to delete them to make room for todays real log files, but the last log state for the stats is at the end of the bad ones, so basically its going to ignore todays real stats..

so yeah, the old stats are fucked for good now.. i could fix it sorta by editing the state file, but idk lol... i dont really feel like bothering

ok making progress lol..

right now ive got it processing the logs for april 2008, so i should be able to get it up to date tonight and then i just gotta export a backup sql file (which will take a while lol) and hopefully that will be done before i goto bed tonight and i can restore that file (will probably be over 1gb) to the real mysql server, which will take even longer then the backup process lol

i spent some more time on the theme and i think im pretty much set with that for now (maybe a few tweaks here and there) but im having a lot of trouble with some stuff as theres still quite a few things that are hard coded in the php files instead of using classes and css and such.. and im struggling to find and modify them

but so far it looks good :-)

woo you rock diamond!

woo you rock diamond!

double post!!!

lmao is one of his guitars (the les paul style) from guitar hero? looks like theres buttons down low on the neck lol

actually are both of them lol? the strat style one doesnt even seem to have a real bridge or pickups

sexy

guitar hero roxz0rs!!!!1111

good work dia, im proud of you and your accomplishments

i dont get the picture diamond.

lol thats inj

the stats are now up to date...

there is one mistake ive noticed, its saying avalanche has been played for 39 years lol.. im not really planning on looking into why anytime soon either..


next i need to finish up the top10 to replace on the motd window for the server then they should be all set to take the place of the old stats..
i also wanna work on getting the heatmaps to look right (currently only concerning myself with avalanche)

ok theres been some updates to the ps SVN repo for the stats that will be quite useful to me lol.. so im gonna start redoing all the logs on my pc again lol and hopefully ill also be able to figure out when & why the avalanche playtime got so crazy

ive been playing on ava that long....hence why i only complain about the non wallable walls now.

ok the stats are all set to go now lol

yay go diamond!

lol except i forgot to setup the alias stuff to combine your stats to one steamid lol

Who cares about stats anyway.

people that are good...


its something you wouldnt understand

lol....

you got me there...

I noticed I'm coming up as !knurd on the stats page =X

its supposed to use the last name you played with.. but i noticed that it doesnt always change it so idk lol

i changed it to !ymmit now but not sure if it will stay like that or not, we'll have to see

weird, i haven't played with !knurd in a while.

hmm i see you played today and then it set it back as that.. idk ill ask stormtrooper about it

if i use butthole will it switch it to butthole?

well it appears for some reason the script for the stats updates isnt completing fully and the stats are a bit fucked up..

i have a backup that goes up to the end of may so restoring it isnt a big deal, but i also need to figure out why its not finishing each time all of a sudden so things might be screwed up for a few days :(

ok so the problem seems to be the gay host lol.. they all of a sudden decided to make it so any query that takes over 15 seconds to complete.. gets terminated

so im moving a backup to a diff database i have in hopes that maybe it will work with that one

ok the other mysql server i had isnt gonna work as making a remote connection for processing the logs is wayy to slow (processing 20minutes worth of playtime takes several hours instead of a minute)

so i got some different hosting lastnight.. uploaded like 3 or 4gb of stuff just so i could test stuff out.. and theres too many problems and its not gonna work out so im cancelling that

so it pretty much seems like there are no good options left. all i can do now is host the mysql db on my pc which means you'll only be able to access the stats when i have my PC on and the mysql server running. This also means that the stats will only update when i manually run the update script.. So this all kind of sucks but it doesnt seem like theres any option left other then paying a ridiculous amount for a dedicated box, and seeing as how im sick of paying for the current stuff.. spending more definitly isnt going to happen

Stats down?

yeah.. repainting my room so i had my pc off for a while today

well i got stormtrooper to add a new feature into the stats...

instead of having to skip the last log (due to the log being open and incomplete) which meant an update wouldnt happen till after a mapchange..

he added the ability to skip the last line in the log, which means i could process an active log file, but avoid processing an incomplete last line..

great in theory, but it seems to have gone wrong.. it says my skill is over 3200, never seen it above 3000 before.. and i didnt even do good last night
..it also says i went 849:171 yesterday too.. which i definitly did not.. and on top of that the daily connection count is already at the daily average and its not even noon yet


and dumb me.. i didnt make any backups recently and i cant find my old ones from june


..technically, its sorta alright tho.. it will be a pain in the ass to reprocess all the logs again.. but it will give me a chance to switch over to MySQL 5 without having to do anything crazy to update the MySQL 4 im running now

bulllet is confused :s:s

so you rig it that your still on top even with the screwed up stats... hmmm

the stats arent screwed up anymore.. theyre just old and not up to date yet..

ah ok my apologiez

:sad::confused::'(

wait major wenching?