UBB.Developers Forums UBB.threads 6 V6 Modifications Beta-[6.4] Online Users 2.1

#<br /># Find this:<br />#<br /><br />// Find out how many are browsing this forum<br />   $query = "<br />      SELECT O_Type,O_Board,COUNT(*)<br />      FROM   {$config['tbprefix']}Online<br />      WHERE  O_Board = '$Board'<br />      GROUP BY O_Type<br />   ";<br />   $sth = $dbh -> do_query($query);<br />   $a = "0";<br />   $r = "0";<br />   while (list($Type,$Extra,$onlinecount) = $dbh -> fetch_array($sth)) {<br />      ${$Type} = $onlinecount;<br />   }<br /><br />#<br /># Change to:<br />#<br /><br />// Start of Online Users hack.<br />// Find out how many are browsing this forum and check who are online.<br />   $Outdated = $html -> get_date() - 600;<br />   $queryOnline = "<br />      SELECT O_Uid,O_Type,O_Board<br />      FROM   {$config['tbprefix']}Online<br />      WHERE  O_Last > $Outdated<br />      ORDER BY O_Last DESC<br />   ";<br />   $sth = $dbh -> do_query($queryOnline);<br />   $a = 0;<br />   $r = 0;<br />   $OnlineUsers = Array();<br />   while (list($ol_usernum,$Type,$VisitingBoard) = $dbh -> fetch_array($sth)) {<br />      // Check if the user is browsing this board and update the counters accordingly<br />      if ( $VisitingBoard == $Board ) {<br />         ${$Type}++;<br />      }<br />      // Add this user to the list of online users if they are logged in.<br />      if ( $ol_usernum ) {<br />         $OnlineUsers[] = $ol_usernum;<br />      }<br />   }<br />// End of Online Users hack.