Page MenuHomePhabricator

Cleanup Wikimini users in database stockwiki (now they are 1+ million)
Open, MediumPublic4 Estimated Story Points

Description

It would be nice to cleanup Wikimini users from the database wikimini_stockwiki. Now the registered users are 1+ million. Most of them are just probably automated accounts with bad intentions.

A mitigation for this situation is proposed here:

These two activities are complementary and can be started in any order.

To begin with, it would be useful to:

  • see some already existing utilities
  • find some criteria for identifying spammers in wikimini_stockwiki
    • maybe users without edits and without a confirmed email?
      • SELECT COUNT(*) FROM user WHERE user_editcount = 0 AND user_email_authenticated IS NULL → 285469
    • maybe other things?