Show "who's in chat room" on forum home page with integrated phpmychat!

[Velocd]

This would greatly help getting more people into my integrated phpmychat room, since when users are on the main forum page they can see who's online in the chat room.

Currently I'm only asking for a number (digit) of the people who are in the chat room, but if it were somehow possible to get it displaying the usernames, that would be really sweet. I know this isn't a Vbulletin hack, but in a sense it is since you are modifying/adding code to Vbulletin templates and php files. (it would also be really cool if done).

thanks

[mem]

DO you want attachment ??


sorry , my english is poll !! aranoid:

[Velocd]

You bet I do! In..uh, english that is

[mem]

DO you want attachment ??

if you want it . you need to


Looking for:
====================
index.php

PHP Code:

} else { 
$pminfo=''; 
} 


Add the string after it....:
========================

PHP Code:

//END CHAT HACK 
// Cleanup Old Users First! 
// 240 = Wait 4 mins before deleteing inactive users 
$DB_site->query("DELETE from c_users where u_time < ".(time() - 240)." and u_time > 0"); 
$numchattersa = $DB_site->query_first("SELECT count(username) AS username FROM c_users"); 
// Ok Get Users and Stats 
if ($bbuserinfo['userid']!=0) {
$chat_name = $DB_site->query("SELECT username FROM c_users");
while ( $chat_names=$DB_site->fetch_array($chat_name)) {
$chat_username .= "&nbsp;$chat_names[username]&nbsp;";
}
$numchatters = $numchattersa[username]; 
eval("\$chatinfo .= \"".gettemplate("chatlogged")."\";"); 
} 


ADD chatlogged template
<font color=red> $numchatters</font> member<font color=green>$chat_username</font> in<a href="/green/chat/index.php3?
U=$username&PASSWORD=&N=20&D=10" target="_new" title="go to chat"> <font color=#B50101>your chat</font></a>
==========================

sorry , my english is poll !! aranoid:

[Velocd]

I hate to say it but that didn't work at all! I tried it and it simply gave me an error when I loaded up my forums. Are you talking about forum/index.php for another index.php? I can't see how the code above references to the chat log. Please help me out

[almightyone]

well i agree a hack of this nature would be nice hopefully someone can get soemthing that works for us who would like to have it

[mem]

i think about your database !!

beacause my chat install database the same vbb

and i do it

you can try again

[Velocd]

What Vbulletin version do you have mem? I tried to install it on 2.2.4 and just gave me errors. I'll try again though, hey what is the link to your forums mem? I wanna see the hack

[mem]

Originally posted by Velocd
What Vbulletin version do you have mem? I tried to install it on 2.2.4 and just gave me errors. I'll try again though, hey what is the link to your forums mem? I wanna see the hack

i used vbb2.24 .

my forums http://www.greenkiss.com/green



my chat http://www.greenkiss.com/green/chat/index.php3

[Velocd]

Here is the error I get:

--------------------------------------------------------
Database error in vBulletin 2.2.4:

Invalid SQL: DELETE from c_users where u_time < 1018581979 and u_time > 0
mysql error: Table 'velocd_Vbulletin.c_users' doesn't exist

mysql error number: 1146

Date: Thursday 11th of April 2002 11:30:19 PM
Script: http://www.diffusion4.com/index.php?
Referer: http://www.diffusion4.com/admin/index.php?action=head
--------------------------------------------------------

Are there any values that I should be changing from your code??