Daily Time Limits

[CompuFreak]

I see several posts about giving users a daily allotment of data transfer, but I'm wondering if the same idea is possible with time? We would like to have a "free user" class that is allowed 1 hour of time each day without manually giving each free user 60 minutes under "when airtime credit is used up" each day. The users can purchase more time after that, or come back after midnight and have another free hour the next day. Is there anyway to reset the time limit daily similar to resetting the data transfer counter?

[alan]

Yes. You need to write a simple SQL statement to reset the field "timeleft" to 60 at midnight. Refer to chapter 5 of firstspot_guide.pdf for the definition for the user table fsusr.

Also, please refer to http://patronsoft.com/forum/viewtopic.php?t=1514 for a guideline in manipulating datasource.
_________________
~ Patronsoft Limited ~

[CompuFreak]

OK that makes sense. Is there any way to do this by plan though, so that certain users in a "free" plan get their airtime reset to 60 each day, but other users in various other paying plans are not affected? I do not see anywhere in that table where plan is referred to.

[alan]

No. Plan is really a template of user attributes that is used when one creates users through the Configuration Manager. The user is not linked to the Plan after the creation.
_________________
~ Patronsoft Limited ~

[capitantrip]

Please could you post the SQL query for resetting the TIMELEFT filed with MSQRY32.EXE? this is very important for a deployment we have to do but i can't manage it by myself

Thank You

[chrisli]

please use

update fsusr set timeleft = 60 where reserved1 is NULL;
_________________
~ Patronsoft Limited ~

[capitantrip]

Thank you, i got i!!!