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!

[Zorg]

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"

[Toliman]

run this query in phpmyadmin:

delete from user where posts='0';

that's it. :D

[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. :D Be careful when you run this though -- you'll delete new members and those who lurk but never post with this command.

[Toliman]

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

[Toliman]

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

[tubedogg]

Remove any whitespace after the ?> in your config.inc.php file and reupload it.

[kreker]

ok works fine!

[kreker]

what can I do for make a link in my cp so I can delete the user from it with some options....can you make i t for me????;) ;) ;) ;) ;)


thanks