Changeset 872 for trunk/Application

Timestamp:

Apr 9, 2017, 3:40:35 PM (8 years ago)

Author:

chronos

Message:

• Fixed: Allow to store IPv6 address in database for UserTrace and UserOnline tables.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -2945 +2945 @@
 }
 
+function UpdateTo872($Manager)
+{       
+  // Allow to store IPv6 addresses
+  $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogin` `LastLogin` DATETIME NULL;');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogout` `LastLogout` DATETIME NULL;');
+  $Manager->Execute('UPDATE `UserTrace` SET LastLogin=NULL WHERE CAST(LastLogin AS CHAR(20))="0000-00-00 00:00:00"');
+  $Manager->Execute('UPDATE `UserTrace` SET LastLogout=NULL WHERE CAST(LastLogout AS CHAR(20))="0000-00-00 00:00:00"');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastIP` `LastIP` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
+}
+
 class Updates
 {
@@ -2982 +2993 @@
   849 => array('Revision' => 857, 'Function' => 'UpdateTo857'),
   857 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
+  867 => array('Revision' => 872, 'Function' => 'UpdateTo872'),
     ));
   }

trunk/Application/Version.php

@@ -7 +7 @@
 
 $Version = '1.0';
-$Revision = 869; // Subversion revision
-$DatabaseRevision = 867; // Database structure revision
-$ReleaseDate = strtotime('2016-02-06');
+$Revision = 872; // Subversion revision
+$DatabaseRevision = 872; // Database structure revision
+$ReleaseDate = strtotime('2017-04-09');