Hay Leute,
Wie kann ich das machen das unter Mitglieder die Anzahl steht ??
Habe das schonmal gehabt aber jetzt finde ich das nicht bei ilch.
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
db_num_rows(db_query("SELECT * FROM prefix_user"));
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de 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 = 99; // Limit $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 ); $MPL = db_make_sites ($page , "" , $limit , '?user' , 'user' ); $anfang = ($page - 1) * $limit; $tpl = new tpl ( 'user/memb_list.htm' ); $tpl->set_out ( 'SITELINK', $MPL, 0); $class = ''; $erg = db_query("SELECT id, staat, name, gebdatum, status, recht, posts, regist, geschlecht, cpoints, fwarn FROM prefix_user ORDER by recht,posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg)) { if($row->gebdatum=='0000-00-00'){$age='n/a'; } else {$age=getage($row->gebdatum); } if(!empty($row->staat)){ $flag='<img src="include/images/flags/'.$row->staat.'" border="0">'; } else { $flag=''; } $state['0']='inaktiv'; $state['1']='aktiv'; $state['2']='gesperrt'; $class='Cmite'; if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $rangcount=rangcount($row->id,$row->posts,$row->cpoints,$row->fwarn); $rang=userrang($rangcount,$row->id); $spezrank=spezrang($row->id); if(!empty($spezrank)){$rang=$rang.'<br/>und '.$spezrank;} $ar = array ( 'NAME' => getgender($row->name,$row->geschlecht).' ('.$age.')', 'RANG' => $rang, 'CLASS' => $class, 'POSTS' => $row->posts, 'UID' => $row->id, 'DATE' => date('d.m.Y',$row->regist), 'RECHT' => getlistrecht($row->recht), 'STATE' => $state[$row->status], 'FLAG' => $flag ); $tpl->set_ar_out($ar,1); } $tpl->out(2); $anzahl = db_num_rows(db_query("SELECT * FROM prefix_user")); $tpl->set_out ( 'ANZAHL', $anzahl, 3); $design->footer(); ?>
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de 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 = 99; // Limit $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 ); $MPL = db_make_sites ($page , "" , $limit , '?user' , 'user' ); $anfang = ($page - 1) * $limit; $tpl = new tpl ( 'user/memb_list.htm' ); $tpl->set_out ( 'SITELINK', $MPL, 0); $class = ''; $erg = db_query("SELECT id, staat, name, gebdatum, status, recht, posts, regist, geschlecht, cpoints, fwarn FROM prefix_user ORDER by recht,posts DESC LIMIT ".$anfang.",".$limit); $user = db_num_rows($erg); while ($row = db_fetch_object($erg)) { if($row->gebdatum=='0000-00-00'){$age='n/a'; } else {$age=getage($row->gebdatum); } if(!empty($row->staat)){ $flag='<img src="include/images/flags/'.$row->staat.'" border="0">'; } else { $flag=''; } $state['0']='inaktiv'; $state['1']='aktiv'; $state['2']='gesperrt'; $class='Cmite'; if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $rangcount=rangcount($row->id,$row->posts,$row->cpoints,$row->fwarn); $rang=userrang($rangcount,$row->id); $spezrank=spezrang($row->id); if(!empty($spezrank)){$rang=$rang.'<br/>und '.$spezrank;} $ar = array ( 'NAME' => getgender($row->name,$row->geschlecht).' ('.$age.')', 'RANG' => $rang, 'CLASS' => $class, 'POSTS' => $row->posts, 'UID' => $row->id, 'DATE' => date('d.m.Y',$row->regist), 'RECHT' => getlistrecht($row->recht), 'STATE' => $state[$row->status], 'FLAG' => $flag, 'USER' => $user ); $tpl->set_ar_out($ar,1); } $tpl->out(2); $design->footer(); ?>
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead" > <td width="5%">Land</td> <td height="15" width="20%">Name</td> <td align="center" width="10%">Status</td> <td align="center" width="15%">Rang</td> <td align="center" width="25%">Forenrang</td> <td width="10%" align="center">Beiträge</td> <td width="10%" align="center">Dabei seit</td> </tr>{EXPLODE} <tr class="{CLASS}"> <td align="center">{FLAG}</td> <td><a href="?user-details-{UID}"><b>{NAME}</b></a></td> <td align="center">{STATE}</td> <td align="center">{RECHT}</td> <td align="center"><font style="font-size: 10px">{RANG}</font></td> <td align="center">{POSTS}</td> <td align="center">{DATE}</td> </tr> </table> <br /> Registrierte Mitglieder: <b>{USER}</b> {EXPLODE} <div align="center">{SITELINK}</div>
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead" > <td width="5%">Land</td> <td height="15" width="20%">Name</td> <td align="center" width="10%">Status</td> <td align="center" width="15%">Rang</td> <td align="center" width="25%">Forenrang</td> <td width="10%" align="center">Beiträge</td> <td width="10%" align="center">Dabei seit</td> </tr>{EXPLODE} <tr class="{CLASS}"> <td align="center">{FLAG}</td> <td><a href="?user-details-{UID}"><b>{NAME}</b></a></td> <td align="center">{STATE}</td> <td align="center">{RECHT}</td> <td align="center"><font style="font-size: 10px">{RANG}</font></td> <td align="center">{POSTS}</td> <td align="center">{DATE}</td> </tr> {EXPLODE} </table> <br /> Registrierte Mitglieder: <b>{USER}</b> {EXPLODE} <div align="center">{SITELINK}</div>
<?php # Copyright by: Manuel # Support: www.ilch.de 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 = 20; // Limit $tpl = new tpl ( 'user/memb_list.htm' ); if($menu->exists('filtername')){ $page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 ); $filtername = escape($menu->get(2), 'string'); }else{ $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 ); } $anfang = ($page - 1) * $limit; $tpl = new tpl ( 'user/memb_list.htm' ); if(isset($_GET['filtername']) AND !empty($_GET['filtername'])){ $filtername = escape($_GET['filtername'], 'string'); } if(!empty($filtername)){ $sql_search=" WHERE prefix_user.name LIKE '%".$filtername."%'"; $MPL = db_make_sites ($page , $sql_search , $limit , '?user-filtername-'.$filtername , 'user' ); }else{ $sql_search=""; $MPL = db_make_sites ($page , "" , $limit , '?user' , 'user' ); } $tpl->set_out ( 'SITELINK', $MPL, 0); $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 $sql_search ORDER by recht,prefix_user.posts DESC 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); } $ANZ_user = db_num_rows(db_query("SELECT id FROM `prefix_user`")); $tpl->set_out('USERANZAHL', $ANZ_user, 3); $tpl->set_out('filtername',$filtername ? $filtername : '',2); $design->footer(); ?>
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead" > <th height="30" width="30%">{_lang_name}</th> <th align="center" width="20%">{_lang_rank}</th> <th align="center" width="20%">{_lang_group}</th> <th width="15%">{_lang_regtime}</th> <th width="15%" align="center">{_lang_posts}</th> </tr>{EXPLODE}<tr class="{CLASS}"> <td><a href="index.php?user-details-{UID}">{NAME}</a></td> <td align="center"><font style="font-size: 10px">{RANG}</font></td> <td align="center">{GRUPE}</td> <td>{DATE}</td> <td align="center">{POSTS}</td> </tr>{EXPLODE} </table> <div>Anzahl der Mitglieder: <b>{USERANZAHL}</b></div><br /> <br /> <div align="center">{SITELINK} <form method="GET" action="index.php"><input type="hidden" name="user" value="" /><input type="text" name="filtername" size="15" value="{filtername}" /> <input type="submit" value="{_lang_filter}" /></form> </div>
defined ('main') or die ( 'no direct access' );
$anz = @db_result(db_query("SELECT count(ID) FROM prefix_user WHERE recht > -10 AND recht < -2"),0);
<div style="text-align: center;">Registrierte Clanmitglieder: {anz} {SITELINK} </div>
Geschlossen | ||
Zurück zu Allgemein |