Mass user delete

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sailvayu
    Member
    • Nov 2009
    • 39

    [Forum] Mass user delete

    I am cleaning out spammers (the bastards) and would like to know if there is a way to mass delete based on IP address and/or email with wildcard like *.ru

    Thanks in advance
    Wayne
  • Chuta
    Member
    • May 2009
    • 80

    #2
    Hello,

    You can run the following query within Maintenance -> Run SQL Query:

    Code:
    DELETE FROM `[COLOR=Red][B]PREFIX[/B][/COLOR]user` WHERE `email` LIKE '%.ru'
    If tables in the db has a prefix, replace PREFIX with it.

    Please take out a backup of your user table (at least) before attempting to use this.
    Andrés Durán Hewitt

    Comment

    • sailvayu
      Member
      • Nov 2009
      • 39

      #3
      Thanks I'll give it a shot
      Wayne

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...