Changeset 522 for trunk/Modules/NetworkConfigRouterOS/Generators/AddressPortability.php

Timestamp:

Apr 15, 2013, 11:08:49 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Skritpy generátorů nastavení routerů přetvořeny na aplikační moduly NetworkConfig.

Location:

trunk/Modules/NetworkConfigRouterOS

Files:

• . (added)
• Generators (added)
• Generators/AddressPortability.php (copied) (copied from trunk/system/generators/address_portability.php ) (5 diffs)

trunk/Modules/NetworkConfigRouterOS/Generators/AddressPortability.php

@@ -2 +2 @@
 
 if(isset($_SERVER['REMOTE_ADDR'])) die();
-include('../../Common/Global.php');
-include('../routerboard.php');
+include_once(dirname(__FILE__).'/../../../Common/Global.php');
+include_once(dirname(__FILE__).'/../Routerboard.php');
 $Path = array('ip', 'dhcp-server', 'lease');
 
@@ -18 +18 @@
 $Routerboard->Timeout = $Config['MainRouter']['ConnectTimeout'];
 
-$DbResult3 = $Database->query('SELECT * FROM `NetworkSubnet` WHERE `Member` = 0 GROUP BY `DHCP`');
+$DbResult3 = $System->Database->query('SELECT * FROM `NetworkSubnet` WHERE `Member` = 0 GROUP BY `DHCP`');
 while($Subnet = $DbResult3->fetch_assoc())
 {
@@ -31 +31 @@
       $Properties['expires-after'] = time() - (24 * 3600 - ConvertExpireTime2($Properties['expires-after']));
       echo('MAC: '.$Properties['active-mac-address']."\n");
-      $DbRows2 = $Database->query('SELECT `Id` FROM `NetworkInterface` WHERE `MAC`="'.$Properties['active-mac-address'].'"');
+      $DbRows2 = $System->Database->query('SELECT `Id` FROM `NetworkInterface` WHERE `MAC`="'.$Properties['active-mac-address'].'"');
       if($DbRows2->num_rows > 0)
       {
         $Interface = $DbRows2->fetch_assoc();
         $InterfaceId = $Interface['Id'];
-        $DbRows2 = $Database->query('SELECT `Id` FROM `NetworkInterfacePortable` WHERE `NetworkInterface`='.$InterfaceId);
+        $DbRows2 = $System->Database->query('SELECT `Id` FROM `NetworkInterfacePortable` WHERE `NetworkInterface`='.$InterfaceId);
         if($DbRows2->num_rows > 0)
         {
-          $Database->update('NetworkInterfacePortable', '`Time` < "'.TimeToMysqlDateTime($Properties['expires-after']).'" AND `NetworkInterface`='.$InterfaceId, array('DynamicIP' => $Properties['active-address'], 'Update' => 1));
-        } else $Database->insert('NetworkInterfacePortable', array('NetworkInterface' => $InterfaceId, 'DynamicIP' => $Properties['active-address'], 'Time' => TimeToMysqlDateTime($Properties['expires-after']), 'Update' => 1));
+          $System->Database->update('NetworkInterfacePortable', '`Time` < "'.TimeToMysqlDateTime($Properties['expires-after']).'" AND `NetworkInterface`='.$InterfaceId, array('DynamicIP' => $Properties['active-address'], 'Update' => 1));
+        } else $System->Database->insert('NetworkInterfacePortable', array('NetworkInterface' => $InterfaceId, 'DynamicIP' => $Properties['active-address'], 'Time' => TimeToMysqlDateTime($Properties['expires-after']), 'Update' => 1));
       } else echo('Not registred'."\n");
       //print_r($Properties);
@@ -52 +52 @@
 $MangleRule = array();
 $NATRule = array();
-$DbRows = $Database->query('SELECT NetworkDevice.Name AS DeviceName, NetworkInterface.Name AS InterfaceName, DynamicIP FROM `NetworkInterfacePortable` JOIN NetworkInterface ON NetworkInterface.Id=NetworkInterfacePortable.NetworkInterface JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE `Update`=1');
+$DbRows = $System->Database->query('SELECT NetworkDevice.Name AS DeviceName, NetworkInterface.Name AS InterfaceName, DynamicIP FROM `NetworkInterfacePortable` JOIN NetworkInterface ON NetworkInterface.Id=NetworkInterfacePortable.NetworkInterface JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device WHERE `Update`=1');
 while($Portable = $DbRows->fetch_assoc())
 {
@@ -68 +68 @@
 $Routerboard->ExecuteBatch($NATRule);
 $Routerboard->ExecuteBatch($MangleRule);
-$Database->query('UPDATE NetworkInterfacePortable SET Update=0');
+$System->Database->query('UPDATE NetworkInterfacePortable SET Update=0');
 
 ?>