Chat Modifications - Unofficial Addonchat Integration

This mod is based on the mod found here: https://vborg.vbsupport.ru/showthread.php?t=179346

Sadly the official plugin has been unsupported for a long time and has a lot of dubious errors. This release fixes several issues:

1. Uncached templates have been fixed
2. Added support for the community submenu
3. Better templates that make more sense
4. Added who's chatting list on forumhome

[DarkStarr]

Originally Posted by Jaxel

By request, I have added the feature where you can select to show the who's chatting box on top of the forum home, or on top of the WHAT'S GOING ON box.

Thank you so much dude, this is a great mod! ...nominated!!

[Forumi Shqiptar]

tagged this mod... will check it later...

[Slugger00001]

tagged will check later

[reotto]

Has anyone figured out how to globalize this add-on so if I use the following piece of code it will work in cmps, dyna, and vb?

PHP Code:

<if condition="$addonchat[vb_enable_popup]">
    <tr><td class="vbmenu_option"><a href="#" onClick="window.open('addonchat.php?$session[sessionurl]do=popup', 'addonchat', 'width=$addonchat[width_float],height=$addonchat[height_float],statusbar=no,scrollbars=no,toolbar=no,menubar=no,resizable=yes'); return false">$vbphrase[addonchat_enter_float]</a></td></tr>
</if> 


[Jaxel]

You SHOULDN'T globalize this mod. This mod adds a .5 second load time to your forumhome as it goes to the addonchat servers to retrieve the who's chatting information. Any page you put this on will load .5 seconds slower.

[Grim77]

Jaxel -- We're gearing up to do another official update. I don't see any license on your modifications, and since it appears as though you used our original code, I assume you're OK with us borrowing some of your improvements? Let me know Any other feature requests -- especially anything tying into our systems -- are also greatly appreciated!

[whitetigergrowl]

Keep up the good work!

[Digital Jedi]

Hay Jaxel. Got an error during import of the product. First error I forgot to copy, but it said something about one of the tables not able to be created.

Second import I got this Database Error.

Database error in vBulletin 3.8.2:

Invalid SQL:

   CREATE TABLE addonchat_settings
   (
      account_id INT UNSIGNED NOT NULL DEFAULT 0,
      login_md5pass VARCHAR(32) NOT NULL DEFAULT '',
      language VARCHAR(8) NOT NULL DEFAULT 'en',
      settings_retrieved TINYINT(1) NOT NULL DEFAULT 0,
      login_email VARCHAR(64) NOT NULL DEFAULT '',   
      edition INT UNSIGNED NOT NULL DEFAULT 0,
      modules VARCHAR(128) NOT NULL DEFAULT '',
      ras_capable TINYINT(1) NOT NULL DEFAULT 0,
      edition_name VARCHAR(128) NOT NULL DEFAULT 'Unknown',
      expire_date DATE NOT NULL DEFAULT 0,
      ras_enabled TINYINT(1) NOT NULL DEFAULT 0,
      ras_url VARCHAR(128) NOT NULL DEFAULT 'http://',
      server_name VARCHAR(64) NOT NULL DEFAULT 'client0.addonchat.com',
      server_port INT UNSIGNED NOT NULL DEFAULT 8000,
      cpanel_login VARCHAR(255) NOT NULL DEFAULT 'http://',
      title VARCHAR(48) NOT NULL DEFAULT 'My Chat Room',
      account_id_fq VARCHAR(32) NOT NULL DEFAULT 'SC-0',
      customer_id_fq VARCHAR(32) NOT NULL DEFAULT 'RC-0',
      enable_auto_login TINYINT(1) NOT NULL DEFAULT 1,
      allow_unregistered_guests TINYINT(1) NOT NULL DEFAULT 0,
      url_exit VARCHAR(128) NOT NULL DEFAULT 'http://',
      width INT UNSIGNED DEFAULT 585,
      height INT UNSIGNED DEFAULT 400,
      width_float INT UNSIGNED DEFAULT 620,
      height_float INT UNSIGNED DEFAULT 420,
      forum_url VARCHAR(255) NOT NULL DEFAULT 'http://',
      ef_profile TINYINT(1) NOT NULL DEFAULT 1,
      ef_find_posts TINYINT(1) NOT NULL DEFAULT 1,
      ef_email TINYINT(1) NOT NULL DEFAULT 1,
      ef_pm TINYINT(1) NOT NULL DEFAULT 1,
      ef_add_buddy TINYINT(1) NOT NULL DEFAULT 1,
      ef_forum_ignore TINYINT(1) NOT NULL DEFAULT 0,
      vb_enable_menu TINYINT(1) NOT NULL DEFAULT 1,
      vb_enable_embed TINYINT(1) NOT NULL DEFAULT 1,
      vb_enable_popup TINYINT(1) NOT NULL DEFAULT 1,
      vb_enable_whos_chatting TINYINT(1) NOT NULL DEFAULT 1,
      vb_enable_whos_chatting_main TINYINT(1) NOT NULL DEFAULT 0     
   ) 
   ENGINE=MyISAM CHARACTER SET utf8;

MySQL Error   : Table 'addonchat_settings' already exists
Error Number  : 1050
Request Date  : Monday, June 1st 2009 @ 02:56:22 AM
Error Date    : Monday, June 1st 2009 @ 02:56:22 AM
Script        : http://www.cogonline.net/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.cogonline.net/forums/admincp/plugin.php?do=productadd
IP Address    : XXXXXXXXX
Username      : Digital Jedi
Classname     : vB_Database
MySQL Version : 5.0.77-community-log

Is it safe to just drop the tables and try importing again?

[silentdub]

Originally Posted by Jaxel

first post

Ok, My connection dropped while I was installing, I got back in, it doesn't show up as installed. I tried to reinstall, and then get a few DB errors in regards to tables already being there.

Do you have a script to manually uninstall the changes?

[silentdub]

[QUOTE=Digital Jedi;1821140]Hay Jaxel. Got an error during import of the product. First error I forgot to copy, but it said something about one of the tables not able to be created.

Second import I got this Database Error.

[CODE]Database error in vBulletin 3.8.2:

Invalid SQL:



I am in the same boat as you are. Some of the tables and such are there so it won't proceed.

We need to back out this mod manually.

How?