Who's Online = working but need help

[mac]

Hi,
I've just started using this great chat program! I love it!

I'm using this script that I found on this site. I changed it a bit and I need some help with it. It's the 'who's online script' which I use on my index.php page which is seperate from X7Chat. It works great, but I would like to enhance it and I don't know much php, maybe somwonw here can help please!

Here's what I have:

<?
//connect to mysql
//change localhost, username and password to your mySQL username and password
mysql_connect("xxxx","xxxx","xxxx");
   
//select which database, change DBname
mysql_select_db("xxxxxx");

//select the table, should be right if you didn't change the prefix in the data base
$result = mysql_query("select * from x7chat2_online");


$expire_time = 240;
$exp_time = time()-$expire_time;
      $q = mysql_query("DELETE FROM x7chat2_online WHERE time<'$exp_time'");

//grab all the content


while($r=mysql_fetch_array($result))
{

   //modify these to match your mysql table columns that you want to display

   $usersonline=$r["name"];
   $room=$r["room"];


   //display the row
   echo "$usersonline";
}
?>

Currently, it shows who's online like this: 'user1user2user3'. How can I add a comma between the usernames so it's like this: 'user1, user2, user3' ?

Also, how can I get it to wrap around, maybe so it starts a new line after every five names or so, lile:

user1, user2, user3, user4, user5,
user6, user7

I suppose some kind of HTML table? Any suggestions greatly welcomed!

[E-Oreo]

For the comma change

Code:

while($r=mysql_fetch_array($result))
{

   //modify these to match your mysql table columns that you want to display

   $usersonline=$r["name"];
   $room=$r["room"];


   //display the row
   echo "$usersonline";
}

to

Code:

$usersonline = '';
while($r=mysql_fetch_array($result))
{

   //modify these to match your mysql table columns that you want to display
   $room=$r["room"];

   $usersonline .= $r['name'] . ', ';
}

if($usersonline != '')
   echo substr($usersonline,0,strlen($usersonline)-3);
else
   echo 'No users online';

For the wrap just put the PHP code inside a <div> with the width that you want and let the browser wrap it.

[mac]

Hmmm....thanks, that works but it intoduces one problem! My username is "Mike_M" and it displays "Mike_"

?!??!

[mac]

Yep I see the problem is with all users: the last letter of their usernames are all missing!

[E-Oreo]

Change the 3 to a 2 in
[CODE
substr($usersonline,0,strlen($usersonline)-3);

Code:

[madfiddler]

Using MKPortal, I couldn't get this to work as a PHP block as it displayed the members outside of the table, and therefore corrupted the look of the site.

This did work for me - it's just blank when there are no members online

Code:

<?
//select the table, should be right if you didn't change the prefix in the data base
$result = mysql_query("select * from x7chat2_online");


$expire_time = 10;
$exp_time = time()-$expire_time;
      $q = mysql_query("DELETE FROM x7chat2_online WHERE time<'$exp_time'");

//grab all the content

$usersonline = '';
while($r=mysql_fetch_array($result))

{

   //modify these to match your mysql table columns that you want to display
   $usersonline .= $r['name'] . ', ';

}

   //display the row
$content="members in chat $usersonline";

?>

However, the looks isn't quite how I want. Is there any way I can centre the text (it does it in the preview, but not the main site), and perhaps display the "members in chat" words in a different font?

Thanks,

m

[Ardbeggordon]

I know this is a very old subject (sorry !) but has anyone managed to get this to work with phpbb3 ?
Or is there another way to get the who's online to show in phpbb3 ?
Thanks

[Peter Koster]

Don't know about phpbb3 (haven't updated yet, since my phpbb2 has so many mods it's nearly 100 % spam free), but in version 2 you couldn't use 'foreign' php. There was a mod to make that possible, but I couldn't get it working.

[Ardbeggordon]

Thanks Peter , i spent a couple of hours trying various combinations of the php but couldn't get anything to appear !

[blablubbb]

You need to do the folowing:
1. Make a new php-file with the code of madfiddler above
2. Ad this to the beginning of this code (but after the opening tag of php (<?):

Code:

mysql_connect("localhost","username","password");
mysql_select_db("DBname");

While DBname, username and password need to be changed and maybe also localhost (in lots of cases it is just localhost)
3. Add this code at the end:

Code:

print "$content";

just after the definition of the $content variable and before the end-tag of the php (?>) in a new line.
4. Upload it somewhere at your server.
5.Add something like this into your forum-code (e.g.: in the overall-footer):

Code:

<iframe src="http://YOUR_FORUM.com/path_to_the_php-file/php-filename.php" name="whoisinchat" scrolling="auto" width="100%" height="300"></iframe>

You should modify the path to your php-file (and for a better loocking width and height and you could set scrolling to "no" and you can change the name and you can do some style-things at the css-file... but thats optional...according to your needs)