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

XF 1.2 What Table are IP Addresses Stored In

Discussion in 'XenForo Questions and Support' started by Wesker, Jun 16, 2014.

  1. Wesker

    Wesker Active Member

    As the title says, what table are IP Addresses stored in for users when they login, post etc.
     
  2. Wesker

    Wesker Active Member

    Found it.
     
  3. Adam K M

    Adam K M Active Member

    Mind sharing?

    Update: I'm looking at the xf_ip table, and the actual IP field in phpMyAdmin... doesn't look like an IP Address at all
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    IPs are normally viewed through XenForo. They are not stored in a readable format in the database.

    If you are running MySQL 5.6.3 or higher then this function should work to view the stored IPs in the xf_ip table:

    Code:
    SELECT INET6_NTOA(ip) AS ipaddress
    FROM xf_ip
    
    Otherwise there isn't an easy way to query the readable IP since XF started supporting IPv6 addresses.
     

Share This Page