Digital Point Chat

[digitalpoint]

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.

[cam2]

Very nice!

[GrAveTzT]

Excellent mod.

[dall100]

Great mod, just what I wanted

[mikey1991]

I knew someone would ask for a vBulletin 3 version, so I 'backported' this with Shawn's (digitalpoint) permission :)

it's attached. I made some minor graphical tweaks, so when you install it will look different to the screenshot (No black lines anymore), and I make NO guarantee or warranty with this, if your forums blow up because of it, this disclaimer makes me blameless (I'm not saying your forum will blow up)


124029

[ProFifaLeagues]

What sort of load will this type chat use up on the hosts end????
Looks good will give it a whirl today and see what the user think of it!
Thanks

[James T Brock]

Any particular benefit/difference between this and some of the other shoutbox mods out there or is this just an alternative?

[preemz10314]

nice. works on 4.0.7 are there any mod controls? to say kick scrollers and trolls?

[Kolbi]

What sort of load will this type chat use up on the hosts end????


That?s a very interesting point.

[digitalpoint]

What sort of load will this type chat use up on the hosts end????
Looks good will give it a whirl today and see what the user think of it!
ThanksNot much, but there are settings to adjust how often it polls.

Any particular benefit/difference between this and some of the other shoutbox mods out there or is this just an alternative?No idea, never looked at any others.

nice. works on 4.0.7 are there any mod controls? to say kick scrollers and trolls?Already on the to-do list for future.

[ProFifaLeagues]

Cheers DigitalPoint

[FReeSTER]

Anyway to put this chat in a subforum instead of forumhome ect.... I will like to have a chat in the administrador section but i havent seen one yet in vb.org with those essentials or tools

[digitalpoint]

Being able to break it apart into private chats (future version I mentioned before), will also have the ability to have separate public chats that are isolated (for example one for each sub-forum if you wanted).

[ProFifaLeagues]

Being able to break it apart into private chats (future version I mentioned before), will also have the ability to have separate public chats that are isolated (for example one for each sub-forum if you wanted).


Come in very handy when that version is released mate Great work

[FReeSTER]

Being able to break it apart into private chats (future version I mentioned before), will also have the ability to have separate public chats that are isolated (for example one for each sub-forum if you wanted).

WoW thank you bro, cant wait for that version to be released, you have gain a Donator for sure. :)

[argothiusz]

Is there anyway to display this chat board on another site?

Thanks :)

[cc8balla]

Would also LOVE this, if we could throw it in the forum sidebar in a block. Any easy way to do so?

[digitalpoint]

Not in it's current for... but as I mentioned, I have a pretty big to-do list for a future version.

[Alfa1]

One function that would be a life saver is to let users report chats. The report would then be auto-posted in the post report forum, similar to other vbulletin reports. It would be nice if the report would link to the chat log.

[8thos]

How to make this as a CMS or Forum Sidebar Widget?

[marshal_ramdev]

thnx Shawn ..

[final kaoss]

So is this thing going to be well optimized (and not a resource hog)... or is that something on the to do list for a future version?

Not in it's current for... but as I mentioned, I have a pretty big to-do list for a future version.

[digitalpoint]

It shouldn't be a resource hog at all. Ran some test with over 1,000 people in the chat and couldn't tell the difference as far as server loads.

[ProFifaLeagues]

Sorry did'nt see the answer but is there a way to show this just inside a forum section or is it only the forum homepage for now?

[MalluParadise]

When i install this mod i got a error like this .....

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/global.php(29) : eval()'d code on line 61


how can i fix it ?

[digitalpoint]

When i install this mod i got a error like this .....

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/global.php(29) : eval()'d code on line 61


how can i fix it ?You are using an old version of vBulletin I assume? That was a bug they fixed in vBulletin itself.

[MalluParadise]

You are using an old version of vBulletin I assume? That was a bug they fixed in vBulletin itself.

ohh i am using Vb- 4.0.7

[indyonline]

Thanks for this Shawn.
I do not see it in any of my nav bars. How do I get it there?
Thanks again.

[Reinhard]

Hello Shawn,

i have installed this mod, but nothing is display in the chat window. The installation was succesful, the submitted text is store in the table, the chat window is empty ...

I'am use 4.08 and standard template.

Edit: in Line 90 in your chat.php is "AS customavar" is missing ... (database error). German umlauts not displayed ... Please fix it.

[sivaganeshk]

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_digitalpoint_chat AS phrasegroup_digitalpoint_chat,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

Got an error :(

-------------------------------------
Btw, you already have Great reputation in SE, so why you still have Chat system by Digital Point ? :P

[digitalpoint]

What does it say the actual error is with the query.

[sivaganeshk]

What does it say the actual error is with the query.

It was db connection error.
I reinstalled the mod, worked fine. Thanks :D

Moreover, you could have made the Chat in the Forum bar.

like Home, Forum, Chat, What's New ?

Btw, Is it legal to remove copyright ?

[digitalpoint]

You can add a link to the navbar for it if you want. Just didn't seem important enough to do it by default is all. You can not remove copyright, sorry.

[blankpage]

Install it! Great :)

[sivaganeshk]

Thanks for the reply. One more question(definitely the LAST one)

"Can we the time display(currently near the username) to the end ?
If no, pls add this in the notes for your future update :) "

[Hawkmaster]

Installed, Thank you Shawn!:)

[Hawkmaster]

I have tried everything and it is just blank and will not add any text. Any ideas please?
www.falconryforum.co.uk/chat.php

[digitalpoint]

I have tried everything and it is just blank and will not add any text. Any ideas please?
www.falconryforum.co.uk/chat.phpIt's for vBulletin 4.x only.

[Da-Vinci]

Hi Digital point, I've installed it and if I go to myurl/chat.php it displays but it doesn't display in my forumhome template, do I need to place a hook in the templates anywhere to call it?

Also I tried to add it in an Iframe but that was also unsuccessful.

[digitalpoint]

It's not designed for embedding into other pages.

[final kaoss]

DP, I thought of an idea for this mod. You know how some chat products have "chat archives"? I think it would be a good idea if you implemented an "archive" type system for this. For example, each day it creates a thread, like "dp chat 1-30-2011" and dumps all of the "chats" for the day/week/month etc. in there and on the chat archive page, have it link to the pages.

[cindy helmond]

nice one but can we add smilies ? and remove message as an admin ?

[huskermax]

I tagged this one. When there are mod controls that allow me and the mods to ban and kick and edit the chat I will try it out. I like it so far. I am looking for a chat that will allow my not registered/not logged in user group to chat. Can't find one that is easy to deal with so far.

[jitsuboy]

Could someone PLEASE explain where this is: Put the digitalpoint_chat.js file in your clientscript folder.

Where is this clientscrpit folder?

Usually I upload using FileZilla to my host, but this is different?? Thanks!

[smaacom]

Could someone PLEASE explain where this is: Put the digitalpoint_chat.js file in your clientscript folder.

Where is this clientscrpit folder?

Usually I upload using FileZilla to my host, but this is different?? Thanks!

in your forum folder

[cs28702]

Thanks for the mod. I have always loved your site , and always look to it when I upgrade my vbulletin.

What I want from a chat module, is the ability to set it on a timer. Make it available only during certain hours. For example, on my site, primetime is between 5 and 9pm central time. Any chance of adding that? Any other time, it would just display a message "chat only available between hours of ...."

This would be of great use to me

[tlwwolfseye]

How can I clean out previous chat, like a prune function ? Otherwise til there is some like that in this Mod, the list will be long as hell. At least a general prune function should be there.

Otherwise I like it very much :)

[jitsuboy]

I've installed, but the thing is the chat only shows up when i go to myurl.com/chat.php
How can I get it to just show up, or to make a tab? Can I even put it into my CMS page?? please help!

[digitalpoint]

It's a standalone page, it's not a shoutbox or something you can embed on to a different page.

[jitsuboy]

So how will the people logging into my forum know that they have to type in the url "mysite.com/chat.php"? They are only going to log into "mysite.com"

Thanks

[digitalpoint]

You could put a link to it if you want, or they could use it under Quick Links.

[HouseAddict]

digitalpoint, don't you see the pattern with the questions here?

everyone wants to know how could we actually embed this on the page somewhere... or at the very least, have it as a CMS widget or something?

[jitsuboy]

You could put a link to it if you want, or they could use it under Quick Links.

could you tell me how to put it on Quick Links?

[digitalpoint]

Should be automatic when you install it.

[PWO81]

do comments in the chat count toward post counts?

[3amalah]

Thanks Its Amazing Could You Tell Me How To Adjust Encoding To Work On Arabic Sites ?

[digitalpoint]

do comments in the chat count toward post counts?No... they don't.

[digitalpoint]

Thanks Its Amazing Could You Tell Me How To Adjust Encoding To Work On Arabic Sites ?It works fine with arabic as long as the charset for the site is UTF-8.

[owensbt]

I am on vBulletin Version 4.1.1. Installed smoothly, but I don't see any text when I hit submit.

http://community.truefaced.com/chat.php

(thanks for this mod, by the way)

[marketing91]

Hii. Is there any way to show this excellent chat in the sidebar of Vbulletin??? Its not taking any load time and it would be excellent to initiate conversations :)

[Kingdombuilder]

I am on vBulletin Version 4.1.1. Installed smoothly, but I don't see any text when I hit submit.

http://community.truefaced.com/chat.php

(thanks for this mod, by the way)

I have the same problem... It shows up fine but will not post my message in the chat box when i type it. i have the user groups set properly... I'm runing 4.1.2

[sross]

seems to work ok on my 4.1.3 but i get no avatars. my wishlist for next version:

-ability to scroll and maintain a longer history
-who's in the chat
-smiley support
-enter a purge command to blank the chat

thanks

[tbworld]

Thanks so much for taking the time to post this code Digital Point. I was looking for simple: very little load time and load on the system. We use this like we would "twitter". Example: "Hey: I will be back on at 8:00 pm" . PS: I do not run a public board so we keep it informal.

I read the posts in the forum and it seems that people did not understand the reason you posted the code. So I wanted to give you a little praise. Thanks Again!

[tvguy347]

How do I get this onto the main forum page?

[MrD]

Hi,
if it?s possible to Open the Chat in a new Window ?
So the User can Chat and read the Forum at the same time :D

[digitalpoint]

I don't see why not, is it not letting you?

[MrD]

Hi,
the chat open in the same Window and works good.
But Users wish, that it open on a new page.
how can i make this?

[digitalpoint]

Could just change the target on the a href tag... although if they want to open it in a new window, why don't they? :)

[Winter Sonata]

Thanks Shawn .....

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

[digitalpoint]

Did you try at chat.php?

[Winter Sonata]

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]

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:
LEFT JOIN " . TABLE_PREFIX . "customavatar ON (customavatar.userid = user.userid)
to this:
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!

[digitalpoint]

What type of avatars are they? I believe it only works with custom avatars that are stored in the database.

[Dave Hybrid]

All custom avatars. Stored in the file system i believe.

[Dave Hybrid]

One other thing shawn, is it possible to have the chat log held for longer, it seems to delete after a period of time. Thanks!

[digitalpoint]

It keeps stuff for an hour... if you want to make it longer, you can edit the "Clean Up Chat Table" plug-in and change "3600" to however many seconds you want to keep stuff.

[Dave Hybrid]

Perfect, thanks.

[Dirt Bike Addict]

Got the following error:

Database error in vBulletin 4.1.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_digitalpoint_chat AS phrasegroup_digitalpoint_chat,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vb_language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_digitalpoint_chat' in 'field list'
Error Number : 1054
Request Date : Monday, November 14th 2011 @ 10:42:50 PM
Error Date : Monday, November 14th 2011 @ 10:42:50 PM
Script : http://www.domain.com/forum/chat.php?do=ajax
Referrer : http://www.domain.com/forum/chat.php
IP Address : ***
Username :
Classname : vB_Database_MySQLi
MySQL Version :

[digitalpoint]

Did you restore a partial backup or anything? Looks like the phrase group that it comes with isn't there any longer.

[Dirt Bike Addict]

Did you restore a partial backup or anything? Looks like the phrase group that it comes with isn't there any longer.This was after a clean install of the chat mod.

[Dirt Bike Addict]

Well that was odd, the phrase error went away but then I got this error (that fix worked).
https://vborg.vbsupport.ru/showpost.php?p=2261703&postcount=72

[Dirt Bike Addict]

I do have one more thing that I'm having trouble with, I'm trying to reverse the chat order (newest at top) and got the PHP part of it working. However I know zlich about JS/AJAX and can't seem to get it to put the new chats at the top, they still get added to the bottom. (they'll be at the top after a page refresh though).

Any ideas?

[paulket]

I have the same problem... It shows up fine but will not post my message in the chat box when i type it. i have the user groups set properly... I'm runing 4.1.2

Having the same problem with 4.1.8

Has anyone figured out how to fix this?

[paulket]

This mod obviously is not supported and I will unfortunately have to uninstall it :( I wish that it worked.

[luismoreira]

friend, need to put this chat on the side blocks.

That would be possible?

Would have to use iframe?

[rbc1225]

Chatbox comes up but when I place text and hit the submit button, nothing happens. Doesn't seem as though there is too good of support here since no updates since December and it is now March, but any help would be appreciated.

[ekool]

It would be nice if it showed who was "online" in the chat.

[datoneer]

Awesome mod!

[lapiervb]

Doesn't put a link anywhere to go to the chat in vb4.2

[lapiervb]

Anybody figure out how to add the link?

[pelican]

Having the same problem with 4.1.8

Has anyone figured out how to fix this?

Chatbox comes up but when I place text and hit the submit button, nothing happens. Doesn't seem as though there is too good of support here since no updates since December and it is now March, but any help would be appreciated.



you need to do the following fix

In chat.php, change this:
LEFT JOIN " . TABLE_PREFIX . "customavatar ON (customavatar.userid = user.userid)
to this:
LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid)

[Swatman1]

I followed the steps and i can change the chat settings in my admincp options, yet the chat does not show up on my forum. Are there more steps i missed other than from the first post?

[ZUCCO]

I followed the steps and i can change the chat settings in my admincp options, yet the chat does not show up on my forum. Are there more steps i missed other than from the first post?

Same here, I uploaded everything as it said but it doesnt work. I disabled my previous vsa chatbox to try this one.

[billstelling]

look in the community tab..

[dartho]

you need to do the following fix
and also edit the digitalpoint_chat template and change the jquery to be https

change
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
to
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>