Changeset 187 for trunk/system/generators/dhcp_routerboard.php

Timestamp:

Apr 5, 2009, 3:54:46 PM (16 years ago)

Author:

george

Message:

• Přidáno: Možnost registrace podsítí pro klienty.
• Upraveno: Skripty pro generování nastavení routerů byly upraveny pro podporu tabulky NetworkSubnet.

File:

• trunk/system/generators/dhcp_routerboard.php (modified) (3 diffs)

trunk/system/generators/dhcp_routerboard.php

@@ -3 +3 @@
 include_once('../../global.php');
 
-$UserName = 'admin-ssh';
-
-$DbResult = $Database->query('SELECT * FROM NetworkSubnet');
+$DbResult = $Database->query('SELECT * FROM `NetworkSubnet` WHERE `Member` = 0');
 while($Subnet = $DbResult->fetch_assoc())
 {
@@ -13 +11 @@
   $Commands = array();
   $Commands[] = '/ip dhcp-server lease { remove [find server=dhcp'.$I.']}';
-  $DbResult2 = $Database->query('SELECT * FROM hosts WHERE (IP LIKE "192.168.'.$I.'.%") AND (MAC != "00:00:00:00:00:00") ORDER BY IP');
+  $DbResult2 = $Database->query('SELECT * FROM `hosts` WHERE (`IP` LIKE "192.168.'.$I.'.%") AND (`MAC` != "00:00:00:00:00:00") ORDER BY `IP`');
   while($Host = $DbResult2->fetch_assoc())
   {
@@ -19 +17 @@
   }
   $Commands = implode(';', $Commands);
-  $Command = '/usr/bin/ssh -l '.$UserName.' -i id_dsa '.$Subnet['DHCP'].' "'.$Commands.'"';
+  $Command = '/usr/bin/ssh -l '.$Config['MainRouter']['UserName'].' -i id_dsa '.$Subnet['DHCP'].' "'.$Commands.'"';
   //echo($Command."\n");
   $Output = '';