Thread: Chat Log
View Single Post
  #4  
Old 03-09-2005, 09:10 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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']==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($header1);
        
        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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01353 seconds
  • Memory Usage 1,865KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete