Changeset 37 for system/bandwidth2.php

Timestamp:

Jan 31, 2008, 8:38:47 PM (16 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)
• bandwidth2.php (modified) (5 diffs)

system/bandwidth2.php

@@ -1 @@
-<?
+<?php
 
-include_once('/a/html/is/db.php');
-DB_Init('localhost','root','','is');
-
-include_once('/a/sys/generators/global.php');
+include_once('../html/global.php');
+include_once('generators/global.php');
 
 function GetTrafficStatus()
@@ -108 +106 @@
 // Preload db host list from database
 $DbHosts = array();
-DB_Select('hosts','*');
-while($Row = DB_Row()) 
+$DbResult = $Database->select('hosts','*');
+while($Row = $DbResult->fetch_array()) 
 {
   if(($Row['vpn'] == 1) and ($Row['external_ip'] == '')) $DbHosts[ToVpnIp($Row)] = $Row['name'];
@@ -125 +123 @@
   Sleep($Period);
   $Hosts = GetTrafficStatus();
-  DB_Query('TRUNCATE TABLE known_hosts_ports');
+  $Database->query('TRUNCATE TABLE known_hosts_ports');
   foreach($Hosts as $Index => $Item) 
   {
@@ -137 +135 @@
     {
       //DB_Query('UPDATE known_hosts SET traffic_total_up = traffic_total_up + '.$Item['up'].', traffic_total_down = traffic_total_down + '.$Item['down'].', traffic_avg_up='.$Item['up'].', traffic_avg_down='.$Item['down'].', hostname="'.$DbHosts[$Index].'" WHERE IP="'.$Index.'"');
-      DB_Replace('known_hosts', array('IP' => $Index, 'hostname' => $DbHosts[$Index], 'traffic_avg_up' => $Item['up'], 'traffic_avg_down' => $Item['down'],
+      $Database->replace('known_hosts', array('IP' => $Index, 'hostname' => $DbHosts[$Index], 'traffic_avg_up' => $Item['up'], 'traffic_avg_down' => $Item['down'],
         'traffic_total_up' => $Item['total_up'], 'traffic_total_down' => $Item['total_down']));
       if(array_key_exists('ports', $Item))
@@ -146 +144 @@
         $Port['up'] = ($Port['up'] - $LastHosts[$Index]['ports'][$PortNumber]['up']) / $Period;
         $Port['down'] = ($Port['down'] - $LastHosts[$Index]['ports'][$PortNumber]['down']) / $Period;
-        DB_Replace('known_hosts_ports', array('host' => $Index, 'port' => $PortNumber, 'up' => $Port['up'], 
+        $Database->replace('known_hosts_ports', array('host' => $Index, 'port' => $PortNumber, 'up' => $Port['up'], 
           'down' => $Port['down'], 'total_down' => $Port['total_down'], 'total_up' => $Port['total_up']));
       }