This command, issued in phpmyadmin, will get rid of the rubbish on your users file: the people who
never completed their registrations (inactive) and have
never made any posts (as opposed to those who are inactive now but were once active and do have posts). The code also protects against the deletion of the
Anonymous User. I have also built in a limit so that you can avoid deleting people who recently partially registered and may still become active.
Code: Select all
DELETE FROM `phpbb_users` WHERE (`user_posts`=0 AND `user_active`=0 AND `user_id`!=-1 AND `user_id` < [number])
Take a backup first!
Note: change [number] to some thing like 8768 (no square brackets) based on your table's most recent user_id values, so as not to delete recent partial registrations.
This code means you do not have to install an irritating PRUNE USER MOD.