Mediawiki
Jump to navigation
Jump to search
Mediawiki Notes
General tasks done over time to maintain mediawiki.
Nuke SPAM accounts
Login to the MySQL database to do this work..
- Spaamers are adding bot email address into notes, so we can use that as a better filter
UPDATE account_requests SET acr_deleted = 1, acr_rejected = DATE_FORMAT(NOW(), '%Y%m%d%H%i%s'), acr_comment = 'Mass rejection due to account bot or spammer abuse' WHERE acr_deleted = 0 AND acr_email = acr_notes;
- This is the old version.
UPDATE account_requests SET acr_deleted = 1, acr_rejected = DATE_FORMAT(NOW(), '%Y%m%d%H%i%s'), acr_comment = 'Mass rejection due to account abuse spike' WHERE acr_deleted = 0;
Attempt indexing
- TBD