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

Timestamp:

Jan 9, 2016, 1:08:20 PM (9 years ago)

Author:

chronos

Message:

• Removed: Old NetworkInterfaceStat table and availability history replaced by NetworkInterfaceUpDown newer mechanizm.

File:

• trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php (modified) (1 diff)

trunk/Modules/NetworkConfigRouterOS/Generators/NetwatchImport.php

@@ -87 +87 @@
       }
       $DbResult = $this->Database->update('NetworkDevice', '`LastOnline` < "'.TimeToMysqlDateTime($StartTime).'"', array('Online' => 0));
-
-      // Update interface online statistics
-      $DbResult = $this->Database->select('NetworkInterface', 'Id', '`Online` = 1');
-      while($Interface = $DbResult->fetch_assoc())
-      {
-        $DbResult2 = $this->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 $this->Database->query('UPDATE `NetworkInterfaceStat` SET `PingCount` = `PingCount` + 1 WHERE (`NetworkInterface`="'.$Interface['Id'].'") AND (`Time` = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
-      }
   }