Ich habe jetzt das Internet, die Suche und diverse "Anfängermethoden" benutzt um zu einer Lösung zu kommen. Leider habe ich keine Lösung für das "Problem" gefunden.
Für mein ILCH-Script habe ich die geordnete Memberübersicht installiert:
externer Link
Wie ich nun festgestellt habe, bringt er jedoch hier irgendwas mit dem Alter durcheinander. Bei manchen steht das aktuelle Jahr hinter, bei anderen wird das Alter +1 angezeigt. Eine Lösung habe ich leider noch nicht gefunden.
Die memb_list.php habe ich jetzt schon diverse mal angesehen und editiert. Leider jedesmal "ohne" Erfolg. kann sich das vielleicht mal jemand ansehen und mir einen Tipp geben woran das liegen könnte?
Memberlist ist hier zu finden: externer Link
Die memb_list.php sieht folgendermaßen aus:
<?php # Copyright by: David Schwarz # Support: www.baduncles.pytalhost.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); $design->header(); $limit = 20; // 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 = ''; $erg92 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -9"); while ($row = db_fetch_object($erg92)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar92 = array('GRUPP9' => $picr,); }else{$ar92 = array('GRUPP9' => '',); } $tpl->set_ar_out($ar92,1); } $erg91 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -9"); while ($row = db_fetch_object($erg91)) { if ($row->zeigen == yes) {$ar91 = array('9LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar91 = array('9LIST' => '',); } $tpl->set_ar_out($ar91,2); } $erg9 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -9 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg9)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar9 = array('9USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar9 = array('9USER' => '', ); } $tpl->set_ar_out($ar9,3); } $erg82 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -8"); while ($row = db_fetch_object($erg82)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar82 = array('GRUPP8' => $picr,); }else{$ar82 = array('GRUPP8' => '',); } $tpl->set_ar_out($ar82,4); } $erg81 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -8"); while ($row = db_fetch_object($erg81)) { if ($row->zeigen == yes) {$ar81 = array('8LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar81 = array('8LIST' => '',); } $tpl->set_ar_out($ar81,5); } $erg8 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -8 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg8)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar8 = array('8USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar8 = array('8USER' => '', ); } $tpl->set_ar_out($ar8,6); } $erg72 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -7"); while ($row = db_fetch_object($erg72)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar72 = array('GRUPP7' => $picr,); }else{$ar72 = array('GRUPP7' => '',); } $tpl->set_ar_out($ar72,7); } $erg71 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -7"); while ($row = db_fetch_object($erg71)) { if ($row->zeigen == yes) {$ar71 = array('7LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar71 = array('7LIST' => '',); } $tpl->set_ar_out($ar71,8); } $erg7 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -7 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg7)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar7 = array('7USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar7 = array('7USER' => '', ); } $tpl->set_ar_out($ar7,9); } $erg62 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -6"); while ($row = db_fetch_object($erg62)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar62 = array('GRUPP6' => $picr,); }else{$ar62 = array('GRUPP6' => '',); } $tpl->set_ar_out($ar62,10); } $erg61 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -6"); while ($row = db_fetch_object($erg61)) { if ($row->zeigen == yes) {$ar61 = array('6LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar61 = array('6LIST' => '',); } $tpl->set_ar_out($ar61,11); } $erg6 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -6 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg6)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar6 = array('6USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar6 = array('6USER' => '', ); } $tpl->set_ar_out($ar6,12); } $erg52 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -5"); while ($row = db_fetch_object($erg52)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar52 = array('GRUPP5' => $picr,); }else{$ar52 = array('GRUPP5' => '',); } $tpl->set_ar_out($ar52,13); } $erg51 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -5"); while ($row = db_fetch_object($erg51)) { if ($row->zeigen == yes) {$ar51 = array('5LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar51 = array('5LIST' => '',); } $tpl->set_ar_out($ar51,14); } $erg5 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -5 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg5)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar5 = array('5USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar5 = array('5USER' => '', ); } $tpl->set_ar_out($ar5,15); } $erg42 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -4"); while ($row = db_fetch_object($erg42)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar42 = array('GRUPP4' => $picr,); }else{$ar42 = array('GRUPP4' => '',); } $tpl->set_ar_out($ar42,16); } $erg41 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -4"); while ($row = db_fetch_object($erg41)) { if ($row->zeigen == yes) {$ar41 = array('4LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar41 = array('4LIST' => '',); } $tpl->set_ar_out($ar41,17); } $erg4 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -4 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg4)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar4 = array('4USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar4 = array('4USER' => '', ); } $tpl->set_ar_out($ar4,18); } $erg32 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -3"); while ($row = db_fetch_object($erg32)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar32 = array('GRUPP3' => $picr,); }else{$ar32 = array('GRUPP3' => '',); } $tpl->set_ar_out($ar32,19); } $erg31 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -3"); while ($row = db_fetch_object($erg31)) { if ($row->zeigen == yes) {$ar31 = array('3LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar31 = array('3LIST' => '',); } $tpl->set_ar_out($ar31,20); } $erg3 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -3 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg3)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar3 = array('3USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar3 = array('3USER' => '', ); } $tpl->set_ar_out($ar3,21); } $erg22 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -2"); while ($row = db_fetch_object($erg22)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar22 = array('GRUPP2' => $picr,); }else{$ar22 = array('GRUPP2' => '',); } $tpl->set_ar_out($ar22,22); } $erg21 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -2"); while ($row = db_fetch_object($erg21)) { if ($row->zeigen == yes) {$ar21 = array('2LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar21 = array('2LIST' => '',); } $tpl->set_ar_out($ar21,23); } $erg2 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -2 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg2)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar2 = array('2USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar2 = array('2USER' => '', ); } $tpl->set_ar_out($ar2,24); } $erg12 = db_query("SELECT id,name,zeigen FROM prefix_grundrechte WHERE id = -1"); while ($row = db_fetch_object($erg12)) { $pgif = 'include/images/rangs/'.$row->name.'.gif'; $pjpg = 'include/images/rangs/'.$row->name.'.jpg'; $picr = (file_exists($pgif)?'<img src="'.$pgif.'">':(file_exists($pjpg)?'<img src="'.$pjpg.'">':$row->name)); if ($row->zeigen == yes) {$ar12 = array('GRUPP1' => $picr,); }else{$ar12 = array('GRUPP1' => '',); } $tpl->set_ar_out($ar12,25); } $erg11 = db_query("SELECT id,zeigen FROM prefix_grundrechte WHERE id = -1"); while ($row = db_fetch_object($erg11)) { if ($row->zeigen == yes) {$ar11 = array('1LIST' => '<th height="30" width="30%">Name</th> <th align="center" width="17%">ForumRang</th> <th align="center" width="17%">Dabei seit</th> <th align="center" width="20%">ICQ</th> <th align="center" width="16%" align="center">Beiträge</th> </tr>'); }else{$ar11 = array('1LIST' => '',); } $tpl->set_ar_out($ar11,26); } $erg1 = db_query("SELECT prefix_grundrechte.zeigen as recht_zeigen,prefix_user.posts,prefix_user.id,prefix_user.regist,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 WHERE prefix_user.recht = -1 ORDER by prefix_user.regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit); while ($row = db_fetch_object($erg1)) { $icq1 = str_replace("-","",$row->icq); $icq2 = str_replace(" ","",$icq1); if (is_numeric($icq2)) {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>'; } $ga = ''; $age1=explode("-",$row->gebdatum); $age = date("Y",time())-$age1[0]; 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 ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } if($row->recht_zeigen == yes) {$ar1 = array('1USER' => '<tr class="'.$class.'"> <td><a href="index.php?user-details-'.$row->id.'">'.$row->name.'</a> '.$ga.'</td> <td align="center"><font style="font-size: 10px">'.userrang($row->posts,$row->id).'</font></td> <td align="center">'.date('d.m.Y',$row->regist).'</td><td align="center">'.$icq.'</td> <td align="center">'.$row->posts.'</td> </tr>', ); }else {$ar1 = array('1USER' => '', ); } $tpl->set_ar_out($ar1,27); } $tpl->out(28); $design->footer(); ?>
verwendete ilchClan Version: 1.1
betroffene Homepage: externer Link
Zuletzt modifiziert von Guardy am 21.07.2008 - 22:35:42