» '.$lang['listofmembers'].$extented_forum_menu_sufix; $design = new design ( $title , $hmenu, 1 ); $design->header(); if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){ $name = ''.$lang['name'].''; }else{ $name = ''.$lang['name'].''; } if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){ $rang = ''.$lang['rank'].''; }else{ $rang = ''.$lang['rank'].''; } if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){ $gruppe = ''.$lang['group'].''; }else{ $gruppe = ''.$lang['group'].''; } if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){ $reg = ''.$lang['regtime'].''; }else{ $reg = ''.$lang['regtime'].''; } if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){ $icq = ''.$lang['icq'].''; }else{ $icq = ''.$lang['icq'].''; } if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){ $a = ''.$lang['posts'].''; }else{ $a = ''.$lang['posts'].''; } $limit = 20; // Limit $page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 ); $MPL = db_make_sites ($page , "" , $limit , '?user-name-asc' , 'user' ); $anfang = ($page - 1) * $limit; $tpl = new tpl ( 'user/memb_list.htm' ); $ar = array ( 'oname' => $name, 'orank' => $rang, 'ogroup' => $gruppe, 'oicq' => $icq, 'oposts' => $a, 'oregtime' => $reg, 'SITELINK' => $MPL ); $tpl->set_ar_out($ar,0); $aufab = ( $menu->get(2) ? escape($menu->get(2), 'textarea') : desc ); $sort1 = ( $menu->get(1) ? escape($menu->get(1), 'textarea') : "recht , posts" ); if ($sort1 == 'recht1'){ $sort2 = 'recht'; }else{ $sort2 = $sort1; } if ($sort2 == 'regist1'){ $sort3 = 'regist'; }else{ $sort3 = $sort2; } if ($sort3 == 'e'){ $sort = 'posts'; }else{ $sort = $sort3; } $class = ''; $erg = db_query("SELECT IF(c.uptime > '$dif','online','offline') as status, prefix_user.posts, prefix_user.id, prefix_grundrechte.name as recht_name, regist, prefix_user.staat, prefix_user.icq, prefix_user.geschlecht, prefix_user.gebdatum, prefix_user.name FROM prefix_user LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id LEFT JOIN `prefix_online` c ON `prefix_user`.id = c.uid AND c.sid = (SELECT sid FROM `prefix_online` WHERE uid = `prefix_user`.id ORDER BY uptime DESC LIMIT 1) ORDER by $sort $aufab LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2) ){ $icq= ''; }else{ $icq = ''; } $ga = ''; $t1 = 0; $t2 = 0; $t3 = 0; $age1=explode("-",$row->gebdatum); $age2 = date("Y",time())-$age1[0]; $a=explode("-",$row->gebdatum); $tag = $a[2]; $mon = $a[1]; $jah = $a[0]; if ($mon > date("m")){$t1 = 2;} if ($mon == date("m")){$t1 = 1;} if ($tag > date("d")){$t2 = 1;} $t3 = ($t1 + $t2); if ($t3 > 1){ $age = ($age2 -1); }else{ $age = $age2; } if ($row->geschlecht == 0){ if ($row->gebdatum != 0000-00-00 ){ $ga.= $age; }else{ $ga.= ''; } } elseif ($row->geschlecht == 1){ if ($row->gebdatum != 0000-00-00 ){ $ga.=' - '.$age.''; }else{ $ga.=''; } } elseif ($row->geschlecht == 2){ if ($row->gebdatum != 0000-00-00 ){ $ga.=' - '.$age.''; }else{ $ga.=''; } } if ($row->staat){ $flagg = ''; }else{ $flagg = ''; } if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $ar = array ( 'NAME' => $row->name, 'RANG' => userrang($row->posts,$row->id), 'FLAGG' => $flagg, 'ICQ' => $icq, 'GA' => $ga, 'CLASS' => $class, 'POSTS' => $row->posts, 'UID' => $row->id, 'DATE' => date('d.m.Y',$row->regist), 'ONLINE' => $row->status, 'GRUPE' => $row->recht_name, ); $tpl->set_ar_out($ar,1); } $tpl->out(2); $design->footer(); ?>