Reset all ip adresses

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • serverguy84
    Member
    • Oct 2007
    • 99
    • 3.7.x

    Reset all ip adresses

    Is there a way to remove/reset everyones ip address?
    And start fresh?
    Because i noticed when i go into admin options it stores an ip address of the users.
    How can i reset and remove everyones stores ip address
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    These queries will clear all ip addresses from the user records and post records (backup first):

    Code:
    UPDATE user
    SET ipaddress = ''
    Code:
    UPDATE post
    SET ipaddress = ''

    Comment

    • serverguy84
      Member
      • Oct 2007
      • 99
      • 3.7.x

      #3
      Where do i put this query in the

      admin->maintenance->Execute SQL Query

      ?

      Comment

      • Jake Bunce
        Senior Member
        • Dec 2000
        • 46598
        • 3.6.x

        #4
        Yes, that is one way to run queries:

        Admin CP -> Maintenance -> Execute SQL Query

        You must have permission to execute queries in your includes/config.php file:

        Code:
        	//	****** 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.
        $config['SpecialUsers']['canrunqueries'] = '';

        Comment

        • serverguy84
          Member
          • Oct 2007
          • 99
          • 3.7.x

          #5
          hmm i think i did it wrong, im a bit confused. I have premissions to do SQL Queries, i went into manual query box and put it

          UPDATE user
          SET ipaddress = ''


          But i got an error

          Whats the second code you gave me?
          I am supposed to add that in too?

          Comment

          • Jake Bunce
            Senior Member
            • Dec 2000
            • 46598
            • 3.6.x

            #6
            They are two separate queries. Run them one at a time.

            What was the error message?

            Comment

            • serverguy84
              Member
              • Oct 2007
              • 99
              • 3.7.x

              #7
              Well when i put this into the query box

              UPDATE user
              SET ipaddress = ''

              i got this error

              An error occurred while attempting to execute your query. The following information was returned.
              error number: 1146
              error desc: Table 'wasku.user' doesn't exist


              and for the second one i got this error

              An error occurred while attempting to execute your query. The following information was returned.
              error number: 1146
              error desc: Table 'wasku.post' doesn't exist

              Comment

              • Jake Bunce
                Senior Member
                • Dec 2000
                • 46598
                • 3.6.x

                #8
                That means you are using a table prefix. You need to change the words user and post to include your table prefix.

                Comment

                • serverguy84
                  Member
                  • Oct 2007
                  • 99
                  • 3.7.x

                  #9
                  ah ok it worked, I did what you told me thanks!


                  For future people i did this:


                  UPDATE forum_user
                  SET ipaddress = ''

                  UPDATE forum_post
                  SET ipaddress = ''

                  Comment

                  • Thomas P
                    Senior Member
                    • Apr 2001
                    • 1497
                    • 5.6.4

                    #10
                    Is it possible to reset all IP Addresses of just one specific user?
                    www.MCSEboard.de
                    German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

                    Comment

                    • Jake Bunce
                      Senior Member
                      • Dec 2000
                      • 46598
                      • 3.6.x

                      #11
                      Code:
                      UPDATE user
                      SET ipaddress = ''
                      WHERE userid = [color=red]X[/color]
                      Code:
                      UPDATE post
                      SET ipaddress = ''
                      WHERE userid = [color=red]X[/color]
                      Where X is the userid of the user.

                      Comment

                      • Thomas P
                        Senior Member
                        • Apr 2001
                        • 1497
                        • 5.6.4

                        #12
                        Thanks, went fine on the testing forum. The last one took some time on a big board
                        www.MCSEboard.de
                        German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

                        Comment

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