Topic: Remove banned and not used accounts
Hello,
I have a lot of banned accounts (thanks Askimet 
) and not used (no messages on the forum).
Is there a way to simply delete this accouts ? (With a SQL querie for exemple)
Thanks !
Re: Remove banned and not used accounts
Okay, but witch queries ?
Re: Remove banned and not used accounts
search for accounts with num_posts=0 in the users table then select the ones you want to delete in the results and click on delete at the bottom of the page
Re: Remove banned and not used accounts
A simple DELETE FORM `pun_users` where `num_posts` = 0 works ?
And for banned users a DELETE FORM `pun_users`WHERE `username` IN (SELECT `username` FROM `pun_bans`) ?
No tables linked with this two ? Nothnig more to do ? (I want to be sure...)
Re: Remove banned and not used accounts
Check out profile.php when we delete users. You may have to do more depending on the circumstances.
Re: Remove banned and not used accounts
Ok, thanks all for your help.