Database->query('SELECT COUNT(*) FROM `User` WHERE (`Login` != "Anonym")'); $DbRow = $DbResult->fetch_row(); $PageList = GetPageList($DbRow[0]); $Output = $PageList['Output']; $Output .= ''; $TableColumns = array( array('Name' => 'Name', 'Title' => 'Jméno'), array('Name' => 'Email', 'Title' => 'E-mail'), array('Name' => 'ICQ', 'Title' => 'ICQ'), array('Name' => 'PhoneNumber', 'Title' => 'Telefón'), array('Name' => '', 'Title' => 'Počítače'), ); $Order = GetOrderTableHeader($TableColumns, 'Name', 0); $Output .= $Order['Output']; $Query = 'SELECT * FROM `User` WHERE (`Login` != "Anonym") '.$Order['SQL'].$PageList['SQLLimit']; $DbResult = $this->Database->query($Query); while($User = $DbResult->fetch_assoc()) { if($User['ICQ'] > 0) $User['ICQ'] = $User['ICQ']; else $User['ICQ'] = ' '; if($User['PhoneNumber'] > 0) $User['PhoneNumber'] = $User['PhoneNumber']; else $User['PhoneNumber'] = ' '; $DbResult2 = $this->Database->query('SELECT Name, Id FROM NetworkDevice WHERE Member = (SELECT Id FROM Member WHERE Member.ResponsibleUser = '.$User['Id'].') AND Used=1 ORDER BY Name'); $Devices = array(); while($Device = $DbResult2->fetch_assoc()) { $Devices[] = $Device['Name']; } $User['Devices'] = implode(', ', $Devices); $Output .= ''. ''. ''. ''. ''; } $Output .= '

'.$User['Name'].'

'.$User['Email'].'

'.$User['ICQ'].'

'.$User['PhoneNumber'].'

'.$User['Devices'].'

'; $Output .= $PageList['Output']; return($Output); } } $System->AddModule(new UserListPage()); $System->Modules['UserListPage']->GetOutput(); ?>