Tab Content
More Activity

62 Visitor Messages

  1. ugh, typo..

    prank11 -> prank1 in a variable..

    All fixed..
  2. View Conversation
    Problem with your most #1's on your stats site. It does not work.
  3. Well, I fixed the rest of the stats, but unfortunately it looks like burp still has not exported any new stats.. xml stats..

    I've got some units too, let's hope for a good run and I can get my 100k
  4. looks like none of the boinc stats have been updated for some reason.. I'm looking..
  5. View Conversation
    Hi Bok,
    When you get a chance could you check BURP's stats? The project has work being crunched at the moment but the Free-DC stats aren't updating.
  6. it is indeed. Funnily enough someone else just emailed me about that exact thing this morning

    I've fixed it to be >= now so on tonight's run it will correct itself..

  7. View Conversation
    Odd (I assume rare) situation...
    I was looking at the stat "most 100K projects" and saw I have 20. Then I recalled that I'd looked at this once before, some time ago. I had 20 then. So I counted my projects >= 100K and I count 21. I suspect it's the last one, SHA-1, on which I have EXACTLY 100K... so I am guessing the test is for > 100K rather than >= 100K. ??
  8. They will be in tonight...
  9. View Conversation
    Hey Bok,
    How do we get Crunchers Inc included in the ORG-26 stats?
    Crunchers Inc
  10. hmm, I see it on Artificial Intelligence. Odd, I have the flag for trinidad and tobago and it's mapped correctly to tt.png (which is it's ISO country code)..

    I'll have to debug.
Showing Visitor Messages 31 to 40 of 62
Page 4 of 7 FirstFirst 1234567 LastLast
Page 4 of 7 FirstFirst 1234567 LastLast
About Bok

Basic Information

Date of Birth
December 30, 1969 (54)
About Bok
Wake Forest, North Carolina, United States
Ice hockey Ice hockey Terry Goodkind, Trudi Canavan, Tolkien Shaun of the Dead Geddy Lee, Paradise Lost, Crypt of Kerberos, Drowning Pool, RUSH, Puddle of Mudd, Staind, Metallica, Tool Band, Disturbed, Nine Inch Nails
Unix Sys Admin / Oracle DBA



Total Posts
Total Posts
Posts Per Day
Total Albums
Total Photos
Visitor Messages
Total Messages
Most Recent Message
05-06-2013 04:48 AM
General Information
Join Date
Home Page

23 Friends

  1. AMDave AMDave is offline


  2. Cappy Cappy is offline

    Honda Sportbike Rider .CBR600

    • Send a message via ICQ to Cappy
  3. Cesium_133* Cesium_133* is offline

    Junior Member

    • Send a message via ICQ to Cesium_133*
    • Send a message via Yahoo to Cesium_133*
  4. Chuck Chuck is offline

    Senior Member

  5. Coleslaw Coleslaw is offline

    Registered User

  6. Darkness Productions Darkness Productions is offline

    Stats God in Training

    • Send a message via ICQ to Darkness Productions
    • Send a message via MSN to Darkness Productions
    Darkness Productions
  7. DrDan DrDan is offline

    Registered User

  8. En.China@LONH En.China@LONH is offline

    Junior Member

  9. Fullmetal Chocobo Fullmetal Chocobo is offline

    Junior Member

    Fullmetal Chocobo
  10. Gamma^Ray Gamma^Ray is offline

    Junior Member

Showing Friends 1 to 10 of 23
Page 1 of 3 123 LastLast
View Bok's Blog

Recent Entries

New Database Server

by Bok on 07-04-2011 at 12:36 PM
Core I7 2600K@4Ghz
16Gb DDR3
2x128Gb Intel 510 SSD'd (databases)

Intention is to make some much needed changes to some of the underlying tables and therefore the scripts that parse and create the data. Main reason for this the way I create the stats.

I have two databases, each on a different SSD. First database is where I parse the xml files into and do all the manipulation to. The second database is the web facing one. Don't want to do major inserts/updates

Read More


New bits and pieces

by Bok on 12-01-2010 at 10:34 AM
I'll try and post one liners for stuff I add in..

Added a 'last28' field into the boinc users table rather than computing it on the fly. Not quite 3rd normal form for a database but it allows it to be indexed and sorted in the front end. Coded the perl scripts to calculate it and fixed the 'users' php script to allow sorting.

Amended the nightly script which calculates a users 'main' team across boinc projects. This is a bit of a grey area really. The script basically uses

Read More


more stats

by Bok on 06-10-2008 at 11:32 AM
I finally got round to looking at why the numbers for the last 28 days of points/teams/users/hosts on the proj page were crap.

Well, it turns out that ever since I converted my tables to be 'generic' I hadn't altered my nightly rollover script to handle this. So it was doing a generic update on the projects table..

I just fixed it to run through each project and do the updates singly. We'll see hot it works overnight tonight. Of course it will take a while to correct fully..

Read More


Seti Classic stats

by Bok on 05-29-2008 at 03:04 PM

finally got a parser going. It's kind of manual right now as this is a one time thing, so each run just gets one teams data (users and team). I've done the top 10. Might just write a quick wrapper and pull out the top 200 team numbers which is all that is listed at

Then I'll have to manually do the ranking and such. Project ranks are going to be wrong as they will just be within the database

Read More



by Bok on 05-26-2008 at 01:05 PM
How I had missed this I don't know. thanks vaughan for pointing it out..

I added in the coding for the indexes on 'yesterday' and 'last_update'. Done the frontend changes for last_update, have yet to do the ones for yesterday.