query("SELECT user FROM ".$xoopsDB->prefix("botcheck")); list($guest_online_num) = $xoopsDB->fetchRow($result); $result = $xoopsDB->query("SELECT bot FROM ".$xoopsDB->prefix("botcheck")); list($bots_online_num) = $xoopsDB->fetchRow($result); $result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("lastseen")." WHERE uid>0 AND online=1"); list($member_online_num) = $xoopsDB->fetchRow($result); $who_online_num = $bots_online_num + $guest_online_num + $member_online_num; $block['content'] = "

"; $block['content'] = "

"; $block['content'] .= sprintf(_MB_WHOSONLINE_BOTS,$bots_online_num); $block['content'] .= "

"; $block['content'] .= sprintf(_MB_WHOSONLINE_THERE,$guest_online_num); $block['content'] .= "

"; $block['content'] .= sprintf(_MB_WHOSONLINE_THERE2,$member_online_num); $block['content'] .= "

"; if ($member_online_num > 3) { $result = $xoopsDB->query("SELECT uid, username FROM ".$xoopsDB->prefix("lastseen")." WHERE uid > 0 AND online=1",3,0); while(list($memuid, $memusername) = $xoopsDB->fetchRow($result)) { $block['content'] .="".$myts->makeTboxData4Show($memusername).", "; } $block['content'] .=""._MB_WHOSONLINE_MORE."
"; } elseif ($member_online_num != 0) { $first = 0; $result = $xoopsDB->query("SELECT uid, username FROM ".$xoopsDB->prefix("lastseen")." WHERE uid>0 AND online=1"); while (list($memuid, $memusername) = $xoopsDB->fetchRow($result)) { if ($first!=0) { $block['content'] .=", "; } $block['content'] .="

".$myts->makeTboxData4Show($memusername).""; $first= 1; } $block['content'] .="
"; } $block['content'] .= "
"; if ( $xoopsUser ) { $block['content'] .= sprintf(_MB_WHOSONLINE_URLAS,$xoopsUser->getVar("uname")); $block['content'] .="

"; } else { $block['content'] .= _MB_WHOSONLINE_URAU; $block['content'] .= "
"._MB_WHOSONLINE_RNOW.""; } if ( $options[0] == 1 ) { $myID = ""; if ( $xoopsUser ) { $myID = $xoopsUser->getVar("uid"); } $mintime = time() - ($options[1] * 86400); $result = $xoopsDB->query("SELECT uid, username, time FROM ".$xoopsDB->prefix("lastseen")." WHERE uid>0 AND time>".$mintime." ORDER BY time DESC",$options[2],0); while (list($uid, $uname, $time) = $xoopsDB->fetchRow($result)) { if ($uid != $myID) { $lastvisit = b_whosonline_create($time); $block['content'] .= "

".$myts->makeTboxData4Show($uname).": "; $block['content'] .= $lastvisit."\n"; } } } return $block; } function b_whosonline_create($date){ $realtime = time() - $date; $lastvisit =""; $days = ""; $hours = ""; $mins = ""; //echo $realtime; // how many days ago? if ( $realtime >= 86400 ) { // if it's been more than a day $days = floor($realtime / (86400)); $realtime -= (86400 * $days); } // how many hours ago? if ( $realtime >= (3600) ) { $hours = floor($realtime / (3600)); $realtime -= (3600*$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; } if ( $days > 1 ) { $lastvisit .= sprintf(_MB_WHOSONLINE_DAYS,$days); } elseif($days == 1) { $lastvisit .= _MB_WHOSONLINE_1DAY; } if ( $hours > 0 ) { if($hours == 1){ $lastvisit .= _MB_WHOSONLINE_1HR; }else{ $lastvisit .= sprintf(_MB_WHOSONLINE_HRS,$hours); } } if ( $mins > 0 ) { if ( $mins == 1 ) { $lastvisit .= _MB_WHOSONLINE_1MIN; } else { $lastvisit .= sprintf(_MB_WHOSONLINE_MINS,$mins); } } if ( !$days && !$hours && !$mins ) { $lastvisit .= sprintf(_MB_WHOSONLINE_SCNDS,$realtime); } $lastvisit .= _MB_WHOSONLINE_AGO; return $lastvisit; } function b_whosonline_edit($options) { $form = _MB_WHOSONLINE_SLAST." "; if ( $options[0] == 1 ) { $chk = " checked='checked'"; } $form .= " "._YES.""; $chk = ""; if ( $options[0] == 0 ) { $chk = " checked='checked'"; } $form .= " "._NO."
"; $form .= _MB_WHOSONLINE_MDAYS." "._MB_WHOSONLINE_DAYS2."\n"; $form .= "
"._MB_WHOSONLINE_MMEM." "._MB_WHOSONLINE_MEMS."\n"; return $form; } /* * Function to update last seen table */ function b_whosonline_update(){ global $xoopsUser, $xoopsDB; $past = time() - 300; // anonymous records are deleted after 10 minutes $userpast = time() - 8640000; // user records idle for the past 100 days are deleted $xoopsDB->queryF("DELETE FROM ".$xoopsDB->prefix("lastseen")." WHERE uid=0 AND time < ".$past.""); $xoopsDB->queryF("DELETE FROM ".$xoopsDB->prefix("lastseen")." WHERE time < ".$userpast.""); $xoopsDB->queryF("UPDATE ".$xoopsDB->prefix("lastseen")." SET online=0 WHERE time < ".$past.""); $ip = $_SERVER['REMOTE_ADDR']; if ($xoopsUser) { $uid = $xoopsUser->getVar("uid"); $uname = $xoopsUser->getVar("uname"); } else { $uid = 0; $uname = "Anonymous"; } $sql = "SELECT count(*) FROM ".$xoopsDB->prefix("lastseen")." WHERE uid=".$uid.""; if ( $uid == 0 ) { $sql .= " AND ip='".$ip."'"; } //echo $sql; $result = $xoopsDB->query($sql); list($getRowsNum) = $xoopsDB->fetchRow($result); if ( $getRowsNum > 0) { $sql = "UPDATE ".$xoopsDB->prefix("lastseen")." SET time = " . time() . ", ip='".$ip."', online=1 WHERE uid=".$uid.""; if($uid == 0){ $sql .= " AND ip='".$ip."'"; } $xoopsDB->queryF($sql); } else { $sql = "INSERT INTO ".$xoopsDB->prefix("lastseen")." (uid, username, time, ip, online) VALUES (".$uid.", '".$uname."', ".time().", '".$ip."', 1)"; $xoopsDB->queryF($sql); } } ?>