Changeset 317 for trunk/system/generators/netwatch_import.php

Timestamp:

Jul 15, 2011, 8:26:28 AM (13 years ago)

Author:

george

Message:

• Uvozovky v názvech v SQL dotazech.

File:

• trunk/system/generators/netwatch_import.php (modified) (3 diffs)

trunk/system/generators/netwatch_import.php

@@ -6 +6 @@
 include('common.php');
 $Path = array('tool', 'netwatch');
+$Period = 60; // every 60 seconds
 
-$DbResult3 = $Database->query('SELECT * FROM `NetworkSubnet`  WHERE `Member` = 0');
+while(1)
+{
+  $StartTime = time();
+
+$DbResult3 = $Database->query('SELECT * FROM `NetworkSubnet` WHERE `Member` IS NULL');
+//echo($DbResult3->num_rows);
 while($Subnet = $DbResult3->fetch_assoc())
 {
@@ -39 +45 @@
       }
 
-      $DbResult = $Database->update('NetworkInterface', 'LocalIP = "'.$Properties['host'].'"', $Values);
+      $DbResult = $Database->update('NetworkInterface', '`LocalIP` = "'.$Properties['host'].'"', $Values);
       if($Online == 1)
       {
-        $DbResult = $Database->select('NetworkInterface', 'Id', 'LocalIP = "'.$Properties['host'].'"');
+        $DbResult = $Database->select('NetworkInterface', 'Id', '`LocalIP` = "'.$Properties['host'].'"');
         $DbRow = $DbResult->fetch_assoc();
         $InterfaceId = $DbRow['Id'];
-        $DbResult2 = $Database->select('NetworkInterfaceStat', '*', '(NetworkInterface="'.$InterfaceId.'") AND (Time = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
-        if($DbResult2->num_rows == 0) $Database->query('REPLACE INTO NetworkInterfaceStat (NetworkInterface, Time) VALUES ("'.$InterfaceId.'", DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');          
-        $Database->query('UPDATE NetworkInterfaceStat SET PingCount = PingCount + 1 WHERE (NetworkInterface="'.$InterfaceId.'") AND (Time = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
+        $DbResult2 = $Database->select('NetworkInterfaceStat', '*', '(`NetworkInterface`="'.$InterfaceId.'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
+        if($DbResult2->num_rows == 0) $Database->query('REPLACE INTO `NetworkInterfaceStat` (`NetworkInterface`, `Time`) VALUES ("'.$InterfaceId.'", DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');          
+        $Database->query('UPDATE `NetworkInterfaceStat` SET `PingCount` = `PingCount` + 1 WHERE (`NetworkInterface`="'.$InterfaceId.'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
         
       }
@@ -55 +61 @@
 
 // Update device online state
-$DbResult = $Database->select('NetworkDevice', 'Id', 'Used=1');
+$DbResult = $Database->select('NetworkDevice', 'Id', '`Used`=1');
 while($Device = $DbResult->fetch_assoc())
 {
-  $DbResult2 = $Database->select('NetworkInterface', 'SUM(Online)', 'Device='.$Device['Id']);
+  $DbResult2 = $Database->select('NetworkInterface', 'SUM(`Online`) AS `SumOnline`', '`Device`='.$Device['Id']);
   $DbRow = $DbResult2->fetch_array();
-  if($DbRow['SUM(Online)'] > 0) $Online = 1; else $Online = 0;  
+  if($DbRow['SumOnline'] > 0) $Online = 1; else $Online = 0;  
   $Database->update('NetworkDevice', 'Id='.$Device['Id'], array('Online' => $Online));
   if($Online == 1) $Database->update('NetworkDevice', 'Id='.$Device['Id'], array('LastOnline' => 'NOW()'));
 }
 
+  $EndTime = time();
+  $Delay = $Period - ($EndTime - $StartTime);
+  if($Delay < 0) $Delay = 0;
+
+  echo('Waiting '.$Delay.' seconds...'."\n");
+  sleep($Delay);
+}
+
 ?>