:: 14-Apr-2003 21:59 GMT (Monday) ::

After a bit of help, I got that final query working. Thanks again to
CalicoJak.

You’re probably all now wondering “when will we see the numbers?” Fair
enough question, but I’m afraid the answer is “I don’t know.”

I don’t really know enough PHP to get the connection to the database
working nor have I had the time to sit down and figure it out. Yes, I
know it can’t be that hard.

:: 07-Apr-2003 09:13 GMT (Monday) ::

I’ve added a number of new pre-release clients to the download page at:
http://www1.distributed.net/download/prerelease.html

The v2.9005.483 clients for x86 platforms all include a fixed version of the
AMD RC5-72 core that was found to be buggy in the previous set of pre-release
clients. Thanks to all of the motivated testers who helped us to find this flaw
while the client was still in pre-release status.

:: 01-Apr-2003 23:28 GMT (Tuesday) ::

Due to an oversight on my part, the current OGR verification database
is missing 2001 data (yes, all of it), so I’ll be adding that over the
next few days.

At this point, the only thing preventing a daily update of the %
complete for OGR is some PHP code to interface with the database. As
this is the first time we’re talking to postgresql, expect it to take a
few days.

:: 28-Mar-2003 00:18 GMT (Friday) ::

First I’d like to introduce myself. My name is Scott Dodson and I’ve
been working with the help@distributed.net and now more recently the
abuse@distributed.net mail queues.

Recently there have been numerous reports of individuals scanning the stats
web pages for participants who are not on teams and then “spamming” users
asking them to join their teams. This activity is not allowed and will not be
tolerated. If we find the report to be accurate we will remove the address from
the stats database and all work from that ID will not be credited to the team.

If you have any questions about this I advise you to review our legal policy
available at http://www.distributed.net/legal/policy.html and contact
help@distributed.net if you have any concerns.

If you would like to report abuse issues please contact abuse@distributed.net
and be sure to include mail headers from the messages you have received.

:: 27-Mar-2003 13:04 GMT (Thursday) ::

Stats are happy again.

:: 26-Mar-2003 22:55 GMT (Wednesday) ::

OGR stats are coming. At this point there are a few things left to do:

-Either convert stats.sql to output in better form or write code to take
current output and put it in a better form.
-Have another set of eyes audit the code.

Also (not blocking to getting stats up):
-Output “done” list to master
-Clean up code to allow it to be run from another directory
-Documentation

As for the first item, it’s currently giving this:
table_name | function | result | project_id
————+———-+———-+————
ogr_stubs | count | 5364870 | 24
ogr_stubs | count | 20879063 | 25
| pass1 | 2781323 | 24
| pass1 | 14693958 | 25
| pass2 | 380871 | 24
| pass2 | 6678337 | 25

But I’d like to be getting this:
rundate | project_id | count | pass1 | pass2
————+————+———-+———-+———
2003-03-25 | 24 | 5364870 | 2779852 | 379837
2003-03-25 | 25 | 20879063 | 14659776 | 6644832
2003-03-26 | 24 | 5364870 | 2781323 | 380871
2003-03-26 | 25 | 20879063 | 14693958 | 6678337

So if you have the time and knowhow, let me know (or just send code).

BTW, yes those numbers are real for those dates. Sorry if it’s lower
than expected, but remember that we had to throw out quite a bit of the
ogr24 work as it couldn’t ber verified. I’d love to have someone audit
the code and find out that we’re actually much further along than I
thought.

:: 26-Mar-2003 22:39 GMT (Wednesday) ::

Statsrun puked and the normal procedure for rebuilding things isn’t working.
I’ve been drinking, so I’m not going to screw with it right now. :) I’ll look
at it (and hopefully fix it) tomorrow.

:: 18-Mar-2003 22:25 GMT (Tuesday) ::

DOH! I botched the OGR run last night with my manual shenanigans. I’m
re-running right now.

:: 17-Mar-2003 22:58 GMT (Monday) ::

A number of new clients are now available on the pre-release page:
http://www1.distributed.net/download/prerelease.html

:: 16-Mar-2003 18:49 GMT (Sunday) ::

Looks like the teamjoin code (in fact, sybase itself) was using CST and not
GMT. I’ve fixed that problem; I’m going to see if it fixes the team join issue.