source: trunk/system/generators/netwatch.php@ 248

Last change on this file since 248 was 248, checked in by george, 16 years ago
  • Opraveno: Import položek Netwatch z routerboardu do datbáze.
  • Property svn:executable set to *
File size: 1.5 KB
Line 
1<?php
2
3if(isset($_SERVER['REMOTE_ADDR'])) die();
4include('../../global.php');
5include('../routerboard.php');
6$Path = array('tool', 'netwatch');
7
8$Routerboard = new Routerboard();
9$Routerboard->UserName = $Config['MainRouter']['UserName'];
10$Routerboard->Timeout = $Config['MainRouter']['ConnectTimeout'];
11$Routerboard->Debug = true;
12
13$DbResult3 = $Database->query('SELECT DISTINCT (`DHCP`) FROM `NetworkSubnet` WHERE `Member` = 0');
14while($Router = $DbResult3->fetch_assoc())
15{
16 echo($Router['DHCP']."\n");
17 $Routerboard->HostName = $Router['DHCP'];
18 $Items = array();
19 $DbResult = $Database->query('SELECT * FROM `NetworkSubnet` WHERE `DHCP`="'.$Router['DHCP'].'"');
20 while($Subnet = $DbResult->fetch_assoc())
21 {
22 //print_r($Subnet);
23 $I = explode('.', $Subnet['AddressRange']);
24 $I = $I[2];
25 $DbResult2 = $Database->query('SELECT NetworkInterface.*, NetworkDevice.Name AS DeviceName FROM NetworkInterface LEFT JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE (NetworkInterface.LocalIP LIKE "192.168.'.$I.'.%") AND (NetworkDevice.Used = 1) ORDER BY NetworkInterface.LocalIP');
26 while($Interface = $DbResult2->fetch_assoc())
27 {
28 $Name = $Interface['DeviceName'];
29 if($Interface['Name'] != '') $Name .= '-'.$Interface['Name'];
30 echo($Name.', ');
31 $Items[] = array('host' => $Interface['LocalIP'], 'interval' => '00:01:00', 'comment' => $Name);
32 }
33 }
34 $Routerboard->ListUpdate($Path, array('host', 'interval', 'comment'), $Items);
35 echo("\n");
36}
37
38?>
Note: See TracBrowser for help on using the repository browser.