= (60 * 60 * 24 * 2)) { // if it's been more than 2 days
$days = mxValueToString(floor($realtime / (60 * 60 * 24)), 0);
$dont = true;
} else if ($realtime >= (60 * 60 * 24)) { // if it's been less than 2 days
$days = 1;
$realtime -= (60 * 60 * 24);
}
if (!$dont) {
// how many hours ago?
if ($realtime >= (60 * 60)) {
// $list .= " ($realtime) ";
$hours = floor($realtime / (60 * 60));
$realtime -= (60 * 60 * $hours);
}
// how many minutes ago?
if ($realtime >= 60) {
$mins = floor($realtime / 60);
$realtime -= (60 * $mins);
}
// just a little precation, although I don't *think* mins will ever be 60...
if ($mins == 60) {
$mins = 0;
$hours += 1;
}
}
$list .= "![\"\"](\"images/menu/rarrow.gif\")
" . urlencode($uname) . ": ";
if ($dont) {
$list .= "" . $days . " " . _LASTSEENDAYS . "";
} else {
if ($days > 0) {
$list .= "" . $days . " " . _LASTSEENDAY . "" . (($hours == 0 && $mins == 0)?(""):(","));
}
if ($hours > 0) {
$list .= "" . $hours . " " . (($hours > 1)?("" . _LASTSEENHOURS . ""):("" . _LASTSEENHOUR . "")) . (($mins == 0)?(""):(","));
}
if ($mins > 0) {
$list .= "" . $mins . " " . (($mins > 1)?("" . _LASTSEENMINUTES . ""):("" . _LASTSEENMINUTE . "")) . "";
} else { // less than a minute :)
$list .= "" . $realtime . " " . _LASTSEENSECONDS . "";
}
}
$list .= " " . _LASTSEENAGO . "
" . $list . "
";
}
//
$ucount = intval($ucount);
$qry="SELECT uname, user_regtime FROM ${user_prefix}_users WHERE user_stat=1 ORDER BY user_regtime DESC LIMIT ".$numusers.";";
$result = sql_query($qry); # x neuste User ermitteln
while (list($uname, $user_regtime) = sql_fetch_row($result)) {
$lasts[] = '
'.$uname.'';
}
if (isset($lasts)) {
$contentuser = implode("
\n",$lasts);
}
//
$numusers = 10;
// Hoehe des Scrollings, 0 um nicht zu scrollen
$hoehe = 70;
$scrolling = 0;
// #################################################################################################################
global $user_prefix, $prefix;
$thisfile = basename(__FILE__);
$mxblockcache = false;
// SQL-bedingung fuer excluded Users erstellen
if (!defined("mxYALoaded")) define("mxYALoaded", 1);
include("modules/Your_Account/config.php");
if (empty($useuserpoints) && !mxIsAdmin()) {
$content = "";
return;
}
$exusers = explode (",", $excludedusers);
if (!mxIsAdmin()) {
foreach ($exusers as $key => $value) {
$xexusers[] = trim($value);
}
}
$xexusers[] = $GLOBALS['anonymous'];
$xexusers[] = "Anonymous";
$excludedusers = "'" . implode("','", mxAddSlashesForSQL($xexusers)) . "'";
$qry = "
SELECT ${prefix}_userpoints.punkte, ${user_prefix}_users.uname
FROM ${prefix}_userpoints LEFT JOIN ${user_prefix}_users ON ${prefix}_userpoints.uid = ${user_prefix}_users.uid
WHERE ${user_prefix}_users.user_stat=1 AND ${prefix}_userpoints.punkte>0 AND (${user_prefix}_users.uname not in($excludedusers))
ORDER BY ${prefix}_userpoints.punkte DESC, ${prefix}_userpoints.uid
LIMIT 0,$numusers;";
$result = sql_query($qry);
$content1 = "";
$i = 0;
if ($result) {
while (list($punkte, $uname) = sql_fetch_row($result)) {
$i++;
$content1 .= " $uname: " . mxValueToString($punkte, 0) . " Puan
";
}
}
if (!empty($content1)) { // && $i >= $numusers
if ($scrolling) $content .= "\n";
$contentpoint .= $content1 . "\n";
if ($scrolling) $contentpoint .= "
";
}
//Göster
$content='
| Puanlar |
Yeni Üyeler |
Kim Buradaydý |
| '.$contentpoint.' |
'.$contentuser.' |
'.$contentlast.' |
';
?>