Welcome to Geeklog, Anonymous Wednesday, December 04 2024 @ 05:29 pm EST
Geeklog Forums
Comments Attack
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
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
21
13
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/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:
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
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
16
34
Quote
Status: offline
eyecravedvd
Forum User
Full Member
Registered: 06/09/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
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
17
31
Quote
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.
19
14
Quote
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
16
19
Quote
Status: offline
eyecravedvd
Forum User
Full Member
Registered: 06/09/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
Shane | www.EyeCraveDVD.com
19
18
Quote
All times are EST. The time is now 05:29 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