sqlcounter / end session at the end of the month

[Alan DeKok]

YvesDM wrote:
> I'm having issues with octet accounting. Users are monthly limited in
> octets, not in time.
> The problem i have is when a user logs in on the last day of the month
> and stays online for 3 days then there's 2days within the new month
> but the accounting counts within the previous month, which we don't
> like :-)

  So... run a query at the end of each month that grabs the current
counters for each user.  Bill them for that, and remember what that
number is in a new column in the table.

  Alan DeKok.