Changeset 255 for trunk/temp/renumbering.php

Timestamp:

Oct 4, 2009, 7:56:50 AM (15 years ago)

Author:

george

Message:

• Upraveno: Generování SQL změn a filtr na 192.168.0.0/16.

File:

• trunk/temp/renumbering.php (modified) (1 diff)

trunk/temp/renumbering.php

@@ -34 +34 @@
     $Output = '';
 
-    $DbResult = $this->Database->query('SELECT * FROM NetworkSubnet');
+    $DbResult = $this->Database->query('SELECT * FROM NetworkSubnet WHERE CompareNetworkPrefix(INET_ATON("192.168.0.0"), INET_ATON(AddressRange), 16)');
+    $Output .= 'UPDATE NetworkInterface SET CZFreeIP = LocalIP<br>';
     while($Subnet = $DbResult->fetch_assoc())
     {
-      $Output .= 'Podsíť '.$Subnet['Name'].': '.$Subnet['AddressRange'].'/'.$Subnet['Mask'].' => '.$this->SubnetTable[$Subnet['Id']]['AddressRange'].'/'.$this->SubnetTable[$Subnet['Id']]['Mask'].'<br>';
-      $DbResult2 = $this->Database->query('SELECT NetworkInterface.LocalIP, NetworkDevice.Name FROM NetworkInterface JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE CompareNetworkPrefix(INET_ATON(NetworkInterface.LocalIP), INET_ATON("'.$Subnet['AddressRange'].'"), '.$Subnet['Mask'].')  ORDER BY NetworkInterface.LocalIP');
+      $Output .= '-- Podsíť '.$Subnet['Name'].': '.$Subnet['AddressRange'].'/'.$Subnet['Mask'].' => '.$this->SubnetTable[$Subnet['Id']]['AddressRange'].'/'.$this->SubnetTable[$Subnet['Id']]['Mask'].'<br>';
+      $DbResult2 = $this->Database->query('SELECT NetworkInterface.Id, NetworkInterface.LocalIP, NetworkDevice.Name FROM NetworkInterface JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE CompareNetworkPrefix(INET_ATON(NetworkInterface.LocalIP), INET_ATON("'.$Subnet['AddressRange'].'"), '.$Subnet['Mask'].')  ORDER BY NetworkInterface.LocalIP');
       $NextIP = IPv4ToInt32($this->SubnetTable[$Subnet['Id']]['AddressRange']) + 1;
       while($Interface = $DbResult2->fetch_assoc())
       {
-        $Output .= '&nbsp;&nbsp;&nbsp;'.$Interface['Name'].': '.$Interface['LocalIP'].' => '.Int32ToIPv4($NextIP).'<br>';
+        $Output .= '-- '.$Interface['Name'].': '.$Interface['LocalIP'].' => '.Int32ToIPv4($NextIP).'<br>';
+        $Output .= 'UPDATE NetworkInterface SET LocalIP = "'.Int32ToIPv4($NextIP).'" WHERE Id='.$Interface['Id'].';<br>';
         $NextIP++;        
       }