";
echo "";
$result = dbquery("
SELECT * FROM ".$db_prefix."threads
INNER JOIN ".$db_prefix."forums ON ".$db_prefix."threads.forum_id=".$db_prefix."forums.forum_id
WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 9
");
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 23);
echo " $itemsubject \n";
}
} else {
echo "Brak Postów";
}
echo " | ";
echo " | ";
echo "";
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,9");
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
$lastseen = time() - $data['user_lastvisit'];
$iW=sprintf("%2d",floor($lastseen/604800));
$iD=sprintf("%2d",floor($lastseen/(60*60*24)));
$iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));
$iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));
$iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));
if ($lastseen < 60){
$lastseen= "Online";
} elseif ($lastseen < 360){
$lastseen= "Offline";
} elseif ($iW > 0){
if ($iW == 1) { $text = "Weekend"; } else { $text = "Weekendy"; }
$lastseen = $iW." ".$text;
} elseif ($iD > 0){
if ($iD == 1) { $text = "Dzień"; } else { $text = "Dni"; }
$lastseen = $iD." ".$text;
} else {
$lastseen = $iH.":".$iM.":".$iS;
}
echo "";
echo " | ";
echo "
";
echo "";
echo "