Automatically change usergroup after certain amount of time

[zsmom]

I would like there to be a way for members' usergroups to automatically change to a different one after a certain amount of time since their last post.

This seems like it would be fairly simple to do, but I have no idea.
Or is there a way to do this already?

[Logician]

do you want to change at the moment they revisited the board or even if they dont revisit? If latter, it will require a cron script.

[Zachery]

could be done with vb3 very simply as its a built in feature

[zsmom]

I'd prefer it to change even if they don't revisit. But either way would be fine with me. It beats having to do it manually, that's for sure.

[Logician]

let us know:
a) Usergroups the hack will apply
b) New Usergroup hack will put users in
c) Time hack will check

[zsmom]

Ok...usergroups 9 and 11 would change to usergroup 2 at 30 days since last post. And I guess it would check this once per day, midnight I guess, though that part doesn't matter much.

Thanks!!!

[Logician]

Create a "anynameyouwant.php" file in your forum directory and put this code inside that file:

PHP Code:

<?php
   set_time_limit(900); 
   require('./global.php');

   $userArray=$DB_site->query("SELECT * FROM user WHERE (usergroupid=9 OR usergroupid=11) AND posts>0");

   while ($user=$DB_site->fetch_array($userArray)) 
       {
       $days = mktime (date("H"), date("i"), date("s"), date("m"), date("d")-30, date("Y"));
    
       $lastpost=$DB_site->query_first("SELECT dateline FROM post WHERE visible=1 AND userid='$user[userid]' ORDER BY dateline DESC LIMIT 1");
         if ($lastpost[dateline]>0 AND $lastpost[dateline]>$days)
           {
           $DB_site->query("UPDATE user SET usergroupid=2 WHERE userid='$user[userid]'");
           }

       }
?>

Now configure your CRON job to run this file once everyday at any time you like.

Please test this script in a test board first! I dont expect a problem but I don't like giving away scripts like this as they make changes in DB so a bug can create serious problems. I didnt test the script myself.

[zsmom]

Thank you so much! I'll give it a whirl...

[g-force2k2]

Question Logician, what exactly does set_time_limit( ) function do? I appreciate any assistance.

Regards,
g-force2k2

[zsmom]

Ok, I tried it and it changes everyone in usergroups 9 & 11, regardless of the time since their last post, to usergroup 2. Any ideas?