out(1); $class = 'Cnorm'; $q = "SELECT b.uid, a.icq, a.avatar, a.status, a.name, c.name as posi, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = ".$gid." ORDER BY c.pos ASC, a.name ASC"; $erg = db_query($q); while($row = db_fetch_assoc($erg) ) { $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' ); $row['class'] = $class; if ( $row['staat'] != '' ) { $row['staat'] = ''; } else { $row['staat'] = 'n/a'; } $row['status'] = ($row['status']? 'aktiv' : 'inaktiv' ); if(!empty($row['icq'])){ $row['icq'] = ''; } else { $row['icq'] = 'n/a'; } if($allgAr['teams_show_list']==1){ if(empty($row['avatar'])){ $row['avatar'] = 'n/a'; } else { $row['avatar'] = 'Avatar von '.$row['name'].''; } $tpl->set_ar_out($row,2); } else { $tpl->set_ar_out($row,3); } } $tpl->out(4); } if ($menu->get(1) == 'show') { $gid = escape($menu->get(2), 'integer'); $name = @db_result (db_query("SELECT name FROM prefix_groups WHERE zeigen = 1 AND id =".$gid)); $bild = @db_result (db_query("SELECT img FROM prefix_groups WHERE zeigen = 1 AND id =".$gid)); $title = $allgAr['title'].' :: Teams :: '.$name; $hmenu = 'Teams » '.$name; $design = new design ( $title , $hmenu ); $design->header(); $tpl = new tpl ('teams'); if (!empty($bild) ) { $show = '
'.$name.'
'; } else { $show = '
'.$name.'
'; } $tpl->set_out('show', $show,0); show_members ($gid,$tpl); } else { $title = $allgAr['title'].' :: Teams'; $hmenu = 'Teams'; $design = new design ( $title , $hmenu ); $design->header(); $tpl = new tpl ('teams'); $erg1 = db_query("SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos"); while ($row = db_fetch_assoc($erg1) ) { if (!empty($row['img']) ) { $row['show'] = ''.$row['name'].''; } else { $row['show'] = ''.$row['name'].''; } $tpl->set_ar_out($row,0); if ($allgAr['teams_show_cat'] == 0) { show_members ($row['gid'],$tpl); } } } $design->footer(0); ?>