Announcement

Collapse
No announcement yet.

How to flush/remove IP addresses from certain Users

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

  • How to flush/remove IP addresses from certain Users

    I have an old database & have moderators with many different ip addresses in their user profiles dating from years back.

    I would like to know how to delete these ip records so that only the latests ip's show from now on.

  • #2
    good question .. i would like to know too

    Comment


    • #3
      Ehm, won't the most recent used show up at the top?
      Deleting IP-data may seem trivial, but it can have its uses, historically speaking.
      Toddler from Hell

      Comment


      • #4
        anyone?

        Comment


        • #5
          These queries will delete ALL the IP addresses in posts and from user registraions (the only ones vB keeps):

          UPDATE user SET ipaddress='';

          UPDATE post SET ipaddress='';

          NOTE: Those are two single quotes ('), not a double-quote(").

          As with any changes to the db, I strongly recommend that you make a good backup of the database first.
          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


          • #6
            Is there any way to do it for a specific user? eg the Admin?

            Comment


            • #7
              UPDATE user SET ipaddress='' WHERE userid='xxx';

              UPDATE post SET ipaddress='' WHERE userid='xxx';

              ...with 'xxx' being the appropriate userid number, not name.
              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

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