Victor - that was a very thorough response - well done! And now for my short response ;)
On 3/9/07, Victor Kane victorkane@gmail.com wrote:
You would need to write a module which, in its modulename_cron() function effectively iterates over the users and carries out the changes you propose.
Another option would be to do this in one query and use the dbcron module to handle the "write a module which..." part.
http://drupal.org/project/dbcron
Writing that as one query maybe isn't the easiest thing, but I believe it's possible. I don't have the time to figure out the exact syntax for you, but wanted to provide this other option.
Regards, Greg