- Timestamp:
- Apr 6, 2020, 11:17:40 PM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/NetworkConfigRouterOS/Generators/FirewallFilter.php
r831 r873 42 42 // Insert blocked addresses 43 43 $DbResult = $this->Database->query('SELECT Member.*, Subject.Name FROM Member JOIN Subject ON Member.Subject = Subject.Id WHERE Member.Blocked=1'); 44 while ($Member = $DbResult->fetch_assoc())44 while ($Member = $DbResult->fetch_assoc()) 45 45 { 46 46 echo($Member['Name'].': '); 47 47 // Hosts 48 48 $DbResult2 = $this->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'); 49 while ($Interface = $DbResult2->fetch_assoc())49 while ($Interface = $DbResult2->fetch_assoc()) 50 50 { 51 51 $Name = $Interface['DeviceName']; 52 if ($Interface['Name'] != '') $Name .= '-'.$Interface['Name'];52 if ($Interface['Name'] != '') $Name .= '-'.$Interface['Name']; 53 53 $Name = RouterOSIdent($Name); 54 54 echo($Name.'('.$Interface['LocalIP'].'), '); … … 59 59 // Subnets 60 60 $DbResult2 = $this->Database->select('NetworkSubnet', '*', 'Member='.$Member['Id']); 61 while ($Subnet = $DbResult2->fetch_assoc())61 while ($Subnet = $DbResult2->fetch_assoc()) 62 62 { 63 63 $Subnet['Name'] = RouterOSIdent('subnet-'.$Subnet['Name']); … … 67 67 $NewAddress->Prefix = $Subnet['ExtMask']; 68 68 $Range = $NewAddress->GetRange(); 69 if ($Subnet['ExtMask'] != 32) $Range = $Range['From']->AddressToString().'-'.$Range['To']->AddressToString();69 if ($Subnet['ExtMask'] != 32) $Range = $Range['From']->AddressToString().'-'.$Range['To']->AddressToString(); 70 70 else $Range = $Range['From']->AddressToString(); 71 if ($Subnet['Mask'] == 32) $Src = $Subnet['AddressRange'];71 if ($Subnet['Mask'] == 32) $Src = $Subnet['AddressRange']; 72 72 else $Src = $Subnet['AddressRange'].'/'.$Subnet['Mask']; 73 73 $Items[] = array('chain' => 'forward', 'out-interface' => $InetInterface, 'src-address' => $Src, 'action' => 'drop','comment' => $Subnet['Name'].'-out-drop'); … … 77 77 $NewAddress->Prefix = $Subnet['Mask']; 78 78 $Range = $NewAddress->GetRange(); 79 if ($Subnet['Mask'] != 32) $Range = $Range['From']->AddressToString().'-'.$Range['To']->AddressToString();79 if ($Subnet['Mask'] != 32) $Range = $Range['From']->AddressToString().'-'.$Range['To']->AddressToString(); 80 80 else $Range = $Range['From']->AddressToString(); 81 if ($Subnet['ExtMask'] == 32) $Dest = $Subnet['ExtAddressRange'];81 if ($Subnet['ExtMask'] == 32) $Dest = $Subnet['ExtAddressRange']; 82 82 else $Dest = $Subnet['ExtAddressRange'].'/'.$Subnet['ExtMask']; 83 83 $Items[] = array('chain' => 'forward', 'in-interface' => $InetInterface, 'dst-address' => $Dest, 'action' => 'drop', 'comment' => $Subnet['Name'].'-in-drop');
Note:
See TracChangeset
for help on using the changeset viewer.