fleccy - do you have a timescale for the next version? The key feature for me is the ability to /kick people as without this we cannot really moderate properly.

My suggestion would be to store a 'kicked <date>' in the perms database field in the user table (where <date> represents the date they were kicked). You could test this variable when entering chat (as you do when someone is an admin) and stop someone entering chat if <date> = todays date. (If <date> was not equal to todays date then you would reset this field.) This would stop someone who had been kicked from reentering till the start of the next calendar day.

Another nice feature would be an 'invisible mode' (for admins only) so they could watch the chat without being shown as being in it. I've seen this on a few PHPmyChat boards previously.

Sorry to be a pest - it's a great hack so far :)

it wont be long because well it's half working and this is my main project at the moment :) damn school...

Don't worry about school - never did me any good.

(Well, apart from the nice job, house, car, family etc.) :D

fleccy,

any update on when this might be available? It's the last thing I need working before I can move over to VB3 (after the new excellent Arcade hack that is available :D)

thanks

James

Indeed, i just gave this a shot and have countless SQL errors. im hoping to get this on before we move servers.

muse,

what errors are you getting? I'm running on a test board without problem.

Are you using the 2.3 version or the version 3 one in this thread?

Any chance of this working for RC3?

Works fine with RC3. Just not the Admin part.

could be dreamweaver, i edited the files in that. ill give it another shot. the errors were:

Database error: Invalid SQL: UPDATE c_users SET u_time = 1075368298 WHERE room = 'Default' AND name = 'James'
MySQL error: 1054 (Unknown column 'name' in 'where clause')
Session halted.

Database error: Invalid SQL: SELECT usr.name, usr.latin1, usr.status, reg.gender FROM c_users usr LEFT JOIN user reg ON usr.name = reg.name WHERE usr.room = 'Default' ORDER BY name
MySQL error: 1054 (Unknown column 'usr.name' in 'field list')
Session halted

thankfully its the test board.

i think i missed a query somewhere

Any news on this hack yet? I'm really looking forward to it being a stable release as my users are desperate for a nice integrated chat room. :)

Question: Do you need to have your own copy of phpmychat for this or is it all included in the hack?

Yes you do.

it's all included in the hack it's like a total conversion

fleccy,

any update on when Mod stuff will be possible? Sorry to hassle - I'm hoping to go live with v3 next weekend.

James

OK Fleccy - managed to get the /kick function to work, but am not sure if this represents a security risk :

in kick.cmd.php change

to

it seems to be the password checking that was causing the kick function to fail - does the password need to be rechecked at this point anyway as the user is already logged in to chat?

sorry ive been away im very busy with school and others things so i wont be able to work on this as much as id like to but yeah nice job saves me the time teling every one lol :)

This code also needs changed in the promote and ban functions. After this, the whole thing works very well. Do you want me to package it back up so you can re-release the original zip?

sure i appreciate it :)

Hello,
i have problems with the chat.
i have installed how it standing in the installfile.
Now i become a white site of www.euroawm.com/board/chat.php
Please can u help me?

P.S I have the VB 3 RC3

Do you have this yet?

Hey,
This is awesome..install flawlessly..Wish the admin issue was resolved but I'm sure you are working on it, as it blows everything else out of the water..there is one thing..when I try to edit the english welcome message i get this when logging in,

Database error: Invalid SQL: INSERT INTO c_messages VALUES (1, 'Default', 'SYS welcome', '', '1076565793', 'dartmoore', 'sprintf("Welcome to Shadow Company's Internal Chat")')
MySQL error: 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 's Internal Chat")')' at line 1)
Session halted.

hit refresh and chat loads w/o(without) the welcome..I can restore the file to original and all is ok..

any ideas..only changed text between the quotes..

Dartmoore - looks like a problem with having quotes in the text you are trying to insert.

You need to use \' for a single quote. Try the following.

or he wiped out his config.lib.php post it here so we can see :)

it was the quote and the above did not work..just took it out and it worked fine..

Ok, after further research I got it to work..you had it except it is a backslash instead of a forward slash..thnx for pointing me in the right direction..

second note..is there a time frame to get the admin login issue fixed?

thnx dart

that's what I said! ;)

Ok, didn't do none of the mod's for admin, but it's running fine on rc4, just wanted to let you all know.

One note to the coder of this fine chat, think you should fix the template or at least add instructions to the install file, so ppl know to edit the path.

Thanx, nice hack.

thanks :)

The admin functions don't prevent the chat from running. All they do is allow better management of chat permissions through VB usergroups. (such as banning a certain usergroup from using chat, or assigning a group as chat moderators).

Also, I dont believe some of the mod functions (such as /kick) work properly with usernames with spaces in them at the moment.

I've made a few tweaks to the software which I've sent to fleccy to do some of the above. I've got a few more bits to finish off, after which I'll send him a new build. All working OK on my site at the moment though.

yeah thanks for helping m8 :D

Just installed and get this error...

....any ideas?

I dont have a "user" table in my database, which is specified in your first query.
Wouldn't I have to create the table "user" before I can alter it? If have a "c_users", but no "user"

ok I got a demo goin on RC4,
user: Chat_Guest pword:guest

http://www.newsoutlet.info/forums/index.php

still not able to get pass the login for the admin tho..

I had this issue also. I actually had the table prefix vb3_ so I had to change the SQL statement to vb3_user and then also change it in the config file.

To be able to log into the admin with VB3 RC4, change that lines in login.lib.php that looks like this:

"$DbLink4Login->query("SELECT password,perms FROM ".C_REG_TBL." WHERE username='$NAME' LIMIT 1");
if ($DbLink4Login->num_rows() != 0)
{
list($PWD_Hash, $perms) = $DbLink4Login->next_record();
if ($PWD_Hash == md5($PASSWORD)) || $PWD_Hash == $PASSWORD)"

to this:
"$DbLink4Login->query("SELECT password,perms,salt FROM ".C_REG_TBL." WHERE username='$NAME' LIMIT 1");
if ($DbLink4Login->num_rows() != 0)
{
list($PWD_Hash, $perms, $salt) = $DbLink4Login->next_record();
if ($PWD_Hash == md5(md5($PASSWORD).$salt) || $PWD_Hash == $PASSWORD)"

Hack worked great for me. :)

Craig

Good to know! If anyone finds any bugs with what I have done, please post them here asap, and I'll see what I can do about them.

nice job sry i been away :) i iz back now really

Is it possible for the chat not to ask for the user name and password? I would like all the users in the chat to be auto logged in with the same user as they have in the forum.

Does anyone have that working?

Hi, I've followed the instructions 100%, and it only loads a white page :(

I tried editing the template src as well to /room and still nothing. Can anyone help? thanks

I've seen this before where the chat templates have been loaded into a different style to the one you have currently selected.

ahh i figured it out, i had the template named wrong :)