[3.0] Update IPv6 support for MySQL

[jdarwood007]

When we added IPv6 to 2.1, we ran into an issue that, due to older MySQL support, we could not use the native INET6_ATON and INET6_NTOA support. Now that we have upgraded our MySQL support. We can improve this now. I think it could also some performance benefits and allow some more native queries.

INET6_ATON => IP to Binary
INET6_NTOA => Binary to IP

@albertlast Any thoughts otherwise?

SMF/Sources/Db/APIs/MySQL.php

Line 2455 in e2a6e1b

return sprintf('unhex(\'%1$s\')', $ip->toHex());

[Sesquipedalian]

This is a good idea

[albertlast]

the important one is, that it can handle ipv6 and ipv4 and this it does: https://dbfiddle.uk/CG_Tbrra
the binary of both ways(php and mysql implementation) should be the same, at least was this target of the php implementation with hex way.
But performancewise shouldn't be a measurable improvment exists,
so end of the day you make it for look.