[mysql101]

Not sure I mentioned this in the previous version, but at the bottom of the output, I included a userlist. I just upgraded to the newest ver of dev shoutbox and no longer have this feature:

PHP Code:

        if ($user_id) {
                $t = time () - 300;
                $q = "select u.username, u.userid, h.ts from user u, shoutbox_hash h where h.userid = u.userid and h.ts > $t
                group by u.userid
                 order by u.username";
                $res = $db->query ($q);
                $i = 0;
                $users = array ();
                while ($row = mysql_fetch_assoc ($res)) {
                        $i++;
                        $age = time () - 30;
                        if ($row['ts'] > $age) {
                                $b1 = "";
                                $b2 = "";
                        } else {
                                $b1 = "<s>";
                                $b2 = "</s>";
                        }
                        $users[] = $b1."<a target='_user' $highlight 
href='/member.php?u=".$row['userid']."'>".$row['username']."</a>".$b2;
                }
                if ($i) {
                        echo "<p><b>".count ($users)." users in chat</b>:<br>".implode (", ", $users)."<br>";
                }
        }