Better stats for MD5CRK

[Bok]

Ok,

got most things working.

MD5CRK stats (http://stats.open-dc.org/md5)

They need a day or two to get some data in but I'm running it every 10 mins (on PCZ advice..) this may change

Feel free to comment, make suggestions. I'm sure there are some things awry :rolleyes:

I'm going to work on some background pieces like milestones and graphs.

Can anyone provide a small icon for display when a user is new??

Bok :D

[heretic]

Nice :cheers:

heretic

[PY 222]

Bok... I don't see myself on the stats!

:confused:

[PCZ]

PY 222

I had a look at the official stats, you are not listed in the users.xml
However you are listed as a member of Free-DC with 297 DP's.

[Bok]

Yup,

just checked this out myself. You aren't in users.xml or users.csv :(

Where is the contact information for the site ? I don't see it.

If someone can either get that to me or mail them and see what is going on..

Bok

[PCZ]

PM'd you Jean's email address

[PCZ]

PY 222

I think the reason you are not in uses.xml is because you have no start points.
It doesn't look like you have run the client.

Is all your output from a magic button on your website ?

[PY 222]

Yeap... I've got the Magic Button on my site and its generating quite some points.

I've got friends from around the world to help me out. I don't understand why I am not listed as the points belong under my account.

Strange I tell you.

[Bok]

You will be :)

Already had a reponse and a fix, so you are now appearing in the .csv and .xml files. You don't have a team on there yet, but I'm sure that will be fixed very soon.

In the meantime this has meant you have appeared in the all users page...

Bok

:D

[PY 222]

Eggcellent. Now I know my DP are being added to the Team.

Lets get going Gang. :cheers:

[Bok]

And you are now in the team :) Very fast responses from the project admins :thumbs:

However there is some logic borked.. so I'm getting dodgy values in the last_update field on my teamstats :bang:

Looking at it.

Bok

[IronBits]

Originally posted by Bok
Ok,

got most things working.

MD5CRK stats (http://stats.open-dc.org/md5)

Bok :D I have added it to the 3rd Party Stats column on stats.Free-DC.org :D

[PCZ]

Bok

Condors detailed stats are a bit screwy.
http://stats.open-dc.org/md5//userstats.php?name=Condor@FDC
maybe its the @ symbol causing trouble ?

[IronBits]

I think he is on a trip or something... :bang:

[Condor]

Or it could be that some imposter has stolen my nick. There is already a Condor.
I would not mind if he was at least returning work but to just let it sit at the bottom like that, ruins the good name.
:crazy:

[Bok]

Originally posted by PCZ
Bok

Condors detailed stats are a bit screwy.
http://stats.open-dc.org/md5//userstats.php?name=Condor@FDC
maybe its the @ symbol causing trouble ?

Yeah, been down in Charleston, SC for a few days. Had a great time too!

I'd noticed that on a few members just before I left. I think it's caused by the sql which is a two table join on the same table :) and the second row is not there. Not sure why it would fail completely but I'll fix it at some point soon.

The @ symbol should be escaped ok before going into the SQL statement.

Bok

[Bok]

It's fixed..

caused by Condor@FDC only having a few days worth of stats. My join uses

a.stat_date = '$day0' ----- today
and b.stat_date = '$day7' ------ 7 days ago

this statement sets some parameters for a later sql statement, but these are not set in this scenario where there are less than 7 days of metrics.

Altered to check for this and then get the minimum date available and then redo the statement using this date instead.

Averages will be a little more skewed, but will be fixed once 7 days are reached.

Bok :D

[IronBits]

Glad you had a great time on your trip! :cheers:

Can you sort the 'threaten' and 'conquest' columns by the 'day/time' they have left. :smoking:

[Bok]

Working on it.....mAg has been helping me on sorting arrays in php :)

Bok

[IronBits]

Originally posted by Bok
mAg has been helping me on sorting arrays in php :)
Bok :swear: Tell him he has homework to be done over here :|punch|: :jester:
It's your stats that make this client fun to run :cheers: :D

[IronBits]

Why are my stats points different using the below two links:confused:

http://stats.open-dc.org/md5//userstats.php?name=IronBits

http://stats.open-dc.org/md5//Free-DC.html

[Bok]

erm, they aren't.....

However it's possible that you looked at your userstats whilst the scripts were running.

Once script gets the data and populates the database, then a 2nd one generates the static html pages. the php script obviously is dynamic, so you may have looked after the first had run but prior to the 2nd, though the window is only a few seconds :)

Hopefully tomorrow I can start on the teampage in php instead as well as some additions to the user page.

Bok

[IronBits]

:rotfl: :blush: :moon: :D

How about making a 3rd column for '3 Days Ago'.
You could possibly get the space from, starting from the right to left
Unique Paths and Daily Average columns and ( Team Rank + Project Rank) maybe?

:notworthy

[Bok]

I actually calculate 3 days ago and 4 days ago, but don't put them out. I'll take a look and see what I can do, you can see them on the individual page anyway.

Bok :D

[IronBits]

Yer too dern sneaky for me!
If I can see what you've been up to for the past few days, I might have 1/2 a chance to try to counter :p or at least try to stay up :cheers:

[Condor]

Oops, I think I broke it again. :bang:


Originally posted by Bok
It's fixed..

caused by Condor@FDC only having a few days worth of stats. My join uses

a.stat_date = '$day0' ----- today
and b.stat_date = '$day7' ------ 7 days ago

this statement sets some parameters for a later sql statement, but these are not set in this scenario where there are less than 7 days of metrics.

Altered to check for this and then get the minimum date available and then redo the statement using this date instead.

Averages will be a little more skewed, but will be fixed once 7 days are reached.

Bok :D

[Bok]

:swear: :swear: :swear: :bonk: :trash:

You're right :)

Let's see what I can do. Md5 is behind all my other stats in the source code tree so it's probably something stupid :haddock:

Bok

[Bok]

Fixed....

remnants of a kludge for Eon were still in there :blush:

Bok

[Condor]

Hey thanks.
I will try not to do that again.