Chat Log

Hi there,

I require the ability to keep a log of all chat activity on my board. I plan to have a single chat room only. Is there a way to dump all activity (time/date stamped) to a text file?

thanks

dave

[wacnstac]

This would be useful to me as well.

[Zero Tolerance]

It may be created for a future version, thats not a promise.

- Zero Tolerance

[sv1cec]

Originally Posted by Zero Tolerance

It may be created for a future version, thats not a promise.

- Zero Tolerance

If I may, add this code at the end of your admin_vbchat.php file, before the ?> :

PHP Code:

// ###################### Do View Messages ########################
if ($_GET['do'] == "viewmessages" ) 
{
    $file="vbchat_store";
    globalize($_REQUEST, array(
        'sid' => INT,
        'perpage' => INT,
        'page' => INT,
        'orderby' => STR,
    ));
    print_cp_header("vBChat System");
    
    $perpage=20;
    
    if ($page < 1)
    {
        $page = 1;
    }
    $startat = ($page - 1) * $perpage;
    
    $counter=$DB_site->query_first("SELECT COUNT(*) AS messages FROM " . TABLE_PREFIX . "{$file} AS message");
    
    if ($counter['messages']==0 or $counter['messages']=='')
    {
        $url='admin_vbchat.php';
        $wait=5;
        print_cp_message("No Chat Messages to Show.", $url, $wait);
    }
    
    $totalpages = ceil($counter['messages'] / $perpage);
        
    $Get_Chat_MSG = $DB_site->query("select m.*,u.*,t.username AS tusername, t.userid AS tuserid from ".TABLE_PREFIX."{$file} m
        left join ".TABLE_PREFIX."user u on (u.userid = m.s_postby) 
        left join ".TABLE_PREFIX."user t on (t.userid = m.s_foruser)
        order by m.s_postime LIMIT $startat, $perpage");
    
    if ($DB_site->num_rows($Get_Chat_MSG))
    {
            
        if ($page != 1)
        {
            $prv = $page - 1;
            $firstpage = "<input type=\"button\" class=\"button\" value=\"&laquo; " . $vbphrase['first_page'] . "\" tabindex=\"1\" onclick=\"window.location='admin_vbchat.php?$session[sessionurl]do=viewmessages&perpage=$perpage&orderby=$orderby&file=$file&page=1'\">";
            $prevpage = "<input type=\"button\" class=\"button\" value=\"&lt; " . $vbphrase['prev_page'] . "\" tabindex=\"1\" onclick=\"window.location='admin_vbchat.php?$session[sessionurl]do=viewmessages&perpage=$perpage&orderby=$orderby&file=$file&page=$prv'\">";
        }
    
        if ($page != $totalpages)
        {
            $nxt = $page + 1;
            $nextpage = "<input type=\"button\" class=\"button\" value=\"" . $vbphrase['next_page'] . " &gt;\" tabindex=\"1\" onclick=\"window.location='admin_vbchat.php?$session[sessionurl]do=viewmessages&perpage=$perpage&orderby=$orderby&file=$file&page=$nxt'\">";
            $lastpage = "<input type=\"button\" class=\"button\" value=\"" . $vbphrase['last_page'] . " &raquo;\" tabindex=\"1\" onclick=\"window.location='admin_vbchat.php?$session[sessionurl]do=viewmessages&perpage=$perpage&orderby=$orderby&file=$file&page=$totalpages'\">";
        }
    
        $aa=($page-1)*$perpage+1;
        if ($page<$totalpages)
        {
            $bb=$page*$perpage;
        }
        else
        {
            $bb=$counter['messages'];
        }
        $cc=$counter['messages'];    

        print_form_header('', '');
        
        print_table_header("View vBChat Messages<br>Page $page of $totalpages<br>Messages $aa to $bb of $cc",14);
                
        $header = array();
        
        $header[] = "<b>ID</b>";
        $header[] = "<b>Poster Name</b>";
        $header[] = "<b>Message</b>";
        $header[] = "<b>Date/Time</b>";
        $header[] = "<b>To User</b>";
            
        print_cells_row($header, 1);
        
        while($message=$DB_site->fetch_array($Get_Chat_MSG))
        {
        
            $cell = array();
            
//             $message[date] = vbdate ( $vboptions['dateformat'], $message[s_postime] ) ;
             $message[time] = vbdate ( $vboptions['timeformat'], $message[s_postime] ) ;
            $message[date]=date("d-m-Y");

            if($message['s_foruser']=="0")
            {
                $touser='All';
            }
            else
            {
                $touser=$message[tusername];
            }
            
            $cell[] = "<font size='-1'>$message[sid]</font>";
            $cell[] = "<font size='-1'>$message[username]<br>$message[userid]</font>";
            $cell[] = "<font size='-1'>$message[s_message]</font>";
            $cell[] = "<font size='-1'>$message[date]<br>$message[time]</font>";
            $cell[] = "<font size='-1'>$touser<br>$message[tuserid]</font>";
            
            print_cells_row($cell);
            
        }
        print_table_footer(5, "$firstpage $prevpage &nbsp; $nextpage $lastpage");
    }
} 

Then edit your admincp/index.php file and find:

PHP Code:

construct_nav_option ( 'Chat Prune Options', 'admin_vbchat.php?do=prune', '<br />' ) ; 

Right below that, add:

PHP Code:

construct_nav_option ( 'Chat Log', 'admin_vbchat.php?do=viewmessages', '<br />' ) ; 

Let me know if that works.

Of course, you should not have the prune chat option active, or else the messages will be deleted.

[AzHousePro]

Looks like it works to me. Nice job.

How hard would it be to code something that dumped the entire log to a text file on the server?

Mike

[Deaths]

Why dump it to a .txt file, if it's already in the DB?

[AzHousePro]

Just thought it would be nice to dump the log to a text file every once in a while and purge the database.

Mike

[sv1cec]

That, Sir, I have no idea how to do it.

[Diana Notacat]

This was brilliantly useful!

Is it possible to make some modifications to this to allowing viewing logs for the created rooms as well? Perhaps a menu to "view Logs for X room"?

[Deaths]

Would you want it to be an actual file on your server, which is updated at regular bases, or do you just want to be able to download the .txt file?