Changeset 37 for system/generators/traffic_shaping.php

Timestamp:

Jan 31, 2008, 8:38:47 PM (17 years ago)

Author:

george

Message:

Upraveno: Přepsán přístup k databázi přes třídu mysqli v systémové složce.
Odstraněno: Staré verze souborů a staré nepoužité soubory.

Location:

system

Files:

• . (modified) (1 prop)
• generators/traffic_shaping.php (modified) (7 diffs)

system/generators/traffic_shaping.php

@@ -3 +3 @@
 $Enabled = 1;
 $ClassesEnabled = 1;
-include('global.php');
-include_once('../../html/is/db.php');
-DB_Init('localhost', 'root', '', 'is');
-DB_Query('SET NAMES latin2');
-
+include_once('../../html/global.php');
 include_once('../../html/finance/include.php');
 NactiMesicniParametry(0);
@@ -51 +47 @@
   { 
     fputs($File, "tc qdisc add dev imq0 root handle 1:0 htb default 2\n");
-    fputs($FileClassInfo, "1:1 Základní tøída\n");
+    fputs($FileClassInfo, "1:1 Z�ladn�t�a\n");
     fputs($File, "tc class add dev imq0 parent 1:0 classid 1:1 htb rate ".$TotalMaxSpeedIn."kbit quantum 1500\n");
     fputs($FileClassInfo, "1:2 Internet zdarma\n");
@@ -102 +98 @@
   fputs($File, "tc class add dev imq0 parent 1:1 classid 1:".$AllUsersClassId." htb rate ".$UsersMaxSpeedIn."kbit prio 1 quantum 1500\n");
   fputs($File, "tc class add dev imq1 parent 1:1 classid 1:".$AllUsersClassId." htb rate ".$UsersMaxSpeedOut."kbit prio 1 quantum 1500\n");
-  fputs($FileClassInfo, '1:'.$AllUsersClassId." V¹ichni u¾ivatelé\n");
+  fputs($FileClassInfo, '1:'.$AllUsersClassId." Vichni uivatel�n");
 
   // Torrent sharing
@@ -121 +117 @@
   fputs($FileClassInfo, '1:'.$TorrentClassId." Torrent\n");
 
-  DB_Select('users', '*, CONCAT(second_name, " ", first_name) as fullname', '(inet=1)'); 
-  while($User = DB_Row())
+  $DbResult = $Database->select('users', '*, CONCAT(second_name, " ", first_name) as fullname', '(inet=1)'); 
+  while($User = $DbResult->fetch_array())
   {
     $UserClassId = $ClassId;
@@ -132 +128 @@
     $Quantum = $Tarify[$User['inet_tarif_now']]['speed_factor'] * 1500;
 
-    DB_Save();
     fputs($File, "# === ".$User['fullname']." ===\n");
     fputs($File, "tc class add dev imq0 parent 1:".$AllUsersClassId." classid 1:".$UserClassId." htb rate ".$SpeedIn."bit ceil ".$UserMaxSpeedIn."bit prio 1 quantum ".$Quantum."\n");
@@ -144 +139 @@
     //echo('User class id: '.$UserClassId."\n");
   
-    DB_Select('hosts', 'COUNT(*)', "block=0 AND MAC!='' AND user=".$User['id']);
-    $Row = DB_Row();
+    $DbResult2 = $Database->select('hosts', 'COUNT(*)', "block=0 AND MAC!='' AND user=".$User['id']);
+    $Row = $DbResult2->fetch_array();
     $HostCount = $Row[0];
     $HostSpeedIn = round($SpeedIn / $HostCount);
     $HostSpeedOut = round($SpeedOut / $HostCount);
  
-    DB_Select('hosts','*',"block=0 AND MAC!='' AND user=".$User['id']);
-    while($Host = DB_Row())
+    $DbResult2 = $Database->select('hosts','*',"block=0 AND MAC!='' AND user=".$User['id']);
+    while($Host = $DbResult2->fetch_array())
     //if($Row['name'] != 'WOW')
     {
@@ -267 +262 @@
       
     }
-    DB_Load();
   }
   //echo($Row['id'].',');