Changeset 4 for www/finance/include.php

Timestamp:

Jan 14, 2008, 9:48:39 PM (17 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)
• finance/include.php (modified) (4 diffs)

www/finance/include.php

@@ -1 @@
-<?
+<?php
 NactiMesicniParametry();
 
 function RecalculateTariffs($Period = 1)
 {
-  global $Tarify, $MaxSpeed, $Internet, $SpeedElement;
+  global $Tarify, $MaxSpeed, $Internet, $SpeedElement, $Database;
     
   $Tarify = array();
-  DB_Select('finance_tariffs', '*', 'period='.$Period.' ORDER BY speed_factor');
-  while($Tariff = DB_Row())
+  $DbResult = $Database->select('finance_tariffs', '*', 'period='.$Period.' ORDER BY speed_factor');
+  while($Tariff = $DbResult->fetch_array())
   {
     $Tarify[$Tariff['id']] = $Tariff;
@@ -20 +20 @@
   foreach($Tarify as $Index => $Tarif)
   {
-    DB_Select('users', 'COUNT(*)', 'inet_tarif_'.$Column.'='.$Index.' AND inet=1 AND role=0');
-    $Row = DB_Row();
+    $DbResult = $Database->select('users', 'COUNT(*)', 'inet_tarif_'.$Column.'='.$Index.' AND inet=1 AND role=0');
+    $Row = $DbResult->fetch_array();
     $Tarify[$Index]['user_count'] = $Row[0];    
     $TotalUserCount = $TotalUserCount + $Tarify[$Index]['user_count'];
@@ -49 +49 @@
 {
   global $kWh, $Internet, $Sprava, $DatumOdecteni, $InternetUsers, $SpravaUsers, $InternetSegmentId, 
-    $MaxSpeed, $RealMaxSpeed, $SpeedReserve;
+    $MaxSpeed, $RealMaxSpeed, $SpeedReserve, $Database;
     
-  DB_Query("SELECT * FROM finance_charge WHERE period=".$Period);
-  $Row = DB_Row();
+  $DbResult = $Database->query("SELECT * FROM finance_charge WHERE period=".$Period);
+  $Row = $DbResult->fetch_array();
   $kWh = $Row['kWh'];
   $Internet = $Row['internet'];
@@ -60 +60 @@
   $MaxSpeed = $RealMaxSpeed - $SpeedReserve;
 
-  DB_Query("SELECT COUNT(*) FROM users WHERE inet=1 AND role=0");
-  $Row = DB_Row();
+  $DbResult = $Database->query("SELECT COUNT(*) FROM users WHERE inet=1 AND role=0");
+  $Row = $DbResult->fetch_array();
   $InternetUsers = $Row[0];
 
-  DB_Query("SELECT COUNT(*) FROM users WHERE overheads=1 AND role=0");
-  $SpravaUsers = DB_Row();
+  $DbResult = $Database->query("SELECT COUNT(*) FROM users WHERE overheads=1 AND role=0");
+  $SpravaUsers = $DbResult->fetch_array();
   $SpravaUsers = $SpravaUsers[0];
   $InternetSegmentId = 21;