Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Creating folding@home stats
New Posts  All Forums:Forum Nav:

Creating folding@home stats

post #1 of 8
Thread Starter 
So I want to create a folding@home stats page in php and use a mysql database for the backend. I started looking around to see if there is any open source software out there or tutorials on how to do this. I didn't find alot so I started to create cron job to download the stats bz2 file from standford website. If anyone has tried to do this or has some pointers on how to unzip and inport the data from the file that is downloaded from standfords website would be a big help. I am starting this because I wish we had are own stats page here on overclock.net site. I like the way the stats are laid out on the other site I use to check the points but figured I would give this a shot and see if I can make a stats page that updates hourly.
Main rig
(13 items)
 
  
CPUMotherboardGraphicsRAM
Icore7 2600k P8P67LE ASUS EVGA 660ti 8 gb Corsair Veng 
Hard DriveOSMonitorKeyboard
Silicon Power ssd 120 gb Windows 10 Acer P237HL microshaft ECR 4000 
PowerCaseMouse
ULTRA LSP 650 thermailtake element t Razor Naga  
  hide details  
Reply
Main rig
(13 items)
 
  
CPUMotherboardGraphicsRAM
Icore7 2600k P8P67LE ASUS EVGA 660ti 8 gb Corsair Veng 
Hard DriveOSMonitorKeyboard
Silicon Power ssd 120 gb Windows 10 Acer P237HL microshaft ECR 4000 
PowerCaseMouse
ULTRA LSP 650 thermailtake element t Razor Naga  
  hide details  
Reply
post #2 of 8
Which site do you use? I find EOC rather good for checking sites.
http://folding.extremeoverclocking.com/search.php

I know there is a few others but I am not a fan of the update times, I did try creating something like that for the BOINC team to help out with keeping stats but didn't have much luck. The best I did was exporting xml stats to google docs.

Good luck though!
>.<
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 4.0ghz 1.27v EVGA E758 3-Way (black/gray) Evga GTX 480 / Evga 9800gtx+ (physx&folding) Corsair Dominator 6gb 1600 8-8-8-24 
Hard DriveOSMonitorPower
x25-M SSD 80gb + 1TB F3 + 2x2TB WD Green Win 7 64bit Viewsonic 20" + Samsung 40" Corsair 1000w 
Case
Haf 932 (modded) - Now caseless 
  hide details  
Reply
>.<
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 4.0ghz 1.27v EVGA E758 3-Way (black/gray) Evga GTX 480 / Evga 9800gtx+ (physx&folding) Corsair Dominator 6gb 1600 8-8-8-24 
Hard DriveOSMonitorPower
x25-M SSD 80gb + 1TB F3 + 2x2TB WD Green Win 7 64bit Viewsonic 20" + Samsung 40" Corsair 1000w 
Case
Haf 932 (modded) - Now caseless 
  hide details  
Reply
post #3 of 8
Subbed. Im pretty good with php mysql and totally geek out on stats and history...
Fridge
(18 items)
 
e-peen
(15 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7-4930k SABERTOOTH X79 NVIDIA Quadro K2000 Corsair 4 x 8GB 
Hard DriveHard DriveOptical DriveCooling
OCZ Revodrive 350 PCIe  Seagate Barracuda 7200.12 1TB 7200 rpm ST31000... Acer HL-DT-ST DVDRAM GH70N  Noctua NH-D14 SE2011 
OSMonitorKeyboardPower
windows 7 professional 64 bit ASUS PB278Q 27-Inch WQHD PLS Monitor razer black widow ultimate Raidmax 630w 
CaseMouseOtherOther
TT Commander Snow Logitech M-U0007 (M500) NextEngine Laser Scanner Mobile Computer Desk 
OtherOther
3D Connexion Space Navigator Huion H58L Tablet 
CPUMotherboardGraphicsRAM
xeon 3440 Maximus III Gene GTS250 G.Skill 2GB F3-10666CL8-2GBHK 
Hard DriveCoolingOSMonitor
SAMSUNG SpinPoint P Series SP2004C 200GB 7200 RPM Zalman windows 7 64 bit Gateway FHX3200B 
MonitorKeyboardPowerCase
Acer AL2216W Razer black widow ultimate CM 500w Coolermaster USP100 red 
Mouse
Logitech MX518 
  hide details  
Reply
Fridge
(18 items)
 
e-peen
(15 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7-4930k SABERTOOTH X79 NVIDIA Quadro K2000 Corsair 4 x 8GB 
Hard DriveHard DriveOptical DriveCooling
OCZ Revodrive 350 PCIe  Seagate Barracuda 7200.12 1TB 7200 rpm ST31000... Acer HL-DT-ST DVDRAM GH70N  Noctua NH-D14 SE2011 
OSMonitorKeyboardPower
windows 7 professional 64 bit ASUS PB278Q 27-Inch WQHD PLS Monitor razer black widow ultimate Raidmax 630w 
CaseMouseOtherOther
TT Commander Snow Logitech M-U0007 (M500) NextEngine Laser Scanner Mobile Computer Desk 
OtherOther
3D Connexion Space Navigator Huion H58L Tablet 
CPUMotherboardGraphicsRAM
xeon 3440 Maximus III Gene GTS250 G.Skill 2GB F3-10666CL8-2GBHK 
Hard DriveCoolingOSMonitor
SAMSUNG SpinPoint P Series SP2004C 200GB 7200 RPM Zalman windows 7 64 bit Gateway FHX3200B 
MonitorKeyboardPowerCase
Acer AL2216W Razer black widow ultimate CM 500w Coolermaster USP100 red 
Mouse
Logitech MX518 
  hide details  
Reply
post #4 of 8
We do actually have our own stats page; it's how we have the postbits and millionaire sig badges:
http://www.overclock.net/fah.php

We are working on a better one for the new forum though, so hopefully we won't be using EOC too much in future.
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
post #5 of 8
Does hfm.net create an HTML page of your stats? I know it creates one for the current WU you are folding.
Venom (Reborn)
(15 items)
 
  
CPUMotherboardGraphicsRAM
Core i7-2600K @ 4.6 GHz [1.33 vCore] [HT ON] ASUS P8P67 PRO (REV 3.1) EVGA GTX470 8 GB [2x4 GB] G.Skill Ripjaws X Series 1600 CL 9 
Hard DriveHard DriveHard DriveOptical Drive
Crucial C300 64 GB Western Digital 640 GB Samsung 2 TB Lite-On DVD Burner 
OSMonitorPowerCase
Windows 7 x64 Ultimate, Ubuntu 10.04, Arch Acer 22" 1680x1050, Dell 19" Corsair TX650 NZXT Tempest 
MouseMouse Pad
Logitech G500 Some random cloth thing 
  hide details  
Reply
Venom (Reborn)
(15 items)
 
  
CPUMotherboardGraphicsRAM
Core i7-2600K @ 4.6 GHz [1.33 vCore] [HT ON] ASUS P8P67 PRO (REV 3.1) EVGA GTX470 8 GB [2x4 GB] G.Skill Ripjaws X Series 1600 CL 9 
Hard DriveHard DriveHard DriveOptical Drive
Crucial C300 64 GB Western Digital 640 GB Samsung 2 TB Lite-On DVD Burner 
OSMonitorPowerCase
Windows 7 x64 Ultimate, Ubuntu 10.04, Arch Acer 22" 1680x1050, Dell 19" Corsair TX650 NZXT Tempest 
MouseMouse Pad
Logitech G500 Some random cloth thing 
  hide details  
Reply
post #6 of 8
Thread Starter 
So far I guess things are going alright, as of right now I have created a cron job to download the stat file from standfords website site, I have also created a cron job to extract the zip file into a .txt file, I have created a schema in mysql and have done a local file load into the mysql table, currently the information displayed in the table is username,total points, wu, team. I have ran into issues when loading the file with some lines in the stats text file. The error I am getting is incorrect int value : '' for colum 'team', there is about 10 or so line with errors. I am currently trying to figure out how I am going to do math functions to update the values for each line in the database and to give values for points avg daily, and other values I would like to have. I was thinking of doing this with php, I am not sure how I am going to update the table with new information, I will be using php. As of right now I was thinking of having php script read the .txt file line by line and run a loop that will update each username in the database with the new information. This way you can take the old value store it in a variable add new info and return the values.
Main rig
(13 items)
 
  
CPUMotherboardGraphicsRAM
Icore7 2600k P8P67LE ASUS EVGA 660ti 8 gb Corsair Veng 
Hard DriveOSMonitorKeyboard
Silicon Power ssd 120 gb Windows 10 Acer P237HL microshaft ECR 4000 
PowerCaseMouse
ULTRA LSP 650 thermailtake element t Razor Naga  
  hide details  
Reply
Main rig
(13 items)
 
  
CPUMotherboardGraphicsRAM
Icore7 2600k P8P67LE ASUS EVGA 660ti 8 gb Corsair Veng 
Hard DriveOSMonitorKeyboard
Silicon Power ssd 120 gb Windows 10 Acer P237HL microshaft ECR 4000 
PowerCaseMouse
ULTRA LSP 650 thermailtake element t Razor Naga  
  hide details  
Reply
post #7 of 8
I keep my own stats using MySql + PHP, if you want I can send you my code to look at.
The Box
(13 items)
 
  
CPUMotherboardGraphicsRAM
I7 920 D0 @ 3.8 GA-EX58-UD4P Radeon 4890 6G Patriot Viper + 12G Mushkin 
Hard DriveOSPower
Intel X-25E/Seagate 7200.11 1.5TB Windows 7 Corsair 650TX 
  hide details  
Reply
The Box
(13 items)
 
  
CPUMotherboardGraphicsRAM
I7 920 D0 @ 3.8 GA-EX58-UD4P Radeon 4890 6G Patriot Viper + 12G Mushkin 
Hard DriveOSPower
Intel X-25E/Seagate 7200.11 1.5TB Windows 7 Corsair 650TX 
  hide details  
Reply
post #8 of 8
@BeHappy, check out the attached php file (save it and get rid of the .txt)... I include it with any mysql work I do... it just sets everything up for me.

Change the top few lines to work with your server.

Now, when I want to run queries, I do stuff like this:
Code:

<?
include( "application.php" );
$sql="SELECT wu, points FROM fahstats WHERE eoc_id=$eoc AND date > $datestart AND date < $dateend"; // mysql date format yyyy-mm-dd
$stats=multiRow($sql);
foreach( $stats as $stat ){ 
    $user['ppd']=$stat['ppd'];
}
?>
I was somewhere on OCN, I saw someone put a bunch of columns named "column_blah1", "column_blah2" etc etc, imho, all of those columns could have gone into another table to be referenced via a JOIN. One of my mentors said to me, whenever possible, do logic in a mysql query rather than in php.

hope this helps ...

Chris
Fridge
(18 items)
 
e-peen
(15 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7-4930k SABERTOOTH X79 NVIDIA Quadro K2000 Corsair 4 x 8GB 
Hard DriveHard DriveOptical DriveCooling
OCZ Revodrive 350 PCIe  Seagate Barracuda 7200.12 1TB 7200 rpm ST31000... Acer HL-DT-ST DVDRAM GH70N  Noctua NH-D14 SE2011 
OSMonitorKeyboardPower
windows 7 professional 64 bit ASUS PB278Q 27-Inch WQHD PLS Monitor razer black widow ultimate Raidmax 630w 
CaseMouseOtherOther
TT Commander Snow Logitech M-U0007 (M500) NextEngine Laser Scanner Mobile Computer Desk 
OtherOther
3D Connexion Space Navigator Huion H58L Tablet 
CPUMotherboardGraphicsRAM
xeon 3440 Maximus III Gene GTS250 G.Skill 2GB F3-10666CL8-2GBHK 
Hard DriveCoolingOSMonitor
SAMSUNG SpinPoint P Series SP2004C 200GB 7200 RPM Zalman windows 7 64 bit Gateway FHX3200B 
MonitorKeyboardPowerCase
Acer AL2216W Razer black widow ultimate CM 500w Coolermaster USP100 red 
Mouse
Logitech MX518 
  hide details  
Reply
Fridge
(18 items)
 
e-peen
(15 items)
 
 
CPUMotherboardGraphicsRAM
Intel i7-4930k SABERTOOTH X79 NVIDIA Quadro K2000 Corsair 4 x 8GB 
Hard DriveHard DriveOptical DriveCooling
OCZ Revodrive 350 PCIe  Seagate Barracuda 7200.12 1TB 7200 rpm ST31000... Acer HL-DT-ST DVDRAM GH70N  Noctua NH-D14 SE2011 
OSMonitorKeyboardPower
windows 7 professional 64 bit ASUS PB278Q 27-Inch WQHD PLS Monitor razer black widow ultimate Raidmax 630w 
CaseMouseOtherOther
TT Commander Snow Logitech M-U0007 (M500) NextEngine Laser Scanner Mobile Computer Desk 
OtherOther
3D Connexion Space Navigator Huion H58L Tablet 
CPUMotherboardGraphicsRAM
xeon 3440 Maximus III Gene GTS250 G.Skill 2GB F3-10666CL8-2GBHK 
Hard DriveCoolingOSMonitor
SAMSUNG SpinPoint P Series SP2004C 200GB 7200 RPM Zalman windows 7 64 bit Gateway FHX3200B 
MonitorKeyboardPowerCase
Acer AL2216W Razer black widow ultimate CM 500w Coolermaster USP100 red 
Mouse
Logitech MX518 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Overclock.net Folding@Home Team
Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Creating folding@home stats