Changeset 193 for trunk/hostlist.php

Timestamp:

Apr 27, 2009, 12:04:53 AM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazování seznamu počítačů.

File:

• trunk/hostlist.php (modified) (1 diff)

trunk/hostlist.php

@@ -10 +10 @@
   {
     $Output = '<div align="center" style="font-size: small;"><table class="WideTable"><tr><th>Jméno počítače</th><th>IP adresa</th><th>Naposledy</th><th>Správce</th></tr>';
-    $DbResult = $this->Database->select('hosts', '*', 'type=0 ORDER BY name');
+    $DbResult = $this->Database->query('SELECT hosts.*, User.Name as UserName FROM hosts LEFT JOIN Member ON Member.Id = hosts.user LEFT JOIN User ON Member.ResponsibleUser = User.Id ORDER BY hosts.name');
     while($Host = $DbResult->fetch_array())
     {
-      $DbResult2 = $this->Database->select('User','*', 'Id='.$Host['user']);
-      $User = $DbResult2->fetch_assoc();
       if($Host['online'] == 1) $Style = 'font-weight: bold; color: blue;'; else $Style = '';
       if($Host['IP'] == '') $Host['IP'] = '&nbsp;';
-      $Output .= '<tr><td style="text-align: left; '.$Style.'">'.$Host['name'].'</td><td>'.$Host['IP'].'</td><td style="text-align: right;">'.HumanDate($Host['last_online']).'</td><td style="text-align: right;">'.$User['Name'].'</td></tr>';
+      $Output .= '<tr><td style="text-align: left; '.$Style.'">'.$Host['name'].'</td><td>'.$Host['IP'].'</td><td style="text-align: right;">'.HumanDate($Host['last_online']).'</td><td style="text-align: right;">'.$Host['UserName'].'</td></tr>';
     }
     $Output .= '</table></div>';