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

XF 1.3 Getting IP from xf_ip table

Jeremy

Well-known member
#2
The easiest way is to navigate to the content in the front end. Otherwise you need to do a decent but of math.
 

Jake Bunce

XenForo moderator
Staff member
#3
What is the goal? Are you looking for a specific IP? Or are you wanting to know what IPs have been used by a specific user?

If you are running MySQL 5.6.3 or higher then this function should work:

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.
 
#4
What is the goal? Are you looking for a specific IP? Or are you wanting to know what IPs have been used by a specific user?

If you are running MySQL 5.6.3 or higher then this function should work:

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.
Thanks.