danke für die schnelle antwort mairu,
hab's so eingegeben wie du's gepostet hast aber nun bekomm ich in der entsprechenden spalte das jahr 2009 angezeigt. hier kannst du's sehen:
externer Link
ich poste mal sicherheitshalber meine memb_list.php, nicht dass ich doch zu unfähig war und es falsch eingesetzt hatte.
<?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 = 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);
$filtername = isset($_GET['filtername']) ? "WHERE prefix_user.name LIKE '%".escape($_GET['filtername'],'string')."%'" : "";
$class = '';
$erg = db_query("SELECT
posts,
icq,
staat,
email,
llogin,
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 ($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,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'GRUPE' => $row->recht_name,
'STAAT' => $row->staat,
'EMAIL' => $row->email,
'LLOGIN' => date('d.m.Y <b\r> H:i',$row->llogin).' Uhr'
);
list($y,$m,$d) = explode('-',$r['gebdatum']);
$alter = date('Y') - $y;
if (mktime(0,0,0) > mktime(0,0,0,$m,$d)) $alter--;
$ar['AGE'] = $alter;
$tpl->set_ar_out($ar,1);
}
$tpl->set_out('filtername',escape(isset($_GET['filtername'])?$_GET['filtername']:'','string'),2);
$design->footer();
?>
Bombing For Peace Is Like Fu**ing For Virginity !!!
