1
Nick_James
Deleting all posts from a spammer

Okay, a spammer signed into my website and posted a lot of advertizing comments on the web site.

Is there an easy way to delete all of the comments?

Or is it just the tedious, one at a time method?

2
Nick_James
Re: Deleting all posts from a spammer

283 comments... grrrr
Nicholas James
President - LaDads
http://www.ladads.info

3
Nick_James
Re: Deleting all posts from a spammer

in just 4 days...
Nicholas James
President - LaDads
http://www.ladads.info

4
Nick_James
Re: Deleting all posts from a spammer

signed is as adamgilb
ip address is 212.117.164.8
or 212.117.164.168
email is 21a@chatterzx.cn
Nicholas James
President - LaDads
http://www.ladads.info

5
Mamba
Re: Deleting all posts from a spammer
  • 2010/7/10 15:49

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


phpMyAdmin would be the easiest way
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

6
Nick_James
Re: Deleting all posts from a spammer

so open the database

and find xxx_xoopscomments

view all the comments

select all the ones I want to delete.

hmmm, there has to be a better way. I need to learn how to query for something.
Nicholas James
President - LaDads
http://www.ladads.info

7
Nick_James
Re: Deleting all posts from a spammer

Ta Da... GONE
Nicholas James
President - LaDads
http://www.ladads.info

8
Nick_James
Re: Deleting all posts from a spammer

So, can we have a modification to make this easier.

I have anonymous (redacted) blocked from commenting on my site because of the tedious nature.

And the captcha turned on so not too many are able to get through and register.

But this one figured it out and trashed the site.

Now it was easy deleting his comments, because nobody else really uses the comment section. So I just had to delete the last 4 days worth of comments.

But it would be much nicer if the comment manager section allowed us to select all comments by a user ID and delete them.

SELECT from 'xxx_xoopscomments' WHERE 'xxx_xoopscoments'.'com_uid'=xxx

Then allow us to mark a few or mark em all and then

DELETE from 'xxx_xoopscomments' WHERE 'xxx_xoopscoments'.'com_uid'=xxx

Although for such a roque user, perhaps all postings should be deleted. So perhaps it shouldn't be limited to comments.


Perhaps I would be able to allow anonymous comments again if we could mass delete by IP address.(field is com_ip)

Nicholas James
President - LaDads
http://www.ladads.info

9
Nick_James
Re: Deleting all posts from a spammer

Thanks MAMBO. Your suggestion worked.

Much better than
'select'
'click delete'
'yes to all'
'back'
'repeat for 283 times' til your fingers bleed and fall off.
Nicholas James
President - LaDads
http://www.ladads.info

10
charpres
Re: Deleting all posts from a spammer
  • 2010/7/10 19:25

  • charpres

  • Not too shy to talk

  • Posts: 168

  • Since: 2003/9/4 2


What is really needed is a function similar to what Simple Machines uses in their forum software.

You can delete a user and then you are prompted as to whether you want to delete all the user's posts and topics at the same time.

Nine times out of ten when dealing with a spammer, you want to delete the account and delete everything the spammer has put on your site. This needs to be done from a single point.

As a matter of fact, that is exactly why I dropped Xoops from one of my sites and replaced it with Simple Machines: I just got very tired of deleting spam posts one by one.

Login

Who's Online

347 user(s) are online (298 user(s) are browsing Support Forums)


Members: 0


Guests: 347


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits