Chat Modifications - MGC Chatbox Evo

This mod is automatically compatible with vB3.6.x, vB3.7.x, vB3.8.x and vB4.x.x

Overview

MGC Chatbox Evo is the most ever installed chatbox for vBulletin !

It offers a new enhanced online experience to your members leading to increased time spent online of more than 25% by providing them with a new, more interactive, way to interact with each other.

• Important number of features
• High level of configurability to fit each users needs
• Channels system
• Many commands
• Bot system
• and more...

... makes MGC Chatbox Evo a must have for your forum !

Detailed features

Following is a non-exhaustive list:

• Simple install
• Ajax based with:
  • Fast and Intelligent chats retrieval through javascript calls to server files (refresh delay configurable per usergroup)
  • Edit/update by double-clicking on a chat
  • Interact on chats through menus and javascript
• Many usergroup permissions to limit features according to usergroups
• Full configuration of the chatbox display:
  Size, position on forum pages, editor layout (either top/bottom input or left/right textarea) and position, number of chats displayed, ...
• Full configuration of the chats display:
  Authorized bbcodes selection, date/time options, avatar display, ...
• Possibility to create channels (unlimited number) with multiple configuration options:
  • Warn user of new message when not active through blinking image and eventually sound notification
  • Possibility to select on which specific page each is displayed
  • Option to display the channel only for selected languages
  • Usergroup/User permissions to access the channel
• Many commands available with usergroup/user permissions to access them:
  • /me: well known IRC command
  • /del: remove shouts (different possibilities of removal)
  • /ignore: ignore shouts from another user
  • /ban: ban user from chatbox
  • /pm: send a private chat to another user
  • /announcement: modify the announcement on top of the chatbox
  • /slap: allow user to slap another user
  • /team: chats sending between specified usergroups
  • /l33t: I33t-ify a message
  • /banchan: ban user from specific channel [PRO only]
• Forum activity notifications system in the chatbox:
  • Different display options:
    • In the chatbox melted with chats
    • In the chatbox in a separate column
    • In the vB4 sidebar or a custom sidebar for vB3
  • Multiple notifications:
    • New thread creation
    • New post creation
    • Post thanked (Abe's)
    • New registrations (not included - separate product)
    • IBProarcade highscore (not included - separate product)
• Bot system with set of predefined trigger chat and corresponding answers and automatic bot chats [PRO only]
• Archive system with statistics as well as download and search capabilities
• Possibility to display the list of users online in the chatbox
• Force anynomous to enter a username before chatting if they can access the chatbox
• Antiflood system
• Private chats feature through PM in tabs
• Optional sound notifications
• Inactive mode feature for server load optimization
• User statistics display in posts and profile
• Chatbox statistics display on forumhome
• Create thread from a chat [PRO only]
• CMS Integration (not included - separate product)
  • vBAdvanced CMPS
  • vBulletin 4 CMS
• Importers from other chatbox systems:
  • cChatbox by Christrato [version 1.5]
  • Cyb - Chatbox by Cybernetec [version 2.3]
  • vBulletin 3.x Shoutbox 1.0 (AJAX) by DionDev [version 1.0]
  • Dream's Chatbox by Dream [version 2.1.1]
  • GSBOS by dinnerbone [version 1.0.5]
  • Inferno vBShout Lite 2.5.0 by Inferno Tech [version 2.5.1 lite]
  • vBShouts 2.0 by Zero Tolerance [version 2.0]
  • MGC Chatbox by MGC [version 1.5]

Install

Refer to the readme for the chatbox install.

Demo

Live demo on MGC Products forum

Languages

1. French
2. English
3. German [Not yet updated]
   
4. Serbian [Not yet updated]

Support

On my website mostly and in this thread

Int?gration

Integration in IBProarcade is described in the readme.
vBAdvanced CMPS and vBulletin 4 CMS integration are available as additional modules.

Compatibility

This hack is compatible with vB3.6.x, vB3.7.x, vB3.8.x and vB4.x.x

Changelog

First part:
https://vborg.vbsupport.ru/showpost....&postcount=221

Second part:
https://vborg.vbsupport.ru/showpost....postcount=5429

Third part:
https://vborg.vbsupport.ru/showpost....postcount=8469

How to set the channel images

Thanks to princeedwards for this little how to : click here

PRO version and additional addons available on my website

This mod is automatically compatible with vB3.6.x, vB3.7.x, vB3.8.x and vB4.x.x

[adnedarn]

In firefox 3.0.5 if the chatbox is minimized I get a sql database error email... I spoke with the guy that the errors were coming from and found if I minimize it I get them for my username as well...

Database error in vBulletin 3.7.3:

Invalid SQL:

				(
				 SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
				 tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid,
				 avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, 
				 customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
				 fromu.avatarid,fromu.avatarrevision			
				 			 
				 FROM mgc_cb_evo_chat AS c
				 LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
				 LEFT JOIN user AS tou ON (c.touid=tou.userid)
				 LEFT JOIN avatar AS avatar ON (avatar.avatarid = fromu.avatarid)
				 LEFT JOIN customavatar AS customavatar ON (customavatar.userid = fromu.userid)
				 
				 WHERE (
							chanid='0' 
							AND coidentifier IN ('0','me','announcement','ban','del','pm') 
							AND (touid='0' OR fromuid='5846' 
							OR touid='5846')
							AND iswarning='0'
						)
				 ORDER BY sticky DESC,c.dateline DESC
				 LIMIT 2
				)
				UNION ALL
				(
				 SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
				 tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid,
				 avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, 
				 customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
				 fromu.avatarid,fromu.avatarrevision
				 
				 FROM mgc_cb_evo_chat AS c
				 LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
				 LEFT JOIN user AS tou ON (c.touid=tou.userid)
				 LEFT JOIN avatar AS avatar ON (avatar.avatarid = fromu.avatarid)
				 LEFT JOIN customavatar AS customavatar ON (customavatar.userid = fromu.userid)
				 
				 WHERE 
				 ORDER BY sticky DESC,c.dateline DESC
				 LIMIT 20
				);

MySQL Error   : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sticky DESC,c.dateline DESC
				 LIMIT 20
				)' at li
Error Number  : 1064
Request Date  : Saturday, January 3rd 2009 @ 03:45:59 AM
Error Date    : Saturday, January 3rd 2009 @ 03:46:00 AM
Script        : http://www.terraforums.com/forums/mgc_cb_evo_ajax.php
Referrer      : http://www.terraforums.com/forums/
IP Address    : 
Username      : adnedarn
Classname     : vb_database
MySQL Version : 4.0.27-standard

Thanks!
Andrew

PS- I know nothing about coding but did see something in there about mysql and limit 20.. so i will say I do have NEW Separate SQL query for the notifications enabled and 20 set for NEW Number of notifications to display in the chatbox....

[chooky]

I have the mistake, that in my second style (no child style) no message were shown, and all message which I type are away and dont show in the message-box.

[Stoebi]

Hi

Using vBulletin 3.8.0 RC 2, Opera 9.6.2 and IE7. If I collapse the shoutbox, an AJAX error occurs.

Edit:
Get a sql database error email too, with the same content like in adnedarn his post (#3671)

Workaround until final fix. Open file mgc_cb_evo_ajax.php and search for:

PHP Code:

$limit = $vbulletin->options['mgc_cb_evo_nbchats_closed']; 


Replace with:

PHP Code:

            $limit = 0;
            $sql_where_clause_notifs = 0; 


Regards, Stoebi

[eurofunny]

Originally Posted by eurofunny View Post

With Version 2.0.2 Shoutbox is visible at the Arcade with the 2.1.0 Version not.

No changes in the current version could make it not to appear. What did you do in the 2.0.2 to get it work in the arcade ?

I copy the 2.0.2 files to my Server and import the Product and then is the Shoutbox visible.

Copy the 2.1.0 files to my Server and import the Product then the Shoutbox is at the arcade not visible but at here mgc_cb_evo.php?do=view_chatbox

[VBDev]

Originally Posted by pedroenf

Maybe. One thing is for sure, i did it in the previous versions and it did not cause any trouble and did use the ' character.

Do you remember which text you put in the phrase when that acted like that ?

Originally Posted by SnapOff Racing

I used to use the vBShout v2.0 ChatBox that was originally created by ZeroTolerance, which I believe now has been renamed into Inferno vBShout Lite. In any case while these two mods are basically the same, unfortunately there are some differences in the table names thus making it not possible to use the Inferno Import Script to import chats from vBShout inot MGC EVO.

So I reworked the import script a little to allow the importing of vBShout Chats into MGC EVO. Just posting this up for VBDev if you would like to implement this into your next version, or if anyone knows what they are doing they could use this to import also. Just replace the mgc_cb_evo.php file from your admincp folder with the one that I have attached. Then your "Import Scripts" page will show up like this.



Also this mgc_cb_evo.php file is from the current 2.1.0 version.

Thanks for the share I'll add it in the next version.

Originally Posted by FF|Skyrider

Just wanted to say to VBDev:

It should be:
$find = '$chatbox_forumhome';

rather than:
$search_text = '$chatbox_forumhome';

in the manual "Display problem in some styles"

Thanks for the update though! And is it possible the sound can be done through something else rather than quicktime? A lot of people don't have quicktime.

Damn I thought I corrected that

[VBDev]

Originally Posted by adnedarn

In firefox 3.0.5 if the chatbox is minimized I get a sql database error email... I spoke with the guy that the errors were coming from and found if I minimize it I get them for my username as well...

Database error in vBulletin 3.7.3:

Invalid SQL:

                (
                 SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
                 tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid,
                 avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, 
                 customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
                 fromu.avatarid,fromu.avatarrevision            
                              
                 FROM mgc_cb_evo_chat AS c
                 LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
                 LEFT JOIN user AS tou ON (c.touid=tou.userid)
                 LEFT JOIN avatar AS avatar ON (avatar.avatarid = fromu.avatarid)
                 LEFT JOIN customavatar AS customavatar ON (customavatar.userid = fromu.userid)
                 
                 WHERE (
                            chanid='0' 
                            AND coidentifier IN ('0','me','announcement','ban','del','pm') 
                            AND (touid='0' OR fromuid='5846' 
                            OR touid='5846')
                            AND iswarning='0'
                        )
                 ORDER BY sticky DESC,c.dateline DESC
                 LIMIT 2
                )
                UNION ALL
                (
                 SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
                 tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid,
                 avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, 
                 customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
                 fromu.avatarid,fromu.avatarrevision
                 
                 FROM mgc_cb_evo_chat AS c
                 LEFT JOIN user AS fromu ON (c.fromuid=fromu.userid)
                 LEFT JOIN user AS tou ON (c.touid=tou.userid)
                 LEFT JOIN avatar AS avatar ON (avatar.avatarid = fromu.avatarid)
                 LEFT JOIN customavatar AS customavatar ON (customavatar.userid = fromu.userid)
                 
                 WHERE 
                 ORDER BY sticky DESC,c.dateline DESC
                 LIMIT 20
                );

MySQL Error   : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sticky DESC,c.dateline DESC
                 LIMIT 20
                )' at li
Error Number  : 1064
Request Date  : Saturday, January 3rd 2009 @ 03:45:59 AM
Error Date    : Saturday, January 3rd 2009 @ 03:46:00 AM
Script        : http://www.terraforums.com/forums/mgc_cb_evo_ajax.php
Referrer      : http://www.terraforums.com/forums/
IP Address    : 
Username      : adnedarn
Classname     : vb_database
MySQL Version : 4.0.27-standard

Thanks!
Andrew

PS- I know nothing about coding but did see something in there about mysql and limit 20.. so i will say I do have NEW Separate SQL query for the notifications enabled and 20 set for NEW Number of notifications to display in the chatbox....

Originally Posted by chooky

I have the mistake, that in my second style (no child style) no message were shown, and all message which I type are away and dont show in the message-box.

Oh crap...

To fix this, edit the mgc_cb_evo_ajax.php file.

Search for:

PHP Code:

        /* LIMIT clause construction */
        if ($status == "closed") {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_closed'];
        } else if ($location == "full") {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_full'];
        } else {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_normal'];
        }      
          
          /* Retrieving of the notifications is separated */
          if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'])
          { 


Replace :

PHP Code:

if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql']) 


by :

PHP Code:

if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'] && $status != "closed") 


Originally Posted by Stoebi

Hi

Using vBulletin 3.8.0 RC 2, Opera 9.6.2 and IE7. If I collapse the shoutbox, an AJAX error occurs.

Edit:
Get a sql database error email too, with the same content like in adnedarn his post (#3671)

Workaround until final fix. Open file mgc_cb_evo_ajax.php and search for:

PHP Code:

$limit = $vbulletin->options['mgc_cb_evo_nbchats_closed']; 


Replace with:

PHP Code:

            $limit = 0;
            $sql_where_clause_notifs = 0; 


Regards, Stoebi

That's a bad fix use the one above

Originally Posted by eurofunny

I copy the 2.0.2 files to my Server and import the Product and then is the Shoutbox visible.

Copy the 2.1.0 files to my Server and import the Product then the Shoutbox is at the arcade not visible but at here mgc_cb_evo.php?do=view_chatbox

Yes that I understand but what have you done in your admincp to make the chatbox show in arcade in the previous version ?

[Harley D]

Nice job!
Working like a charm... THANK YOU

Request:
when clicking on New Post/Threads, have the link take you to the actual or last post made, rather than the first post of the thread.

[Stoebi]

Thank you very much for your fast answer @vBDev

Kind Regards,

Stoebi

[eurofunny]

Originally Posted by VBDev

Yes that I understand but what have you done in your admincp to make the chatbox show in arcade in the previous version ?

With the 2.0.2 Version i have made this:

Integration into IBProarcade 
In order to display the chatbox on the IBProarcade pages, follow these instructions: 
In the admin control panel, go in the Display and positions of the chatbox. 
Activate the option Display the chatbox on defined pages in a var or Display the chatbox on defined pages below the navbar. 
In the pages list, add :

arcade

and then validate. 
Open the arcade/functions/functions.php file and search for function do_output($output_array). 
After // add additional needed variables, add : 

global $mgc_cb_evo,$mgc_cb_evo_var;


Finally, if you are using te option to display the chatbox in a var, edit the ARCADE template and add :

$mgc_cb_evo_var

where you want the chatbox to appear.

What do you post at the readme and the Shoutbox is visible.

Later i have copy the files from 2.1.0 and import the Product and the Shoutbox is invisible at the Arcade...

Now i copy the 2.0.2 files and import the Product and the Shoutbox is visible at arcade...nothing more i have do at the admincp...

Thanks for the quick support.

[chooky]

Oh crap...

To fix this, edit the mgc_cb_evo_ajax.php file.

Search for:

/* LIMIT clause construction */
        if ($status == "closed") {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_closed'];
        } else if ($location == "full") {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_full'];
        } else {
            $limit = $vbulletin->options['mgc_cb_evo_nbchats_normal'];
        }      
          
          /* Retrieving of the notifications is separated */
          if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'])
          {

Replace :

if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'])

by :

if ($vbulletin->options['mgc_cb_evo_separate_chatsnotif_sql'] && $status != "closed")

dont works for me, I ever dont see a message in the box in second style