Right now folder with langs moved to separated package.
This lang used in all Billings.
http://sourceforge.net/project/showfiles.php?group_id=201020&package_id=311740
Archive for the ‘alSAMSBilling’ Category
Right now i’m testing new project alSUMBilling.
As you remember, this is complete solution for accouting all traffic (proxy+NAT) in you bussines.
This is alSAMSBilling + alLANBilling.
alSUMBilling will be released after adding multilang and some fixes for another people (right now its configured only for my databases).
Also new version of the alLANBilling and alSAMSBilling coming with fixed month selection (select any month, not just currently and prevous) .
New planned project: alTelbookLDAP. This is simply PHP-script to show contents (Name, Phone Number, email) of the your Microsoft LDAP Server (Active Directory). Like a phone book for your bussines with storage in Active Directory. May be it will be merged with “alStaff” (Telephone book for small organizations (old project name - “alPhoneBook”) integrated with base of inventory.)
New version of the alSAMSBilling. 25042008
Changes:
Fixed counting money.
Added new columns in the user traffic table called “From Cache”, “From Internet”
Right now when counting user trafic you’ll see 3 colums “Total trafic”, “From Cache” and “From Internet”.
This meens trafic from squid cache or from internet and total traffic. In the cost column value will be only for the internet-traffic (i think this correct)
New version avaible at SourceForge. You should download asb250408-2.zip! In the asb250408.zip in user traffic table no column “Total trafic”!
Oh… Happy new year!
Today me have woken and have informed, that it is impossible to see internet-statistics (in the alSAMSBilling) of work in December 2007…
Fixed! Right now you can select 2007 or 2008 year.
Month selection also fixed (”december bug”).
Displaying client’s IP address of the query (because same user name (login) may be used from the different computers):
In the alSAMSBilling version asb071012 added new feature:
Grouping URLs in the user statistic by sub-domain
This function will work only if your MySQL server version is higger than 5.0 (because you’ll should add user function to the MySQL and version < 5.0 doesn’t support it). Code for the function you’ll find in the file ufunct.sql. (function should be created in the squldlog database!)
Thanks to the Richard K Miller (www.richardkmiller.com) for the function.
Added sams.conf file parsing (for the sqlhost, user,password) (be careful!).
Added free-urls file upload.
Bug fixes!! Recomend to update.
With release of the alSAMSBilling “lang” folder will be one for all projects (files with langs will contain traslation for both projects)
Today released first public release of the alSAMSBilling.
alSAMSBilling based on SAMS + SQUID , it can help you to count HTTP, FTP traffic (trought SQUID proxy-server, like web-sites, ftp-sites) for your small bussines.
For counting direct traffic (like e-mail) please look at alLANBilling (based on fprobe-ulog + flow-tools).