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
<?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 = 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("SELECT
llogin,
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.name
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.llogin = prefix_grundrechte.id
$sql_search
ORDER 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
<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>
