Changeset 803 for trunk/admin


Ignore:
Timestamp:
Apr 14, 2014, 8:29:20 PM (11 years ago)
Author:
chronos
Message:
  • Added: Do not log new referrals if client IP was previously blocked as spam source.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/UpdateTrace.php

    r795 r803  
    23472347  ADD CONSTRAINT `User_ibfk_1` FOREIGN KEY (`Language`) REFERENCES `Language` (`Id`),
    23482348  ADD CONSTRAINT `User_ibfk_2` FOREIGN KEY (`Team`) REFERENCES `Team` (`Id`);");
    2349  
     2349
    23502350  $Manager->Execute('INSERT INTO `DbVersion` (`Id` ,`Revision`) VALUES ("1", "498")');
    23512351  $Manager->Execute('INSERT INTO `Language` (`Id` ,`Name` ,`Enabled`)VALUES (NULL , "Angličtina", 0);');
     
    24792479
    24802480function UpdateTo506($Manager)
    2481 {     
     2481{
    24822482  global $System;
    2483  
     2483
    24842484  $DbResult = $System->Database->query('SELECT `TablePrefix` FROM `Group`');
    24852485  while($Group = $DbResult->fetch_assoc())
     
    25142514
    25152515function UpdateTo510($Manager)
    2516 {     
     2516{
    25172517  $Manager->Execute('ALTER TABLE `News` ADD `Title` VARCHAR( 255 ) NOT NULL AFTER `Time`');
    25182518  $Manager->Execute('UPDATE `News` SET `Title` = (SELECT `Name` FROM `User` AS `T` WHERE `T`.`ID` = `User`)');
     
    25202520
    25212521function UpdateTo524($Manager)
    2522 {     
     2522{
    25232523  $Manager->Execute('ALTER TABLE `User` ADD `PreferredVersion` INT NULL DEFAULT NULL');
    25242524  $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )');
     
    25342534  while($DbRow = $DbResult->fetch_row())
    25352535  {
    2536     $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); 
    2537   } 
     2536    $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8");
     2537  }
    25382538}
    25392539
     
    25592559
    25602560function UpdateTo543($Manager)
    2561 { 
     2561{
    25622562  $Manager->Execute('ALTER TABLE `Group` ADD INDEX ( `Name` )');
    25632563}
    25642564
    25652565function UpdateTo567($Manager)
    2566 { 
     2566{
    25672567  $Manager->Execute('ALTER TABLE `Log` ADD `URL` VARCHAR( 255 ) NOT NULL ;');
    25682568}
    25692569
    25702570function UpdateTo574($Manager)
    2571 { 
     2571{
    25722572  $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` (
    25732573                `Id` int(11) NOT NULL AUTO_INCREMENT,
     
    25972597
    25982598function UpdateTo585($Manager)
    2599 { 
     2599{
    26002600  $Manager->Execute('CREATE TABLE IF NOT EXISTS `APIToken` (
    26012601    `Id` int(11) NOT NULL AUTO_INCREMENT,
     
    26132613        $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`)
    26142614VALUES (NULL , 'Nenalezené', 'teal', 'Nenalezené stránky');");
    2615 } 
     2615}
    26162616
    26172617function UpdateTo604($Manager)
     
    26462646`Code` = "en" WHERE `Language`.`Name` ="Angličitna";');
    26472647  $Manager->Execute('UPDATE `Language` SET `Code` = "cs" WHERE `Language`.`Name` ="Čeština";');
    2648   $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";');   
     2648  $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";');
    26492649}
    26502650
     
    26622662`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
    26632663  $Manager->Execute('ALTER TABLE `Server` ADD `CheckIP` VARCHAR( 16 ) NOT NULL ,
    2664 ADD `CheckPort` INT NOT NULL ;');   
     2664ADD `CheckPort` INT NOT NULL ;');
    26652665}
    26662666
     
    26732673function UpdateTo666($Manager)
    26742674{
    2675         $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' ,  \'Instalace - Instalační soubor pro klienta\');');   
    2676         $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'84\');');   
     2675        $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' ,  \'Instalace - Instalační soubor pro klienta\');');
     2676        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'84\');');
    26772677}
    26782678
    26792679function UpdateTo678($Manager)
    26802680{
    2681         $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'11\');');   
     2681        $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL ,  \'10\',  \'11\');');
    26822682}
    26832683
     
    26862686        $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'.
    26872687  '`Export` int(11) NOT NULL,`GroupItem` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `Export` (`Export`),'.
    2688   ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');   
     2688  ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
    26892689        $Manager->Execute('ALTER TABLE `ExportGroupItem`'.
    26902690  'ADD CONSTRAINT `ExportGroupItem_ibfk_1` FOREIGN KEY (`Export`) REFERENCES `Export` (`Id`),'.
    2691   'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');   
     2691  'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');
    26922692}
    26932693
     
    27112711function UpdateTo716($Manager)
    27122712{
    2713         $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');   
     2713        $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');
    27142714}
    27152715
    27162716function UpdateTo725($Manager)
    27172717{
    2718         $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');   
     2718        $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');
    27192719}
    27202720
    27212721function UpdateTo731($Manager)
    27222722{
    2723         $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');   
     2723        $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');
    27242724}
    27252725
    27262726function UpdateTo732($Manager)
    27272727{
    2728         $Manager->Execute('ALTER TABLE  `ExportTask` CHANGE  `Progress`  `Progress` DOUBLE( 4, 2 ) NOT NULL ;');   
     2728        $Manager->Execute('ALTER TABLE  `ExportTask` CHANGE  `Progress`  `Progress` DOUBLE( 4, 2 ) NOT NULL ;');
    27292729}
    27302730
     
    28002800}
    28012801
     2802function UpdateTo803($Manager)
     2803{
     2804  $Manager->Execute('ALTER TABLE `Referrer` CHANGE `Show` `Visible` INT( 11 ) NOT NULL DEFAULT "1";');
     2805  $Manager->Execute('ALTER TABLE `Referrer` ADD `LastIP` VARCHAR( 16 ) NOT NULL ;');
     2806}
     2807
    28022808$Updates = array(
    28032809        498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
     
    28152821        609 => array('Revision' => 610, 'Function' => 'UpdateTo610'),
    28162822        610 => array('Revision' => 639, 'Function' => 'UpdateTo639'),
    2817         639 => array('Revision' => 646 , 'Function' => 'UpdateTo646'),
    2818         646 => array('Revision' => 666 , 'Function' => 'UpdateTo666'),
    2819         666 => array('Revision' => 678 , 'Function' => 'UpdateTo678'),
    2820         678 => array('Revision' => 695 , 'Function' => 'UpdateTo695'),
    2821         695 => array('Revision' => 712 , 'Function' => 'UpdateTo712'),
    2822         712 => array('Revision' => 716 , 'Function' => 'UpdateTo716'),
    2823         716 => array('Revision' => 725 , 'Function' => 'UpdateTo725'),
    2824         725 => array('Revision' => 731 , 'Function' => 'UpdateTo731'),
    2825         731 => array('Revision' => 732 , 'Function' => 'UpdateTo732'),
    2826         732 => array('Revision' => 748 , 'Function' => 'UpdateTo748'),
    2827   748 => array('Revision' => 787 , 'Function' => 'UpdateTo787'),
     2823        639 => array('Revision' => 646, 'Function' => 'UpdateTo646'),
     2824        646 => array('Revision' => 666, 'Function' => 'UpdateTo666'),
     2825        666 => array('Revision' => 678, 'Function' => 'UpdateTo678'),
     2826        678 => array('Revision' => 695, 'Function' => 'UpdateTo695'),
     2827        695 => array('Revision' => 712, 'Function' => 'UpdateTo712'),
     2828        712 => array('Revision' => 716, 'Function' => 'UpdateTo716'),
     2829        716 => array('Revision' => 725, 'Function' => 'UpdateTo725'),
     2830        725 => array('Revision' => 731, 'Function' => 'UpdateTo731'),
     2831        731 => array('Revision' => 732, 'Function' => 'UpdateTo732'),
     2832        732 => array('Revision' => 748, 'Function' => 'UpdateTo748'),
     2833  748 => array('Revision' => 787, 'Function' => 'UpdateTo787'),
     2834  787 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
    28282835);
Note: See TracChangeset for help on using the changeset viewer.