Famous spam removal script for Hubzilla servers which came in handy since mad Ivan Zlax started terrorizing the Fediverse.
Fill the variables in the script or in a seperate
config file with your database connection details and a valid source for the spammers file. The script will remove all items (posts, comments) and notifications of usernames in that list from your Hubzilla database and deactivates these accounts locally.
Ivan is known to create one to six accounts daily, spamming posts made by firstname.lastname@example.org and people resharing posts made by email@example.com, tagging users who liked or reshared these posts and threatening them.
It is not necessary to create a cronjob for this script because once used, he's disposing these newly created accounts.
Be careful when adding new account names with wildcards to the list. Ivan mimics usernames of other Diaspora* users. Just adding username@% might remove content from innocent users.
Don't try to communicate with him. He's going to tell you a story with made-up "facts" to justify his crusade and you'll probably end up in his list of spam targets. He has lost his mind; treat him exactly like that.