The Arcive of Official vBulletin Modifications Site.

[AJAX] cChatBox · **Released**: 02-04-2008

cChatBox - AJAX-based ChatBox for vBulletin 3.6.8 & 3.7.x

by ChriStrato - vbulletin-italia.it

Features:

Enable / Disable ChatBox
Select if unregistred user can use or only show the chat.
Ban Usergroup/Users from AdminCP
Set Height of ChatBox
Set Name Of BOT
A BOT that answer when use a "action" or "command".
The Number of message to be displayed is not influenced by messages of BOT because some mess of bot are visualizable only by who have used the "action" or "command".
Command for users: /me /myip (show your ip, only you see) /stats (show statistics of chatbox)
System of "Action" for Admin or other usergroup that you set in AdminCP.
List of "Action": /help /topic /listaction /say /mute /unmute /lunarize /unlunarize /kennylize /unkennylize /removeactions /delmess /deleteall
Into AdminCP you can select the allowed action.
The Administrator by default can use the "Action"
A Topic that is displayed at right of title "cChatBox". Can set Topic via AdminCP or with Action /topic <message>
Select the Allowed BBCode into AdminCP.
Into AdminCP can select the usergroup can edit/delete all messages and if users can edit/delete their own message.
Can select if show the ChatBox on template FORUMDISPLAY (Forum List) or SHOWTHREAD (Thread List) and the Position.
Can Enable the Users List at right of ChatBox
Send Private Message from the menu of Users List.
Select if display (on Users List) all user logged or only who have write on ChatBox and set the Width.
Double Click on messages for display the Editor for Edit/Delete message.
Editor with image of the style: Bold, Italic, Underline, Color, Smilie, URL, IMG & Remove Text Formatting
vBMenu Popup for: Color, Smilie & Fonts.
Border of Editor image change color when select (highlight) / deselect (default).
Statistics of ChatBox is only visible by command "/statistics", show: Tot Mess, Your Mess & Top 5
Can delete all message (action: /deleteall) for clear chatbox or database and not lose statistics.
This "Action" affect the message of users: /mute (Mutes user) /lunarize (User talk funny) /kennylize (Message will be affected)
If you can use "Action" the /help command retrieve the list of "Action" allowed, else show you the list of command.
Can enable and insert a "Announce" and show it below chatbox.
Select various tag for the username.
The cChatBox is disponible in 2 language: English or Italian.
ChatBox and Users List are autorefresh
Select if use the class "smallfont" for the text of ChatBox
Preview of smilies into popup
... and more ...

Installation:

Download the file "product-cchatbox-1.4.1_eng.zip" if you use English language on your forum, if you use Italian language download the file "product-cchatbox-1.4.1_ita.zip".
Upload file 'cchatbox.php', directory 'includes' and directory 'clientscript' into forum root.
Import XML File: AdminCP -> Plugin System -> Manage Products -> Add / Import Product
Go into: "AdminCP -> vBulletin Options -> cChatBox" and set options for the ChatBox.

Note:

This product is compatible with vbulletin 3.6.8 and 3.7.x.
I have tested only with this version of vbulletin.

I've write also a little tool for convert the statistics of VBSHOUT for the cChatBox! You can find in the directory: "not upload/tool_cchatbox.php".
Use of this tool: Upload file "tool_cchatbox.php" in the root directory of forum and start the script only if you have installed the product cChatBox.

ATTENTION:

If you update from the version 1.0 or 1.0.1 you must delete all messages with the command /deleteall, because in the new version the "userid" of BOT is different.

History:

v1.0 - (02/05/08)
First Public Release

v1.0.1 - (02/05/08)

Fix: Underline / Italic button
Fix: Add TABLE_PREFIX on a table of query for Users List

v1.1 - (02/12/08)
Fix: Output Date/Time for message visble only by who have write the message
Fix: Action: mute / lunarize / kennylize / topic
Fix: Message counter for statistics.
Add: Select if unregistred user can use or only show the chat.
Add: Usergroup/User that can use the "Action", although affected by them, they can use them.
Add: Send Private Message from the menu of Users List
Add: Show Button URL and IMG if select into admincp
Add: Select various tag for the username
Add: Can enable and insert a "Announce" and show it below chatbox.

v1.2 - (02/13/08)
Fix: Problems with a query of users list
Fix: Value of "Messages Time Limit (in hour) for Users List" options. Now can select 1 and the users list work.
Add: Can select if use the class "smallfont" for the chatbox.
Add: Can set the number / row of smilies into popup from the admincp.
Add: Preview of smilie when mouse is over the smilie.

v1.3 - (02/18/08)
Add: Expire time for this actions: mute, lunarize, kennylize.
Add: Checkbox for select the usergroup into admincp.
Add: Check if user is invisible and not show into users list. Are visible only by usergroup can see hidden users.
Add: Can select the position (up or down) of editor toolbar.
Add: Set the refresh time of ChatBox and Users List
Add: ONLY FOR 3.7.x VERSION: Can add friend from Users List menu.
Add: ONLY FOR 3.7.x VERSION: Show "+" after username into Users List if the user is a friend.

v1.3.1 - (02/18/08)
Add: 5 and 15 minutes for expire time of actions
Fix: Now can see the Toolbar for FORUMDISPLAY and SHOWTHREAD templates

v1.4 - (03/12/08)
Fix: Problem with users list when use the action "/say".
Fix: Query for show users list.
Mod: Modified the principal template "cchatbox".
Add: Hook system.
Add: Javascript engine.

v1.4.1 - (08/16/08)
Fix: Query for show users list for the "All Online User" option.
Fix: Select of colour.
Fix: SQL Injection problem.

v1.5 - (08/28/08)
Fix: Friend Request via "User List".
Add: Update Session when write a message.
Add: Set min posts for use the cChatBox

Thanks to:

Enzo and all community of vbulletin-italia.it that they have supported to me for this project.

Click INSTALL if you use this product TNX

christrato · #32 02-12-2008, 01:28 PM

Quote:

Originally Posted by trance nation

It made some of my forum text red >.< - sorted

When i enable the online suer list i get a mysql error

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid,session.userid,user.options AS options,cchatbox.username AS cchatusername
FROM vb_cchatbox_message AS cchatbox
LEFT JOIN vb_user AS user USING (userid)
LEFT JOIN vb_session AS session USING (userid)
WHERE session.lastactivity > 1202809562 AND cchatbox.userid = user.userid AND cchatbox.time > 1202810462 - (0*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid,session.userid,user.options AS options,cchatbox.username AS cchatusername
FROM vb_session AS session
LEFT JOIN vb_user AS user USING (userid)
LEFT JOIN cchatbox_message AS cchatbox USING (userid)
WHERE session.lastactivity > 1202809562 AND user.userid = session.userid
ORDER BY username ASC);;

MySQL Error : Table 'servermax5.cchatbox_message' doesn't exist
Error Number : 1146
Date : Tuesday, February 12th 2008 @ 10:01:02 AM
Script : http://www.xevolution.co.uk/cchatbox.php?do=userlist
Referrer : http://www.xevolution.co.uk/index.php
IP Address :******
Username : *****
Classname : vB_Database
MySQL Version : 5.0.22

I did put my prefixes as vb_ maybe thats why?

I correct this problem, but it seems to me wrong.

Go to line: 284 and substitute this code into file "functions_cchatbox.php":

PHP Code:


			
            LEFT JOIN cchatbox_message AS cchatbox USING (userid)

with:

PHP Code:


			
            LEFT JOIN " . TABLE_PREFIX . "cchatbox_message AS cchatbox USING (userid)

bye and excuse me

trance nation · #33 02-12-2008, 02:10 PM

What file am i looking at?

Namaless · #34 02-12-2008, 02:15 PM

Another fix (I have fixed in old version, but with new version you have recreate bug).

For fetch_musername require all user informations. THis is fixed function:

PHP Code:


			
    function tagusername($userid, $username)
     {
        global $db, $vbulletin;
        
         $tagusername = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userid;");
        
         if ($tagusername['username'] == $username) {
            
             return fetch_musername($tagusername);
            
             } else {
            
            return $username;
            
             } 
        
        }

Get this

Bye !

trance nation · #35 02-12-2008, 02:17 PM

I hate being new, How do i add that

christrato · #36 02-12-2008, 04:54 PM

Quote:

Originally Posted by Namaless

Another fix (I have fixed in old version, but with new version you have recreate bug).

For fetch_musername require all user informations. THis is fixed function:

PHP Code:


			
    function tagusername($userid, $username)
     {
        global $db, $vbulletin;
        
         $tagusername = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userid;");
        
         if ($tagusername['username'] == $username) {
            
             return fetch_musername($tagusername);
            
             } else {
            
            return $username;
            
             } 
        
        }

Get this

Bye !

are you sure that this function require all informations???

works with only usegroupid and username.

if you see the functions inside the file functions.php you can see that this functions require only "username" and "usergroupid".

bye

trance nation · #37 02-13-2008, 08:17 AM

Password on the rar, Help?

christrato · #38 02-13-2008, 08:28 AM

opssssssssssssss! excuse me! i have zipped file with password for error

now have reupload the file with no password. excuse me

trance nation · #39 02-13-2008, 08:31 AM

Thanks, Amazing work!

Fearlessninja · #40 02-13-2008, 06:38 PM

I suggest a way to give bots custom commands =) with custom answers/responses. That will make this make awesome!

christrato · #41 02-13-2008, 07:43 PM

Quote:

Originally Posted by Fearlessninja

I suggest a way to give bots custom commands =) with custom answers/responses. That will make this make awesome!

you can custom the answers / response from the admincp -> language & phrases -> search phrases

for the custom commands... i think in future

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08761 seconds Memory Usage 2,347KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
caoducanh9x

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!