Hi,
In our forum we two have main classes of members. We have "VAST Subscribers" and "Regular Members". We also offer the ability for users to buy download credits in packs of 100.
What we want to do is on a monthly basis, fill regular members to 10 credits (if they have less than 10 credits) and to fill VAST Subscribers to 100 credits (if they have less than 100).
Firstly, is this possible by running SQL commands, and if so what would be those commands (sorry SQL is definitely not my strong suit)?
Secondly, is it possible to automate those commands so they run on the first of the month, through CRON or some other mechanism?