Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 01:05 pm EDT

Geeklog Forums

phpMyChat integration almost done!

Page navigation


Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
I've been working on integrating phpMyChat as a plugin and I'm almost done. I have the user piece pretty much complete and I'm working on the admin piece this weekend.

So far the user piece lets users see links to rooms based on thier rights. The user/password databases are syncronized. (only one way Geeklog -> phpMyChat). When the user clicks on a room link it takes him/her directly to that room without the need to login to phpmychat.

I'm hoping to work out the Admin interface this weekend. It should let the admin create rooms and assign permissions to them based on geeklog rights.

The security on phpmychat isn't the best in the world. Once inside phpmychat if you know what you are doing you can get to other rooms without any trouble at all, but for the casual user and site, it isn't bad...

If you are interested in getting the plugin when I'm done please reply and let me know..

B.
 Quote

Status: offline

jnordquist

Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
Very interested!
John Nordquist,
Applications Specialist, medical Technologies
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 01/12/03
Posts: 445
Yeah, me too Big Grin

geKow
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
VERY VERY interested.

-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

TechSys

Forum User
Regular Poster
Registered: 12/02/03
Posts: 90
I am interested in it also
http://70.145.174.180/
 Quote

Status: offline

DownForLife

Forum User
Newbie
Registered: 02/08/04
Posts: 6
i would like it too. does anyone know if the user/password databases are syncronized for Chatterblock 3.0 or would this phpMyChat be better?
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Quote by DownForLife: i would like it too. does anyone know if the user/password databases are syncronized for Chatterblock 3.0 or would this phpMyChat be better?

Chatterblock 3.0 was written for GL AFAIK. So the answer would be most certainly be yes. However, chatterblock is more or less a "shoutout box" for quick messages. It is not a full fledged chat like phpMyChat would be. A standalone running demo of phpMyChat can be found here: www.opensourcecms.com/phpmychat

An example of the chatterblock can be found at www.portalparts.com or www.squatty.com.
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

DownForLife

Forum User
Newbie
Registered: 02/08/04
Posts: 6
thank you for the info!
 Quote

Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
I didn't get finished this weekend but I hope to sometime this week. The password databases are syncronized by the way...

B.
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Quote by notime: I didn't get finished this weekend but I hope to sometime this week. The password databases are syncronized by the way...

B.

That rocks. Can't wait to see the release. Let me know if you need any testers. I have a fairly active site and with MSN's recent outages my users are flocking to my Java IRC Integrated Chat which crashes their PC's half the time Neutral
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
I got the admin interface working last night. You can assign the usual sorts of geeklog permissions to rooms, you can pick the name of room and a description that shows up in a room list. I also added a sort order field so that you can specify how the rooms are show in the room list.

I still have just a couple of small hacks to make to phpmychat to clean up things like where to go when exiting, not showing other chatrooms that you don't have access to, etc..

I'll put up a test version on my site later in the week..

B.
 Quote

Status: offline

DownForLife

Forum User
Newbie
Registered: 02/08/04
Posts: 6
any new news on this yet? Big Grin
 Quote

Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
Just finished version 1.0. I just have to write my install doc and get it up on my site to download. I hope to have it in place tomorrow or Tuesday at the latest..

B.
 Quote

Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
You can download it from here:

http://www.notime-enterprises.com

if you want to try it before downloading you have to register... sorry but I didn't want anonymous users in the database... Thanks..

Let me know what you think!

B.
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
I did get an error when installing this. Here's my error.log
Text Formatted Code

Mon Feb 16 17:32:26 2004 - Attempting to install the phpmychat Plugin
Mon Feb 16 17:32:26 2004 - Creating roomtable table
Mon Feb 16 17:32:26 2004 - Success - Created roomtable table
Mon Feb 16 17:32:26 2004 - Creating C_MSG_TBL table
Mon Feb 16 17:32:26 2004 - Success - Created C_MSG_TBL table
Mon Feb 16 17:32:26 2004 - Creating C_USR_TBL table
Mon Feb 16 17:32:26 2004 - Success - Created C_USR_TBL table
Mon Feb 16 17:32:26 2004 - Creating C_REG_TBL table
Mon Feb 16 17:32:26 2004 - Success - Created C_REG_TBL table
Mon Feb 16 17:32:26 2004 - Creating C_BAN_TBL table
Mon Feb 16 17:32:26 2004 - Success - Created C_BAN_TBL table
Mon Feb 16 17:32:26 2004 - Inserting default data into roomtable table
Mon Feb 16 17:32:26 2004 - Success - inserting data into roomtable table
Mon Feb 16 17:32:26 2004 - Attempting to create phpmychat admin group
Mon Feb 16 17:32:26 2004 - ...success
Mon Feb 16 17:32:26 2004 - About to save group_id to vars table for use during uninstall
Mon Feb 16 17:32:26 2004 - ...success
Mon Feb 16 17:32:26 2004 - Adding phpmychat.admin feature
Mon Feb 16 17:32:26 2004 - Success
Mon Feb 16 17:32:26 2004 - Adding phpmychat.admin feature to admin group
Mon Feb 16 17:32:26 2004 - Success
Mon Feb 16 17:32:26 2004 - Adding phpmychat.view feature
Mon Feb 16 17:32:26 2004 - Success
Mon Feb 16 17:32:26 2004 - Adding phpmychat.view feature to admin group
Mon Feb 16 17:32:26 2004 - Success
Mon Feb 16 17:32:26 2004 - Attempting to give all users in Root group access to phpmychat admin group
Mon Feb 16 17:32:27 2004 - Registering phpmychat plugin with Geeklog
Mon Feb 16 17:32:27 2004 - 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 '2b3b1f669d22bb482e51396aa64fc5b8', '', '', '', '', 'danman00@ho. SQL in question: INSERT INTO gl_c_reg_users  values('dunkin'', '', '2b3b1f669d22bb482e51396aa64fc5b8', '', '', '', '', 'danman00@hotmail.com', '0', '', '', 1076981547, '127.0.0.1', '0')

 

I ignored the error, created one of the missing tables (just looked in install.php, copied and pasted to MySQL) and it worked fine.

I am running MySQL 4.0.16
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Notime,

When viewing a persons info (clicking their username in the chat) it displays their email address which is not good. It should show the "Send Email" link instead... Cool
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

Status: offline

notime

Forum User
Newbie
Registered: 02/06/04
Posts: 6
Looks like I forgot to addslashes to the values from your gl_users table....

I believe there is a setting in phpmychat's config.lib.php3 that turns the email line off... I'll see if I can find it.




Mon Feb 16 17:32:27 2004 - 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 '2b3b1f669d22bb482e51396aa64fc5b8', '', '', '', '', 'danman00@ho. SQL in question: INSERT INTO gl_c_reg_users values('dunkin'', '', '2b3b1f669d22bb482e51396aa64fc5b8', '', '', '', '', 'danman00@hotmail.com', '0', '', '', 1076981547, '127.0.0.1', '0')

[/code]
I ignored the error, created one of the missing tables (just looked in install.php, copied and pasted to MySQL) and it worked fine.

I am running MySQL 4.0.16[/QUOTE]
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Some time has passed, is this phpmychat plugin working all right now? What about this displaying of the email address?
 Quote

Status: offline

jnordquist

Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
A lot of time has past indeed! Looks like it was abandoned? I'm using FlashChat by tufat.com, but although its a wonderful package and integrates perfectly into Geeklog, it doesn't like when more than 8 or 9 people are in and slows to a trickle. And if your users are on dialup, they consistently get booted from chat.

I would be very interested in phpMyChat to replace FlashChat!
John Nordquist,
Applications Specialist, medical Technologies
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Right, so flash chat does not seem to be the one to go for. On the other hand I have a probem with the idea of email addresses being visible. Can this be turned off? has anybody experience with phpMyChat an the integration into geeklog?

What about phpOpenChat?
 Quote

Page navigation

All times are EDT. The time is now 01:05 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content