Bis jetzt sortiert er die Ränge ja alphabetisch.
Wie kann ich das ändern?
Hier der Code:
<?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();
?>
