- Timestamp:
- Apr 15, 2013, 11:08:49 PM (11 years ago)
- Location:
- trunk/Modules/NetworkConfigRouterOS
- Files:
-
- 2 added
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/NetworkConfigRouterOS/Generators/FirewallFilter.php
r521 r522 2 2 3 3 if(isset($_SERVER['REMOTE_ADDR'])) die(); 4 include ('../../Common/Global.php');5 include ('../routerboard.php');6 include ('common.php');4 include_once(dirname(__FILE__).'/../../../Common/Global.php'); 5 include_once(dirname(__FILE__).'/../Routerboard.php'); 6 include_once('Common.php'); 7 7 $Path = array('ip', 'firewall', 'filter'); 8 $Database = &$System->Database;9 8 10 9 $Routerboard = new Routerboard($Config['MainRouter']['HostName']); … … 44 43 45 44 // Insert blocked addresses 46 $DbResult = $ Database->query('SELECT Member.*, Subject.Name FROM Member JOIN Subject ON Member.Subject = Subject.Id WHERE Member.Blocked=1');45 $DbResult = $System->Database->query('SELECT Member.*, Subject.Name FROM Member JOIN Subject ON Member.Subject = Subject.Id WHERE Member.Blocked=1'); 47 46 while($Member = $DbResult->fetch_assoc()) 48 47 { 49 48 echo($Member['Name'].': '); 50 49 // Hosts 51 $DbResult2 = $ Database->query('SELECT NetworkInterface.*, NetworkDevice.Name AS DeviceName FROM NetworkInterface LEFT JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE (NetworkInterface.ExternalIP <> "") AND (NetworkDevice.Member = '.$Member['Id'].') AND (NetworkInterface.LocalIP != NetworkInterface.ExternalIP) ORDER BY id DESC');50 $DbResult2 = $System->Database->query('SELECT NetworkInterface.*, NetworkDevice.Name AS DeviceName FROM NetworkInterface LEFT JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE (NetworkInterface.ExternalIP <> "") AND (NetworkDevice.Member = '.$Member['Id'].') AND (NetworkInterface.LocalIP != NetworkInterface.ExternalIP) ORDER BY id DESC'); 52 51 while($Interface = $DbResult2->fetch_assoc()) 53 52 { … … 61 60 62 61 // Subnets 63 $DbResult2 = $ Database->select('NetworkSubnet', '*', 'Member='.$Member['Id']);62 $DbResult2 = $System->Database->select('NetworkSubnet', '*', 'Member='.$Member['Id']); 64 63 while($Subnet = $DbResult2->fetch_assoc()) 65 64 {
Note:
See TracChangeset
for help on using the changeset viewer.