NEED HELP! PLEASE WITH RESET COUNTERS

RouterOS Scripting
1

Does anyone have a clue on a script to reset PPPoE Queues at Midnight of the end of each month?

We have a SQL script that does data accounting for us and it calculates every minute and resets our SQL counters at midnight and then archieves them.

But then we need to reset all the counters on the Mikrotik so that we can start receiving new values for the new month with kicking all the users off.

We figured it would be simpler to reset the counters auto at the end of each month.

Thanks.
Any help would be greatly appriciated.

2

radius with interim update records could solve your problem with less problems. just a thought.

3

We do have interim ON at 30 min intervals.

Mkrotik sends updates to our radius which writes the info to SQL we then do scripting on it via PHP for adding the totals and checking if user has gone over limit and if so the script changes the users Radius Attributes.

What we are looking to do is at the end of each month is reset all the counters on the active pppoe connections or disconnect them all so the counters can start all over again.