Ich Habe mal eine Frage
Kann man die memberliste ändern das da eine suche mit bei ist wo man aus wellen kann
Namme
Mann
Frau
Alter von bis
Ort
Plz
wie kann man das machen kann mir einer helfen
memb_list.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 | <?php# Copyright by: Manuel# Support: www.ilch.dedefined ('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 = 39; // 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("SELECTllogin,prefix_user.id,prefix_grundrechte.name as recht_name,regist,prefix_user.gebdatum,prefix_user.avatar,prefix_user.plz, prefix_user.Ord, prefix_user.opt_pm,prefix_user.status,prefix_user.geschlecht, prefix_user.nameFROM prefix_userLEFT JOIN prefix_grundrechte ON prefix_user.llogin = prefix_grundrechte.id$sql_searchORDER by prefix_user.llogin 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 (file_exists($row->avatar)) { $avatar = '<img src="'.$row->avatar.'" height="85" width="75" alt="User '.$view->name.'" border="0" />'; } elseif ($row->avatar == "" && $row->geschlecht == "1") { $avatar = '<img src="include/images/avatars/male.jpg" height="85" width="75" alt="User '.$view->name.'" border="0" />'; } elseif ($row->avatar == "" && $row->geschlecht == "2") { $avatar = '<img src="include/images/avatars/female.jpg" height="85" width="75" alt="User '.$view->name.'" border="0" />'; } elseif ($row->avatar == "" && $row->geschlecht == "0") { $avatar = '<img src="include/images/avatars/xxx.gif" height="85" width="75" alt="User '.$view->name.'" border="0" />'; } if(!empty($row->Ord)){$row->Ord=''.$row->Ord.'';} else {$row->Ord='N/A';} if(!empty($row->plz)){$row->plz=''.$row->plz.'';} else {$row->plz='N/A';} if(!empty($row->opt_pm)){$row->opt_pm='<a href="index.php?forum-privmsg-new=0&empfid='.$row->id.'">PM Senden</a>';} else {$row->opt_pm='N/A';}$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); $abf1 = "SELECT * FROM prefix_online where uid = ".$row->id; $erg1 = db_query($abf1); $status = db_fetch_object($erg1); if ($status->uid == $row->id) { $row->online = ' <img src="include/images/icons/online.gif" border="0">'; } else { $row->online = ' <img src="include/images/icons/offline.gif" border="0">'; } if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $ar = array ( 'NAME' => $row->name, 'RANG' => userrang($row->posts,$row->id), 'AGE' => $age, 'AVATA' => $avatar, 'PLZ' => $row->plz, 'ORD' => $row->Ord, 'PN' => $row->opt_pm, 'ONLINE' => $row->online, 'LASTAK' => date('d M Y - H:i',$row->llogin), 'STATE' => $state[$row->status], 'CLASS' => $class, 'POSTS' => $row->posts, 'UID' => $row->id, 'GRUPE' => $row->recht_name ); $tpl->set_ar_out($ar,1);}$tpl->set_out('filtername',$filtername ? $filtername : '',2);$design->footer();?> |
memb_list.html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | <style type="text/css"><!--.style258 {font-size: 9px}--></style>{EXPLODE}<div style="float: left; padding: 5px;"><table bgcolor="#666666" width="211"> <tr> <td width="203" class="style258" ><div align="center"><a href="?user-details-{UID}">{ONLINE} {NAME} ({AGE})</a></div></td> </tr> <tr> <td class="style258"><div align="center"><a href="?user-details-{UID}">{AVATA}</a></div></td> </tr> <tr> <td><div align="center"><span class="style258">{PLZ} {ORD}</span></div></td> </tr> <tr> <td><div align="center"><span class="style258">{LASTAK}</span></div></td> </tr> <tr> <td class="style258"><div align="center"><a href="index.php?user-details-{UID}">Zum User Profil</a></div></td> </tr> <tr> <td class="style258"><div align="center">{PN}</div></td> </tr> <tr> <td class="style258"><div align="center"><a href="index.php?user-usergallery-{UID}">Zu User Gallery</a></div></td> </tr> <tr> <td class="style258"><div align="center"><a href="index.php?user-usergb-view-{UID}">Zum User Gästebuch</a></div></td> </tr> <tr> <td><div align="center"><span class="style258">{RANG} {STATE} </span></div></td> </tr> <tr> <td><div align="center"><span class="style258"></span></div></td> </tr></table></div>{EXPLODE}<table width="100%"> <tr> <td><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></td> </tr></table> |
