<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:14pt"><div><font size="2"><span style="font-weight: bold;"></span></font><font size="2">hello friends ..</font></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><font size="2">i have some problem with reset parameter .. <br></font></div><div style="color: rgb(0, 0, 0);
font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"> </div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">i use this setting for data limit and traffic limitation ..</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"> If reset parameter is one of this value : " weekly, monthly ,never " counter work fine and user disconnect in exact usage of limitatin ...</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style:
normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">but like in this setting reset = daily or hourly user not disconnect in exact usage !!! how can in solve this problem ?<br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"> <br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">sqlcounter monthlytrafficcounter {<br> counter-name = Monthly-Traffic<br> check-name = Max-Monthly-Traffic<br> reply-name =
Mikrotik-Xmit-Limit<br> sqlmod-inst = sql<br> key = User-Name<br> <span style="font-weight: bold;"> reset = daily</span><br> query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) > '%b'"<br>}</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">====</div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">regards<br></div></div></body></html>