The code is here webstatsdb-0.1.tar.gz. It includes 4 files. One is mysql table structure (webstatsdb.sql) one is the actual script to update (webstatsdb.php), one is a sample of how you can display the data (webstatsshow.php) and finally the .css file to make the display pretty. They are kind of documented, but pretty straight forward. If you have any suggestions for improvement please let me know. I’m always open to suggestions. A screenshot of the sample is here.
This script pulls input from a cli webcam snapper called clcam, slaps a time stamp on it, keeps a cache of the old images and has a default ‘offline’ image. You can view the source. You can change a few variables, but again hopefully it’s straight forward. Requires clcam, php4, gd, and a ttf font of your choice. An online sample is here.