Mediawiki: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:mediawiki ===Mediawiki Notes=== General tasks done over time to maintain mediawiki. ==Nuke SPAM accounts== Login to the MySQL database to do this work.. * 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; ==Attempt indexing== * TBD") |
mNo edit summary |
||
| Line 5: | Line 5: | ||
==Nuke SPAM accounts== | ==Nuke SPAM accounts== | ||
Login to the MySQL database to do this work.. | Login to the MySQL database to do this work.. | ||
* 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; | * Spaamers are adding bot email address into notes, so we can use that as a better filter | ||
<pre> | |||
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; | |||
</pre> | |||
* This is the old version. | |||
<pre> | |||
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; | |||
</pre> | |||
==Attempt indexing== | ==Attempt indexing== | ||
* TBD | * TBD | ||
Latest revision as of 09:08, 27 August 2025
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