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.

i see smth like this:

Yes I am seeing this as well now. What am I doing wrong?

After reading some of the posts here I figured out that I did not put in the correct path. Once I did this, now the chat comes up like it did....is it supposed to do this or is there supposed to be a link. Also you can't get into the chat at all now, not even with a password.

How do I integrate the chat into my boards.

I really need help. :(

Ok... I have it working somewhat. When you go to my chat http://www.theparentclub.com/tpcchat/index.php3 , the message appears when you are not registered, but I'd like to provide a link to register after that message. I do not know php at all and when I try to put html code into it, I get an error. So it's obvious that I don't know what to do and reall need help on this last step. I'm anxious to make this available to my members.

Please help.

Thanks.

find that
replace it with
So you can use HTML now

THANK YOU...THANK YOU....THANK YOU!

:)

You've made my day!

give my hack a good rating ;)

Can you make a Hack...
In Forum Home can see who in chat room now
thx....

Has anyone else had a problem with phpmychat crashing MS IE 6.0?

Has any one got this to work on a PHP4 server? I have made the necessary changes but get a internal error of 500 when I try to run the setup.php3. Something tells me my server doesnt support PHP3.

try to rename php3 in php, something tells me that php3 is comaptible with php4

I'm not having much like getting it to work. The chat page at least used to display before the hack, now I just get a blank page at beta.errantlands.com/chat/:

Any ideas? I do have the chdir statements pointing to the correct places...

Christina

i see just error 404-nor found

Any ideas wha would cause them now? The page used to load...
The /chat directory has a .index.php in it, which really is just a link to phpMyChat.php3 in its directory...

Bump :)

ping - pong

still gettin' errorz?

Well, I can't figure out why I'd get a page not found error now. If I remove the hack (I backed up the original files), it works as it did before...

<a href="http://beta.errantlands.com/chat/index.php3" target="_blank">http://beta.errantlands.com/chat/index.php3</a>

yahh... i`m still gettin 404 :cry:

u need to use it as a link.... phpchat can check refferer before startin'

There is no index.php3 in that directory... There is just a .index.php which is a like to phpMyChat.php3. In the /chat/chat directory there is a index.php3, though.

<a href="http://beta.errantlands.com/chat/chat/index.php3" target="_blank">http://beta.errantlands.com/chat/chat/index.php3</a>

i see "no" that meanz i`m not logged in, hack works

Odd, you are right. lol. I must have an error somewhere else though, if I try to logoff of the chat, it gives me another 'page cannot be displayed'. Maybe the default directory structure is weird for the installed phpMyChat on VO?

log of the chat means u re clicking exit link in the chat frame?

Yes, the exit link on the top right side. When I do it, it sits for a while and then a "Page Cannot be Displayed" message is shown by the browser. It is trying to use this link:

http://beta.errantlands.com/chat/cha...E=Default&EN=1

Thanks, btw, you've been quite helpful.

u got to look into hack :)

Oh, sheesh. Don't tell me I missed that, I hate missing details like this, it is so embarassing! Thanks, as always!

:D:D:D:D

Yep, that was the problem, thanks so much. Now I just have to edit their UI screen and put some of my headers and footers on it and it's all set! Thanks.

do u have a dedicated server? i`m seraching smbd to host smth

No, unfortunately. I have a shared one at VO. I might move things back to my DSL line though, its slower than it was when I ran it on a server at home. LOL.

:D lol i know that ****