Chat Modifications - [AJAX] cChatBox

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:

1. 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".
2. Upload file 'cchatbox.php', directory 'includes' and directory 'clientscript' into forum root.
3. Import XML File: AdminCP -> Plugin System -> Manage Products -> Add / Import Product
4. 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

[cajunboy2208]

Originally Posted by hilfe-forum

Ok now it works


I disable all product
Dont work (endless loading)

I delete old files from another Chatbox...
Dont work...

Reinstall your Chatbox...
Now it works...

Aktivate other product
Stil works

so i think old files of other Chatbox was the problem

I have same problem.
I did all of the steps.
I've never had a chatbox before on my forum though.
And I still have the problem.
It works fine on default skin, but not on my custom skin.

[christrato]

you can give me the link of your custom skin for download and try?

tnx

[Geeps]

Any idea why this error would be showing up in internet explorer?

error on page

Line: 668
Char: 1
Error: 'null" is null or not an object
Code: 0

Works fine in FireFox

[Geeps]

uninstalled the new version. just received emails about database errors:

Database error in vBulletin 3.6.8:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM cchatbox_message AS cchatbox
LEFT JOIN user AS user USING (userid)
LEFT JOIN session AS session USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203569931 - (1*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM session AS session
LEFT JOIN user AS user USING (userid)
LEFT JOIN cchatbox_message AS cchatbox USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'jamesp57_forum.session.usergroupid' in 'on clause'
Error Number : 1054


I'm using a modded default skin, Vb version 3.68

http://4x4sonthe.net

[inteller2k7]

I'm getting this, and the forum colors changing to red, any ideas?



Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM hackercchatbox_message AS cchatbox
LEFT JOIN hackeruser AS user USING (userid)
LEFT JOIN hackersession AS session USING (userid)
LEFT JOIN hackerusergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203577110 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203578910 - (1*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM hackersession AS session
LEFT JOIN hackeruser AS user USING (userid)
LEFT JOIN hackercchatbox_message AS cchatbox USING (userid)
LEFT JOIN hackerusergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203577110 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'aioforum_hacker.session.usergroupid' in 'on clause'
Error Number : 1054
Date : Thursday, February 21st 2008 @ 02:28:30 AM
Script : http://aioforums.com/cchatbox.php?do=userlist
Referrer : http://aioforums.com/aioforums.php?styleid=19
Classname : vB_Database
MySQL Version : 4.1.22-standard

[christrato]

Originally Posted by Geeps

Any idea why this error would be showing up in internet explorer?

error on page

Line: 668
Char: 1
Error: 'null" is null or not an object
Code: 0

Works fine in FireFox

when this error appear?

Originally Posted by Geeps

uninstalled the new version. just received emails about database errors:

Database error in vBulletin 3.6.8:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM cchatbox_message AS cchatbox
LEFT JOIN user AS user USING (userid)
LEFT JOIN session AS session USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND cchatbox.userid = user.userid AND usergroup.usergroupid = user.usergroupid AND cchatbox.time > 1203569931 - (1*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid AS userid,user.pmtotal,usergroup.pmquota,user.options AS options,cchatbox.username AS cchatusername
FROM session AS session
LEFT JOIN user AS user USING (userid)
LEFT JOIN cchatbox_message AS cchatbox USING (userid)
LEFT JOIN usergroup AS usergroup USING (usergroupid)
WHERE session.lastactivity > 1203569331 AND user.userid = session.userid AND usergroup.usergroupid = user.usergroupid
ORDER BY username ASC);;

MySQL Error : Unknown column 'jamesp57_forum.session.usergroupid' in 'on clause'
Error Number : 1054


I'm using a modded default skin, Vb version 3.68

http://4x4sonthe.net

damn... probably is the position of LEFT JOIN... because " LEFT JOIN usergroup AS usergroup USING (usergroupid)" don't found the usergroupid column on the table "session or cchatbox".

i not receive this error and can't try if this solution work or not... i attach the file "functions_cchatbox.php" download it and upload into directory "includes".

wait for your answer...

[christrato]

<a href="https://vborg.vbsupport.ru/member.php?u=205225" target="_blank">inteller2k7</a> try to download and overwrite the functions_cchatbox.php that i have attached into my previous post.

[inteller2k7]

Originally Posted by christrato

inteller2k7 try to download and overwrite the functions_cchatbox.php that i have attached into my previous post.

Thank you, works great....

[Geeps]

The error on page shows up in the lower left corner of the Internet Explorer window. It doesn't seem to effect anything, and it shows only when the chat is turned on. I never noticed it since I use Firefox, but one of the forum members pointed it out last night.

[inteller2k7]

Originally Posted by Geeps

The error on page shows up in the lower left corner of the Internet Explorer window. It doesn't seem to effect anything, and it shows only when the chat is turned on. I never noticed it since I use Firefox, but one of the forum members pointed it out last night.

Download the new functions file, in post 56 above, and replace it. I had the same problem and that fixed it.