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

Timestamp:

Sep 8, 2009, 9:03:14 AM (15 years ago)

Author:

george

Message:

• Opraveno: Import položek Netwatch z routerboardu do datbáze.

File:

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

trunk/system/generators/netwatch_import.php

@@ -16 +16 @@
   $List = $Routerboard->ListGetPrint($Path, array('host', 'status'));
   
-  //print_r($List);
   foreach($List as $Properties)
   {
     if(IsAddressInSubnet($Properties['host'], $Subnet['AddressRange'], $Subnet['Mask']))
     {
+      //echo($Properties['host'].', ');
       if($Properties['status'] == 'up')
       {
@@ -36 +36 @@
         $DbResult = $Database->select('NetworkInterface', 'Id', 'LocalIP = "'.$Properties['host'].'"');
         $DbRow = $DbResult->fetch_assoc();
-        $HostId = $DbRow['Id'];
-        $DbResult2 = $Database->select('stat_hosts', '*', '(host_id="'.$HostId.'") AND (time = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
-        if($DbResult2->num_rows == 0) $Database->query('REPLACE INTO stat_hosts (host_id, time) VALUES ("'.$HostId.'", DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');          
-        $Database->query('UPDATE stat_hosts SET count = count + 1 WHERE (host_id="'.$HostId.'") AND (time = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
+        $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 Count = Count + 1 WHERE (NetworkInterface="'.$InterfaceId.'") AND (Time = DATE_FORMAT(NOW(), "%Y-%m-%d %H:00:00"))');
       }
     }