[SloppyGoat]

Originally posted by X-Fan
Well whaddya know, I got it working!

Forgetting about displaychatusers.php I decided to go straight for index.php, into which I added this code...

PHP Code:

// get chatters
$datecut=time()-$cookietimeout;
$chatters = '';
$comma = '';
$forumusers = $DB_site->query("SELECT username,invisible,userid,usergroupid FROM user WHERE inchat=1 AND lastchatactivity>$datecut ORDER BY invisible ASC, username ASC");
while ($forumuser = $DB_site->fetch_array($forumusers)) {
    if ($forumuser['invisible']==0 or $bbuserinfo['usergroupid']==6 or $bbuserinfo['usergroupid']==5 or $bbuserinfo['usergroupid']==7) {
        $userid = $forumuser['userid'];
        if ($forumuser['invisible'] == 1) { // Invisible User but show to Admin
        $invisibleuser = '*';
        } else {
        $invisibleuser = '';
        }
        if ($forumuser['usergroupid'] == 6 and $highlightadmin) {
            $username = "<b><i>$forumuser[username]</i></b>";
        } else if (($mod["$userid"] or $forumuser['usergroupid'] == 5) and $highlightadmin) {
                  $username = "<b>$forumuser[username]</b>";
        } else {
        $username = $forumuser['username'];
        }
    eval("\$chatters .= \"".$comma.gettemplate('forumhome_loggedinuser')."\";");
    $comma = ', ';
    }
} 


after this code...

PHP Code:

} else {
  $pminfo='';
} 


and it works great! (FYI, my usergroupid of 6 is my administrators group. You'll need to change it to whatever yours is if you want to use this code.)

I managed to get the number of users currently in chat displayed as well. I just added this code to index.php:

PHP Code:

// get total chatters
$datecut=time()-$cookietimeout;
$chatnum = mysql_num_rows(mysql_query("select * from user WHERE inchat=1 AND lastchatactivity>$datecut")); 


after the above code and it works fine.



to show it all on the front page after the logged in users section.

This looks like a great hack, but I can't quite figure it out. Can someone clue me in a bit? First, I don't know how to find out what usergroup id is the admin! How is this done? Second, will I need to edit the other usergroupid's listed in this code? I'm not very knowledgeable in php. Please elaborate for idiots like me. What is usergroup 5, 6, and 7 in this example? I think I'm close, if i can just figure out this usergroupid thing.

[edit]
Ok, I figured out how to find it in phpmyadmin, and my usergoupid's are the same, so now I don't know what I'm doing wrong....unless the db needs to be modified?

I keep getting this db error when I try this:

Invalid SQL: SELECT username,invisible,userid,usergroupid FROM user WHERE inchat=1 AND lastchatactivity>1041116216 ORDER BY invisible ASC, username ASC
mysql error: Unknown column 'inchat' in 'where clause'

mysql error number: 1054

Do I need to modify the db with this?

ALTER TABLE user ADD lastchatactivity int(10) unsigned DEFAULT '0' not null
ALTER TABLE user ADD inchat smallint(4) DEFAULT '0' not null

If so, how do I do that? I do have phpmyadmin installed, but don't know much about it. :ermm:

[edit2]
AAAARRRRGGGHHHH!!! Well, I added those two to my user table, but it still didn't do anything.