XF IP address data stored long2ip format - how to convert them to IPv4 dotted quad

[CTXMedia]

When I'm looking through XF table data all the IP addresses are in a number string rather than the usual IPv4 dotted quad grouping we're used to seeing - 192.168.0.1 - so here's an online tool to allow you to quickly convert the XF IP data to a "regular" IP address:

http://www.tools4noobs.com/online_php_functions/long2ip/

Hope it helps a few of you.

Cheers,
Shaun

 

[CTXMedia]

Oh, and here's the sister tool - to convert IPv4 addresses into a long2ip number string: http://www.tools4noobs.com/online_php_functions/ip2long/ - in case you want to write IP data back to your XF tables.

 

[Luke F]

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton