Changeset 102

Timestamp:

Aug 3, 2008, 6:48:38 PM (16 years ago)

Author:

george

Message:

• Upraveno: Vystředění stránky dostupnost sítě.

Location:

devel/www

Files:

• network/dostupnost.php (modified) (2 diffs)
• page.php (modified) (1 diff)
• temp/transform.php (modified) (1 diff)

devel/www/network/dostupnost.php

@@ -11 +11 @@
     $Output = '<div style="font-size: small;">Dostupnost zařízení se kontroluje jednou za minutu. Hodnoty u delších intervalů nemusí odpovídat skutečnosti, protože záznam byl spuštěn až v průběhu těchto intervalu. 
 Všechny prvky sítě jsou kontrolovány z směrovačů, tj. pokud vypadne některé blízké zařízení, všechny další zařízení propojené přes něj jsou také nedostupné.</div>';
-    $Output .= '<table width="100%"><tr><td valign="top"></td><td valign="top">';
+    $Output .= '<div align="center">';
 
     // Zařízení
-    $Output .= '<strong>Zařízení:</strong><table style="font-size: small;" cellspacing="0" cellpadding="3" border="1">';
+    $Output .= '<br /><table style="font-size: small;" cellspacing="0" cellpadding="3" border="1">';
     $Output .= '<tr><th>Jméno</th><th>Hodina [%]</th><th>Den [%]</th><th>Týden [%]</th><th>Měsíc [%]</th><th>Year [%]</th></tr>';
     $DbResult = $this->Database->query('SELECT hosts.name, PeriodHour.Percent as Hour, PeriodDay.Percent as Day, PeriodWeek.Percent as Week, PeriodMonth.Percent as Month, PeriodYear.Percent as Year FROM hosts LEFT JOIN (SELECT stat_hosts.host_id, (SUM(stat_hosts.count) / 1 / 60 * 100) as Percent FROM stat_hosts WHERE (time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 1 HOUR)) AND (time< DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY host_id) as PeriodHour ON PeriodHour.host_id=hosts.id LEFT JOIN (SELECT stat_hosts.host_id, (SUM(stat_hosts.count) / 24 / 60 * 100) as Percent FROM stat_hosts WHERE (time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 HOUR)) AND (time< DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY host_id) as PeriodDay ON PeriodDay.host_id=hosts.id LEFT JOIN (SELECT stat_hosts.host_id, (SUM(stat_hosts.count) / 24 / 7 / 60 * 100) as Percent FROM stat_hosts WHERE (time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 7 HOUR)) AND (time< DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY host_id) as PeriodWeek ON PeriodWeek.host_id=hosts.id LEFT JOIN (SELECT stat_hosts.host_id, (SUM(stat_hosts.count) / 24 / 30 / 60 * 100) as Percent FROM stat_hosts WHERE (time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 30 HOUR)) AND (time< DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY host_id) as PeriodMonth ON PeriodMonth.host_id=hosts.id LEFT JOIN (SELECT stat_hosts.host_id, (SUM(stat_hosts.count) / 24 / 365 / 60 * 100) as Percent FROM stat_hosts WHERE (time > DATE_SUB(DATE_SUB(NOW(), INTERVAL 1 HOUR), INTERVAL 24 * 365 HOUR)) AND (time< DATE_SUB(NOW(), INTERVAL 1 HOUR)) GROUP BY host_id) as PeriodYear ON PeriodYear.host_id=hosts.id WHERE hosts.used=1 AND hosts.show_online=0');
@@ -20 +20 @@
     while($Row = $DbResult->fetch_array())
     {
-      $Output .= '<tr><td>'.$Row['name'].'</td><td>'.sprintf("%01.2f", $Row['Hour']).'</td><td>'.sprintf("%01.2f", $Row['Day']).'</td><td>'.sprintf("%01.2f", $Row['Week']).'</td><td>'.sprintf("%01.2f", $Row['Month']).'</td><td>'.sprintf("%01.2f", $Row['Year']).'</td></tr>';
+      $Output .= '<tr><td>'.$Row['name'].'</td><td style="text-align: right;">'.sprintf("%01.2f", $Row['Hour']).'</td><td style="text-align: right;">'.sprintf("%01.2f", $Row['Day']).'</td><td style="text-align: right;">'.sprintf("%01.2f", $Row['Week']).'</td><td style="text-align: right;">'.sprintf("%01.2f", $Row['Month']).'</td><td style="text-align: right;">'.sprintf("%01.2f", $Row['Year']).'</td></tr>';
     }
-    $Output .= '</table>';
-    $Output .= '</td></tr></table>';
+    $Output .= '</table></div>';
     return($Output);
   }

devel/www/page.php

@@ -166 +166 @@
     $Output = $this->ShowHeader($this->FullTitle, $this->ShortTitle).$Output;
     $Output .= $this->ShowFooter();
-    echo($this->FormatOutput($Output));
-    //echo($Output);
+    //echo($this->FormatOutput($Output));
+    echo($Output);
   }
 

devel/www/temp/transform.php

@@ -147 +147 @@
 
     $this->SubjectOpenTime();
+
+    // Import chat messages history
+    //$this->Database->query('TRUNCATE TABLE ChatHistory');
+    //$this->Database->query('INSERT INTO ChatHistory (SELECT id as Id, nick as Nick, text as Text, time as Time, color as Color, roomname as RoomName, roomtype as RoomType, "" as Host FROM `sunrisechat_history`)');
     return($Output);
   }