So do you want to grant permission to use the chat or the ability to ban someone that mis-uses the chat.farazhamzaa wrote:its my 3rd post but yet didnt any reply..
how can we block a register user from mchat
is it possible ??????????????????????????????????????????????????
I am going to BUMB my own post as this looks like it is being supported from a different source..Petesat wrote:I tried and tried to install this with no luck..
I wasted 12 hrs playing with the jQuery settings, and tried all kinds, read the script you posted..If this really is an issue, and it seems it is for many, why did you not make the file without the $ in it at all, at least that way there is no way for others human error.
Until this has a fix, I will not bother with it, and I suggest the same for others.
My forum has a lot of mods on it, and there is no way of knowing if there is conflict betweem them..
Pete
Code: Select all
SQL ERROR [ mysql4 ]
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 '', user_colour varchar(6) co [1064]
SQL
CREATE TABLE phpbb_mchat(message_id mediumint(8) unsigned NOT NULL auto_increment, user_id mediumint(8) unsigned NOT NULL default '0', username varchar(255) collate utf8_bin NOT NULL default '', user_colour varchar(6) collate utf8_bin NOT NULL default '', user_ip varchar(40) collate utf8_bin NOT NULL default '', message mediumtext character set utf8 collate utf8_unicode_ci NOT NULL, bbcode_bitfield varchar(255) collate utf8_bin NOT NULL default '', bbcode_uid varchar(8) collate utf8_bin NOT NULL default '', bbcode_options tinyint(1) unsigned NOT NULL default '7', message_time int(11) unsigned NOT NULL default '0', PRIMARY KEY (message_id)) DEFAULT CHARSET=utf8 COLLATE=utf8_bin
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()
FILE: mchat.php
LINE: 120
CALL: dbal_mysql->sql_query()
Tell your host to update to MySQL5. No one even uses 4 anymore.NarayanGR wrote:I was setup this on my localhost server with Mysql 5 and worked fine, but on my host that runs Mysql 4.0.6 I'm getting this error:
What can I change to work with that version of mysql?Code: Select all
SQL ERROR [ mysql4 ] 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 '', user_colour varchar(6) co [1064] SQL CREATE TABLE phpbb_mchat(message_id mediumint(8) unsigned NOT NULL auto_increment, user_id mediumint(8) unsigned NOT NULL default '0', username varchar(255) collate utf8_bin NOT NULL default '', user_colour varchar(6) collate utf8_bin NOT NULL default '', user_ip varchar(40) collate utf8_bin NOT NULL default '', message mediumtext character set utf8 collate utf8_unicode_ci NOT NULL, bbcode_bitfield varchar(255) collate utf8_bin NOT NULL default '', bbcode_uid varchar(8) collate utf8_bin NOT NULL default '', bbcode_options tinyint(1) unsigned NOT NULL default '7', message_time int(11) unsigned NOT NULL default '0', PRIMARY KEY (message_id)) DEFAULT CHARSET=utf8 COLLATE=utf8_bin BACKTRACE FILE: includes/db/mysql.php LINE: 174 CALL: dbal_mysql->sql_error() FILE: mchat.php LINE: 120 CALL: dbal_mysql->sql_query()
If I responded I would be off topic and hijacking worse than that. Not about the pron, but about the monkey comment.jimcarrel wrote:I guess some people are proud of Porn. Maybe some did descend from monkeys