Previous Thread
Next Thread
Print Thread
Rate Thread
UBB.threads 7.6.0 - Progress Report (2016-06-26) #321897
08/09/2016 4:25 AM
08/09/2016 4:25 AM
Joined: Jul 2001
Posts: 1,180
California
isaac Offline OP
$coffee=code(true);
isaac  Offline OP
$coffee=code(true);

Joined: Jul 2001
Posts: 1,180
California
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 Files 20160626_16-20-21.PNG

isaac @ id242.com // UBB.threads 7.6.x Progress ReportsIsaac DeCoursey
Sponsored Links

Moderated by  Gizmo, isaac 

Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 84
Joined: December 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,454
Posts293,496
Members13,800
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,941
Greg Hard 5,533
Top Posters(30 Days)
isaac 8
Gizmo 3
driv 1
Today's Statistics
Currently Online 864
Topics Created 1
Posts Made 1
Users Online 1
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.3
(Snapshot build 20180915.dev)
Page Time: 0.072s Queries: 15 (0.024s) Memory: 3.2323 MB (Peak: 3.4859 MB) Zlib enabled. Server Time: 2018-09-22 05:48:45 UTC