Endgültig fertige Version!
memb_list.php
<?php
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: User :: '.$lang['listofmembers'];
$hmenu = $extented_forum_menu.'User <b> » </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$limit = 30; // Limit
$mema = @db_result(db_query("SELECT COUNT(id) FROM prefix_user WHERE recht < -2 AND status = 1"),0);
$memi = @db_result(db_query("SELECT COUNT(id) FROM prefix_user WHERE recht < -2 AND status = 0"),0);
$user = @db_result(db_query("SELECT COUNT(id) FROM prefix_user WHERE recht > -2"),0);
$emem = @db_result(db_query("SELECT COUNT(id) FROM prefix_user WHERE recht = -2"),0);
$var = array($mema => 'WHERE recht < -2 AND status = 1',
$memi => 'WHERE recht < -2 AND status = 0',
$user => 'WHERE recht > -2' ,
$emem => 'WHERE recht = -2',);
$max = $var[max($mema,$memi,$user,$emem)];
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , $max , $limit , '?user' , 'user' );
$anfang = ($page - 1) * $limit;
$tpl = new tpl ( 'user/memb_list.htm' );
$tpl->set_out ( 'SITELINK', $MPL, 0);
if ( $anfang < $mema) echo '<tr><td colspan="5" align="left">Clanmitglieder (aktiv)</td></tr>';
$class = '';
$erg = db_query("SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht < -2 AND status = 1 ORDER by recht,prefix_user.posts ASC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'NAME' => $row->name,'RANG' => userrang($row->posts,$row->id),'CLASS' => $class,'POSTS' => $row->posts,'UID' => $row->id,'DATE' => date('d.m.Y',$row->regist),'GRUPE' => $row->recht_name,);
$tpl->set_ar_out($ar,1);
}
if ( $anfang < $memi) echo '<tr><td colspan="5" align="left">Clanmitglieder (inaktiv)</td></tr>';
$class = '';
$erg2 = db_query("SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht < -2 AND status = 0 ORDER by recht,prefix_user.posts ASC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg2)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'INAME' => $row->name,'IRANG' => userrang($row->posts,$row->id),'ICLASS' => $class,'IPOSTS' => $row->posts,'IUID' => $row->id,'IDATE' => date('d.m.Y',$row->regist),'IGRUPE' => $row->recht_name,);
$tpl->set_ar_out($ar,2);
}
if ( $anfang < $user)echo '<tr><td colspan="5" align="left">User</td></tr>';
$class = '';
$erg5 = db_query("SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht > -2 ORDER by recht,prefix_user.posts ASC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg5)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'UNAME' => $row->name,'URANG' => userrang($row->posts,$row->id),'UCLASS' => $class,'UPOSTS' => $row->posts,'UUID' => $row->id,'UDATE' => date('d.m.Y',$row->regist),'UGRUPE' => $row->recht_name,);
$tpl->set_ar_out($ar,3);
}
if ( $anfang < $emem) echo '<tr><td colspan="5" align="left">Ehrennmitglieder</td></tr>';
$class = '';
$erg3 = db_query("SELECT posts,prefix_user.id,prefix_grundrechte.name as recht_name,regist, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id WHERE prefix_user.recht = -2 ORDER by recht,prefix_user.posts ASC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg3)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'ENAME' => $row->name,'ERANG' => userrang($row->posts,$row->id),'ECLASS' => $class,'EPOSTS' => $row->posts,'EUID' => $row->id,'EDATE' => date('d.m.Y',$row->regist),'EGRUPE' => $row->recht_name,);
$tpl->set_ar_out($ar,4);
}
$tpl->out(5);
$design->footer();
?>
memb_list.htm bleibt so!
*EDIT: verbessert
Zuletzt modifiziert von boehserdavid am 09.07.2007 - 18:54:37
