Hack for delete all 0 posters

[kreker]

Hi

I have a lot of 0 posters in my board (about 130) and I'm coming mad for delete all!

Someone can made an hack for delete in once time all the member have 0 post??

thanks!

Kreker,

I have a lot of members that register and then never come back. I think my board has around 200-300. So I'm in the same boat as you Kreker.

Maybe adding to your suggestion, add a "last visited" and "register before xxxx-xx-xx".
That way I can remove users that have not visited since last year.

[Dakota]

I would like to see this hack too. I have almost 7500 members on my forums, and about 700 accounts that don't have any posts. There are more that are inactive, but I haven't looked at that yet.

[Castel]

That hack is already made, just search for "mass user delete"

run this query in phpmyadmin:

delete from user where posts='0';

that's it.

[kreker]

I have this error

Warning: Cannot add header information - headers already sent by (output started at /web/sites/13/kreker/****/bherp/config.inc.php:478) in /web/sites/13/kreker/****/bherp/sql.php on line 87

[Me2Be]

Originally posted by Toliman
run this query in phpmyadmin:

delete from user where posts='0';

that's it.

Be careful when you run this though -- you'll delete new members and those who lurk but never post with this command.

I'm sorry of not advicing of runing this query, as Me2be told you, it is dangeours because it will delete ALL users with 0 posts, all of them. This is a better query, since it will delete all users that have 0 posts and haven't visited the forum in one month.

DELETE FROM user WHERE posts=0 AND lastvisit < unix_timestamp(DATE_SUB(NOW(),interval 1 month))

[kreker]

ok but I have the similar errorr

that error is from your phpmyadmin... seems that your file's are somehow corrupted, you should try re-uploading them.