Changeset 735 for trunk/Common/Setup/Updates.php

Timestamp:

Apr 6, 2015, 1:03:33 PM (10 years ago)

Author:

chronos

Message:

• Added: Support for Internet free access. Unregistered users are redirected to activation page where they can found useful information and activate free access for 24 hours.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -1306 +1306 @@
   $Manager->Execute('ALTER TABLE `ModuleLink`
         MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+}
+
+function UpdateTo735($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkFreeAccess` (
+`Id` int(11) NOT NULL,
+`IPAddress` varchar(255) NOT NULL,
+`Time` datetime NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+        
+        $Manager->Execute('ALTER TABLE `NetworkFreeAccess`
+        ADD PRIMARY KEY (`Id`);');
+        
+        $Manager->Execute('ALTER TABLE `NetworkFreeAccess`
+        MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;');
+        
+        $Manager->Execute('ALTER TABLE `NetworkFreeAccess` ADD `Configured` INT NOT NULL ;');
+        $DbResult = $Manager->Execute('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) VALUES '.
+                '(NULL, "Konfigurace internetu zdarma", "ScheduleConfigureFreeAccess");');
+        $ActionId = $Manager->Database->insert_id;
+        $Manager->Execute('INSERT INTO `Scheduler` (`Id`, `Name`, `Enabled`, `Action`, 
+                `Log`, `LastExecutedTime`, `ScheduledTime`, `Period`) VALUES (NULL, "Internet zdarma", 
+                1, '.$ActionId.', "", NULL, "", 5);');
+        $Manager->Execute('ALTER TABLE `Scheduler` CHANGE `ScheduledTime` `ScheduledTime` DATETIME NULL;');
 }
 
@@ -1372 +1396 @@
         729 => array('Revision' => 730, 'Function' => 'UpdateTo730'),
         730 => array('Revision' => 731, 'Function' => 'UpdateTo731'),
+        731 => array('Revision' => 735, 'Function' => 'UpdateTo735'),
     ));
   }