[req] delete inactive users

[SLL]

Something like used with most forums - delete users without any picture uploaded or comment posted. Any volunteers to create such mod? 

[mawenzi]

... here is a plugin : Delete all registered users with no action on website during the last xx days ...
... that you can modify to your (remaining) needs ...
... http://www.4homepages.de/forum/index.php?topic=10097.msg49306#msg49306 ...

[SLL]

... that you can modify to your (remaining) needs ...

thanks, this is almost what i wanted 

just one question: what variable should i use in sql query in order to keep user with an image assigned to this user?

in other words - i do not want to delete users if they have active images in a gallery

[mawenzi]

... try this ...

Code: [Select]

$sql_del_users = "DELETE FROM ".USERS_TABLE."
WHERE user_level = 2
AND user_t_images = 0
AND user_lastaction < ".(time()-$no_action*24*3600);
$result = $site_db->query($sql_del_users);
echo "Users deleted !";

... "user_t_images" is a additional_user_field ... "user_total_images" ... I think from [Mod] Keep Track Of Each action ...