Diskuse

Zdravím,
chci se zeptat, jak dát při vyvolání HCM modulu "Naposledy registrovaní uživatelé" datum registrace a při "Naposledy aktivní" čas poslední aktivity. Zde je kód:
//users
case "users":
if(count($paramarray)>=2){

$rtype=$paramarray[1];
if(isset($paramarray[2])){$rlimit=abs(intval($paramarray[2]));}else{$rlimit=5;}
if(isset($paramarray[3])){$rnamecut=intval($paramarray[3]);}else{$rnamecut=false;}

$rcond="";
switch($rtype){
case 2: $rorder="activitytime DESC"; $rcond=" WHERE ".time()."-activitytime<600"; break;
case 3: $rorder="(SELECT COUNT(id) FROM `"._mysql_prefix."-posts` WHERE author=`sunlight-users`.id) DESC"; break;
case 4: $rcond=" WHERE (SELECT COUNT(id) FROM `"._mysql_prefix."-articles` WHERE author=`"._mysql_prefix."-users`.id AND rateon=1 AND ratenum!=0)!=0"; $rorder="(SELECT ROUND(SUM(ratesum)/SUM(ratenum)) FROM `"._mysql_prefix."-articles` WHERE rateon=1 AND ratenum!=0 AND author=`"._mysql_prefix."-users`.id) DESC"; break;
default: $rorder="id DESC"; break;
}

if($rtype!=4){$mresult="<ol>\n";}else{$mresult="<ol>\n";}
$query=mysql_query("SELECT id FROM `"._mysql_prefix."-users`".$rcond." ORDER BY ".$rorder." LIMIT ".$rlimit);
while($item=mysql_fetch_array($query)){

//pridani doplnujicich informaci
switch($rtype){

//pocet prispevku
case 3:
$rvar=mysql_result(mysql_query("SELECT COUNT(id) FROM `"._mysql_prefix."-posts` WHERE author=".$item['id']), 0);
if($rvar==0){continue;}else{$rext=" (".$rvar.")";}
break;

//hodnoceni autora
case 4:
$rvar=mysql_fetch_array(mysql_query("SELECT ROUND(SUM(ratesum)/SUM(ratenum)),COUNT(id) FROM `"._mysql_prefix."-articles` WHERE rateon=1 AND ratenum!=0 AND author=".$item['id']));
$rext=" - ".$rvar[0]."%, ".$_lang['global.articlesnum'].": ".$rvar[1];
break;

//nic
default:
$rext="";
break;

}

$mresult.="<li>"._linkUser($item['id'], null, false, false, $rnamecut).$rext."</li>\n";
}
if($rtype!=4){$mresult.="</ul>\n";}else{$mresult.="</ol>\n";}

}
break;
Několikrát jsem to zkoušel, ale neúspšně.