[mccollin]

I said I wasn't going to post the other code, but this is cool... I replaced the "guest" with the ip address, and sorted by it. Each ip address is a hotlink to samspade.com to get the host info.

PHP Code:

$datecut = time()-$cookietimeout;

$onlineusers = mysql_query("SELECT DISTINCT username,location,session.lastactivity,usergroupid FROM user,session WHERE session.userid=user.userid AND session.lastactivity>$datecut ORDER BY username ASC");
           echo "<br><br><table width=\"90%\" align=\"center\" border='0' cellpadding='0' cellspacing='0' class='tblborder'><tr><td>";
           echo "<table width=\"100%\" border=0 cellspacing=1 cellpadding=4><tr class='tblhead'><td align=\"center\" colspan=4 width=\"100%\"><b><span class='tblhead'>Who's Online</span></b></td></tr>\n";
    echo "<tr class='".getrowbg()."'><td nowrap align=\"center\"><font size='1'><b>Username</b></font></td><td align=\"center\" nowrap><font size='1'><b>Location</b></font></td><td align=\"center\" nowrap><font size='1'><b>Last Active</b></font></td></tr>\n";
        while ($online=$DB_site->fetch_array($onlineusers)) {       
        if (!$online[location]) {
        $online[location] = "Control Panel";
       }
        if ($online['usergroupid'] == 6) {
       $username = "<b><i>$online[username]</i></b>";
       } else if ($online['usergroupid'] == 5) {
           $uusername = "<b>$user[username]</b></font>";
       } else {
        $username = $online[username];
        }
        $lastactivity=vbdate($timeformat,$online[lastactivity]);
        echo "<tr class='".getrowbg()."'><td nowrap><a href=\"../member.php?s=$session[sessionhash]&action=getinfo&username=$online[username]\" target=_blank>$username</a></td><td nowrap>$online[location]</td><td nowrap>$lastactivity</td></tr>";
    }
$onlineguests = mysql_query("SELECT DISTINCT location,lastactivity, host FROM session WHERE userid=0 AND session.lastactivity>$datecut ORDER BY host ASC");
        while ($onlineg=$DB_site->fetch_array($onlineguests)) {       
        $lastguestactivity=vbdate($timeformat,$onlineg[lastactivity]);
        echo "<tr class='".getrowbg()."'><td nowrap><a href=\"http://www.samspade.org/t/ipwhois?a=$onlineg[host]\" target=_blank>$onlineg[host]</a></td><td nowrap>$onlineg[location]</td><td nowrap>$lastguestactivity</td></tr>";
    }
echo "</table></td></tr></table>";