How do I mass delete users with a "special" criteria?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • turkerm
    Member
    • Apr 2006
    • 31

    How do I mass delete users with a "special" criteria?

    Hello,

    My forum didn't require a code verification and thus by a script or a software, someone made automated registrations for hundreds of fake usernames and emails. (Now we require code verification but the old fake members are still members)

    All of these users have the same IP address and Birthday.

    How can I mass delete those users?

    I use VBulletin 3.5.4

    Thanks.
    Last edited by turkerm; Thu 20 Apr '06, 11:02am.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    There is no built-in method to do this by that criteria nor do I know of any other easy way. Sorry.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Lats
      Senior Member
      • Mar 2002
      • 3671

      #3
      You could create a new usergroup and prune the whole group via the ACP after running this query...
      Code:
      UPDATE
          user
      SET
          usergroupid = XXX
      WHERE
          ipaddress = '123.123.123.123'
      AND
          birthday = '02-23-1959'
      Replace XXX with the new usergroupid.
      Lats...

      Comment

      • turkerm
        Member
        • Apr 2006
        • 31

        #4
        Thanks, but how can I run a query?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          To run queries you first need to give yourself permission to run queries in the Admin CP. To dothis, edit this section of config.php:

          // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
          // The users specified here will be allowed to run queries from the control panel.
          // See the above entries for more information on the format.
          // Please note that the ability to run queries is quite powerful. You may wish
          // to remove all user IDs from this list for security reasons.
          $canrunqueries = 'x';

          ...with x being your userid number.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • turkerm
            Member
            • Apr 2006
            • 31

            #6
            Thanks, it worked!
            Last edited by turkerm; Thu 20 Apr '06, 11:14am.

            Comment

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