Changeset 124 for system/generators/traffic_shaping_routerboard.php

Timestamp:

Dec 11, 2008, 8:28:30 AM (16 years ago)

Author:

george

Message:

• Opraveno: Generování traffic shapingu routerboardu se správně zformátovanými jmény uživatelů a počítačů.

File:

• system/generators/traffic_shaping_routerboard.php (modified) (5 diffs)

system/generators/traffic_shaping_routerboard.php

@@ -3 +3 @@
 $Enabled = 1;
 $ClassesEnabled = 1;
-chdir('/var/www/html/dev/centrala/www');
+chdir('/a/www/centrala');
 include_once('global.php');
 include_once('finance/include.php');
@@ -29 +29 @@
 
 $InetInterface = 'ether3';
-$Router = '192.168.10.33';
+$Router = '192.168.0.11';
 
 $Commands = array();
@@ -50 +50 @@
 
 // Slow free internet
-$Commands[] = ' /queue tree add name=free-out limit-at='.$FreeInetSpeed.' max-limit='.$FreeInetSpeed.' parent=main-out packet-mark='.$PacketMark;
-$Commands[] = ' /ip firewall mangle add chain=inet-out out-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' queue=wireless-default';
+$Commands[] = ' /ip firewall mangle add chain=inet-out out-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' comment="Free inet"';
+$Commands[] = ' /queue tree add name=free-out limit-at='.$FreeInetSpeed.' max-limit='.$FreeInetSpeed.' parent=main-out packet-mark='.$PacketMark.' queue=wireless-default';
 $PacketMark++;
+$Commands[] = ' /ip firewall mangle add chain=inet-in in-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' comment="Free inet"';
 $Commands[] = ' /queue tree add name=free-in limit-at='.$FreeInetSpeed.' max-limit='.$FreeInetSpeed.' parent=main-in packet-mark='.$PacketMark.' queue=wireless-default';
-$Commands[] = ' /ip firewall mangle add chain=inet-in in-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark;
 $PacketMark++;
 
-
 // Process users
-$DbResult = $Database->select('users', '*, CONCAT(second_name, "_", first_name) as fullname', '(inet=1)');
+$DbResult = $Database->select('users', '*, CONCAT(second_name, " ", first_name) as fullname', '(inet=1)');
 while($User = $DbResult->fetch_array())
 {
-  $User['fullname'] = strtr(strtolower($User['fullname']), array(
+  $User['fullname'] = strtr(strtolower(trim($User['fullname'])), array(' ' => '-', '(' => '-', ')' => '-',
   'č' => 'c', 'š' => 's', 'ě' => 'e', 'ř' => 'r', 'ž' => 'z', 'ý' => 'y', 'á' => 'a', 'í' => 'i', 'é' => 'e', 'ů' => 'u', 'ú' => 'u', 'ď' => 'd', 'ť' => 't', 'ň' => 'n', 'ó' => 'o',
   'Č' => 'c', 'Š' => 's', 'Ě' => 'e', 'Ř' => 'r', 'Ž' => 'z', 'Ý' => 'y', 'Á' => 'a', 'Í' => 'i', 'É' => 'e', 'Ů' => 'u', 'Ú' => 'u', 'Ď' => 'd', 'Ť' => 't', 'Ň' => 'n', 'Ó' => 'o',
@@ -89 +88 @@
     $IPParts = explode('.', $Host['IP']);
     $Subnet = $IPParts[2];
-    $Commands[] = ' /ip firewall mangle add chain=inet-out-'.$Subnet.' src-address='.$Host['IP'].' out-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' passthrough=no';
+    $Commands[] = ' /ip firewall mangle add chain=inet-out-'.$Subnet.' src-address='.$Host['IP'].' out-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' passthrough=no comment="'.$Host['name'].'"';
     $Commands[] = ' /queue tree add name='.$Host['name'].'-out limit-at='.$HostSpeedIn.' max-limit='.$UserMaxSpeedIn.' parent='.$User['fullname'].'-out packet-mark='.$PacketMark.' queue=wireless-default';
     $PacketMark++;
-    $Commands[] = ' /ip firewall mangle add chain=inet-in-'.$Subnet.' dst-address='.$Host['IP'].' in-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' passthrough=no';
+    $Commands[] = ' /ip firewall mangle add chain=inet-in-'.$Subnet.' dst-address='.$Host['IP'].' in-interface='.$InetInterface.' action=mark-packet new-packet-mark='.$PacketMark.' passthrough=no comment="'.$Host['name'].'"';
     $Commands[] = ' /queue tree add name='.$Host['name'].'-in limit-at='.$HostSpeedOut.' max-limit='.$UserMaxSpeedOut.' parent='.$User['fullname'].'-in packet-mark='.$PacketMark.' queue=wireless-default';
     $PacketMark++;
@@ -114 +113 @@
   echo("\n");
 }
-$Commands = implode(';', $Commands);
+print_r($Commands);
+$Commands = addslashes(implode(';', $Commands));
 $Command = '/usr/bin/ssh -l admin-ssh -i /root/.ssh/id_dsa '.$Router.' "'.$Commands.'"';
 //echo($Command."\n");
 exec($Command, $Output);
-array_pop($Output);
+//array_pop($Output);
+print_r($Output);
 
 ?>