One of my users keeps getting this error. It's kind of odd because only one person has this issue. Can someone help me figure this out? Here's his error: (2ManyZ's is his username)

Database error: Invalid SQL: SELECT room FROM c_users WHERE username='2ManyZ's' LIMIT1

MY SQL error: 1064 ( You have an error in your SQL suntax near "s" LIMIT 1' at line 1) Session halted.

UPDATE: I was just thinking about this, could this be a result of an apostrophe (') in his username?

Look at the USer name!

It´s: 2ManyZ's

rename the user to 2ManyZs and it will work fine!

Best regards!

Thanks....

I got the chat running, but now I need to know how to integrate the Who's chatting to show next to my who's online...

How do I do that?

I'd even like to add a block to my phpportals front page that shows who is in the chat room. Anyone know how to do this?

there is a script coming with phpmychat...

What do you mean by that?
Are you saying a new phpmychat is coming out now?

there is a script in phpmychat zip which allows you to see users chatting at the moment

Yep, you're right. The file is called chat_activity.php3. It's included with the distribution of phpMyChat. The file is NOT inside your chat directory, but, one back.

It's a cool little program. But, I want to make it work with my phpportals mod in a block. Maybe I'll try to take the code and copy it to a block.

-- Mike
:stoned:

I hope someone can help me and hope you have some patience too, because I have only tried to do simple hacks and having problems with this one.

I did exactly what the instructions said and I am getting this error:

Parse error: parse error in /lib/index.lib.php3 on line 741

Fatal error: Call to undefined function: send_headers() in /home/www/theparentclub/tpcchat/index.php3 on line 20


http://www.theparentclub.com/tpcchat/index.php3

Now here's my other question. How do I exactly make the chat show up within my boards? How do I integreate it seemlessly?

Hope someone can help guide me on how to do this.

Thank you so much.