auto-kick from group after X day without activity ?

[Essamz]

hi ,,
is there a hack that remove the user from certain usergroup ? :ermm:

i have VIP usergroup ,, and i cant keep my eye on them every day and see if they are active or not ..
so it would be great idea to make this hack ,,

[Andreas]

primary or secondary?

[Essamz]

<u>primary </u>

remove them from usergroupid = 677

to Registered "usergroupid = 2"

[Andreas]

That is easy

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);

if (!is_object($DB_site))
{
    exit;
}

$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 2 WHERE usergroupid = 677 AND lastactivity < " . (TIMENOW-X*86400));

log_cron_action('Inactive VIP Users reset to Registered', $nextitem);
?>

Replace X with the number of days, save this a a php-file in includes/cron, create a cron-job for it (to be run once/day for example) and you're done.

[Essamz]

thank you very much

[Paul M]

Originally Posted by Essamz

primary

remove them from usergroupid = 677

to Registered "usergroupid = 2"

Usergroup 677 !!! Jesus .....

[Andreas]

Well, if you are experimenting a lot ... creating and deleting usergroups

[The Ottoman]

Originally Posted by Andreas

That is easy

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);

if (!is_object($DB_site))
{
    exit;
}

$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 2 WHERE usergroupid = 677 AND lastactivity < " . (TIMENOW-X*86400));

log_cron_action('Inactive VIP Users reset to Registered', $nextitem);
?>

Replace X with the number of days, save this a a php-file in includes/cron, create a cron-job for it (to be run once/day for example) and you're done.

If I wanted to run this against multiple usergroups (say group 123, 5 and 6), would I be correct in adjusting the syntax of the code to something along the lines of :

user SET usergroupid = 2 WHERE usergroupid = 677 OR 123 OR 5 OR 6 AND lastactivity....

[rogersnm]

Yes that would work fine

[The Ottoman]

So I've saved this code:

PHP Code:

<?php 
error_reporting(E_ALL & ~E_NOTICE); 

if (!is_object($DB_site)) 
{ 
    exit; 
} 

$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid = 2 WHERE usergroupid = 15 AND lastpost < " . 

(TIMENOW-45*86400)); 

log_cron_action('Inactive VIP Users reset to Registered', $nextitem); 
?>

to a file called autokick.php, created a cron job, set it to log, and ran it manually, I just get a screen with the cron job name, and it just hangs.


I'm a tard, what am I doing wrong?