xferlogDB

A PHP/MySQL tool for analysing xferlog from glFTPd, and it is compatible with version 1.x up to 2.x. xferlogDB reads the log file from glftpd and adds the data to a MySQL database. The rest is done by PHP scripts.

Download: xferlogDB.tgz
See the demo here. It is empty right now, I need a good xferlog.

Required a MySQL/Apache server running (with PHP support) and read access to the glftpd log files

• create a database on your MySQL server (eg. xferlogdb)
• create the tables, use the 'xferlogdb_tables.sql' script
• copy the PHP scripts and the 'styles.css' to a folder on your webserver
• rename the 'dbconnect.php.new' to 'dbconnect.php' if this is a new installation
  
• edit the 'dbconnect.php'
  (the 'xferlog', 'glftpd.log' file path, the ftp site root and MySQL user/passwd/host)
• that's it

See README file.

2004.04.16: v0.8 <- current release

• fixed timestamp conversion problem with php 4.3.6
• fixed missing </dev> tag
• log list now holds template change and if selected from user shows only that user
• convert all ` to _ right after reading the xferlog file
• fixed "Warning: Cannot modify header information - headers already sent"

2003.12.24: v0.7

• glftpd 1.31 or greater moved LOGIN and LOGOUT to login.log, change made to read the login.log as well
• Added template selection picklist
• Added checks to site total queries

2003.09.04: v0.6

• Added site all time, monthly, weekly and daily stat
• Program only reload glftpd.log in update.php now, it was a performance issue with large glftpd.log
• Added "hideip" option in dbconnect.php to hide ip field
• Program will not delete all records in log and online tables now. It will just delete from the point where the log starts, that is, the date/time in the first line.
• User selectable 'latest 10 directories' via array in dbconnect.php
• More performace enhancements

2003.05.16: v0.5

• Added monthly, weekly and daily stat
• Only update new entries from the xferlog
• Performance enhancement

2003.01.04: v0.4.3

• Added a "SITE NEW" function - it shows the latest directories
• Better layout, higher speed with large files

2003.01.03: v0.4.0

• Added user online status (a new MySQL table must be created - see the script in the .tgz file)

2003.01.02: v0.3.5

• Better handling of large logfiles (65000+ lines).
• General code cleanup.

2002.12.10: v0.3.3

• Fixed a bug in top10bytes function (it displayed top10-1).

2002.12.03: v0.3.2

• Updated the log read function - better support for large log files (tested with a 12MB logfile)

2002.12.02: v0.3.1

• Minor bugfixes

2002.12.01: v0.3.0

• Initial release