Announcement

Collapse
No announcement yet.

Clear IP Addresses

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

  • Clear IP Addresses

    Not sure if this is the right place it post this.
    Is there a way to go in and clear all IP addresses out for all members at one time?

  • #2
    Execute this query:

    Code:
    UPDATE user SET ipaddress='';

    Comment


    • #3
      Worked like a charm!

      Thank you
      Quest

      Comment


      • #4
        May I ask one more question...

        How can you make it so nobody is invisible online.
        I was watching my site and most of the people are invisible and it makes it look to the members that there is nobody there.

        Thanks

        Comment


        • #5
          Originally posted by Quest4DSS
          May I ask one more question...

          How can you make it so nobody is invisible online.
          I was watching my site and most of the people are invisible and it makes it look to the members that there is nobody there.

          Thanks
          UPDATE user SET invisible = '0'

          Comment


          • #6
            And if you would like to make everyone visible except you (as I do on my site), you can do it like this (taking the example that my userid is 20)

            UPDATE user SET invisible = '0' where userid != '20'

            Comment


            • #7
              Then don't forget to remove the option for users to select invisible mode when they register or view their user CP.

              Syl...

              Comment


              • #8
                Thank you!

                Comment

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