[RC] Simple Chat v2.1 - new AJAX chat for phpBB3

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
User avatar
katib
Registered User
Posts: 562
Joined: Thu Jun 26, 2008 12:27 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by katib » Mon Jan 26, 2009 2:06 pm

@maclanes
Well
I think chat directory should look like this:
example.com/forum/chat
Then you can acces the chat window simply by typing:
example.com/forum/chat
into browser
that's all ;)

User avatar
novanilla
Registered User
Posts: 332
Joined: Wed Jul 02, 2008 1:08 pm
Location: Colorado
Contact:

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by novanilla » Mon Jan 26, 2009 5:33 pm

I have to check this out. Looks very interesting. Can anybody tell me how this compares to the other phpBB chat mods listed here?

Thanks

RokDiesel
Registered User
Posts: 3
Joined: Sat Dec 20, 2008 12:05 am

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by RokDiesel » Tue Jan 27, 2009 2:54 am

nm

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Tue Jan 27, 2009 3:28 am

I am wondering if it is possible to make a way to upload mp3s to play on the chat or maybe a way to link to mp3s online to listen to while we chat.. That would be absolutely amazing! :o

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Tue Jan 27, 2009 5:01 am

Ok.. First error message for you. And of course I caused it.. :oops:
SQL ERROR [ mysql4 ]

Unknown column 'last_active' in 'where clause' [1054]

SQL

SELECT * FROM Forumchat_sessions WHERE last_active < '1233032085' ORDER BY last_active

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: chat/index.php
LINE: 73
CALL: dbal_mysql->sql_query()
What did I do wrong and how can I fix it?

What I did:
I did the sql:
I changed the phpbb_ to Forum (As this is what I use)
I zipped the Chat directory and then I uploaded it.
I unzipped the directory accessed the index.php
Seen the error.. Thought what the heck.. Redid the sql with the phpbb_ prefix just in case that caused it..

Pressed ctrl + f5.

No change..

So now what? :cry:

User avatar
novanilla
Registered User
Posts: 332
Joined: Wed Jul 02, 2008 1:08 pm
Location: Colorado
Contact:

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by novanilla » Tue Jan 27, 2009 5:16 am

Mudjosh, this might be a dumb question, but should it be "Forum_chat_sessions", instead of "Forumchat_sessions"?

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Tue Jan 27, 2009 5:25 am

Well, actually when I first started the forum, (And had no clue what I was doing.. lol) I changed the phpbb3_ to Forum (Note there is no "_" at the end) so that should be no issue. Unless I'm missing something.. Which isn't impossible.. lol..

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Tue Jan 27, 2009 5:33 am

Ok sorry for the double posting again.. I hear it was unwise to edit your previous post on a support forum.. So I have stopped editing previous posts.. ;)

Anyway, this is my fields for ForumChat_Sessions:

user_id
username
user_colour
user_login
user_firstpost
user_lastpost
user_lastupdate

I don't see last_active there.. Should it be? If so, I don't know sql, how do I add it?

Ok.. I broke my rule.. I edited:

I found my problem.. There is a conflict between this mod and Handyman's Ajax chat in the mysql..

I will figure out how to correct this.. Not sure how but I'll get it..

Thanks for.. umm.. supporting me with your thoughts! :D

----
I found it and changed it.. It works now. Though maybe the Mod Author could change the Field Name to something else to help those with both installed..

sloeri
Registered User
Posts: 37
Joined: Sat Jan 03, 2009 8:45 am

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by sloeri » Tue Jan 27, 2009 9:56 am

Mudjosh wrote:Ok sorry for the double posting again.. I hear it was unwise to edit your previous post on a support forum.. So I have stopped editing previous posts.. ;)

Anyway, this is my fields for ForumChat_Sessions:

user_id
username
user_colour
user_login
user_firstpost
user_lastpost
user_lastupdate

I don't see last_active there.. Should it be? If so, I don't know sql, how do I add it?

Ok.. I broke my rule.. I edited:

I found my problem.. There is a conflict between this mod and Handyman's Ajax chat in the mysql..

I will figure out how to correct this.. Not sure how but I'll get it..

Thanks for.. umm.. supporting me with your thoughts! :D

----
I found it and changed it.. It works now. Though maybe the Mod Author could change the Field Name to something else to help those with both installed..

Can you tell me what you did to solve it ?
have the same issue :)

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Tue Jan 27, 2009 5:22 pm

Run this sql:

Code: Select all

CREATE TABLE IF NOT EXISTS `phpbb_chat_messages2` (
	`msg_id` int(11) unsigned NOT NULL auto_increment,
	`user_id` mediumint(8) unsigned NOT NULL default '0',
	`username` varchar(255) collate utf8_bin NOT NULL default '',
	`time` int(11) unsigned NOT NULL default '0',
	`text` varchar(255) collate utf8_bin NOT NULL default '',
	`color` varchar(6) collate utf8_bin NOT NULL default '',
	PRIMARY KEY  (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=0;

CREATE TABLE IF NOT EXISTS `phpbb_chat_sessions2` (
	`user_id` mediumint(8) unsigned NOT NULL default '0',
	`username` varchar(255) collate utf8_bin NOT NULL default '',
	`last_active` int(11) unsigned NOT NULL default '0',
	`user_status` tinyint(3) unsigned NOT NULL default '0',
	`user_activity` smallint(6) NOT NULL default '0',
	`user_blocked` tinyint(1) NOT NULL default '0',
	UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

root/chat/index.php

Find:

Code: Select all

define('CHAT_MESSAGES_TABLE',	$table_prefix . 'chat_messages');
define('CHAT_SESSIONS_TABLE',	$table_prefix . 'chat_sessions');
Replace:

Code: Select all

define('CHAT_MESSAGES_TABLE',	$table_prefix . 'chat_messages2');
define('CHAT_SESSIONS_TABLE',	$table_prefix . 'chat_sessions2');
That should work..

Hope I helped!

User avatar
1234homie
Registered User
Posts: 439
Joined: Fri Sep 26, 2008 3:17 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by 1234homie » Tue Jan 27, 2009 9:48 pm

thanks for this mod, it will be great :D :D

azzurri
Registered User
Posts: 909
Joined: Fri Jul 21, 2006 7:48 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by azzurri » Tue Jan 27, 2009 10:58 pm

Thank you for sharing this. It is much appreciated. I have installed it and it works great. Only thing missing is moderator rights. Thank you.

Also, why is there a minimum of 5 second delay? If it is AJAX shouldn't it be able to handle live chat?

austriaka
Registered User
Posts: 8
Joined: Wed Jan 21, 2009 7:21 am

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by austriaka » Wed Jan 28, 2009 5:58 pm

this is a really great little script. Far way easiest installation ever :D
It is working really smooth.

To show the chatting users in the "who is online" page you have to add the path in the viewonline.php:

OPEN viewonline.php
SEARCH
case 'index':
$location = $user->lang['INDEX'];
$location_url = append_sid("{$phpbb_root_path}index.$phpEx");
break;
INSERT BEFORE
case 'chat/index':
$location = 'In the Chatroom';
$location_url = append_sid("{$phpbb_root_path}chat/index.$phpEx");
break;
@ BLR_VEG: it would be great to have english comments in the code :D
And I think there is a need of logging the conversations... what you already do with action=sync could easily go into logfiles, either just as text files or (luxury variation) in the ACP

thx for sharing
KArin

Mudjosh
Registered User
Posts: 234
Joined: Sat Jun 14, 2008 11:04 pm

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by Mudjosh » Wed Jan 28, 2009 9:10 pm

How would you show who is in chat at the bottom of the index_body/overall_footer (Which ever it is.. )

EDIT:

Hey Veg, it is nice to see you making your rounds! And yes, the chat is working lovely.. My only suggestion is bbcodes. Though I wouldn't want them to be displayed. That would be too cluttering..

User avatar
VEG
Registered User
Posts: 84
Joined: Sat Jun 25, 2005 9:31 am
Location: Belarus, Minsk
Contact:

Re: [BETA] SimpleChat v2.0 - new AJAX chat for phpBB3

Post by VEG » Wed Jan 28, 2009 10:23 pm

Adrian1 wrote:Whwn i try to visit demo site kaspersky internet security block it :?
It is possible that the problem is in the domain name, in english it looks like adults' site :D
TonyF80 wrote:Will this chatbox be for only my registered members once they sing in? Can that be done?
Chatbox is available only for registered users.
Mudjosh wrote:So, what are your planned features?
  • Chat bot for notify about new topics
  • User statuses
  • ...
RokDiesel wrote:nm
I don't understand you.
azzurri wrote:Also, why is there a minimum of 5 second delay?
It is necessary for reduce the load on the server.
austriaka wrote:it would be great to have english comments in the code :D
Ok. I will try to translate them.
novanilla wrote:I have to check this out. Looks very interesting. Can anybody tell me how this compares to the other phpBB chat mods listed here?
I have nothing against it, if you do it yourself
Mudjosh wrote:How would you show who is in chat at the bottom of the index_body/overall_footer (Which ever it is.. )
katib wrote:How to put this chat in an iframe on index_body.html ?
It needs additional modifications. Sorry, i have no time for it now :(
Best regards, Evgeny

Locked

Return to “[3.0.x] MODs in Development”