Changeset 167 for www/system/netwatch_import.php

Timestamp:

Mar 24, 2009, 11:44:03 AM (16 years ago)

Author:

george

Message:

• Přidáno: Stránka pro rozeslání emailů s počátečními hesly.
• Upraveno: Konfigurační skripty pro nastavení síťových zařízení se systémem RouterOS doplněny o podporu zápisu konfigurace do více samostatných zařízení. Změna se týká konfigurace DHCP serveru a sledování net_watch.
• Opraveno: Některé nefunkční odkazy na hlavní stránce.
• Upraveno: Tabulka finance_operations nově převedena na tabulky FinanceOperation a FinanceClaimsLiabilities. Upraveny související stránky.

File:

• www/system/netwatch_import.php (modified) (1 diff)

www/system/netwatch_import.php

@@ -1 +1 @@
 <?php
-include_once('/a/www/centrala/global.php');
+$SessionDisable = true;
+include_once('../global.php');
 
+$UserName = 'admin-ssh';
 $Config['Web']['ShowErrors'] = 1;
 
-$Commands = array();
-//$MaxSubnet = 1;
-$Commands[] = '/tool netwatch print terse';
-$Commands = implode(';', $Commands);
-$Command = '/usr/bin/ssh -l admin-ssh -i /root/.ssh/id_dsa rt-hajda-0 "'.$Commands.'"';
-//echo($Command."\n");
-exec($Command, $Output);
-array_pop($Output);
-//print_r($Output);
+$DbResult3 = $Database->query('SELECT DISTINCT (`DHCP`) FROM `NetworkSubnet`');
+while($Router = $DbResult3->fetch_assoc())
+{
+  $Commands = array();
+  $Commands[] = '/tool netwatch print terse';
+  $Commands = implode(';', $Commands);
+  $Command = '/usr/bin/ssh -l '.$UserName.' -i generators/id_dsa '.$Router['DHCP'].' "'.$Commands.'"';
+  //echo($Command."\n");
+  $Output = '';
+  exec($Command, $Output);
+  array_pop($Output);
+  //print_r($Output);
+  foreach($Output as $Row)
+  {
+    $Row = substr($Row, 6);
+    $RowParts = explode(' ', $Row);
+    $Properties = array();
+    foreach($RowParts as $Index => $Item)
+    {
+      if(strpos($Item, '=') !== false) 
+      {
+        $ItemParts = explode('=', $Item);
+        $Properties[$ItemParts[0]] = $ItemParts[1];
+      }
+    }
+    if($Properties['status'] == 'up')
+    {
+      $Online = 1;
+      $Values = array('online' => $Online,  'last_online' => 'NOW()');
+    } else 
+    {
+      $Online = 0;
+      $Values = array('online' => $Online);
+    }
 
-foreach($Output as $Row)
-{
-  $Row = substr($Row, 6);
-  $RowParts = explode(' ', $Row);
-  $Properties = array();
-  foreach($RowParts as $Index => $Item)
-  {
-    if(strpos($Item, '=') !== false) 
+    $DbResult = $Database->update('hosts', 'IP="'.$Properties['host'].'"', $Values);
+    if($Online == 1)
     {
-      $ItemParts = explode('=', $Item);
-      $Properties[$ItemParts[0]] = $ItemParts[1];
+      $DbResult = $Database->select('hosts', 'id', 'IP="'.$Properties['host'].'"');
+      $DbRow = $DbResult->fetch_array();
+      $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"))');
     }
-  }
-  if($Properties['status'] == 'up')
-  {
-    $Online = 1;
-    $Values = array('online' => $Online,  'last_online' => 'NOW()');
-  } else 
-  {
-    $Online = 0;
-    $Values = array('online' => $Online);
-  }
-
-  $DbResult = $Database->update('hosts', 'IP="'.$Properties['host'].'"', $Values);
-  if($Online == 1)
-  {
-    $DbResult = $Database->select('hosts', 'id', 'IP="'.$Properties['host'].'"');
-    $DbRow = $DbResult->fetch_array();
-    $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"))');
   }
 }