Announcement

Collapse
No announcement yet.

Deleting members from database with a specific email account

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Deleting members from database with a specific email account

    Hi:
    I wish to delete all members that share a particular email account (ie: @yahoo.com). Am I correct I can simply go into phpmyadmin and run the following query:

    Code:
    delete from user where email like "'%@yahoo.com%"
    Is my regular expression correct? Also, is there any other queries I need to run to clean up after deleting members this way?

    Thanks!

    - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

  • #2
    That will delete any such users yes, however deleting users directrly in the database is not supported. There will almost certainly be unintended consequences.

    You should search for users in the admincp that have that email domain and then delete from there.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.2 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Just deleting them from user would be a bad and unsupported idea.

      Just create a dummy usergroup that cannot do anything, and move them to that.
      Baby, I was born this way

      Comment


      • #4
        Thanks for the response. The problem is there are over 1000 members who are using the same email service (ie: @yahoo.com) and who are spammers that I wish to delete or ban quickly. There doesn't seem to be a way to quickly manipulate members by email address in the user CP, hence the reason I'm asking to do it via a mysql query. Do you have any suggestions in this case?
        - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

        Comment


        • #5
          Do what I said above.

          "Just create a dummy usergroup that cannot do anything, and move them to that. "
          Baby, I was born this way

          Comment


          • #6
            Should be
            Code:
            delete * from user where email like '%@yahoo.com'
            or
            Code:
            select * from user where email like '%@yahoo.com'
            will give you a list of usernames
            Psychlinks Mental Health Support Forum
            Local Search Forum

            Comment


            • #7
              A warning to anyone reading...please DO NOT delete users by database query.

              You will break your site, and support won't be able to fix it.

              Both Paul and I have tried to make this clear but it's still being suggested, for some reason.

              MARK.B | vBULLETIN SUPPORT

              TalkNewsUK - My vBulletin 5.5.2 Demo
              AdminAmmo - My Cloud Demo

              Comment

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