Login
Register
Login
Register
Communities
Directory
Help
Language
Legal
Search
Communities
Directory
Help
Language
Legal
Search
Visit
Poke
Cyborg 2-A ✅
Wed, 27 Jul 2022 17:33:51 -0400
Did I miss something?
DELETE FROM item WHERE obj LIKE '%yandex.ru%';
DELETE FROM notify WHERE msg LIKE '%yandex.ru%';
Link to source
spamOrama.png
1 Like
A.min (2 years ago)
Visit
Poke
Wed, 27 Jul 2022 17:54:19 -0400
That will do the trick but there are a number of database things that can be attached to these such as iconfig (post metadata) and term (tags).
Delivery reports and threadlisteners also exist but will get cleaned up automatically at some point --- but iconfig and term won't be. They aren't huge but they do exist. This probably needs an interface to at least select everything on the page or remove everything - although that might remove a couple of legitimate entries.
The other concern is that you might have legitimate content from yandex. In any case, like I said - that will work but cleanup of messes like this probably could use a bit of improvement.
Link to source
1 Like
Cyborg 2-A ✅ (2 years ago)
Visit
Poke
Cyborg 2-A ✅
Wed, 27 Jul 2022 20:34:27 -0400
This person(s) are putting litter everywhere. It's like a big waste of time and energy i think? A spammer's brain thinks if they can put out their messages to millions or more that like "point 1%" will earn them money big time. But there is no "point 1%", it just doesn't happen. It's reallly like zero. I mean who would click on their link?
Link to source
Visit
Poke
Bill Statler
Wed, 27 Jul 2022 21:18:04 -0400
On the left side of the image, the 6-character sequences -- those are the contents of posts? Maybe they're commands to a botnet that's programmed to follow that account?
Link to source
Visit
Poke
Cyborg 2-A ✅
Wed, 27 Jul 2022 22:19:12 -0400
yes, they are all about titles and subjects but not body contents. maybe the sequence means something. i've seen this same thing on other sites that are not federated, ie different software.
Link to source
Login
Login/Email
Password
Remember me
Login
Register
Password Reset
Remote Authentication