Changeset 171 for www/system/generators/nat_routerboard.php

Timestamp:

Mar 24, 2009, 7:28:33 PM (16 years ago)

Author:

george

Message:

• Opraveno: Konfigurační skripty síťových zařízení opraveny pro nové tabulky Member a Subject.

File:

• www/system/generators/nat_routerboard.php (modified) (3 diffs)

www/system/generators/nat_routerboard.php

@@ -1 +1 @@
 <?php
+
 include_once('../../global.php');
 
@@ -8 +9 @@
 $Commands[] = '/ip firewall nat { remove [find] }';
 
-$DbResult = $Database->select('users', 'CONCAT(second_name, " ", first_name) as fullname, id');
-while($User = $DbResult->fetch_array())
+$DbResult = $Database->query('SELECT Member.*, Subject.* FROM Member ON Member.Subject = Subject.Id');
+while($Member = $DbResult->fetch_assoc())
 {
-  echo($User['fullname']."\n");
-  $DbResult2 = $Database->select('hosts', '*', '(external_ip <> "") AND (user='.$User['id'].') AND (IP != external_ip) ORDER BY id DESC');
-  while($Host = $DbResult2->fetch_array())
+  echo($Member['Name']."\n");
+  $DbResult2 = $Database->select('hosts', '*', '(external_ip <> "") AND (user='.$Member['Id'].') AND (IP != external_ip) ORDER BY id DESC');
+  while($Host = $DbResult2->fetch_assoc())
   {
     echo($Host['name']."\n");
@@ -28 +29 @@
 
 $Commands = addslashes(implode(';', $Commands));
-$Command = '/usr/bin/ssh -l admin-ssh -i /root/.ssh/id_dsa '.$Router.' "'.$Commands.'"';
-//echo($Command."\n");
-exec($Command, $Output);
+$Command = '/usr/bin/ssh -l admin-ssh -i id_dsa '.$Router.' "'.$Commands.'"';
+echo($Command."\n");
+//exec($Command, $Output);
 //array_pop($Output);
 //print_r($Output);