For those who like #sql, here's an sql that looks for the currently used spam-images per instance, limited by the last 3 hours and at least 10 hits.
I’ll use this as a blocklist for now. #mastoadmin #spam
Edit to clarify: It looks for a hash of the blurred pictures created by mastodon, so it actually looks for the pictures in a way, not hashtags.
https://gist.github.com/strafplanet/cfdd10c3a999ac2d14a73cc5d9eae6a9#file-mastospam_sql_1-md
chris strafplanet /
npub1cm…q5etu
2024-02-18 14:12:17
Author Public Key
npub1cmg3vk2kkxrtldywctzk9y94g2e87twm84ukayg6p9hr88mnm4hskq5etuPublished at
2024-02-18 14:12:17Event JSON
{
"id": "c9997bf065f0fc79fc4516e149f477119a15c382a9f9f9f71d3e33d5c0d7c74d",
"pubkey": "c6d1165956b186bfb48ec2c56290b542b27f2ddb3d796e911a096e339f73dd6f",
"created_at": 1708265537,
"kind": 1,
"tags": [
[
"t",
"sql"
],
[
"t",
"mastoadmin"
],
[
"t",
"spam"
],
[
"proxy",
"https://mstdn.strafpla.net/users/chris/statuses/111952890234158262",
"activitypub"
]
],
"content": "For those who like #sql, here's an sql that looks for the currently used spam-images per instance, limited by the last 3 hours and at least 10 hits.\n I’ll use this as a blocklist for now. #mastoadmin #spam\nEdit to clarify: It looks for a hash of the blurred pictures created by mastodon, so it actually looks for the pictures in a way, not hashtags.\n\nhttps://gist.github.com/strafplanet/cfdd10c3a999ac2d14a73cc5d9eae6a9#file-mastospam_sql_1-md",
"sig": "b95c7e9e56d91f2d32e0ac09f46cdfca1f3f8361d6f3d3f20c0c04ced22c87727be09dff6ddda6dabe7a458c7876e034139239ade6a5cf46d4bfdc1dd58a8d1a"
}