XF 1.3 Getting IP from xf_ip table

[Tyrone Chicken]

Could anyone tell me how to get the ip from the xf_ip table? there is a row called "ip" but it's not plain text.

 

[Jeremy]

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]

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:

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.

 

[Tyrone Chicken]

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:

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.