Changeset 817 for trunk/Modules/NetworkConfigRouterOS/Generators/DHCP.php

Timestamp:

Mar 16, 2016, 8:51:59 PM (8 years ago)

Author:

chronos

Message:

• Modified: NetworkConfig now register OnChange handler to NetworkDevice and NetworkInterface so network configuration can be propagated if network device or interface was changed.

File:

• trunk/Modules/NetworkConfigRouterOS/Generators/DHCP.php (modified) (1 diff)

trunk/Modules/NetworkConfigRouterOS/Generators/DHCP.php

@@ -20 +20 @@
       $Items = array();
       $Server = 'dhcp'.$Subnet['Id'];
-      $DbResult2 = $this->Database->query('SELECT NetworkInterface.*, NetworkDevice.Name AS DeviceName FROM `NetworkInterface` '.
-          ' LEFT JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE '.
-          ' CompareNetworkPrefix(INET_ATON(LocalIP), INET_ATON("'.$Subnet['AddressRange'].'"), '.$Subnet['Mask'].') AND (`MAC` != "00:00:00:00:00:00") ORDER BY `LocalIP`');
+      $DbResult2 = $this->Database->query('SELECT `NetworkInterface`.*, `NetworkDevice`.`Name` AS `DeviceName` FROM `NetworkInterface` '.
+        'LEFT JOIN `NetworkDevice` ON `NetworkDevice`.`Id` = `NetworkInterface`.`Device` '.
+        'WHERE CompareNetworkPrefix(INET_ATON(`LocalIP`), INET_ATON("'.$Subnet['AddressRange'].'"), '.$Subnet['Mask'].') '.
+        'AND (`MAC` != "00:00:00:00:00:00") ORDER BY `LocalIP`');
       while($Interface = $DbResult2->fetch_assoc())
       {