ilch.de :: Forum :: Ilch Clan 1.1 :: Allgemein :: Limit festlegen in der Userliste?

Das wär die jetzige:
<?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> &raquo; </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$tpl = new tpl ( 'omember.htm' );
# für die geordnete memberliste gibts keine sites!

$limit = 20;  // Limit 
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , "" , $limit , '?omember' , 'user' );
$anfang = ($page - 1) * $limit;


$tpl->set_out ( 'SITELINK', $MPL, 0);

$filtername = isset($_GET['filtername']) ? " AND prefix_user.name LIKE '%".escape($_GET['filtername'],'string')."%'" : "";

$tpl->out(0);
# alle anzuzeigenden rechte holen:
$qry = db_query('SELECT `id`, `name` FROM `prefix_grundrechte` WHERE `show` = 1 ORDER BY `id` ASC');
while ($gr = db_fetch_assoc($qry)) {
$erg = db_query("SELECT
  posts,
  icq,
  staat,
  email,
  llogin,
  prefix_user.id,
  prefix_grundrechte.name as recht_name,
  regist,
  prefix_user.name,
  recht
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id
WHERE recht = ".$gr['id'].$filtername."
ORDER by prefix_user.posts DESC LIMIT ".$anfang.",".$limit);

# wenn die gruppe leer ist, wird sie automatisch ausgeblendet:
if(db_num_rows($erg)==0) continue;
$tpl->set('group_id', $gr['id']);
$tpl->set('group_name', $gr['name']);
$tpl->out(1);

$class = '';
while ($row = db_fetch_object($erg)) {
if($row->icq == ""){ 
	$icq = "";
	} else {
	$icq = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".str_replace("-","",$row->icq)."\" target=\"_blank\"><img src=\"http://status.icq.com/online.gif?web=".str_replace("-","",$row->icq)."&img=5\" border=\"0\"></a>";
	}
	if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
	$ar = array ( 'NAME' => $row->name,
	                'RANG' => userrang($row->posts,$row->id),
									'CLASS' => $class,
									'POSTS' => $row->posts,
									'ICQ' => $icq,
									'UID'   => $row->id,
									'DATE' => date('d.m.Y',$row->regist),
									'GRUPE' => $row->recht_name,
									'STAAT' => ($row->staat!="" ? $row->staat : "na.gif"),
									'EMAIL' => $row->email,
									'LLOGIN' => date('d.m.Y <b\r> H:i',$row->llogin).' Uhr'
	);
	$tpl->set_ar_out($ar,2);
}
}
$tpl->set_out('filtername',escape(isset($_GET['filtername'])?$_GET['filtername']:'','string'),3);



$design->footer();
?>
Geschlossen		Seite 2 von 2 ‹12›

	Zurück zu Allgemein
Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Allgemein » Limit festlegen in der Userliste?
