\n"; $output .= "NameNickFunktion\n"; $DB->query("SELECT u.id AS id, u.nick, u.vorname, u.nachname, u.email, o.funktion, o.group_id, g.name AS group_name FROM user_orga AS o LEFT JOIN user AS u ON o.user_id=u.id LEFT JOIN user_orgagroups AS g ON g.id=o.group_id WHERE o.display_team=1 ORDER by g.display_order ASC, o.display_order ASC, u.nick ASC"); $last_group_id = 0; while($team = $DB->fetch_array()) { if($last_group_id!=$team['group_id']) { $output .= "".htmlentities($team['group_name'])."\n"; $last_group_id = $team['group_id']; } $output .= "".htmlentities($team['vorname']." ".$team['nachname'])."link(sprintf($USER->link['userdetails'],$team['id']))."\">".htmlentities($team['nick'])."".htmlentities($team['funktion'])."\n"; } $output .= "\n"; //$output = $HTML->message("Team ".$global['sitename'],$output); if(@file_exists($global['script_root']."/images/team/team.jpg")) { $info = GetImageSize($global['script_root']."/images/team/team.jpg"); $output .= "
".$HTML->message("Das ".$global['sitename']." Team in Reallife","
        

"); } // Title $PAGE->htmltitle="Das Team"; $PAGE->sitetitle="Team ".$global['sitename']; $PAGE->render($output); ?>