vB Chatbox 1.2.4

What this hack does : Adds a box on top of your vB home page
where all members can chat/shout in an IRC like way, with all the
vB options added (smilies, vBcodes....)

I started this hack by modifying the shoutbox made by Doug
Tanner for phpnuke (i think).. And it went far far from his original
code. As far as i think he wouldn't recognize it .

I integrated it as far as i could with vB, and in the admin CP,
with every bit of it being possible to modify trough the admin
CP (prune, ban, censure...)...

SCREENSHOT

This hack has been tested and used by some people out
there in france .

1.2.4 changes :
Install problems with the mysql reserved words solved,
Uninstalling option added to the install script,
Possibility to automaticaly add the templates to the
templatesets you chose in the install script,
IE6 problem with divs solved,
timezoneoffset mod integrated,
text input limited to 255 characters.

1.2.3 changes :
security hole on the pruning of the admin part fixed.

1.2.2 changes :
templatesused var filled with all templates used by the
script in the shoutbox.php file and in the index.php file.
And chmod 777 made on the admin/shoutbox_config.php file
by the install script. Thanks to erwin

Name changed from shoutbox to chatbox, because some people
thought of this hack as related with TWT-commish's shoutbox...
no more excuses


Here is some sort of [high]FAQ[/high] from all the thread,
hope this helps, and prevents you from reading all that i just read :

[high]#----------------------------------------------------------#[/high]
Erwin : limit of smilies a person can post in the shoutbox.
This is to prevent smilie spamming : HERE
[high]#----------------------------------------------------------#[/high]
Erwin : Another tip for installers - instead of manually having to
ban users in the shoutbox, to automatically ban users who
you have already banned from the forums : HERE
[high]#----------------------------------------------------------#[/high]
For the shoutbox to be in a popup : HERE
[high]#----------------------------------------------------------#[/high]
To have 5 'shouts/chats' visible when the chatbox is reduced :
HERE
[high]#----------------------------------------------------------#[/high]
SpeedStreet : This simply creates a link for people to click on so
that they can easily view the 'Who's Online' page without
having to dig for it : HERE
[high]#----------------------------------------------------------#[/high]
ThoughtDiver: if you want the date format on the shout timestamps
to read Month/Day instead of Day/Month : HERE
[high]#----------------------------------------------------------#[/high]

[Erwin]

Btw, it's 5 am here in Melbourne, Australia. I need to go and sleep. I have really no idea why the installer cannot find the file, if you have uploaded all the files. Make sure that the shoutbox_config.php is chmod to 777. I have to go now. good luck!

[havefun]

thanks!

i will give it a try!
good night! nice dreams...

edit:
i've reinstalled all, deleted the files in mysql
& started again..

don't know why it hasn't worked the first time...

it works now!!! :banana:

[Anitah]

Erwin, this is a great hack, thank you. I installed this in a test database and it all went well. Only had to change the chmod to 777 in the shoutbox_config file and all went without a hitch.

The trouble is that I can't seem to get this to work in my regular database. I've installed and uninstalled three times and I am repeatedly coming up with this error message (yes, I deleted the shoutbox files in the database before I reinstalled, yes, I've tried it with the new templates installer, it just gave me more errors...

the error for the original install is as follows:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `shoutbox` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL default '', `comment` TEXT NOT NULL, `date` VARCHAR(30) NOT NULL default '', PRIMARY KEY (`id`))
mysql error: Table 'shoutbox' already exists

mysql error number: 1050

Date: Friday 27th of September 2002 02:11:05 AM
Script: http://www.mydomain.com/forum/forum/...ll.php?etape=1
Referer: http://www.mydomain.com/forum/admin/...ox_install.php

Is it saying the shoutbox already exists because it somehow connects to the test database? (again, I've repeatedly deleted the forum "home" database and started fresh).

And why does the script show double "forum/forum" ?

Sorry if this doesn't make sense, but I'm confused.


:ermm:

[havefun]

first of all:

i really like this hack!!!
works 4 me fine on 227 :banana:

had some probs so this could help u out!!!

havefun

[Anitah]

Thank you, but that didn't solve the problem I'm having in the database.

WHen I run a query, as you said, it returns this error:

Error

SQL-query :

ALTER TABLE user
ADD shoutbox TINYINT DEFAULT 1 not null

MySQL said:

Duplicate column name 'shoutbox'

What seems to be happening is this: if you start the install clean it works, but if for some reason you interrupt the process, delete the templates from your database and start again, it tells you "shoutbox" already exists. I don't see it anywhere, and I don't know what needs to be deleted or where, in order to start with a clean slate.

Anybody?

[Erwin]

I suspect all of you are moving from TWT's shoutbox. You need to delete the old table shoutbox and the column shoutbox in the user table using PHPMYADMIN. Then reinstall the database. Each time it says - "duplicate table or column".

Also, you cannot run the installer again and again - it will keep trying to put in the db tables and columns, which it can only do once. To skip to just the templates, use the template installer above.

[Anitah]

Erwin, that's exactly what I did - I removed shoutbox and the shoutbox column in PHPMYADMIN. Reinstalled again, got the same 1060 error.

Then using the shoutbox_installer_templates you gave, I get another error:

') mysql error: You have an error in your SQL syntax near ''shoutbox','

I'm completely stumped.

[Anitah]

I forgot to mention, above the mysql 1060 error message there is also this:

Warning: chmod failed: Operation not permitted in /home/channelv/mydomain/forum/admin/shoutbox_install.php on line 62

[havefun]

Originally posted by Anitah
WHen I run a query, as you said, it returns this error:

Error

SQL-query :

ALTER TABLE user
ADD shoutbox TINYINT DEFAULT 1 not null

MySQL said:


Duplicate column name 'shoutbox'


What seems to be happening is this: if you start the install clean it works, but if for some reason you interrupt the process, delete the templates from your database and start again, it tells you "shoutbox" already exists. I don't see it anywhere, and I don't know what needs to be deleted or where, in order to start with a clean slate.

Anybody?

go to PHPMYADMIN on your database:

delete these 3 tables-->

shoutbox
shoutbox_ban
shoutbox_swears

and go to the table "user"
and delete the field shoutbox ...

perhaps you've forgotten to delete "shoutbox" in the table user
that could was the reason for getting the error massage on this
sql-query: ALTER TABLE user
ADD shoutbox TINYINT DEFAULT 1 not null
because it was already there...

I forgot to mention, above the mysql 1060 error message there is also this:

Warning: chmod failed: Operation not permitted in /home/channelv/mydomain/forum/admin/shoutbox_install.php on line 62

had the same, just chmod it to 777 with your upload manager...

hope this helps!

[Erwin]

That's what I told him, havefun.