Da ich jetzt immernoch voll überfragt bin damit , bitte ich jetzt einfach mal um hilfe , könnte mir das jemand funktionstüchtig in meine meberliste eintragen ?
memblist.htm
<table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolor="#333333" bgcolor="#000000" class="border">
<tr class="Chead">
<th width="4%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#333333" class="Stil8"><span class="Stil6"><span class="Stil15">L</span><span class="Stil16">and</span></span></th>
<th width="2%" height="30" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil6"><span class="Stil15">C</span><span class="Stil16">lan</span></span></th>
<th width="2%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">S</span><span class="Stil16">ex</span></th>
<th width="26%" height="30" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">N</span><span class="Stil16">ame</span></th>
<th width="7%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">R</span><span class="Stil16">ang</span></th>
<th width="5%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">D</span><span class="Stil16">abei seit</span></th>
<th width="9%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">L</span><span class="Stil16">etzter</span> <span class="Stil15">L</span><span class="Stil16">ogin</span></th>
<th width="5%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil9"><span class="Stil15">S</span><span class="Stil16">tatus</span></th>
<th width="7%" align="center" background="/include/images/profil/icon_back2.jpg" bgcolor="#000000" class="Stil8"><span class="Stil15">P</span><span class="Stil16">M</span></th>
</tr>
{EXPLODE}
<tr class="{CLASS}"> </tr>
<tr class="{CLASS}">
<th width="4%" height="13" align="center" valign="middle" background="/include/images/profil/icon_back.jpg" bgcolor="#333333" class="Stil4"><img src="include/images/flags/{STAAT}" alt="" width="20" height="15" border="0" /></th>
<td height="13" align="center" valign="middle" background="/include/images/profil/icon_back.jpg" bgcolor="#333333" class="Stil4"><img src="include/images/clans/{CLAN}" border="0" /></td>
<td height="13" align="center" valign="middle" background="/include/images/profil/icon_back.jpg" bgcolor="#333333" class="Stil4">{GESCHLECHT}</td>
<td align="left" valign="middle" background="/include/images/profil/icon_back.jpg" bgcolor="#333333" border="0px">
<a href="index.php?user-details-{UID}" class="Stil2 Stil6"> {NAME}</a></td>
<td width="7%" height="13" align="center" valign="middle" background="/include/images/profil/icon_back2.jpg" bgcolor="#2D2D2D" class="Stil4">{RANG}</td>
<td width="5%" height="13" align="center" valign="middle" background="/include/images/profil/icon_back2.jpg" bgcolor="#2D2D2D" class="Stil13">{DATE}</td>
<td width="9%" height="13" align="center" valign="middle" bordercolor="#030303" background="/include/images/profil/icon_back2.jpg" bgcolor="#FF9933" class="Stil4 Stil5 Stil12">{LLOGIN}</td>
<td width="5%" height="13" align="center" valign="top" background="/include/images/profil/icon_back2.jpg" bgcolor="#181818" class="Stil4"><img src="include/images/lvl/{GRUPE}.gif" alt="" height="20" border="0" /> </td>
<td width="7%" height="13" align="center" valign="top" background="/include/images/profil/icon_back2.jpg" bgcolor="#181818" class="Stil4"><a href="index.php?forum-privmsg-new-0&empfid={UID}"><img src="http://www.okularrulz.net/include/images/icons/pm.gif" alt="pm" height="20" border="0" /></a></td>
</tr>
{EXPLODE}
<tr class="{CLASS}"></tr>
</table>
<span class="Stil4"><br />
</span>
<div align="center" class="Stil4"><span class="Stil6">{SITELINK}
</span>
<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>
memblist.php
<?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> » </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$limit = 100; // 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);
$filtername = isset($_GET['filtername']) ? "WHERE prefix_user.name LIKE '%".escape($_GET['filtername'],'string')."%'" : "";
$class = '';
$erg = db_query("SELECT
posts,
icq,
staat,
clan,
email,
llogin,
geschlecht,
prefix_user.id,
prefix_grundrechte.name as recht_name,
regist,
prefix_user.name
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id
$filtername
ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
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($row->geschlecht == 0)
$geschlecht = '<img height="20" width="20" src="include/images/icons/na.gif" alt="n/a" border="0"/>';
elseif($row->geschlecht == 1)
$geschlecht = '<img height="20" width="20" src="include/images/icons/mann.gif" alt="männlich" border="0"/>';
else
$geschlecht = '<img height="20" width="20" src="include/images/icons/frau.gif" alt="weiblich" border="0"/>';
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,
'GESCHLECHT' => $geschlecht,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'GRUPE' => $row->recht_name,
'STAAT' => $row->staat,
'CLAN' => $row->clan,
'EMAIL' => $row->email,
'LLOGIN' => date('d.m.Y <b\r> H:i',$row->llogin).' Uhr'
);
$tpl->set_ar_out($ar,1);
}
#Status abfragen
function getstate($value,$id){
$state['0']='inaktiv';
$state['1']='aktiv';
$state['2']='gesperrt';
$state['3']='ausgetreten';
$ergResul=@db_result(db_query('SELECT COUNT(`uid`) FROM `prefix_awaycal` WHERE uid = "'.$id.'" AND von<="'.date('Y-m-d').'" AND bis>="'.date('Y-m-d').'"'),0);
if($ergResul>=1){
$allowed=@db_result(db_query('SELECT pruef FROM `prefix_awaycal` WHERE uid = "'.$id.'" AND von<="'.date('Y-m-d').'" AND bis>="'.date('Y-m-d').'"'),0);
if($allowed==1){
$away='<br><a href="index.php?awaycal" style="color:#FF0000;">Away</a>';
} elseif($allowed==2){
$away='<br><a href="index.php?awaycal" style="color:#FF7F00;">Away</a>';
} elseif($allowed==3){
$away='<br><a href="index.php?awaycal" style="color:#00FF00;">Away</a>';
}
} else {
$away='';
}
$aus=$state[$value].$away;
return $aus;
}
$tpl->set_out('filtername',escape(isset($_GET['filtername'])?$_GET['filtername']:'','string'),2);
$design->footer();
?>