1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delete/Modify Registration IP Address

Discussion in 'XenForo Questions and Support' started by AFP, Jul 29, 2012.

  1. AFP

    AFP New Member

    A member of my forum has a valid reason to change the IP address that he registered his account with.

    I was unable to find out how to delete/modify the Registration IP address, and if someone could help me out here I'd greatly appreciate it.


  2. 0xym0r0n

    0xym0r0n Well-Known Member

    I go in through the MYSQL database and remove it but every time he logs in, it will re-log that address.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query:

    UPDATE xf_ip
    SET ip = INET_ATON('')
    WHERE content_type = 'user'
    AND action = 'register'
    AND content_id = 3;
    Fill in the new IP and user_id.
    0xym0r0n, AFP and CyclingTribe like this.
  4. AFP

    AFP New Member

    Thanks Jake =)

    That's exactly what I was looking for, I even meant to ask for the SQL command in my original post.

    I know you got my back, feel free to hit me up if you ever need anything LOL
  5. Adam Howard

    Adam Howard Well-Known Member

    Off topic

    What was the reason? And IP's are only viewable to admin, s mods, or generally anyone you give access to view them. He/she can change their IP and still have access.

    You can pm me the answer if you don't want it public. I'm just wondering ..... Seems like an odd and maybe dangerous request.

Share This Page