UBB.Dev
Posted By: isaac UBB.threads 7.6.0 - Progress Report (2016-06-26) - 08/09/2016 11:25 AM
Changelog 2016-06-26
• Admin Logs -Fixed IP address logging after performing an admin function with Control Panel.
• Admin Logs -This template is now cleaned up and works with IPv6 addresses. Also fixed are the page validation errors -- there were many of them.

---

NOTES

IPv4 maths: (75x structure)
4 groups of 3 digits with 3 '.' between them. [192.168.000.001]
4 * 3 + 3 = 15
plus a trailing null = 16

IPv6 maths: (76x structure)
8 groups of 4 digits with 7 ':' between them.
8 * 4 + 7 = 39
plus a trailing null = 40

To take into account the IPv4 tunneling features [0000:0000:0000:0000:0000:0000:192.168.000.001],
(6 * 4 + 5) + 1 + (4 * 3 + 3) = 29 + 1 + 15 = 45
plus a trailing null = 46


Beta testers: To allow IPv6 addresses within your Admin Logs and WhosOnline, run this SQL from:
Control Panel > Database Tools > SQL Command

Code
ALTER TABLE ubbt_ADMIN_LOG
CHANGE LOG_IP LOG_IP VARCHAR(46);
ALTER TABLE ubbt_ONLINE
CHANGE ONLINE_USER_IP ONLINE_USER_IP VARCHAR(46);

This will be coded within the upgrader script before release.
20161003 added to altertable-7.6.0.php

Attached picture 20160626_16-20-21.PNG
© UBB.Developers