Official SigmaChat Integration

Product Info
Name: SigmaChat Official Integration Extension
Product ID: sc7400
Version: 1.0.4 (Version re-schemed)
Author: RaiderSoft (http://www.raidersoft.com/)
Last Modified: 17 Oct. 2005
Compatibility: vBulletin 3.5.0 Gold, 3.5.0 RC-2/3
Mirror: forums.raidersoft.com

Overview
This extension allows you to fully integrate a SigmaChat Platinum or Enterprise Java? Chat Room with your vBulletin 3.5.x forum system, including the ability to authenticate access via your vBulletin forum system, and provide a "Who's Chatting" page list showing who is currently logged into your chat room.

Requirements

• vBulletin 3.5.x
• SigmaChat Platinum, or Enterprise. Please note that SigmaChat Basic and SigmaChat Professional are no longer supported. You may register for a SigmaChat account at www.sigmachat.com.
• PHP with allow_url_fopen directive enabled in your php.ini file. This is required to download the Who's Chatting list from SigmaChat servers.

What's new?
This extension dramatically improves upon the previous release by making use of the vBulletin Database to store Who's Chatting list updates. Additionally, the Who's Chatting box at the bottom of the main forum page has been removed in favor of showing a (nearly) real-time count of users in your chat room directly from the main navbar. Both embedded and popup chat room options are provided to your user. The Who's Chatting list has been cleaned up. Two additional remote functions (Add Buddy and Forum Ignore) have been added as well.

Features

• Seamless integration between your vBulletin forum and SigmaChat
• Popup and Embedded Chat room link options
• Automatic (one minute interval) User's Chatting count updates
• Real-Time Who's Chatting list
• Display the amount of users within your chat room on your main navbar shown throughout your entire forum
• Remote authentication allows you to authenticate access into your chat room based on your vBulletin user database
• Automatic user login option
• Remote authentication allows you to choose which vBulletin user groups are allowed chat room administrative privileges
• Remote functions system allows you to tie in vBulletin forum functions into the SigmaChat user menu
• Uses the new vBulletin 3.5 XML product import architecture, making installation/uninstallation easier, requiring no modifications to the codebase.
• Improves over previous versions by storing Who's Chatting list within it's own MySQL database table

Installation
Installaion will require between 10 and 15 minutes of your time. Download the supplied ZIP file, and extract it on your personal computer. Open the README.html in your web browser file for full installation instructions. No PHP code modifications are required as this script makes use of the new vBulletin XML Product system.

Support
Support is provided by RaiderSoft for this script provided you have a Platinum or Enterprise SigmaChat account. Read the included instructions for details. Please let us know if you have any problems installing this extension.

Updates
8/12/05 - vbsc7400_101.zip uploaded fixing the auto-login problem. To update from the previous release, simply download and extract the new archive and copy the 'chat.php' file to the root directory of your vBulletin forum. No other changes are required.
8/13/05 - vbsc7400_102.zip uploaded fixing minor issue with displaying users currently chatting. This may have effected all users using a custom table prefix.
10/5/05 - vbsc7400_103.zip uploaded fix minor issue relating to table prefixes. This script now been fully tested with VB 3.5.0 Gold.
10/17/05 - vbsc7400_104.zip uploaded. Users experiencing problems with table locking or the who's chatting list should download and install this update.

Screenshots are attached.

[mutus123]

Grim77 thanks for this, I am waiting until gold to upgrade from 3.0.7 to 3.5.

Quick question... is there anything I need to un-do or remove from the previous sigma integration on 3.0.7, prior to upgrade? I assume the upgrade will over-write at least portions of the previous sigma hack modifications.

Or can I just go ahead and upgrade vBulletin, and then install this new sigma integration on to that, without worrying about the previous sigma hack?

[LittleBoy1]

Hello, I have problems when installing the PlugIns, leaves this to me:

Warning: Invalid argument supplied for foreach() in /includes/functions.php

Buaaa =(

[Grim77]

I would just upgrade vBulletin, then reinstall the script -- should work like a charm

Originally Posted by mutus123

Grim77 thanks for this, I am waiting until gold to upgrade from 3.0.7 to 3.5.

Quick question... is there anything I need to un-do or remove from the previous sigma integration on 3.0.7, prior to upgrade? I assume the upgrade will over-write at least portions of the previous sigma hack modifications.

Or can I just go ahead and upgrade vBulletin, and then install this new sigma integration on to that, without worrying about the previous sigma hack?

[mutus123]

Originally Posted by Grim77

I would just upgrade vBulletin, then reinstall the script -- should work like a charm

Beautiful!! Thank you so much.

That last sigma integration I installed also worked flawlessly!

[RMS-Chef]

Originally Posted by Sleepyk

You have to pay for this chat though so why get it?

Mainly due to the fact that local hosted chat scripts can put quite a strain on your server. FlashChat is adding quite a load as well as becoming a bit buggy when I get more than 20 or so users chatting at once. To many people, like myself, paying a mear $8/mo to offload all of the additional server strain is well worth it.

[Eladesor]

I've posted this error on your 'support forum' along with a couple of other people - but no-one seems to want to answer.....

While installing the SC integration script, my forum gives this error after I complete step 6 (add product product-sc7400.xml) of the instructions:
Table 'scwho' was not locked with LOCK TABLES

Any ideas please?

[cylosoft]

Originally Posted by Eladesor

I've posted this error on your 'support forum' along with a couple of other people - but no-one seems to want to answer.....

Any ideas please?

Mine is doing the same thing.

[ninermac]

Originally Posted by cylosoft

Mine is doing the same thing.

Same problem with mine as well. The fix is to change (in product-sc7400.xml) from

$chatcount_q = $vbulletin->db->query_first("SELECT COUNT(ID)  FROM scwho");

to

$chatcount_q = $vbulletin->db->query_first("SELECT COUNT(ID)  FROM  " . TABLE_PREFIX . "scwho");

[Grim77]

Hello,

An update to this script was made today to resolve the problems relating to SQL errors (specifically a problem in the XML file where table prefixes weren't being used where they should have been).

Additionally, the script has now been fully tested with vBulletin 3.5.0 Gold

To upgrade from a previous 3.5.x based release, simply upload the new product-sc7400.xml file, replacing the old product install.

[moonclamp]

my "who is chatting page" is stretched beyond 1024 pixels for some reason. I've looked at the template but can't quite figure it