Chat Modifications - Digital Point Chat

About
This is a simple, pseudo realtime chat system for vBulletin 4.

I tossed this together today real quick as a test of something and figured that people might have some use for it.

Installation

• Put the chat.php file in your forum folder.
• Put the digitalpoint_chat.js file in your clientscript folder.
• Install the product-dp_chat.xml product under AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product

You can find setting for it under AdminCP -> Options -> Settings -> Digital Point Chat

It has full unicode support so non-latin based languages work as well.

[Winter Sonata]

Originally Posted by digitalpoint

Did you try at chat.php?

Sorry, what should I try at chat.php ?

[Dave Hybrid]

Hi Shawn,

Can you help me with the install please.

---

Chat messages do not display

Getting this DB error:

Any ideas?

Database error in vBulletin 4.1.7:

Invalid SQL:

			SELECT chat.*, user.username, user.usergroupid, user.displaygroupid, user.infractiongroupid, user.membergroupids, IF(LENGTH(customavatar.filedata) AND customavatar.width AND customavatar.height, 1, 0) AS has_avatar, customavatar.dateline AS avatar_dateline
			FROM tfdigitalpoint_chat AS chat
				LEFT JOIN tfuser AS user ON (user.userid = chat.userid)
				LEFT JOIN tfcustomavatar ON(customavatar.userid = user.userid)
			
			ORDER BY chatid DESC
			LIMIT 50;

MySQL Error   : Unknown column 'customavatar.filedata' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 26th 2011 @ 02:55:01 PM
Error Date    : Wednesday, October 26th 2011 @ 02:55:01 PM
Script        : http://www.travel-fans.com/chat.php?do=ajax
Referrer      : http://www.travel-fans.com/chat.php
IP Address    : 62.255.192.162
Username      : Hybrid
Classname     : vB_Database
MySQL Version : 5.5.17-cll

[jchaffin]

Having the same issue as some others. Submitted chat does not show up. Running 4.1.2.

***Nevermind it is working now. Great mod. Thanks.

[digitalpoint]

Originally Posted by Dave Hybrid

Hi Shawn,

Can you help me with the install please.

---

Chat messages do not display

Getting this DB error:

Any ideas?

Database error in vBulletin 4.1.7:

Invalid SQL:

			SELECT chat.*, user.username, user.usergroupid, user.displaygroupid, user.infractiongroupid, user.membergroupids, IF(LENGTH(customavatar.filedata) AND customavatar.width AND customavatar.height, 1, 0) AS has_avatar, customavatar.dateline AS avatar_dateline
			FROM tfdigitalpoint_chat AS chat
				LEFT JOIN tfuser AS user ON (user.userid = chat.userid)
				LEFT JOIN tfcustomavatar ON(customavatar.userid = user.userid)
			
			ORDER BY chatid DESC
			LIMIT 50;

MySQL Error   : Unknown column 'customavatar.filedata' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 26th 2011 @ 02:55:01 PM
Error Date    : Wednesday, October 26th 2011 @ 02:55:01 PM
Script        : http://www.travel-fans.com/chat.php?do=ajax
Referrer      : http://www.travel-fans.com/chat.php
IP Address    : 62.255.192.162
Username      : Hybrid
Classname     : vB_Database
MySQL Version : 5.5.17-cll

In chat.php, change this:

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "customavatar ON (customavatar.userid = user.userid) 


to this:

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid) 


[Dave Hybrid]

Sorted, thanks!

On another note are you releasing your best answer mod here at all?

That one looks sweet too.

Dave.

[digitalpoint]

No sorry... have to keep some stuff or else my site wouldn't be unique.

I think there is an addon here at vb.org that does something similar though.

[Winter Sonata]

Thanks Shawn .....

I ave a custome style and the chat doesn't show up anywhere, any ideas ?

[Dave Hybrid]

Hey Shawn,

Is it possible to include avatars like on DP?

Also is it possible to stop the 'entering' and 'leaving' messages, they clog the window up on my forum.

[digitalpoint]

I thought avatars were included? Hmmm... can you give me a link to where you have it installed?

[Dave Hybrid]

Sure here two

http://www.travel-fans.com/chat.php

http://www.computer-juice.com/forums/chat.php

Thanks!