NPLB Free-DC Stats - Page 7

IronBits · 2008-11-28, 10:08

http://pma.cihar.com/trunk/
loginID is root, password is blank

Allows remote admin of a database, with all kinds of bells and whistles, including a 'web page gui' front end, and there are lots of books on how to be a master db admin with it.

http://www.phpmyadmin.net/home_page/index.php

Quote:

Originally Posted by gd_barnes

What in the world are you talking about? English please.

IronBits · 2008-11-28, 11:54

I've added a little more color to make it easier to read and follow the flow of data within the cells.
The data in cols 01 and 02 are not right, but 03 seems to have made up for it, in the today's hourly running section only.
I'm sure it was caused by scheduling problems with the report being run too late, too early, not at all, or twice... my BAD!

It will all be worked out by midnight tonight I think, when the next stats rollover happens.

I added in 3 additional days worth of stats history so you can see how your getting along day to day, as well as hourly.
I wrote a small vbscript that should handle the month and yearly rollovers to.
I didn't think about it at the time, but it's also another way to spot if the Server chokes, or the network goes down,

But, in addition to that, it also allows you to see if/when your network goes down or you have some boxen taking a nap, or even when you just start contributing, or even, if you stop participating.

I tossed in some hyperlinks so that you can click on your UserName and go straight into the Free-DC stats system to see your stats over there to.

I don't do any fancy validation on your UserName, I just toss it into the link ...

I cleaned up more of the code, and moved some of the color settings into the .css file.
Which reminds me, I need to clean up my styles.css file as it has way too many entries from years gone by...

Enjoy!

mdettweiler · 2008-11-28, 16:29

Quote:

Originally Posted by IronBits

http://pma.cihar.com/trunk/
loginID is root, password is blank

Allows remote admin of a database, with all kinds of bells and whistles, including a 'web page gui' front end, and there are lots of books on how to be a master db admin with it.

http://www.phpmyadmin.net/home_page/index.php

Okay, cool--thanks for the link. I browsed around the demo site a bit, and though it seems a bit complex, from what I can tell a lot of that is due to the fact that the demo site has gazillions of individual databases that have been added under it, whereas ours would only have one or two.

Quote:

Originally Posted by IronBits

I've added a little more color to make it easier to read and follow the flow of data within the cells.
The data in cols 01 and 02 are not right, but 03 seems to have made up for it, in the today's hourly running section only.
I'm sure it was caused by scheduling problems with the report being run too late, too early, not at all, or twice... my BAD!

It will all be worked out by midnight tonight I think, when the next stats rollover happens.

I added in 3 additional days worth of stats history so you can see how your getting along day to day, as well as hourly.
I wrote a small vbscript that should handle the month and yearly rollovers to.
I didn't think about it at the time, but it's also another way to spot if the Server chokes, or the network goes down,

But, in addition to that, it also allows you to see if/when your network goes down or you have some boxen taking a nap, or even when you just start contributing, or even, if you stop participating.

I tossed in some hyperlinks so that you can click on your UserName and go straight into the Free-DC stats system to see your stats over there to.

I don't do any fancy validation on your UserName, I just toss it into the link ...

I cleaned up more of the code, and moved some of the color settings into the .css file.
Which reminds me, I need to clean up my styles.css file as it has way too many entries from years gone by...

Enjoy!

Sweet!

Looks good to me.

henryzz · 2008-11-28, 20:34

the zeros problem is even worse
i have been on contuously from 8:30 am GMT and i have lots too many zeros in my report
i should have no zeros today i think

IronBits · 2008-11-29, 00:35

I understand.
The log file that it reads to build those tables is totally screwed up for today.
I'm working on rebuilding todays log file by re-counting the totals from results.txt
Should have it done within a few hours, or at least before roll over for tomorrow

It's a thankless job, but we need to do something to keep the interest up

Nothing is lost, I will be able to rebuild any daily run from the original results.txt, or will be able to as soon as I finish the script. /bangs head

Here is what we have so far today for Port 400.

Code:

2008.11.28.00.BlisteringSheep=98
2008.11.28.00.Flatlander=31
2008.11.28.00.gd_barnes=390
2008.11.28.00.glennpat=14
2008.11.28.00.IronBits=91
2008.11.28.00.Wabbit98=4
2008.11.28.01.BlisteringSheep=52
2008.11.28.01.Flatlander=18
2008.11.28.01.gd_barnes=212
2008.11.28.01.glennpat=8
2008.11.28.01.henryzz=5
2008.11.28.01.IronBits=49
2008.11.28.01.Wabbit98=1
2008.11.28.02.BlisteringSheep=54
2008.11.28.02.Flatlander=18
2008.11.28.02.gd_barnes=209
2008.11.28.02.glennpat=8
2008.11.28.02.henryzz=10
2008.11.28.02.IronBits=48
2008.11.28.03.BlisteringSheep=53
2008.11.28.03.Flatlander=18
2008.11.28.03.gd_barnes=207
2008.11.28.03.glennpat=8
2008.11.28.03.henryzz=10
2008.11.28.03.IronBits=48
2008.11.28.04.ArsTechnica_BlisteringSheep=9
2008.11.28.04.BlisteringSheep=54
2008.11.28.04.Flatlander=19
2008.11.28.04.gd_barnes=209
2008.11.28.04.glennpat=8
2008.11.28.04.henryzz=9
2008.11.28.04.IronBits=47
2008.11.28.05.ArsTechnica_BlisteringSheep=1
2008.11.28.05.BlisteringSheep=62
2008.11.28.05.Flatlander=18
2008.11.28.05.gd_barnes=209
2008.11.28.05.glennpat=9
2008.11.28.05.henryzz=10
2008.11.28.05.IronBits=48
2008.11.28.06.BlisteringSheep=64
2008.11.28.06.Flatlander=17
2008.11.28.06.gd_barnes=208
2008.11.28.06.glennpat=8
2008.11.28.06.henryzz=9
2008.11.28.06.IronBits=49
2008.11.28.07.BlisteringSheep=63
2008.11.28.07.Flatlander=18
2008.11.28.07.gd_barnes=207
2008.11.28.07.glennpat=8
2008.11.28.07.henryzz=10
2008.11.28.07.IronBits=48
2008.11.28.08.BlisteringSheep=61
2008.11.28.08.Flatlander=18
2008.11.28.08.gd_barnes=210
2008.11.28.08.glennpat=7
2008.11.28.08.henryzz=10
2008.11.28.08.IronBits=49
2008.11.28.08.nuggetprime=31
2008.11.28.09.BlisteringSheep=63
2008.11.28.09.Flatlander=19
2008.11.28.09.gd_barnes=210
2008.11.28.09.glennpat=7
2008.11.28.09.henryzz=10
2008.11.28.09.IronBits=48
2008.11.28.09.nuggetprime=38
2008.11.28.10.BlisteringSheep=61
2008.11.28.10.Flatlander=17
2008.11.28.10.gd_barnes=206
2008.11.28.10.glennpat=8
2008.11.28.10.henryzz=11
2008.11.28.10.IronBits=48
2008.11.28.10.nuggetprime=38
2008.11.28.10.Wabbit98=5
2008.11.28.11.BlisteringSheep=65
2008.11.28.11.Flatlander=18
2008.11.28.11.gd_barnes=210
2008.11.28.11.glennpat=8
2008.11.28.11.henryzz=10
2008.11.28.11.IronBits=49
2008.11.28.11.nuggetprime=34
2008.11.28.12.BlisteringSheep=56
2008.11.28.12.Flatlander=18
2008.11.28.12.gd_barnes=206
2008.11.28.12.glennpat=8
2008.11.28.12.henryzz=9
2008.11.28.12.IronBits=47
2008.11.28.12.nuggetprime=37
2008.11.28.13.BlisteringSheep=62
2008.11.28.13.Flatlander=17
2008.11.28.13.gd_barnes=209
2008.11.28.13.glennpat=7
2008.11.28.13.henryzz=10
2008.11.28.13.IronBits=48
2008.11.28.13.nuggetprime=4
2008.11.28.14.BlisteringSheep=67
2008.11.28.14.Flatlander=18
2008.11.28.14.gd_barnes=208
2008.11.28.14.glennpat=8
2008.11.28.14.IronBits=49

IronBits · 2008-11-29, 01:26

There! Now let's see what happens on the next stats run at 7pm...

IronBits · 2008-11-29, 09:11

Ok, looks like I finally got all the bugs out. Let's see how it runs on autopilot.

I'm beat, took me many days of very long hours and a couple of all nighters to get it to this point.

Today I re-built all the logs by reprocessing the results.txt going back 4 days, plus, because the clock rolled past midnight, I reprocessed yesterdays.
Re-ran the progress report one last time and what do you know, no extra padded zeros, and the data lines up in the columns where they should.

I just watched it roll over for the 2am run, and checked it again, and it's looking great

Flatlander · 2008-11-29, 14:22

Quote:

Originally Posted by IronBits

...
It's a thankless job, but we need to do something to keep the interest up

Thank you!
I regularly look at the stats to see how things are going.

IronBits · 2008-11-30, 00:52

Thanks Flatlander. Glad you enjoy them and find them worthwhile.

I know I do...

I added a couple more pages, not linked any where, more for curiosity than anything else.
http://nplb.ironbits.net/progress_c443.html - page for Carlos
http://nplb.ironbits.net/progress_gb4000.html - page for Gary

I did have to change Mini-Geek to Mini_Geek tho, seems DOS wants to read that as a math string and causes the script to blow up.

I will have to replace any username that uses a character of - to _ (dash to underscore).

Keep the names simple folks... Until I get a chance to port it to vbscript or perl, or, I get it into a database for live queries by date or something.

mdettweiler · 2008-11-30, 00:58

Quote:

Originally Posted by IronBits

Thanks Flatlander :thumbs:

I added a couple more pages, not linked any where, more for curiosity than anything else.
http://nplb.ironbits.net/progress_c443.html - page for Carlos
http://nplb.ironbits.net/progress_gb4000.html - page for Gary

I did have to change Mini-Geek to Mini_Geek tho, seems DOS wants to read that as a math string and causes the script to blow up.

I will have to replace any username that uses a character of - to _ (dash to underscore).

Keep the names simple folks... Until I get a chance to port it to vbscript or perl, or, I get it into a database for live queries by date or something.

Sweet! Looks good to me.

em99010pepe · 2008-11-30, 12:26

IB, you have another C443 file to import to the stats. Thank you.

2008-11-28, 11:54	#68
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 2131₈ Posts	I've added a little more color to make it easier to read and follow the flow of data within the cells. The data in cols 01 and 02 are not right, but 03 seems to have made up for it, in the today's hourly running section only. I'm sure it was caused by scheduling problems with the report being run too late, too early, not at all, or twice... my BAD! It will all be worked out by midnight tonight I think, when the next stats rollover happens. I added in 3 additional days worth of stats history so you can see how your getting along day to day, as well as hourly. I wrote a small vbscript that should handle the month and yearly rollovers to. I didn't think about it at the time, but it's also another way to spot if the Server chokes, or the network goes down, But, in addition to that, it also allows you to see if/when your network goes down or you have some boxen taking a nap, or even when you just start contributing, or even, if you stop participating. I tossed in some hyperlinks so that you can click on your UserName and go straight into the Free-DC stats system to see your stats over there to. I don't do any fancy validation on your UserName, I just toss it into the link ... I cleaned up more of the code, and moved some of the color settings into the .css file. Which reminds me, I need to clean up my styles.css file as it has way too many entries from years gone by... Enjoy! Last fiddled with by IronBits on 2008-11-28 at 12:21

2008-11-28, 20:34	#70
henryzz Just call me Henry "David" Sep 2007 Cambridge (GMT/BST) 16F8₁₆ Posts	the zeros problem is even worse i have been on contuously from 8:30 am GMT and i have lots too many zeros in my report i should have no zeros today i think Last fiddled with by henryzz on 2008-11-28 at 20:34

2008-11-30, 00:52	#75
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 2131₈ Posts	Thanks Flatlander. Glad you enjoy them and find them worthwhile. I know I do... I added a couple more pages, not linked any where, more for curiosity than anything else. http://nplb.ironbits.net/progress_c443.html - page for Carlos http://nplb.ironbits.net/progress_gb4000.html - page for Gary I did have to change Mini-Geek to Mini_Geek tho, seems DOS wants to read that as a math string and causes the script to blow up. I will have to replace any username that uses a character of - to _ (dash to underscore). Keep the names simple folks... Until I get a chance to port it to vbscript or perl, or, I get it into a database for live queries by date or something. Last fiddled with by IronBits on 2008-11-30 at 00:59

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amusing stats: luckiness of NPLB members	Mini-Geek	No Prime Left Behind	6	2010-06-11 13:12
CSVs for stats available + New combined stats	opyrt	Prime Sierpinski Project	3	2010-05-31 08:13
NPLB.net down	Mini-Geek	No Prime Left Behind	17	2009-09-25 18:51
When will NPLB be the top project...	MooooMoo	No Prime Left Behind	29	2009-07-31 08:47
One month of NPLB	em99010pepe	No Prime Left Behind	5	2008-02-24 14:37

2008-11-29, 01:26	#72
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	There! Now let's see what happens on the next stats run at 7pm...

2008-11-29, 09:11	#73
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts	Ok, looks like I finally got all the bugs out. Let's see how it runs on autopilot. I'm beat, took me many days of very long hours and a couple of all nighters to get it to this point. Today I re-built all the logs by reprocessing the results.txt going back 4 days, plus, because the clock rolled past midnight, I reprocessed yesterdays. Re-ran the progress report one last time and what do you know, no extra padded zeros, and the data lines up in the columns where they should. I just watched it roll over for the 2am run, and checked it again, and it's looking great

2008-11-30, 12:26	#77
em99010pepe Sep 2004 2×5×283 Posts	IB, you have another C443 file to import to the stats. Thank you.