IP addresses wrong format

[user25]

I am trying to call members' IP addresses in their member, but the IP addresses in the database return weird configurations, for example 2Y??.  How do I fix this?

IP's show up correctly in the post ip.

[StefanT]

IP addresses are stored in a binary format: http://php.net/manual/en/function.inet-ntop.php

[user25]

That link is way over my brain function. How do handle that information? The IP search function doesn't work because of the different format.

[Destroy666]

Use in a plugin:

$somevar = my_inet_ntop($db->unescape_binary($memprofile['lastip']));

Or with Template Conditionals:

<?=my_inet_ntop($db->unescape_binary($memprofile['lastip']))?>

But you'll have to add my_inet_ntop and unescape_binary to inc/plugins/phptpl_allowed_funcs.txt