Online Users Chat Mod IS HERE!

What expire settings are you talking about?

My settings are below..

Max idle time - 30 seconds

Messages Expire - 0

Rooms Expire - 30 minutes

Guest Accounts Expire - 1 munite (disabled in ACP)

The code may *sort of* work, but it is reading the wrong part of the SQL table. It should not be reading "user"...

Take a look at online.php

Quote

   // Get the number of people online
      $exptime = time()-30;
      $query = $db->DoQuery("SELECT * FROM {$prefix}online WHERE invisible<>'1' AND time>'$exptime'");
      while($row = $db->Do_Fetch_Row($query))
         $number++;

I am integrated with phpBB.. I wonder if the cookie is messing things up?

What I'd really like to do is have code like this.. I currently use FlashChat for my chat system, but do not care for flash systems that much. BUT, they do have a killer "who's online" file that I can integrate with my forums.. It shows the name of the room, how may users are in the room, and which users are in the room. It uses javascript in the code. I am really not a coder.. I have a "mess around and keep trying 'til it works" method

If you want to call it that. I know very little PHP and JS.. I do know HTML fairly well. Check this out if you can and tell me what you think. It is a killer way to show peeps online cool

I've attached two images below for reference to the Flashchat files.

Code for info.php

Quote

<?php

   header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
   header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
   header("Cache-Control: no-store, no-cache, must-revalidate");
   header("Cache-Control: post-check=0, pre-check=0", false);
   header("Pragma: no-cache");

/**
If this file is not in the FlashChat root folder, then change this
path to the location of the inc/common.php file.
*/
require_once('inc/common.php');

ChatServer::purgeExpired();

/**
Retrieves the number of users who are chatting in any room.
Leave the $room parameter empty to return the number of users in all room.
*/
function numusers( $room = "" )
{
   if($room) {
      $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?");
      $rs = $stmt->process(SPY_USERID, $room);
   } else {
      $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms
                      WHERE userid IS NOT NULL AND userid <> ? AND ispublic IS NOT NULL
                      AND {$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id");
      $rs = $stmt->process(SPY_USERID);
   }

   $rec = $rs->next();

   return $rec?$rec['numb']:0;
}

/**
Retrieves a list of the users (by login ID) who are in $room.
Leave the $room parameter empty to return a list of all users in all rooms.
*/
function usersinroom( $room = "" )
{
   $list = array();

   if($room) {
      $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?");
      $rs = $stmt->process(SPY_USERID, $room);
   } else {
      $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ?");
      $rs = $stmt->process(SPY_USERID);
   }

   while($rec = $rs->next())
   {
      $usr = ChatServer::getUser($rec['userid']);
      if($usr == null && $GLOBALS['fc_config']['enableBots']) $usr = $GLOBALS['fc_config']['bot']->getUser($rec['userid']);
      $list[] = array_merge($usr, $rec);
   }

   return $list;
}

/**
Retrieves a list of all available rooms, as an array.
*/
function roomlist()
{
   $list = array();

   // populate $list with the names of all available rooms
   $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL order by ispermanent");
   $rs = $stmt->process();

   while($rec = $rs->next()) $list[] = $rec;

   //result will be an array of arrays like ('id' => <room id>, 'updated' = <timestamp>, 'created' => <timestamp>, 'name' => <room name>, 'ispublic' => <public flag>, 'ispermanent' => <autoclose flag>)
   return $list;
}

$rooms = roomlist();
$roomnumb = sizeof($rooms);
$usernumb = numusers();
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Who's in the chat?</title>
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
<style type="text/css">

</style>
</head>
   <body>
      <center>
      <p class=normal>There are <?php echo numusers()?> users in <?php echo $roomnumb?> rooms.</p>
      <?php if($roomnumb) { ?>
         <table border="1" cellpadding="1" class="normal">
            <tr>
               <th>ID</th>
               <th>Name</th>
               <th>Count</th>
               <th>Users</th>
            </tr>
            <?php foreach($rooms as $room) { ?>
               <tr>
                  <td><?php echo $room['id']?></td>
                  <td><?php echo $room['name']?></td>
                  <td><?php echo numusers($room['id'])?></td>
                  <td><?php

                  $users = usersinroom($room['id']);

                  foreach( $users as $user ) {
                     echo $user['login'] . "<br>";
                  }

                  ?> </td>
               </tr>
            <?php } ?>
         </table>
      <?php } ?>

      <p><a href="javascript:window.close()">Close</a></p>
      </center>
   </body>
</html>

Code for info_embedded.php (What I use on my forum index)

Quote

<?php

   header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
   header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
   header("Cache-Control: no-store, no-cache, must-revalidate");
   header("Cache-Control: post-check=0, pre-check=0", false);
   header("Pragma: no-cache");

/**
If this file is not in the FlashChat root folder, then change this
path to the location of the inc/common.php file.
*/
require_once('inc/common.php');

ChatServer::purgeExpired();

/**
Retrieves the number of users who are chatting in any room.
Leave the $room parameter empty to return the number of users in all room.
*/
function numusers( $room = "" )
{
   if($room) {
      $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?");
      $rs = $stmt->process(SPY_USERID, $room);
   } else {
      $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms
                      WHERE userid IS NOT NULL AND userid <> ? AND ispublic IS NOT NULL
                      AND {$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id");
      $rs = $stmt->process(SPY_USERID);
   }

   $rec = $rs->next();

   return $rec?$rec['numb']:0;
}

/**
Retrieves a list of the users (by login ID) who are in $room.
Leave the $room parameter empty to return a list of all users in all rooms.
*/
function usersinroom( $room = "" )
{
   $list = array();

   if($room) {
      $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?");
      $rs = $stmt->process(SPY_USERID, $room);
   } else {
      $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ?");
      $rs = $stmt->process(SPY_USERID);
   }

   while($rec = $rs->next())
   {
      $usr = ChatServer::getUser($rec['userid']);
      if($usr == null && $GLOBALS['fc_config']['enableBots']) $usr = $GLOBALS['fc_config']['bot']->getUser($rec['userid']);
      $list[] = array_merge($usr, $rec);
   }

   return $list;
}

/**
Retrieves a list of all available rooms, as an array.
*/
function roomlist()
{
   $list = array();

   // populate $list with the names of all available rooms
   $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL order by ispermanent");
   $rs = $stmt->process();

   while($rec = $rs->next()) $list[] = $rec;

   //result will be an array of arrays like ('id' => <room id>, 'updated' = <timestamp>, 'created' => <timestamp>, 'name' => <room name>, 'ispublic' => <public flag>, 'ispermanent' => <autoclose flag>)
   return $list;
}

$rooms = roomlist();
$roomnumb = sizeof($rooms);
$usernumb = numusers();
?>
<html>
<head>
<title>Who's in the chat?</title>
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
<style type="text/css">

</style>
<script type="text/javascript">
function toggleUserList(id) {
   if (l = document.getElementById(id)) {
   if (l.style.display == '' || l.style.display == 'block') l.style.display = 'none';
   else l.style.display = 'block';
   }
   return false;
}

</script>
</head>
<body>
<p class=normal><?php echo $usernumb ?> user<?php if ($usernumb != 1) echo "s" ?> in <?php echo $roomnumb ?> room<?php if ($roomnumb != 1) echo "s"; ?>.</p>
<ul id="roomList">
<?php if($roomnumb) { ?>
      <?php foreach($rooms as $room) { ?>
            <li><strong><a href="#" onclick="javascript:toggleUserList('room_<?php echo $room['id']?>')"><?php echo $room['name']?> (<?php echo numusers($room['id']) ?>)</a></strong>
            <?php

               $users = usersinroom($room['id']);
   if ($users) {
   echo "<ul class=\"userList\" id=\"room_".$room['id']."\">";
   foreach( $users as $user ) {
                echo "<li>".$user['login'] . "</li>";
                }
   echo "</ul>";
   }

            ?> </li>
      <?php } ?>
<?php } ?>
</ul>

</body>
</html>