Welcome to Geeklog Sunday, May 27 2018 @ 01:53 pm EDT

Geeklog Forums

Comments Attack


Status: offline

eyecravedvd

Forum User
Full Member
Registered: 09/06/03
Posts: 152
angry
Well, after months of having no attacks on my site a registered user who's been with the site for over a year decided to start spamming comments with some retarded amount of pharmacy crap.

When I first noticed I went through about 6 pages deleting them manually. I then decided to check in phpMyAdmin to see how many there were. He had over 50 left to remove. Rather then do them manually I deleted them right from phpMyAdmin.

Now all those posts he'd replied to still show 1 or 2 comments but there are no comments to be found. How can I reset the counter?
Shane | www.EyeCraveDVD.com

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
That's very interesting, as the same thing happened here on geeklog.net a few days ago. Spam-X caught all the spam, though.

Can you please email me the following information:
  • The username of the spammer
  • The user's email adddress (or at least a recognizable part of it)
  • The date when that user registered
  • The IP address the spam came from

Thanks!

And the next time something like this happens, you may want to use Spam-X's "Mass Delete" module, which would have deleted all the comments easily and fixed the comment counter.

I seem to remember that Tom Willet wrote a script to fix the comment counter - try searching for it ...

bye, Dirk

Status: offline

eyecravedvd

Forum User
Full Member
Registered: 09/06/03
Posts: 152
Thanks Dirk. I'll get you all the info, but I'm still running 1.3.8-1sr4.

I've been working on a very modified 1.3.11sr3 (I think) that will be going live soon that will have spamX included so I know it won't occur again.
Shane | www.EyeCraveDVD.com

Status: offline

bjudson

Forum User
Junior
Registered: 01/01/04
Posts: 34
And the next time something like this happens, you may want to use Spam-X's "Mass Delete" module, which would have deleted all the comments easily and fixed the comment counter.

There seems to be aproblem with the IP Blacklist however (at least on 1.4.0rc1) I recently tried to delete about 50 comments myself from one spammer, where the IP was clearly indicated on the comment, and the IP Blacklist did not remove the comments.

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
The ip blacklist will not work after-the-fact, in other words, with mass delete. It detects the ip of the user which in this case would be you.

Status: offline

bjudson

Forum User
Junior
Registered: 01/01/04
Posts: 34
The ip blacklist will not work after-the-fact, in other words, with mass delete. It detects the ip of the user which in this case would be you.


Why not modify it so it in the Mass Delete to check out the IP Address too? The IP Address is stored with the comment, and in this case I had to go into MySQL and do a SQL DELETE from gl_comments where ipaddress='address'.

-Astrogen













Status: offline

eyecravedvd

Forum User
Full Member
Registered: 09/06/03
Posts: 152
I still don't know how to reset my comment counters for the ones with no comments. Please help.
Shane | www.EyeCraveDVD.com

All times are EDT. The time is now 01:53 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content