Changeset 4 for www/statistic/bandwidth.php

Timestamp:

Jan 14, 2008, 9:48:39 PM (16 years ago)

Author:

george

Message:

Upraveno: Změna přístupu k databázi na třídu rozšířenou mysqli.
Upraveno: Sjednocení
Upraveno: Změna kódování všech stránek na UTF-8.
Odstraňeno: Staré nepotřebné soubory.

Location:

www

Files:

• . (modified) (1 prop)
• statistic/bandwidth.php (modified) (6 diffs)

www/statistic/bandwidth.php

@@ -1 @@
-<?
+<?php
 
 Header('Refresh: 10');
 
-include_once('/a/html/is/db.php');
-DB_Init('localhost','root','','is');
-DB_Query('SET CHARACTER SET latin2');
+include_once('../global.php');
 
 include_once('../style.php');
-ShowHeader('Zatí¾ení linky do internetu','Zatí¾ení internetu');
+ShowHeader('Zatížení linky do internetu','Zatížení internetu');
 
 include_once('../finance/include.php');
@@ -16 +14 @@
 
 $HostsStat = array();
-DB_Select('known_hosts','*');
-while($Row = DB_Row())
+$DbResult = $Database->select('known_hosts','*');
+while($Row = $DbResult->fetch_array())
 {
   $HostsStat[$Row['IP']] = $Row;
@@ -27 +25 @@
 $TotalTrafficDown = 0;
 $Users = array();
-DB_Select('users', 'id, CONCAT(second_name," ",first_name) as fullname, inet_tarif_now', 'inet=1 ORDER BY fullname');
-while($User = DB_Row())
+$DbResult = $Database->select('users', 'id, CONCAT(second_name," ",first_name) as fullname, inet_tarif_now', 'inet=1 ORDER BY fullname');
+while($User = $DbResult->fetch_array())
 {
-  DB_Save();
-  
   // Read hosts traffic
   $Hosts = array();
   $TotalUserTrafficUp = 0;
   $TotalUserTrafficDown = 0;
-  DB_Select('hosts', '*', 'block=0 AND user='.$User['id']);
-  while($Host = DB_Row()) 
+  $DbResult2 = $Database->select('hosts', '*', 'block=0 AND user='.$User['id']);
+  while($Host = $DbResult2->fetch_array()) 
   { 
     if($Host['name'] == 'TBC') continue;
@@ -55 +51 @@
     $TotalUserTrafficDown = $TotalUserTrafficDown + $TrafficDown;
     
-    DB_Save();
-    DB_Select('known_hosts_ports', '*', 'host="'.$Host['IP'].'"');
-    while($Port = DB_Row()) 
+    $DbResult3 = $Database->select('known_hosts_ports', '*', 'host="'.$Host['IP'].'"');
+    while($Port = $DbResult3->fetch_array()) 
     { 
       $Host['ports'][] = $Port;
     }
-    DB_Load();
     if($Host['online'] == 1) $Hosts[] = $Host;
     //echo($Row['IP'].' '.$Row['name'].'<br>');
@@ -99 +93 @@
   $User['hosts'] = $Hosts;
   $Users[] = $User;
-  
-  
-  DB_Load();
 }
 
@@ -122 +113 @@
 
 // Show table
-echo('Informace o zatí¾ení internetu jednotlivými èleny sítì:<br>
-<table style="font-size: small;" cellspacing="0" border="1"><tr><th>Jméno èlena</th><th>Pøíchozí [B/s]</th><th>Odchozí [B/s]</th><th>Podíl [%]</th><th>Limit [B/s]</th></tr>');
+echo('Informace o zatíľení internetu jednotlivými členy sítě:<br>
+<table style="font-size: small;" cellspacing="0" border="1"><tr><th>Jméno člena</th><th>Příchozí [B/s]</th><th>Odchozí [B/s]</th><th>Podíl [%]</th><th>Limit [B/s]</th></tr>');
 $TrafficDownT = 0;
 $TrafficUpT = 0;