PHPstats

News

As of 28 september 2005 the phpstats 0.1* branch is no longer in development and most likely no further updates will be made.
Thanks for your all your support.

What is PHPstats ?

PHPstats generates statistics for the distributed.net projects. Look here for an example of what PHPstats can do.

Required software

• PHP 4.3 or better (not tested with php 5)
• Apache(2), not tested with IIS
• GNUplot (if you want graphs)
• MySQL

Recommanded:

• PHPmyAdmin (because not all options are available in the gui)
• Lynx for the SUB

Features

• DB orientated stats
• Users can claim and manage there own IPs
• Stats are easy to maintain
• Stats scripts are easy to add or mutate
• Stats can be updated frequently
• Export proxy data (http://us.keyserver.org/stats/export)

How to make this work

• Note that this stats script is for the RC5-72 project only (in the near future more projects will be supported)
• Extract the files in to your htdocs dir
• Create a new MySQL DB
• Execute the createdb.txt SQLs (change the INSERT data at the end of the file, or change the data afterwards at the admin page)
• Read and change init.php
• Execute the SUB (Stats Update Bot) by opening the sub.php in a browser
• You can parse old logs by adding the date of the logfile: phpstats/sub.php?d=20040519, you should see some info about parsetimes
• Open the index.php, you should see some stats by now
• Login (user: Admin, pwd: password) and add users
• Let users login and set there pwd and let them claim there IP's (or do it for them at the Uberclaim section)
• Run the sub every x time (for example: lynx -dump http://url.org/phpstats/sub.php)
• Enjoy the stats

Updating

• Read the changelog
• Use the update.txt file to update your db to the current version (works for version 0.172 and better)
• Overwrite your phpstats dir with the new files

Todo

• DB generated menu's
• DB abstraction layer
• Rewrite current code
• Make it easier to add new projects
• Make install script
• etc.

Known bugs

• When you disable the SUB while it is processing, the occupied setting is still checked
  Change the setting back by hand, using the admin tool (level 5 only)
• If GNUplot gives errors concerning transparant images. Solution update GNUplot, or remove the word 'transparent' in the gnuplot.php file module file.

License

PHPStats is published under the BSD License

History

v0.176 (28-01-2007)

• Fix empty /aq dir in package
• Minor bugs

v0.175 (03-10-2005)

• Fixed login problem
• Added some extra info when running the SUB
• Update a small bug with a MySQL querie

v0.175 Beta (05-01-2005)

• Changed linking system
• Changed variable system, register_globals is no longer a must
• In theory it should work on IIS now (removed req. for Apache MultiView), this is not tested though
• Added some missing images, thanks to Witlof
• Changed some static text (team names) into db generated text, thanks to Witlof
• Added clog_pre, clog_path and clog_sufix as new variables, for the location and filename of the console log
• Stats now identify CPU ID #17 as X86-64
• Renamed the table 'data' into 'rc572'
• Fixed total per week, now shows total of the week per year
• Added total per month and total per year
• Finally added a settings page, you can now edit all the DB settings using the admin tool
• Added a 'List all claimed IP's' function at the admin tool

v0.173 (27-12-2004)

• You can now config GNUplot settings using the init file
• Updated html layout
• Export file updated, it's now compliant with monitor v3
• Some minor updates

v0.171 (20-12-2004)

• Updated sub and footer, now displaying OGRp2 stats
• Added check for windows platform, by server status

v0.170 (20-12-2004)

• Improved the images generated by gnuplot
• Added user agent stats
• Stats are now available by WAP
• Images are now included within the package, you are still free to use my mirror
• internal linking improved
• Numerous small fixes

v0.165 (19-05-2004)

• Made an install SQL script
• Made EXAMPLE stats query
• Made this site

Credits

Thanks to Clan-of-nine and United Subteams for helping me develop and debug this project.
Special thanks go out to eNeRGy for letting me use his XPindex layout