Changeset 522 for trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

Timestamp:

Apr 15, 2013, 11:08:49 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Skritpy generátorů nastavení routerů přetvořeny na aplikační moduly NetworkConfig.

Location:

trunk/Modules/NetworkConfigRouterOS

Files:

• . (added)
• Generators (added)
• Generators/NetwatchImport.php (copied) (copied from trunk/system/generators/netwatch_import.php ) (4 diffs)

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -2 +2 @@
 
 if(isset($_SERVER['REMOTE_ADDR'])) die();
-include('../../Common/Global.php');
-include('../routerboard.php');
-include('common.php');
+include_once(dirname(__FILE__).'/../../../Common/Global.php');
+include_once(dirname(__FILE__).'/../Routerboard.php');
+include_once('Common.php');
 $Path = array('tool', 'netwatch');
 $Period = 60; // every 60 seconds
-$Database = &$System->Database;
 
 while(1)
@@ -13 +12 @@
   $StartTime = time();
 
-  $DbResult3 = $Database->query('SELECT DHCP, AddressRange, Mask FROM `NetworkSubnet` WHERE (`Configure` = 1) AND (`Member` IS NULL) GROUP BY DHCP');
+  $DbResult3 = $System->Database->query('SELECT DHCP, AddressRange, Mask FROM `NetworkSubnet` WHERE (`Configure` = 1) AND (`Member` IS NULL) GROUP BY DHCP');
   //echo($DbResult3->num_rows);
   while($Subnet = $DbResult3->fetch_assoc())
@@ -38 +37 @@
       }
 
-      $DbResult = $Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"', $Values);
+      $DbResult = $System->Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"', $Values);
     }
   }
 
   // Update device online state
-  $DbResult = $Database->select('NetworkDevice', 'Id', '`Used`=1');
+  $DbResult = $System->Database->select('NetworkDevice', 'Id', '`Used`=1');
   while($Device = $DbResult->fetch_assoc())
   {
-    $DbResult2 = $Database->select('NetworkInterface', 'SUM(`Online`) AS `SumOnline`', '`Device`='.$Device['Id']);
+    $DbResult2 = $System->Database->select('NetworkInterface', 'SUM(`Online`) AS `SumOnline`', '`Device`='.$Device['Id']);
     $DbRow = $DbResult2->fetch_array();
     if($DbRow['SumOnline'] > 0) $Online = 1; 
@@ -52 +51 @@
     $Values = array('Online' => $Online);
     if($Online == 1) $Values['LastOnline'] = 'NOW()';
-    $Database->update('NetworkDevice', 'Id='.$Device['Id'], $Values);
+    $System->Database->update('NetworkDevice', 'Id='.$Device['Id'], $Values);
   }
 
   // Update interface online statistics
-  $DbResult = $Database->select('NetworkInterface', 'Id', '`Online` = 1');
+  $DbResult = $System->Database->select('NetworkInterface', 'Id', '`Online` = 1');
   while($Interface = $DbResult->fetch_assoc())
   {
-    $DbResult2 = $Database->select('NetworkInterfaceStat', '*', '(`NetworkInterface`="'.$Interface['Id'].'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
-    if($DbResult2->num_rows == 0) $Database->query('REPLACE INTO `NetworkInterfaceStat` (`NetworkInterface`, `Time`, `PingCount`) VALUES ("'.$Interface['Id'].'", DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"), 1)');          
-      else $Database->query('UPDATE `NetworkInterfaceStat` SET `PingCount` = `PingCount` + 1 WHERE (`NetworkInterface`="'.$Interface['Id'].'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
+    $DbResult2 = $System->Database->select('NetworkInterfaceStat', '*', '(`NetworkInterface`="'.$Interface['Id'].'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
+    if($DbResult2->num_rows == 0) $System->Database->query('REPLACE INTO `NetworkInterfaceStat` (`NetworkInterface`, `Time`, `PingCount`) VALUES ("'.$Interface['Id'].'", DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"), 1)');          
+      else $System->Database->query('UPDATE `NetworkInterfaceStat` SET `PingCount` = `PingCount` + 1 WHERE (`NetworkInterface`="'.$Interface['Id'].'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
   }