mastodon_spam_scanner
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
mastodon_spam_scanner [2023/02/09 03:27] admin |
mastodon_spam_scanner [2023/05/02 10:11] (current) neil |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| <code sql> | <code sql> | ||
| - | copy (select username,suspended_at from accounts where domain is null) to 'users.csv'; | + | copy (select username,suspended_at from accounts where domain is null) to '/tmp/users.csv' with delimiter ','; |
| </code> | </code> | ||
| Line 96: | Line 96: | ||
| <code bash> | <code bash> | ||
| php scan_for_spammers.php | grep -E "^4" > output.html | php scan_for_spammers.php | grep -E "^4" > output.html | ||
| + | </code> | ||
| + | |||
| + | To answer a question on Mastodon; You could add a list of spam keywords or suspicious urls at the top of the file, for example: | ||
| + | |||
| + | <code php> | ||
| + | $spam_keywords = array('spam_term', 'spamwebsite.com'); | ||
| + | </code> | ||
| + | |||
| + | Then add a loop just after the ''foreach($attachment..'' to search the profile text for a url or keyword, for example, adding this would increase the score generated based on more keywords matching: | ||
| + | |||
| + | <code php> | ||
| + | foreach($spam_keywords as $keyword) { | ||
| + | if(preg_match("/$keyword/i", $json['summary'])) | ||
| + | $score++; | ||
| + | } | ||
| + | |||
| </code> | </code> | ||
| Back to the [[Mastodon]] page. | Back to the [[Mastodon]] page. | ||
mastodon_spam_scanner.1675913272.txt.gz ยท Last modified: 2023/02/09 03:27 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
