Changeset 803 for trunk/admin/UpdateTrace.php

Timestamp:

Apr 14, 2014, 8:29:20 PM (10 years ago)

Author:

chronos

Message:

• Added: Do not log new referrals if client IP was previously blocked as spam source.

File:

• trunk/admin/UpdateTrace.php (modified) (15 diffs)

trunk/admin/UpdateTrace.php

@@ -2347 +2347 @@
   ADD CONSTRAINT `User_ibfk_1` FOREIGN KEY (`Language`) REFERENCES `Language` (`Id`),
   ADD CONSTRAINT `User_ibfk_2` FOREIGN KEY (`Team`) REFERENCES `Team` (`Id`);");
-  
+
   $Manager->Execute('INSERT INTO `DbVersion` (`Id` ,`Revision`) VALUES ("1", "498")');
   $Manager->Execute('INSERT INTO `Language` (`Id` ,`Name` ,`Enabled`)VALUES (NULL , "Angličtina", 0);');
@@ -2479 +2479 @@
 
 function UpdateTo506($Manager)
-{      
+{
   global $System;
-  
+
   $DbResult = $System->Database->query('SELECT `TablePrefix` FROM `Group`');
   while($Group = $DbResult->fetch_assoc())
@@ -2514 +2514 @@
 
 function UpdateTo510($Manager)
-{      
+{
   $Manager->Execute('ALTER TABLE `News` ADD `Title` VARCHAR( 255 ) NOT NULL AFTER `Time`');
   $Manager->Execute('UPDATE `News` SET `Title` = (SELECT `Name` FROM `User` AS `T` WHERE `T`.`ID` = `User`)');
@@ -2520 +2520 @@
 
 function UpdateTo524($Manager)
-{      
+{
   $Manager->Execute('ALTER TABLE `User` ADD `PreferredVersion` INT NULL DEFAULT NULL');
   $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )');
@@ -2534 +2534 @@
   while($DbRow = $DbResult->fetch_row())
   {
-    $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); 
-  }  
+    $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8");
+  }
 }
 
@@ -2559 +2559 @@
 
 function UpdateTo543($Manager)
-{ 
+{
   $Manager->Execute('ALTER TABLE `Group` ADD INDEX ( `Name` )');
 }
 
 function UpdateTo567($Manager)
-{ 
+{
   $Manager->Execute('ALTER TABLE `Log` ADD `URL` VARCHAR( 255 ) NOT NULL ;');
 }
 
 function UpdateTo574($Manager)
-{ 
+{
   $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` (
                 `Id` int(11) NOT NULL AUTO_INCREMENT,
@@ -2597 +2597 @@
 
 function UpdateTo585($Manager)
-{ 
+{
   $Manager->Execute('CREATE TABLE IF NOT EXISTS `APIToken` (
     `Id` int(11) NOT NULL AUTO_INCREMENT,
@@ -2613 +2613 @@
         $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`)
 VALUES (NULL , 'Nenalezené', 'teal', 'Nenalezené stránky');");
-} 
+}
 
 function UpdateTo604($Manager)
@@ -2646 +2646 @@
 `Code` = "en" WHERE `Language`.`Name` ="Angličitna";');
   $Manager->Execute('UPDATE `Language` SET `Code` = "cs" WHERE `Language`.`Name` ="Čeština";');
-  $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";');   
+  $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";');
 }
 
@@ -2662 +2662 @@
 `ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
   $Manager->Execute('ALTER TABLE `Server` ADD `CheckIP` VARCHAR( 16 ) NOT NULL ,
-ADD `CheckPort` INT NOT NULL ;');   
+ADD `CheckPort` INT NOT NULL ;');
 }
 
@@ -2673 +2673 @@
 function UpdateTo666($Manager)
 {
-        $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' ,  \'Instalace - Instalační soubor pro klienta\');');   
-        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'84\');');   
+        $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' ,  \'Instalace - Instalační soubor pro klienta\');');
+        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'84\');');
 }
 
 function UpdateTo678($Manager)
 {
-        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'11\');');   
+        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'11\');');
 }
 
@@ -2686 +2686 @@
         $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'.
   '`Export` int(11) NOT NULL,`GroupItem` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `Export` (`Export`),'.
-  ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');   
+  ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
         $Manager->Execute('ALTER TABLE `ExportGroupItem`'.
   'ADD CONSTRAINT `ExportGroupItem_ibfk_1` FOREIGN KEY (`Export`) REFERENCES `Export` (`Id`),'.
-  'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');   
+  'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');
 }
 
@@ -2711 +2711 @@
 function UpdateTo716($Manager)
 {
-        $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');   
+        $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');
 }
 
 function UpdateTo725($Manager)
 {
-        $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');   
+        $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');
 }
 
 function UpdateTo731($Manager)
 {
-        $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');   
+        $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');
 }
 
 function UpdateTo732($Manager)
 {
-        $Manager->Execute('ALTER TABLE  `ExportTask` CHANGE  `Progress`  `Progress` DOUBLE( 4, 2 ) NOT NULL ;');   
+        $Manager->Execute('ALTER TABLE  `ExportTask` CHANGE  `Progress`  `Progress` DOUBLE( 4, 2 ) NOT NULL ;');
 }
 
@@ -2800 +2800 @@
 }
 
+function UpdateTo803($Manager)
+{
+  $Manager->Execute('ALTER TABLE `Referrer` CHANGE `Show` `Visible` INT( 11 ) NOT NULL DEFAULT "1";');
+  $Manager->Execute('ALTER TABLE `Referrer` ADD `LastIP` VARCHAR( 16 ) NOT NULL ;');
+}
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
@@ -2815 +2821 @@
         609 => array('Revision' => 610, 'Function' => 'UpdateTo610'),
         610 => array('Revision' => 639, 'Function' => 'UpdateTo639'),
-        639 => array('Revision' => 646 , 'Function' => 'UpdateTo646'),
-        646 => array('Revision' => 666 , 'Function' => 'UpdateTo666'),
-        666 => array('Revision' => 678 , 'Function' => 'UpdateTo678'),
-        678 => array('Revision' => 695 , 'Function' => 'UpdateTo695'),
-        695 => array('Revision' => 712 , 'Function' => 'UpdateTo712'),
-        712 => array('Revision' => 716 , 'Function' => 'UpdateTo716'),
-        716 => array('Revision' => 725 , 'Function' => 'UpdateTo725'),
-        725 => array('Revision' => 731 , 'Function' => 'UpdateTo731'),
-        731 => array('Revision' => 732 , 'Function' => 'UpdateTo732'),
-        732 => array('Revision' => 748 , 'Function' => 'UpdateTo748'),
-  748 => array('Revision' => 787 , 'Function' => 'UpdateTo787'),
+        639 => array('Revision' => 646, 'Function' => 'UpdateTo646'),
+        646 => array('Revision' => 666, 'Function' => 'UpdateTo666'),
+        666 => array('Revision' => 678, 'Function' => 'UpdateTo678'),
+        678 => array('Revision' => 695, 'Function' => 'UpdateTo695'),
+        695 => array('Revision' => 712, 'Function' => 'UpdateTo712'),
+        712 => array('Revision' => 716, 'Function' => 'UpdateTo716'),
+        716 => array('Revision' => 725, 'Function' => 'UpdateTo725'),
+        725 => array('Revision' => 731, 'Function' => 'UpdateTo731'),
+        731 => array('Revision' => 732, 'Function' => 'UpdateTo732'),
+        732 => array('Revision' => 748, 'Function' => 'UpdateTo748'),
+  748 => array('Revision' => 787, 'Function' => 'UpdateTo787'),
+  787 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
 );