Squid2MySQL - squid accounting system.

Change log

 News 
 Features 
 Change Log 
 Description 
 Screenshots 
 Download 

Last versions:
Squid2MySQL 1.0.0
Version 1.0.0
1. A fix for a backup log bug (thanks Kirill Mityagin).
2. squid2mysql.sql connect to database bug fixed (thanks to Stuckenberger, Patrick).
3. A fix for a squid2mysql script bug (thanks to all people who complaining about non-working logging :)) and many thanks to Sergey Kasatikoff, who first of all corrects an error :)
4. Existing user's info and creating new user now opens in a new window.
5. Thanks to bpao@airbase.dyndns.org for some ideas and patches.
6. Now archiving rdnload table too.
7. Several errors in sqauth were fixed. However, that's don't guarantee his fine work :)
8. Host support was removed. Please use 0.9.0 release.
9. URL search and user search was added.
10. Archiving and restoring was updated.
Version 0.9.0
1. Fixed many security bugs.
2. Added auto-configure script, that will install Squid2MySQL for you.
3. Added real time calculation.
4. Added months backing up.
5. Added restoring from archive.
Version 0.5
1. Fixed bug with sqauth script (thanks to Vic Uvarov).
2. Added account period change to user's detail statistics.
Version 0.4.3
1. Fixed bug with password nullify in userprop.php script.
2. Several security fixes.
3. Added german translation by beckers.
Version 0.4.2
1. Fixed bug with squid2mysql.sql file (thanks to Chai Mee Joon).
Version 0.4.1
1. Fixed bug with sqauth script (arithmetic typeset error).
Version 0.4
1. Successfully added ;) daily, weekly and monthly statistics. For this I had to make one more table 'rdnload', containing summary of user's daily downloads, because database with many records works too slow. (for month, about 65M, 20-30 seconds on K6-2-450)
2. Multi-language supported. I'd like to include your tables, because now thereis two tables - english and russian with koi8-r encoding.
Version 0.3
1. Added user management scripts (create new users, edit user properties). User properties called from index.php clicking by user real name field.
2. Accounting period fixed.
3. Billing setup includes into squid2mysql script.
4. Little security bugfixes.
Version 0.2
1. Now user authentication makes by sh script using mysql program, user names and passwords is in auth table squidlog database.
2. Added cache using statistics.
3. Added daily download limit.
Note! Squid authentication engine made impossible immidiately bail-out user's that has reach download limit. If you want more interactive set Authenticate_ttl to 1 minute.
4. Added user creation script.
5. Added user identification. Not secured.
6. Now registered user (not administrator - who's had set admin field to "Y" in auth table squidlog database) may see his own download statistics.
Version 0.1
First release.