Changeset 154 for www/userlist.php

Timestamp:

Feb 16, 2009, 7:54:34 PM (15 years ago)

Author:

george

Message:

• Upraveno: Postupné odstraňování odkazů na tabulku users.
• Upraveno: Některé stránky přepracovány do nového zobrazovacího systému.
• Přidáno: Tabulka Subject rozdělena na tabulky Subject a Member. Transformační skript upraven.

File:

• www/userlist.php (modified) (2 diffs)

www/userlist.php

@@ -11 +11 @@
     $Output = '<table class="WideTable" style="font-size: small;"><tr><th>Jméno uživatele</th><th>E-mail</th><th>ICQ</th><th>Telefon</th><th>Počítače</th></tr>';
 
-    $DbResult = $this->Database->select('users', '*, CONCAT(second_name," ",first_name) as fullname', '1 ORDER BY fullname');
+    $DbResult = $this->Database->select('User', '*, TRIM(CONCAT(SecondName, " ", FirstName)) as FullName', 'Name != "Anonym" ORDER BY FullName');
     while($User = $DbResult->fetch_array())
     {
-      if($User['icq'] > 0) $ICQ = $User['icq']; else $ICQ = '&nbsp;';
-      if($User['phone'] > 0) $Phone = $User['phone']; else $Phone = '&nbsp;';
+      if($User['ICQ'] > 0) $ICQ = $User['ICQ']; else $ICQ = '&nbsp;';
+      if($User['PhoneNumber'] > 0) $Phone = $User['PhoneNumber']; else $Phone = '&nbsp;';
 
-      $DbResult2 = $this->Database->select('hosts', '*', 'user='.$User['id'].' AND block=0 ORDER BY name');
+      $DbResult2 = $this->Database->select('hosts', '*', 'user='.$User['Id'].' AND block=0 ORDER BY name');
       $Hosts = '';
       while($Host = $DbResult2->fetch_array())
@@ -25 +25 @@
       }
       if($Hosts != '') $Hosts = substr($Hosts, 0, -2);
-      $Output .= '<tr><td>'.$User['fullname'].'</td><td>'.$User['email'].'&nbsp;</td><td>'.$ICQ.'</td><td>'.$Phone.'</td><td>'.$Hosts.'</td></tr>';
+      $Output .= '<tr><td>'.$User['FullName'].'</td><td>'.$User['Email'].'&nbsp;</td><td>'.$ICQ.'</td><td>'.$Phone.'</td><td>'.$Hosts.'</td></tr>';
     }
     $Output .= '</table>';