vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   Active Users in Chat (Works with any web chat client including JPilot) (https://vborg.vbsupport.ru/showthread.php?t=34065)

Dom 01-12-2002 10:00 PM
I am using JPilot for a chat client on my websites. I haven't found a great solution for showing what users are in the chat so I decided to code my own.

Live demo at : http://www.cgchat.com
The users are listed at the top.

The script seems to work well, but I haven't had time to take a look at much of the vbulletin code, so it does maybe need some work.

Instructions:

!Backup your vbulletin and site!

Modify user table with the fallowing lines

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

Whatever chat software you are using, you have to have it open in a new browser window. Create a page that has two frames.
=============================

<html>
<head>
<title>Site Title.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<frameset rows="1,*" frameborder="NO" border="0" framespacing="0">
<frame name="topFrame" scrolling="NO" noresize src="mainchat_top.php" >
<frame name="mainFrame" src="main_chat.php">
</frameset>
<noframes><body bgcolor="#FFFFFF" text="#000000">

</body></noframes>
</html>

=============================


main_chat.php: This page has your chat client, in my case jpilot.

mainchat_top.php: The top page has a page with this code:

=============================
<?php
require("global.php");
if( $bbuserid ) {

$DB_site->query("UPDATE user SET inchat='1' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("UPDATE user SET lastchatactivity=$ourtimenow WHERE userid='$bbuserinfo[userid]'");
} else {

} // end if
?><html>
<head>
<meta http-equiv="refresh" content="100; url=http://www.cgchat.com/board/mainchat_top.php">
</head>
<body bgcolor="#0F1D2D">
<center><font face="Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Please leave this window open when you are in the CG Live Chat
</font></center></body>
</html>

=============================

What this does is the top hidden frame refreshes every 100 seconds updating the database with the user in the chat. So if the users are using a chat client like mirc this won't show them that they are on the chat, unless you make a new page and point them to the code that updates the db like the code above.

Now the printing isn't very well optimized for vbulletin. This is because I get confused when working with templates in vb , didn't have much time to play around with them yet. Anyway this is what I do:

Create a new page call it : displaychatusers.php and place this code

------------------------------------------------
<?
if ($showforumusers) {
$datecut = $ourtimenow - $cookietimeout;
$chatters = '';
$comma = '';
$forumusers = $DB_site->query("SELECT username, invisible, userid
FROM user
WHERE inchat = 1 AND
lastchatactivity > $datecut");
while ($forumuser = $DB_site->fetch_array($forumusers)) {
if (!$forumuser['invisible'] or $bbuserinfo['usergroupid'] == 6) {
$userid = $forumuser['userid'];
$username = $forumuser['username'];
if ($forumuser['invisible'] == 1) { // Invisible User but show to Admin
$invisibleuser = '*';
} else {
$invisibleuser = '';
}
eval("\$chatters .= \"".$comma.gettemplate('forumdisplay_loggedinuser' )."\";");
$comma = ', ';
}
}

}
?>
------------------------------------------------

Now I include this page in the header of vbulletin, and echo $chatters in one of the templates. That's it.

If you want to display the users in the forums I used GeorgeofCS previous code from his hack on digichat. Here is a paste:

in forumdisplay.php

at the very bottom the right above:

eval("dooutput(\"".gettemplate('forumdisplay')."\" );");

add:

// Get users chatting
if ($showforumusers) {
$datecut = $ourtimenow - $cookietimeout;
$chatters = '';
$comma = '';
$forumusers = $DB_site->query("SELECT username, invisible, userid
FROM user
WHERE inchat = 1 AND
lastchatactivity > $datecut");
while ($forumuser = $DB_site->fetch_array($forumusers)) {
if (!$forumuser['invisible'] or $bbuserinfo['usergroupid'] == 6) {
$userid = $forumuser['userid'];
$username = $forumuser['username'];
if ($forumuser['invisible'] == 1) { // Invisible User but show to Admin
$invisibleuser = '*';
} else {
$invisibleuser = '';
}
eval("\$chatters .= \"".$comma.gettemplate('forumdisplay_loggedinuser' )."\";");
$comma = ', ';
}
}
if ($chatters) {
if (!$moderatedby) {
$onlineusers = "<br>";
}
eval("\$onlineusers .= \"".gettemplate('forumdisplay_loggedinusers')."\"; ");
}
}

Next in forumdisplay_loggedinusers template
change:

<br>(Users Browsing this Forum: $browsers)

to:

<br>(Users Browsing this Forum: $browsers)
<br>(Users In Chat: $chatters)

Thats it, if you have any suggestions or extra info let me know. It seem to be a little delayed, and sometimes when a user leaves a chat it still prints there name in chatters , it has to do something with the lastactivity and cookietimeout. I stole that from GeorgeofCS code and it seems to work quite well.

Let me know what you think.

Cheers

Dom
dominik@insidecg.com
www.insidecg.com
www.cgchat.com

rawnet 01-13-2002 10:09 AM
Hi Dom,

This hack looks hugely encouraging. I'm not keen to be the first person to try it. I'm also using vbPortal and would like to include this information in a side block, if possible.

My main concern before installing it would be speed - how does this affect loading time of your forums? Have you noticed much difference? What has been the response of your users?

Cheers for now,

Ross

GeorgeofCS 01-13-2002 11:15 AM
I know solution to the delay, but seeing that everyone just "steals" my code and re-releases it without asking first I'll keep the information for myself. :mad: Cause frankly if you had asked I would have told you the code doesn't work quite well for refreshing.

rawnet 01-13-2002 11:37 AM
If part of this hack hack does user GeorgeofCS's code, and he hasn't been asked or credited then this hack should be removed.

Dom 01-13-2002 12:48 PM
The reason I posted this is no body has made a good solution for showing who is in the chat when using vbulletin.

The code works fine with reloading and I don't see any performance changes. It works well.

As for the code I stole, it was only the
----
if ($showforumusers) {
$datecut = $ourtimenow - $cookietimeout;
$chatters = '';
$comma = '';
$forumusers = $DB_site->query("SELECT username, invisible, userid
FROM user
WHERE inchat = 1 AND
lastchatactivity > $datecut");
while ($forumuser = $DB_site->fetch_array($forumusers)) {
if (!$forumuser['invisible'] or $bbuserinfo['usergroupid'] == 6) {
$userid = $forumuser['userid'];
$username = $forumuser['username'];
if ($forumuser['invisible'] == 1) { // Invisible User but show to Admin
$invisibleuser = '*';
} else {
$invisibleuser = '';
}
eval("\$chatters .= \"".$comma.gettemplate('forumdisplay_loggedinuser' )."\";");
$comma = ', ';
}
}

}
------

I would have rewrote, but why do it if one is already main availble. I have noted it's your code. I really don't care if you or I made it. I am not here for competition! I am here to offer some sort of solution to your problems. I mentioned your name.

ITS GEORGEOFCS CODE!!! Yes those 10 lines are his code. It works well. If he won't allow you to use it, I will write my own.

I am sorry for the missunderstanding, I thought this is a community for sharing ideas. Seems to me it's a popularity spike.
I am not selling the code, so don't worry no million is going to arrive at my door.

Cheers

-Dom

sk187 01-13-2002 04:08 PM
Dom- great script im deffinetly going to use it but can you please post a link to the jpilot hack you used? I have a copy of jpilot and have been using it in a different way on my board and want to intergreat it like you did.

Hi stan

Dom 01-13-2002 04:30 PM
You are going to have to tell me exacthly what you mean. All you have to do is make a button in one of the templates to open a new window that frame window.

Lesane 01-13-2002 05:37 PM
Great! Thanks for sharing. Gonna install this one later.

GeorgeofCS 01-13-2002 06:15 PM
The point of my post is at least you could have asked me first. Not so much because I don't want you taking my hack, but rather there's bugs in my code and the better version was to be release within the next day or so, and it's bug free and not beta.

Dom 01-13-2002 08:17 PM
I am sorry Goerge , I should have asked you are right. If you do have a new version do share it with us if you like. I didn't proclaim the code as being mine, so I really didn't think it would matter to you even if I mentioned your name.

Again sorry.

There seems to be a slight delay in a post however. It displays the users in the chat, but they are no longer there. It does have something to do with your code and cookietimeout time stamp.

-Dom

jisung 01-17-2002 04:46 AM
Dom,
I'm trying to install this hack but having difficulty now.

Quote:
Now I include this page in the header of vbulletin, and echo $chatters in one of the templates. That's it.
How can I include this "displaychatusers.php" in every header?
I've tried to put them in phpinclude by adding a line of "include (./displaychatusers.php)" and it works only in forumdisply.php but showtread.php can't be viewed since then.

Thanks in adv.
Jisung

PhotoGenie 02-04-2002 12:19 PM
Just wondering. I saw the word refresh. I would like to have someway to see who's in chat but the refresh thing bothers me. Can you here the refresh clicks while you are in chat? If not I will install this and try it on 2.2.2 .. I just dont like that clicking sound from the refresh. Thanks :)

PhotoGenie 02-06-2002 08:36 PM
No clicking sound.. Great!!.. You have to wait on the cookie to clear to be shown as logged out of the chat. I found an alternative and that was to add a popup on exit to the frameset. Then I created another php file I named chat_logout.php ..

The frameset looks like this:

<html>
<head>
<title>Site Title.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
function leave() {
window.open('http://www.Your-Site.com/chat_logout.php','','toolbar=no,menubar=no,locatio n=no,height=204,width=700');
}
// End -->
</SCRIPT>
</head>

<frameset onUnload="leave()" rows="1,*" frameborder="NO" border="0" framespacing="0">
<frame name="topFrame" scrolling="NO" noresize src="mainchat_top.php" >
<frame name="mainFrame" src="main_chat.php">
</frameset>
<noframes><body bgcolor="#FFFFFF" text="#000000">

</body></noframes>
</html>

The new php file looks like this:

<?php
require("global.php");
if( $bbuserid ) {

$DB_site->query("UPDATE user SET inchat='0' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("UPDATE user SET lastchatactivity=$ourtimenow WHERE userid='$bbuserinfo[userid]'");
} else {

} // end if
?>
<head>
<title>Chat Log-Out</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<BODY onLoad="setTimeout(window.close, 5000)"
</body>
</html>

The chat_logout.php is the pop up. The settings above are for 5 seconds. You can customize the body of the pop up to look like you want.. I made mine match my vb and it basically says that you have succesfully logged out of chat. The pop up above is blank. This logs you straight out of the chat with no waiting on cookies and will do me till I see a better solution.

sk187 02-11-2002 03:05 AM
im having the same problem as jisung

How do i include displaychatusers.php in the header

and isnt $chatters already echo'd later on in the hack.

Any way any help is appreciated.

PhotoGenie 02-11-2002 09:27 AM
Quote:
Originally posted by sk187
im having the same problem as jisung

How do i include displaychatusers.php in the header

and isnt $chatters already echo'd later on in the hack.


Any way any help is appreciated.

It depends on where you want it to be.. Mine is at the bottom of my boards under private messages. I included mine in my forumhome_pmloggedin template but I wanted mine where it wasnt visible unless you are looged in. Guest dont see it. I just added this to the bottom of the template.

<tr id="cat">
<td bgcolor="#606096" colspan="6"><smallfont color="#FFF788"><b>Current Chatters </b></smallfont><smallfont color="#FFF788"></smallfont></td>
<tr>
<td bgcolor="#F1F1F1" colspan="6"><smallfont>$chatters</smallfont></td>
</tr></tr>


in root/index.php I put:

require('./displaychatusers.php');


right under:

require('./global.php');

and thats all the changes I made to index.php.



the second problem I was having problems with was when I added the part to show chatters in threads. If chatters were in chat. It would add everything twice to the top of the threads Instead of looking like this:

(Moderated by: milo)
(Users Browsing this Forum: Dave)
(Users In Chat: Dave)

it looked like this:

(Moderated by: milo)
(Users Browsing this Forum: Dave)
(Users In Chat:)
(Users Browsing this Forum: Dave)
(Users In Chat: Dave)


.. I got mine fixed. If you have this problem just pm me and I'll tell you what I did.
Anyway, hope this helped you. :)

My chat is open to guest if you would like to check it out:) It will not show guest as logged in though :(

sk187 02-12-2002 02:10 AM
Is there anyway to make jpilot automatically log the chat users in under there name on the board.

Somthing like what is done in other scripts like

<param name="NickName" value="{$bbuserinfo[username]}">

in the jpilot script.

The way this current hack is set up the user gets to manually enter his name in. I want to know if its possiable to log them in automatically.

Thanks in advance

And thanks to PhotoGenie for the help it worked great

PhotoGenie 02-12-2002 02:21 AM
Your param for that should look like this:

<param name="NickName" value="$bbuserinfo[username]">

Here is whate my applet code looks like:

<applet archive="jirc_nss.zip" code=Chat.class width=700 height=365 >
<param name="CABBASE" value="jirc_mss.cab">
<param name="LicenseKey" value="Your License key">
<param name="ServerPort" value="6667">
<param name="ServerName1" value="Your server">
<param name="Channel1" value="Your Channel name">
<param name="AllowURL" value="true">
<param name="AllowIdentd" value="true">
<param name="WelcomeMessage" value="Your Welcome message">
<param name="RealName" value="Use anything here">
<param name="NickName" value="$bbuserinfo[username]">
<param name="UserName" value="">
<param name="isLimitedServers" value="true">
<param name="isLimitedChannels" value="true">
<param name="ChannelPasword" value="">
<param name="IgnoreLevel" value="3">

<param name="FilterKeys" value=":) :( :D :p ;) (cry) :B :O :o) :zz :{ (b) (coffee) (m) (cake) (h) (l) (moon) (note) (rose) (*) (d) (p) (gift)" />
<param name="FilterVals" value="smile.gif sad.gif biggrin.gif tounge.gif wink_smile.gif cry_smile.gif embaressed_smile.gif omg_smile.gif shades_smile.gif sleepy.gif angry_smile.gif beer_yum.gif coffee.gif martini_shaken.gif cake.gif heart.gif lightbulb.gif moon.gif musical_note.gif rose.gif star.gif thumbs_up.gif thumbs_down.gif present.gif" />
<param name="MessageCol" value="80">
<param name="BackgroundColor" value="99,132,181">
<param name="TextColor" value="black">
<param name="TextScreenColor" value="white">
<param name="ListTextColor" value="blue">
<param name="ListScreenColor" value="lightgray">
<param name="TextFontName" value="MS Sans Serif">
<param name="TextFontSize" value="11">
<param name="ConfigNickOnly" value="false">
<param name="NickNChannelOnly" value="true">
<param name="LogoBgColor" value="white">
<param name="BorderVsp" value="3">
<param name="DirectStart" value="true">
<param name="FGColor" value="black">
<param name="TitleBackgroundColor" value="black">
<param name="TitleForegroundColor" value="white">
<param name="InputTextColor" value="black">
<param name="InputScreenColor" value="white">
<param name="IgnoreLevel" value="3">
<param name="DisplayConfigRealName" value="false">
<param name="DisplayConfigServer" value="false">
<param name="DisplayConfigPort" value="false">
<param name="DisplayConfigMisc" value="false">
<param name="InitCommands" value="/clear;/me enters">
<param name="UserListWidth" value="160">
<param name="RefreshColorCode" value="false">
<param name="DisplaySoundControl" value="true">
<param name="NoConfig" value="true">
<param name="DisplayAbout" value="false">
<param name="IgnoreServerMsg" value="true">
<param name="IgnoreModeMsg" value="true">
<param name="IgnoreMOTD" value="true">
<param name="IgnoreChannelChangeMsg" value="true">
<param name="AllowSound" value="true">
</applet></td>
</tr>

</table>
</td></tr></table>

</body>

</html>

sk187 02-22-2002 02:58 AM
thanks for the help PhotoGenie

I just have one more problem

i still keep getting erroneus name when loggin into the chat rooms

It has somthing to do with
<param name="NickName" value="$bbuserinfo[username]">

and it not calling the vb database correctly

is there anyone that can help with this PLEASE

thanks alot sk187

lifesourcerec 03-13-2002 04:28 PM
I got jpilot integrated and trying to figure out how to integrate this into it. my files are named different and I already have a pop up. Will this every be released?

The only things I may have to integrate is:

Quote:
<?php
require("global.php");
if( $bbuserid ) {

$DB_site->query("UPDATE user SET inchat='1' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("UPDATE user SET lastchatactivity=$ourtimenow WHERE userid='$bbuserinfo[userid]'");
} else {

} // end if
?>
and the displaychatusers.php file.

Can someone help me on this? I use this integration chat:

https://vborg.vbsupport.ru/showthrea...threadid=33050

Swamper 03-21-2002 05:34 AM
...I had a need for this sort of thing last year and the majority of the regular users in my chat now don't use the java client anymore so there was no accurate way to do it with mysql :) - So I just set up an eggdrop bot in the channel and have it running a simple TCL script I wrote that writes out the # of people in the channel to disk every time someone joins (didn't bother to have it do it when someone leaves - but that's easy to add too)

..then set up a crontab to copy the file over to my web directory (since the bot runs as user nobody) and within global.php have:

$fd = fopen ("path/to/file_with_number_in_chat", "r");
$num_in_chat = fgets($fd, 3);
fclose ($fd);

...then just insert $num_in_chat in a template or wherever and I have easy access to it..

lifesourcerec 03-22-2002 06:17 AM
Quote:
Originally posted by PhotoGenie
No clicking sound.. Great!!.. You have to wait on the cookie to clear to be shown as logged out of the chat. I found an alternative and that was to add a popup on exit to the frameset. Then I created another php file I named chat_logout.php ..

The new php file looks like this:

<?php
require("global.php");
if( $bbuserid ) {

$DB_site->query("UPDATE user SET inchat='0' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("UPDATE user SET lastchatactivity=$ourtimenow WHERE userid='$bbuserinfo[userid]'");
} else {

} // end if
?>
<head>
<title>Chat Log-Out</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<BODY onLoad="setTimeout(window.close, 5000)"
</body>
</html>
Is the above the new main_top.php file?

nighteyes 03-23-2002 06:39 AM
Quote:
Originally posted by Swamper
...I had a need for this sort of thing last year and the majority of the regular users in my chat now don't use the java client anymore so there was no accurate way to do it with mysql :) - So I just set up an eggdrop bot in the channel and have it running a simple TCL script I wrote that writes out the # of people in the channel to disk every time someone joins (didn't bother to have it do it when someone leaves - but that's easy to add too)

..then set up a crontab to copy the file over to my web directory (since the bot runs as user nobody) and within global.php have:

$fd = fopen ("path/to/file_with_number_in_chat", "r");
$num_in_chat = fgets($fd, 3);
fclose ($fd);

...then just insert $num_in_chat in a template or wherever and I have easy access to it..
Would you possibly mind sharing this TCL script? And how you have cron setup? This would be a far more efficient way of doing things than using MySQL. :) vbulletin has enough mysql queries already going on.

Swamper 03-23-2002 09:31 PM
Here is my crontab:

* * * * * root /path/to/file_to_run

contents of file_to_run:

/bin/cp /path/to/eggdrop/numchat.txt /path/to/yoursite.com/wherever

Make sure to chmod 755 the file_to_run afterwards...

I modified the peak eggdrop script (announces in channel whenever a new record is set for # of ppl in the channel) - I just added to line 31:

Code:
set fid [open "numchat.txt" "WRONLY CREAT"]
puts $fid $curnum
close $fid
Change the filename to whatever you want (not necessary)

Then in your bot config file add:

source scripts/peak1.5.tcl

That's it :) Enjoy

Patrik 04-14-2002 09:41 AM
I followed the instructions for jPilot, added the include for displachatusers.php in my index.php the way explained and added the $chatters to my header, but nothing happens... Any idea why I can't see the people ?

Harryli 04-20-2002 07:28 PM
Hm , is it possible that since 2.2.5 the $chatters wont work? I changed nothing, use the same templates, but the chatters are shown no more ... ??? I cant see any reason for this... but now noone is shown as chatting

kypdurron 06-26-2002 07:32 PM
Ok..so I'm working on a better integration with IRC.
Can I do the following:

I want to pass a channel name as a parameter, and I want to know who is in that channel.

This way, all the users are in "#ForumChat" will be displayed

and there is also a "#ForumsAdmin" Channel, which will also be displayed.

I DO NOT want to have one bot per channel, as the number of channels that I want to do this for can be infinite.

So..it will show you who is in chat for all users, plus
moderators can see who is in the #forumchat and if
there is people in another channel, say #forumsadmin.

Any thoughts?

X-Fan 06-28-2002 03:05 PM
Just installed this hack, and I just can't get it working. I can get a chat section to come up on my forum's main page, but it's not listing any of the users in the chatroom at the time.

Help!!!

Also, how would you get the number of users currently in the chat to display like the number of users online?

X-Fan 06-28-2002 03:58 PM
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.

Then added this to the bottom of the forumhome_loggedinusers template:

Code:
<tr id="cat">
        <td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="6"><a href="chat/"><normalfont color="#000000"><b>Users Chatting</b></normalfont></a><normalfont color="#000000"><b>: $chatnum</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#1C5780" align="center" valign="top">
<a href="chat/"><img src="https://vborg.vbsupport.ru/images/activechatters.gif" alt="Users Chatting" align=middle border=0></a>
</td>
        <td bgcolor="#13486D" colspan="5"><smallfont>
        $chatters</smallfont></td>
</tr>
to show it all on the front page after the logged in users section.

amykhar 06-29-2002 01:28 AM
working quite well on 2.2.6 Thank you :)

Amy

Matt 07-19-2002 02:02 AM
How do I make it so I can show the number of people in the chat? Fantastic hack btw!! :D

Velocd 07-22-2002 05:33 PM
I'm wondering who has got this to work without having to clear your cookies everytime you leave the chat, in order to get the "who's chatting" updated. I saw the solution with the popup on the first page, but surely there is an automatic way...

Velocd 07-22-2002 06:39 PM
Never mind, after awhile tinkering with the code I have finally got it to work :)

Simply perfect, I have it working with the IRC Bocazas chat hack and everything works fine. This hack causes no performance drop either, for those questioning this. Only thing I wish could be possible is if users using mIRC, or another chat client, could be picked up also..ofcourse that logically isn't possible with this hack.

SloppyGoat 12-28-2002 09:46 PM
Quote:
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? :confused: 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.

lifesourcerec 01-07-2003 04:40 AM
Yes, use phpMyAdmin. If you enter it, use this:

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

A ";" was missing.

Works great for me now.. but messes up another script.

SloppyGoat 01-07-2003 12:33 PM
Thanks, I'll try it again then. What other script does it mess up, though? :disappointed:

lifesourcerec 01-08-2003 04:24 AM
The Top 5 Statistics hack.

In the "Top 5 Newest Members:", whenever someone joins the chat, it will put their name before the first new user.

Conflict with $username.

SloppyGoat 01-08-2003 12:25 PM
Ok cool. I don't use that hack anyway. :)

hubba 05-02-2004 05:40 PM
Hm, in VB 3 this gives a database eroor?

$DB_site->query("UPDATE user SET inchat='0' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("UPDATE user SET lastchatactivity=$ourtimenow WHERE userid='$bbuserinfo[userid]'");

hubba 05-09-2004 03:50 PM
Wahhh isnt it possible to rewrite that to VB3???


All times are GMT. The time now is 05:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01542 seconds
  • Memory Usage 1,936KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (6)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (39)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete