exclude usergroups from automatic user pruning

Hey,
this is my first (small) addon i made and probably it could be better, but it works...

What does this do?
This is actually an addon for the atomatic user pruning hack you can find here
with this hack you can exclude several usergroups from been pruned.

How to Install

Open your deleteinactive.php file

FIND

PHP Code:

// This only needs to be modified if you set above to false
$groupid=8; 


BELOW ADD

PHP Code:

//set this to false if you want to exclude some usergroups from pruning
$pruneall = false;

// If you have set false above, you can set here the usergroups you do NOT wish to be modified, seperate each groupid with a space
$exclude = "1 8 3"; 


FIND

PHP Code:

$prunedmembers = $DB_site->query("
        SELECT * FROM `" . TABLE_PREFIX . "user`
        WHERE `posts` <= '$maxposts'
        AND `lastactivity` <= '" . (TIMENOW - ($lastactivity * 86400)) . "'
        AND `lastpost` <= '" . (TIMENOW - ($lastpost * 86400)) . "' 
    "); 


REPLACE WITH

PHP Code:

if($pruneall==true){
    $prunedmembers = $DB_site->query("
        SELECT * FROM `" . TABLE_PREFIX . "user`
        WHERE `posts` <= '$maxposts'
        AND `lastactivity` <= '" . (TIMENOW - ($lastactivity * 86400)) . "'
        AND `lastpost` <= '" . (TIMENOW - ($lastpost * 86400)) . "' 
    ");
}else{
$donotprune = explode(" ", $exclude);
    for($i=0; $i<count($donotprune); $i++){
        $endquery.="AND `usergroupid` != '".$donotprune[$i]."' ";
    }
    $prunedmembers = $DB_site->query("
        SELECT * FROM `" . TABLE_PREFIX . "user`
        WHERE `posts` <= '$maxposts'
        AND `lastactivity` <= '" . (TIMENOW - ($lastactivity * 86400)) . "'
        AND `lastpost` <= '" . (TIMENOW - ($lastpost * 86400)) . "' $endquery 
    ");
} 


grz,
seba

[Marco van Herwaarden]

Thanks for sharing your work.

Could you please also provide the instructions in a (zipped) textfile. This makes it easier for future refence (upgrades for example) for those who installed it.

[waza]

K, I added a txt file with the instructions.