NPLB Database

IronBits · 2008-12-26, 15:15

I am far from being happy, however, I'm far enough along to start sharing

It's not all working the way it was yet, but, the data is up-to-date (since two days ago)

http://stats.ironbits.net/statsnew/main.php?a=reset
Edit: Link is now (9/21/09) http://www.noprimeleftbehind.net/

I don't need bug reports yet, but if the numbers don't appear to be right, then be sure to speak up.

Enjoy what you can see as I stumble through getting the pages to show everything it used to.

IronBits · 2008-12-28, 05:46

http://stats.ironbits.net/statsnew
Edit (9/21/09): Link is now http://www.noprimeleftbehind.net/
We have graphs again thanks to AMDave.
primes by team is being a snot to code but it will get there. (tech talk)

admin page is not working yet either, but everything else should be working fine now.

I have enhanced the teams table so it now contains
team
username
email
email2 (some of you requested automatic email to two different addresses)
just have to get that admin page to work.

Next up is the automating of the updates to the database around midnight for my servers and 8am for Gary's server.

Then you can start asking for features and changes.

mdettweiler · 2008-12-28, 14:18

Quote:

Originally Posted by IronBits

http://stats.ironbits.net/statsnew
We have graphs again thanks to AMDave.
primes by team is being a snot to code but it will get there. (tech talk)

admin page is not working yet either, but everything else should be working fine now.

I have enhanced the teams table so it now contains
team
username
email
email2 (some of you requested automatic email to two different addresses)
just have to get that admin page to work.

Next up is the automating of the updates to the database around midnight for my servers and 8am for Gary's server.

Then you can start asking for features and changes.

Nice work!

And the database queries seem a lot faster than before, too.

I know that it's not really time to ask for changes yet...but I guess this isn't quite so much of a feature/change request as a bug report.

Looking at the Stats by User page, I notice that the last person in the main table is the user "Death", with 452 results. However, if memory serves, we had a number of distinct users in the table before with less than that # of results. It seems as if they just got shaved off the end.

Or does the Stats by User page only show the top x# of users (at least for the time being)?

IronBits · 2008-12-28, 14:57

Everything is fixed now.
Ready for bug reports and feature requests.

Looking into the stats by user page, I see it shows 1-25, the chart uses 31 but I can find 45 distinct users.
Looks like teams.username and results.username are not the same.

Good catch!

edit:
After going into the admin panel, I added all the usernames into teams.username for you.
I'll see if we can come up with a way that gets the names from results.username so we don't have to manually update the teams.username page.

I see I fubared the stats page, give me some time to work thru it.

IronBits · 2008-12-28, 16:02

stats by user fixed.

IronBits · 2008-12-28, 22:10

Is everyone assigned to the correct Team ?

http://stats.ironbits.net/statsnew/stats.php

mdettweiler · 2008-12-28, 22:17

Quote:

Originally Posted by IronBits

stats by user fixed.

Thanks!

Quote:

Originally Posted by IronBits

Is everyone assigned to the correct Team ?

http://stats.ironbits.net/statsnew/stats.php

As far as I can tell, everybody seems to be on the right team.

IronBits · 2008-12-28, 23:11

Great!
I'll close all trouble tickets with the database.
The daily progress reports are a nice addition to what you used to have, so,
now go out and find some recruits for Free-DC.

I'll continue to work on the automation of importing the daily results from here and Gary's server.

mdettweiler · 2008-12-28, 23:56

Quote:

Originally Posted by IronBits

I'll continue to work on the automation of importing the daily results from here and Gary's server.

Just curious: would it be at all easier if I set Gary's server to run the daily results copy-off script at 1 A.M. CST (i.e. 12 A.M. Arizona time) so that you can pull everything down at the same time? It shouldn't be too hard for me to switch it over--just one little number to change in the crontab.

IronBits · 2008-12-29, 00:23

If you like, then when the .csv files are imported around 1am az time, yours will go in at the same time as mine.
Your choice.

mdettweiler · 2008-12-29, 04:48

Quote:

Originally Posted by IronBits

If you like, then when the .csv files are imported around 1am az time, yours will go in at the same time as mine.
Your choice.

Okay, I'll see about getting it changed over sometime tomorrow. It won't be in time for the next results copy-off, but it will be for the one after that.

2008-12-26, 15:15	#1
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts	NPLB Database I am far from being happy, however, I'm far enough along to start sharing It's not all working the way it was yet, but, the data is up-to-date (since two days ago) http://stats.ironbits.net/statsnew/main.php?a=reset Edit: Link is now (9/21/09) http://www.noprimeleftbehind.net/ I don't need bug reports yet, but if the numbers don't appear to be right, then be sure to speak up. Enjoy what you can see as I stumble through getting the pages to show everything it used to. Last fiddled with by mdettweiler on 2009-09-21 at 13:22 Reason: added new link

2008-12-28, 05:46	#2
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 1113₁₀ Posts	http://stats.ironbits.net/statsnew Edit (9/21/09): Link is now http://www.noprimeleftbehind.net/ We have graphs again thanks to AMDave. primes by team is being a snot to code but it will get there. (tech talk) admin page is not working yet either, but everything else should be working fine now. I have enhanced the teams table so it now contains team username email email2 (some of you requested automatic email to two different addresses) just have to get that admin page to work. Next up is the automating of the updates to the database around midnight for my servers and 8am for Gary's server. Then you can start asking for features and changes. Last fiddled with by mdettweiler on 2009-09-21 at 13:23 Reason: added new link

2008-12-28, 14:57	#4
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	Everything is fixed now. Ready for bug reports and feature requests. Looking into the stats by user page, I see it shows 1-25, the chart uses 31 but I can find 45 distinct users. Looks like teams.username and results.username are not the same. Good catch! edit: After going into the admin panel, I added all the usernames into teams.username for you. I'll see if we can come up with a way that gets the names from results.username so we don't have to manually update the teams.username page. I see I fubared the stats page, give me some time to work thru it. Last fiddled with by IronBits on 2008-12-28 at 15:25

2008-12-28, 23:11	#8
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 459₁₆ Posts	Great! I'll close all trouble tickets with the database. The daily progress reports are a nice addition to what you used to have, so, now go out and find some recruits for Free-DC. I'll continue to work on the automation of importing the daily results from here and Gary's server. Last fiddled with by IronBits on 2008-12-28 at 23:13

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NPLB.net down	Mini-Geek	No Prime Left Behind	17	2009-09-25 18:51
Servers for NPLB	gd_barnes	No Prime Left Behind	0	2009-08-10 19:21
NPLB on BOINC?	jasong	No Prime Left Behind	17	2008-12-01 10:25
two ideas for NPLB	Mini-Geek	No Prime Left Behind	16	2008-03-01 23:32
One month of NPLB	em99010pepe	No Prime Left Behind	5	2008-02-24 14:37

2008-12-28, 16:02	#5
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts	stats by user fixed.

2008-12-28, 22:10	#6
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	Is everyone assigned to the correct Team ? http://stats.ironbits.net/statsnew/stats.php

2008-12-29, 00:23	#10
IronBits I ♥ BOINC! Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts	If you like, then when the .csv files are imported around 1am az time, yours will go in at the same time as mine. Your choice.