Und zwar hab ich schon versucht die ganze zeit an unten stehender php rumzuwerkeln aber ich hab da null plan von.
Ich möchte gerne eine Abfrage an die Datenbank stellen, ob der User sich selbst auf Aktiv oder Inaktiv gestellt hat und das dann in der Memberlist ausgeben.
Ich post mal meine memb_list.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();
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){
$name = '<a href="?user-name-desc">'.$lang['name'].'</a>';
}else{
$name = '<a href="?user-name-asc">'.$lang['name'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){
$rang = '<a href="?user-spezrank-desc">'.$lang['rank'].'</a>';
}else{
$rang = '<a href="?user-spezrank-asc">'.$lang['rank'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$gruppe = '<a href="?user-recht1-desc">'.$lang['group'].'</a>';
}else{
$gruppe = '<a href="?user-recht1-asc">'.$lang['group'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$reg = '<a href="?user-regist1-desc">Dabei seit</a>';
}else{
$reg = '<a href="?user-regist1-asc">Dabei seit</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$icq = '<a href="?user-icq-asc">'.$lang['icq'].'</a>';
}else{
$icq = '<a href="?user-icq-desc">'.$lang['icq'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$a = '<a href="?user-e-desc">Posts</a>';
}else{
$a = '<a href="?user-e-asc">Posts</a>';
}
$rei = escape($menu->get(1), 'textarea');
$nach =escape($menu->get(2), 'textarea');
$anz = @db_result(db_query("SELECT count(ID) FROM prefix_user"),0);
$limit = 50; // Limit
$page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 );
$MPL = db_make_sites ($page , "" , $limit , '?user-'.$rei.'-'.$nach.'' , '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,
'anz' =>$anz,
'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
llogin,
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 ORDER by $sort $aufab
LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg)) {
$abf1 = "SELECT * FROM prefix_online WHERE uid = '".$row->id."'";
$erg1 = db_query($abf1);
$row1 = db_fetch_assoc($erg1);
if(isset($row1['uid'])){
$online = '<img src="include/images/icons/on1.png" alt="online" border="0"/>';
}else{
$online = '<img src="include/images/icons/off2.png" alt="offline" border="0" />';
}
$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=5" border="0"></a>';
}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.='<img src="include/images/icons/user.png" border="0"> - '.$age.'';
}else{
$ga.='<img src="include/images/icons/user.png" border="0"> - 00';
}
}
elseif ($row->geschlecht == 2){
if ($row->gebdatum != 0000-00-00 ){
$ga.='<img src="include/images/icons/user_female.png" border="0"> - '.$age.'';
}else{
$ga.='<img src="include/images/icons/user_female.png" border="0"> - 00';
}
}
if ($row->staat){
$flagg = '<img src="include/images/flags/'.$row->staat.'" alt="" border="0"> ';
}else{
$flagg = '';
}
$anzna = round((time()-$row->llogin)/(24*60*60),0);
if ($anzna < 9) {
$aktiv = ' <font color="#008000"> •</font> ';
}elseif ($anzna < 20) {
$aktiv = '<font color="#C60000"> •</font> ';
} else {
$aktiv = ' <font color="#C60000"> •</font> ';
}
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'NAME' => $row->name,
'RANG' => userrang($row->posts,$row->id),
'AKTIV' => $aktiv,
'FLAGG' => $flagg,
'ICQ' => $icq,
'GA' => $ga,
'CLASS' => $class,
'POSTS' => $row->posts,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'ONLINE' => $online,
'GRUPE' => $row->recht_name
);
$tpl->set_ar_out($ar,1);
}
$tpl->out(2);
$design->footer();
?>
Vielen Dank
