Welcome to Geeklog, Anonymous Thursday, December 12 2024 @ 08:51 am EST
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.
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.
26
22
Quote
Status: offline
jnordquist
Forum User
Full Member
Registered: 03/14/03
Posts: 129
Location:Kenosha
Very interested!
John Nordquist,
Applications Specialist, medical Technologies
John Nordquist,
Applications Specialist, medical Technologies
23
24
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/
http://70.145.174.180/
24
27
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?
30
27
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
26
22
Quote
Status: offline
DownForLife
Forum User
Newbie
Registered: 02/08/04
Posts: 6
thank you for the info!
24
23
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.
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
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
26
30
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.
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.
31
26
Quote
Status: offline
DownForLife
Forum User
Newbie
Registered: 02/08/04
Posts: 6
any new news on this yet?
33
20
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.
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.
28
33
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
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
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
28
23
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...
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
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...
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
25
25
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]
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]
30
31
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
I would be very interested in phpMyChat to replace FlashChat!
John Nordquist,
Applications Specialist, medical Technologies
28
27
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?
What about phpOpenChat?
30
21
Quote
Page navigation
All times are EST. The time is now 08:51 am.
- 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