Hello,LoOoD wrote:How about an option to delete all unactivated users w/ no time frame .. I suppose you would only use it once the first time you install this but yeah.
Code: Select all
phpbb=> SELECT user_id FROM phpbb_users WHERE (user_active = 0) and (user_id <>-1) and (user_lastvisit = 0) and (user_regdate < "1186045406") ;
ERROR: column "1186045406" does not exist
Hello,Nothing is easy wrote:2) If the userid being deleted is also in the banned user list is the userid also removed from there too?
Using the delete function from within the User Admin Management panel does remove the userid from the ban list. However, that does not necessarily mean to say that this mod deletes users in the same way as the User Management delete function does it?Martin Truckenbrodt wrote:Hello,Nothing is easy wrote:2) If the userid being deleted is also in the banned user list is the userid also removed from there too?
just test it without the MOD!
Create a test account. Ban the user(name). Delete the user. Look the the ban list.
Code: Select all
...
$thisuseridrow = $db->sql_fetchrow($thisuseridresult);
$sql = "DELETE FROM " . USERS_TABLE . "
WHERE user_id = $user_id";
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete user', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . USER_GROUP_TABLE . "
WHERE user_id = $user_id";
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete user from user_group table', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . GROUPS_TABLE . "
WHERE group_id = " . $thisuseridrow['group_id'];
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);
}
$db->sql_freeresult($thisuseridresult);
...