Changeset 14 for stat_functions.php

Timestamp:

Oct 17, 2007, 7:53:48 PM (17 years ago)

Author:

george

Message:

Oprava: Funkce pro přestavbu cache.

File:

• stat_functions.php (modified) (7 diffs)

stat_functions.php

@@ -249 +249 @@
 function GetTimeRange($Measure, $Level)
 {
-  global $Debug;
+  global $Debug, $Database;
   
   // Get first and last time
-  echo($Measure['Id'].','.$Level.','.StatTableName($Level)."\n"); 
+  //echo($Measure['Id'].','.$Level.','.StatTableName($Level)."\n"); 
   $Result = $Database->select($Measure['DataTable'], '*', 'measure='.$Measure['Id'].' AND level='.$Level.' ORDER BY time LIMIT 1');
   if($Result->num_rows > 0)
@@ -395 +395 @@
 function RebuildMeasureCache($Measure)
 {
-  global $MaxLevel, $LevelReducing;
-
-  echo('Velicina '.$Measure['Name']."\n");
+  global $MaxLevel, $LevelReducing, $Database;
+
+  echo('Velicina '.$Measure['Name']."<br>\n");
   if($Measure['Continuity'] == 0) $Measure['ContinuityEnabled'] = 0;  // non continuous
     else $Measure['ContinuityEnabled'] = 2;    // continuous graph
 
   // Clear previous items
-  $Result = $Database->select($Measure['DataTable'], 'COUNT(*)', 'level>0 AND measure='.$Measure['Id']);
-  $Row = $Result->fetch_array();
+  $DbResult = $Database->select($Measure['DataTable'], 'COUNT(*)', 'level>0 AND measure='.$Measure['Id']);
+  $Row = $DbResult->fetch_array();
   echo("Mazu starou cache (".$Row[0]." polozek)...");
   $Database->delete($Measure['DataTable'], 'level>0 AND measure='.$Measure['Id']);
-  echo("\n");
+  echo("<br>\n");
 
   for($Level=1; $Level <= $MaxLevel; $Level++)
   {
-    echo('Uroven '.$Level."\n");
+    echo('Uroven '.$Level."<br>\n");
     $TimeRange = GetTimeRange($Measure, $Level-1);
     //echo($Measure['Id'].','.($Level-1)."\n");
@@ -418 +418 @@
     $EndTime = AlignTime($TimeRange['right'], $TimeSegment);
     $BurstCount = 500; 
-    echo('For 0 to '.round(($EndTime - $StartTime) / $TimeSegment / $BurstCount)."\n");
+    echo('For 0 to '.round(($EndTime - $StartTime) / $TimeSegment / $BurstCount)."<br>\n");
     for($I = 0; $I <= round(($EndTime - $StartTime) / $TimeSegment / $BurstCount); $I++)
     {
@@ -425 +425 @@
       $EndTime2 = $StartTime + ($I+1) * $BurstCount * $TimeSegment;
       $Values = array();
-      DB_Select($Measure['DataTable'], '*', 'time > "'.TimeToMysqlDateTime($StartTime2).'" AND time < "'.
+      $DbResult = $Database->select($Measure['DataTable'], '*', 'time > "'.TimeToMysqlDateTime($StartTime2).'" AND time < "'.
         TimeToMysqlDateTime($EndTime2).'" AND measure='.$Measure['Id'].' AND level='.($Level-1).' ORDER BY time');
-      while($Row = DB_Row())
+      while($Row = $DbResult->fetch_array())
       {
         $Row['time'] = MysqlDateTimeToTime($Row['time']);
@@ -453 +453 @@
             $Point = ComputeOneValue($StartTime3, $EndTime3, $SubValues, $Measure, $Level);
             $Continuity = $SubValues[1]['continuity'];   
-            DB_Insert($Measure['DataTable'], array('level' => $Level, 'measure' => $Measure['Id'], 'min' => $Point['min'], 
+            $Database->insert($Measure['DataTable'], array('level' => $Level, 'measure' => $Measure['Id'], 'min' => $Point['min'], 
               'avg' => $Point['avg'], 'max' => $Point['max'], 'continuity' => $Continuity, 'time' => TimeToMysqlDateTime($StartTime3+($EndTime3-$StartTime3)/2)));
           }        
@@ -462 +462 @@
       //array_pop($NextValues);
     }  
-    echo("Uroven dokoncena\n");         
-    DB_Select($Measure['DataTable'], 'COUNT(*)', 'level='.$Level.' AND measure='.$Measure['Id']);
-    $Row = DB_Row();
-    echo("Vlozeno ".$Row[0]." polozek.\n");
+    echo("Uroven dokoncena<br>\n");         
+    $DbResult = $Database->select($Measure['DataTable'], 'COUNT(*)', 'level='.$Level.' AND measure='.$Measure['Id']);
+    $Row = $DbResult->fetch_array();
+    echo("Vlozeno ".$Row[0]." polozek.<br>\n");
   } 
 }   
@@ -479 +479 @@
   $Result = $Database->select('measure', '*');
   while($Measures[] = $Result->fetch_array());
-  array_pop($Measures);
+    array_pop($Measures);
 
   foreach($Measures as $Measure)