Tab Content
More Activity

62 Visitor Messages

  1. View Conversation
    I'm a Team Norway member, but on DCR I'm listed as a TA member? How do I change it?

    You do a great job with the stats Bok! Thanks!

    Espen/Junta
  2. View Conversation
    Just came over to say hello and see what the classier side of DC was up to!
    Dave
Showing Visitor Messages 61 to 62 of 62
Page 7 of 7 FirstFirst ... 34567
Page 7 of 7 FirstFirst ... 34567
About Bok

Basic Information

Date of Birth
December 30, 1969 (54)
About Bok
Location:
Wake Forest, North Carolina, United States
Interests:
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
Occupation:
Unix Sys Admin / Oracle DBA

Signature


Statistics


Total Posts
Total Posts
24,444
Posts Per Day
3.28
Albums
Total Albums
1
Total Photos
1
Visitor Messages
Total Messages
62
Most Recent Message
05-06-2013 03:48 AM
General Information
Join Date
10-16-2003
Home Page
http://stats4.free-dc.org/stats.php?page=index

23 Friends

  1. AMDave AMDave is offline

    Administrator

    AMDave
  2. Cappy Cappy is offline

    Honda Sportbike Rider .CBR600

    • Send a message via ICQ to Cappy
    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*
    Cesium_133*
  4. Chuck Chuck is offline

    Senior Member

    Chuck
  5. Coleslaw Coleslaw is offline

    Registered User

    Coleslaw
  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

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

    Junior Member

    En.China@LONH
  9. Fullmetal Chocobo Fullmetal Chocobo is offline

    Junior Member

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

    Junior Member

    Gamma^Ray
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 11:36 AM
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

Categories
Uncategorized

New bits and pieces

by Bok on 12-01-2010 at 09: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

Categories
Uncategorized

more stats

by Bok on 06-10-2008 at 10: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

Categories
Uncategorized

Seti Classic stats

by Bok on 05-29-2008 at 02:04 PM
Ok,

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

http://seticlassic.ssl.berkeley.edu/...am_type_0.html

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

Categories
Uncategorized

Hydrogen@Home

by Bok on 05-26-2008 at 12: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.
Categories
Uncategorized