Changeset 4418

Timestamp:

07/17/07 18:37:36 (6 years ago)

Author:

p_lindheimer

Message:

add cronmanager table and default enabling of online updates at install time

Files:

• freepbx/branches/2.3/SQL/newinstall.sql (modified) (1 diff)
• freepbx/branches/2.3/SQL/newinstall.sqlite3.sql (modified) (1 diff)
• freepbx/branches/2.3/upgrades/2.3.0beta2/tables.php (modified) (1 diff)

freepbx/branches/2.3/SQL/newinstall.sql

@@ -442 +442 @@
-);
-
+CREATE TABLE IF NOT EXISTS `cronmanager` (
+  `module` varchar(24) NOT NULL default '',
+  `id` varchar(24) NOT NULL default '',
+  `time` varchar(5) default NULL,
+  `freq` int(11) NOT NULL default '0',
+  `lasttime` int(11) NOT NULL default '0',
+  `command` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`module`,`id`)
+);
+
-
-/*!40000 ALTER TABLE `zap` DISABLE KEYS */;

freepbx/branches/2.3/SQL/newinstall.sqlite3.sql

@@ -441 +441 @@
-)
-
+CREATE TABLE IF NOT EXISTS `cronmanager` (
+  `module` varchar(24) NOT NULL default '',
+  `id` varchar(24) NOT NULL default '',
+  `time` varchar(5) default NULL,
+  `freq` int(11) NOT NULL default '0',
+  `lasttime` int(11) NOT NULL default '0',
+  `command` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`module`,`id`)
+);
-
-/*!40000 ALTER TABLE `zap` DISABLE KEYS */;

freepbx/branches/2.3/upgrades/2.3.0beta2/tables.php

@@ -373 +373 @@
-}
-
+outn("creating cronmanager table..");
+$sql = " CREATE TABLE IF NOT EXISTS `cronmanager` (
+          `module` varchar(24) NOT NULL default '',
+          `id` varchar(24) NOT NULL default '',
+          `time` varchar(5) default NULL,
+          `freq` int(11) NOT NULL default '0',
+          `lasttime` int(11) NOT NULL default '0',
+          `command` varchar(255) NOT NULL default '',
+          PRIMARY KEY  (`module`,`id`)
+        )
+        ";
+$check = $db->query($sql);
+if(DB::IsError($check)) {
+  out("ERROR: Can not create cronmanager table");
+}
+out("Done");
+
+outn("enabling online update checking..");
+$sql = "SELECT * FROM cronmanager WHERE module = 'module_admin' AND id = 'UPDATES'";
+$result = $db->getAll($sql, DB_FETCHMODE_ASSOC);
+if (DB::IsError($result)) { // error - table must not be there
+  out("can't update cronmanager table");
+} else {
+  if (count($result)) {
+    out("already enabled");
+  } else {
+    $freq = 24;
+    $night_time = array(19,20,21,22,23,0,1,2,3,4,5);
+    $run_time = $night_time[rand(0,10)];
+    $command = $amp_conf['AMPBIN']."/module_admin listonline";
+  
+    $sql = "INSERT INTO cronmanager 
+            (module, id, time, freq, lasttime, command)
+            VALUES
+            ('module_admin', 'UPDATES', '$run_time', $freq, 0, '$command')
+          ";
+    $check = $db->query($sql);
+    if(DB::IsError($check)) {
+      out("ERROR: can not insert update information in cronmanager");
+    } else {
+      out("Done");
+    }
+  }
+}
+
-?>