How to delete all comments by user?
Asked Modified Viewed 2,603 times
Someone registered on my site and posted more than 100 obscene comments.
Can I somehow delete all comments by that user, instead of checking every news item individually?
Thanks.
Can I somehow delete all comments by that user, instead of checking every news item individually?
Thanks.
answered
Use this at your own risk. Backup comments table if necessary before running the code.
It will delete all comments by the user 999999 independant on the comment type. Change 999999 to the user id you wish to delete all comments for and preview the code in a custom page:
It will delete all comments by the user 999999 independant on the comment type. Change 999999 to the user id you wish to delete all comments for and preview the code in a custom page:
Code Download source
<?php
$result = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_name = '999999' ");
if ($result) { echo "<center>Comments deleted!</center>"; } else { echo "<center><b>ERROR:</b> There was a problem deleting comments.</center>"; }
?> Wanabo
Wanabo 10
- Senior Member, joined since
- Contributed 598 posts on the community forums.
- Started 94 threads in the forums
Or delete this user, all posts and comments are deleted aswell!!
answered
As Wanabo says, just delete the user from the user admin control panel.
It instantly removes all of their comments.
If they've posted that many, they deserve to have their account deleted anyway.
It instantly removes all of their comments.
If they've posted that many, they deserve to have their account deleted anyway.
Edited by tapaga on 14-03-2007 01:48,
answered
I've had to delete the same person 3 times today as they keep signing up as anew member.
Different IP's every time and different email address but the same type of name, luis 7467, or something similar with 4 numbers after the name. Reminds of the problems with subimp997 in the past.
I read your other post and replied there also....
Different IP's every time and different email address but the same type of name, luis 7467, or something similar with 4 numbers after the name. Reminds of the problems with subimp997 in the past.
I read your other post and replied there also....
Thank you. I deleted the offenders and blacklisted their IP addresses.
answered
ya..happend to me too...today :@ i deleted him, btw can tell me someone how to ban the IP of some one? i tried, but nothing happend..how is working?
answered
Quote
inuken wrote:
ya..happend to me too...today :@ i deleted him, btw can tell me someone how to ban the IP of some one? i tried, but nothing happend..how is working?
You go to User Admin, then go to Blacklist, then enter the IP address of the spammer.
You can find out the IP address from the comments management system, or from the IP logo on the forum.
answered
i know that, but doesn't work :(
answered
Quote
inuken wrote:
i know that, but doesn't work :(
How do you know it doesn't work?
answered
i tried on myself :D
answered
you can try to use our blacklist lusername mod.
should be somewhere in this forum (core support).
then enter the name like "luis*" ...
should be somewhere in this forum (core support).
then enter the name like "luis*" ...
answered
i've noticed a pattern.. anybody that registers with a user name that has several numbers either before or after their name and has an email address that is illegible.. (ie.... nrsbjjjes.com) is spam
Category Forum
Official Core Support - 6Labels
None yet
Statistics
- Views 0 views
- Posts 12 posts
- Votes 0 votes
- Topic users 8 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions