[Add-on] AJAX Chat 2.0.0 Beta

[Daan Daan Janssen]

when do you think you'll releasi it?

[Highway of Life]

I think he said Sunday...

[bare cd4]

ok, i will help wait for sunday

have the same problem......

[Handyman]

Ok... I downloaded Beta 5 so I can test it and fix any issues with Beta 5

[GroovePlugs]

Handyman, how about making scripts for the chat mod similar to Adium Scripts?
I'm specifically thinking of the brb script! If you don't know what I'm talking about, I'll explain further

[bare cd4]

@ handyman,

I have installed youre updated scripr for the chatmod, but still no luck.
chatbox apears but I am still not able to enter txt.
do you have anny idee what i'm doing wrong???
cleared cache and all but nothing helps

running phpbb 3b5

[Handyman]

I'll have to test this on Beta 5... I'll see if I can do it today.
That is the second report of it not working on Beta 5.

I'll let you know when I have it together... I was hoping I would get it done yesterday... but deadlines got in the way.

@Major Hochstetter
I know exactly what you are talking about... I'll add that feature, but not until much later in development.

[Highway of Life]

Handyman... STG is Beta5.

[Handyman]

OH! I seemed to have missed that tiny detail.
It's working perfectly on the index page.
I'm gonna do a fresh install on a fresh Beta 5... then package it, just to make sure it's all good.

[maveric]

Hello all,

i get this sql error message when installing the chat ...

Mysql Message:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_bin NOT NULL default '',
message text collate u

this is the code

Code: Select all

CREATE TABLE phpbb_chat(
message_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
chat_id int( 11 ) unsigned NOT NULL default '0',
user_id int( 11 ) unsigned NOT NULL default '0',
user_name varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
message text COLLATE utf8_bin NOT NULL ,
bbcode_bitfield varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
bbcode_uid varchar( 5 ) COLLATE utf8_bin NOT NULL default '',
bbcode_options tinyint( 1 ) unsigned NOT NULL default '7',
post_time int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `message_id` )
)

mysql version: MySQL 4.0.24-Max-log
phpmyadmin: 2.6.4-pl3

Help ...

Thanks Maveric

EDIT:
i found the answer ...

the new code for my version

Code: Select all

CREATE TABLE phpbb_chat(
message_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
chat_id int( 11 ) unsigned NOT NULL default '0',
user_id int( 11 ) unsigned NOT NULL default '0',
user_name varchar( 255 ) NOT NULL default '',
message text NOT NULL ,
bbcode_bitfield varchar( 255 ) NOT NULL default '',
bbcode_uid varchar( 5 ) NOT NULL default '',
bbcode_options tinyint( 1 ) unsigned NOT NULL default '7',
post_time int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `message_id` )
)