Bis jetzt sortiert er die Ränge ja alphabetisch.
Wie kann ich das ändern?
Hier der Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | <?php # Copyright by: Manuel # Support: www.ilch.de defined (\'main\') or die ( \'no direct access\' ); $title = $allgAr[\'title\'].\' :: Teams\'; $hmenu = \'Members\'; $design = new design ( $title , $hmenu ); $design->header(); $tpl = new tpl ( \'teams\' ); $tpl->out(0); $erg1 = db_query(\"SELECT a.name,b.img,gid FROM prefix_teams b LEFT JOIN prefix_groups a ON b.gid = a.id ORDER BY b.pos\"); while ($row1 = db_fetch_assoc($erg1) ) { if ( !empty($row1[\'img\']) ) { $row1[\'show\'] = \'<img src=\"\'.$row1[\'img\'].\'\" title=\"\'.$row1[\'name\'].\'\" alt=\"\'.$row1[\'name\'].\'\"><br /><b>\'.$row1[\'name\'].\'</b>\'; } else { $row1[\'show\'] = \'<b>\'.$row1[\'name\'].\'</b>\'; } $tpl->set_ar_out($row1,1); $class = \'Cnorm\'; $q = \"SELECT uid, a.name, c.name as pos FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_userfuncs c ON b.fid = c.id WHERE b.gid = \".$row1[\'gid\'].\" ORDER BY c.pos ASC\"; $erg = db_query($q); while($row = db_fetch_assoc($erg) ) { $class = ( $class == \'Cmite\' ? \'Cnorm\' : \'Cmite\' ); $row[\'class\'] = $class; $row[\'flag\'] = @db_result(db_query(\"SELECT val FROM prefix_userfields WHERE uid = \".$row[\'uid\'].\" AND fid = 10\"),0); if ( $row[\'flag\'] != \'\' ) { $row[\'flag\'] = \'<img src=\"include/images/flags/\'.$row[\'flag\'].\'\" alt=\"\" border=\"0\">\'; } $row[\'status\'] = ( db_count_query(\"SELECT COUNT(uid) FROM prefix_userfields WHERE uid = \".$row[\'uid\'].\" AND fid = 11 AND val = 1\") == 0 ? \'inaktiv\' : \'aktiv\' ); $tpl->set_ar_out($row,2); } } $tpl->out(3); $design->footer(); ?> |
