source: trunk/system/netwatch_import.php@ 176

<?php
include_once('../global.php');

$UserName = 'admin-ssh';
$Config['Web']['ShowErrors'] = 1;

$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);
    }

    $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"))');
    }
  }
}

?>