Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted May 10, 20186 yr Is there a good way to determine what % of users/topics/posts are from IPv6 users? I'd love to see that kind of statistic.
July 6, 20186 yr Author On 5/11/2018 at 5:50 AM, bfarber said: Why? Because it would be interesting to me.
July 6, 20186 yr https://www.google.com/intl/en/ipv6/statistics.html Considering pretty much everyone uses google in some manner, this would be pretty accurate.
July 9, 20186 yr You could probably query your database directly to capture this information. Something along the lines of SELECT COUNT(*) FROM _table_ WHERE ip_address LIKE '%:%'; SELECT COUNT(*) FROM _table_ WHERE ip_address NOT LIKE '%:%';
July 9, 20186 yr IPv4: Select count(*) from table where inet_aton(ip_address) IS NOT NULL IPv6: Select count(*) from table where inet_aton(ip_address) IS NULL
Archived
This topic is now archived and is closed to further replies.