Parachat Plugin for phpBB3

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
trace1301t
Registered User
Posts: 6
Joined: Tue Mar 15, 2011 11:39 am

Parachat Plugin for phpBB3

Post by trace1301t » Sun Jun 10, 2012 8:34 pm

I have added a parachat module to my forum, having followed all the install instructions and set ups, I pressed submit and get the below script, now I am at a loss as what to do next.. please can anyone help,


[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 30: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 30: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 31: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 31: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 32: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 32: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 33: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 33: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 34: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 34: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 35: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 35: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 36: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 36: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 37: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 37: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)
[phpBB Debug] PHP Warning: in file [ROOT]/adm/index.php on line 154: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3815)

User avatar
KevC
Support Team Member
Support Team Member
Posts: 67013
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Parachat Plugin for phpBB3

Post by KevC » Sun Jun 10, 2012 8:37 pm

You need to post in the topic where you got it.

It looks like your account doesn't have permission to access something that the MOD wants.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Grumpykitty
Registered User
Posts: 30
Joined: Thu Sep 08, 2016 7:26 pm

Re: Parachat Plugin for phpBB3

Post by Grumpykitty » Tue Dec 27, 2016 9:23 pm

I"m actually having the same issue. I have spoken with Support over at Parachat, they have directed me here. So all I need is to fix it. If you could help me that would be awesome.


Kitty

User avatar
Lumpy Burgertushie
Registered User
Posts: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Parachat Plugin for phpBB3

Post by Lumpy Burgertushie » Tue Dec 27, 2016 11:46 pm

this has nothing to do with phpbb. that error above is saying that the user trying to access the database does not have permission to do so.
I have never heard of parachat, but I would assume that somewhere in the install process it asks for your database name/username/password so it can access the database. If you are getting that same error as above, then whatever you put in those fields during the parachat install is not correct.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

Grumpykitty
Registered User
Posts: 30
Joined: Thu Sep 08, 2016 7:26 pm

Re: Parachat Plugin for phpBB3

Post by Grumpykitty » Wed Dec 28, 2016 3:38 am

Lumpy Burgertushie wrote:this has nothing to do with phpbb. that error above is saying that the user trying to access the database does not have permission to do so.
I have never heard of parachat, but I would assume that somewhere in the install process it asks for your database name/username/password so it can access the database. If you are getting that same error as above, then whatever you put in those fields during the parachat install is not correct.


robert
Actually it does Robert. Parachat.com check it out, they made a Mod for this forum. I have asked them about that they told me to come here. So, I'm only doing as I was told. :lol:

User avatar
Lumpy Burgertushie
Registered User
Posts: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Parachat Plugin for phpBB3

Post by Lumpy Burgertushie » Wed Dec 28, 2016 3:47 am

did you download the phpbb plugin for it?
personally, I wouldn't associate with a site that pops up so many different windows that it is hard to dismiss them all and see what is on the page. also, you can't do anything without creating an account.

just bad business. anyway, if you have some instructions about how to use the phpbb plugin etc. then send them to me in a PM and I will see what I can come up with.

hopefully you did not pay for this. there are plenty of chats around for phpbb that are easy to install and work just fine.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

Grumpykitty
Registered User
Posts: 30
Joined: Thu Sep 08, 2016 7:26 pm

Re: Parachat Plugin for phpBB3

Post by Grumpykitty » Wed Dec 28, 2016 5:18 am

Lumpy Burgertushie wrote:did you download the phpbb plugin for it?
personally, I wouldn't associate with a site that pops up so many different windows that it is hard to dismiss them all and see what is on the page. also, you can't do anything without creating an account.

just bad business. anyway, if you have some instructions about how to use the phpbb plugin etc. then send them to me in a PM and I will see what I can come up with.

hopefully you did not pay for this. there are plenty of chats around for phpbb that are easy to install and work just fine.


robert

Actually they are a good company and I enjoy them. Fast service with support easy when it comes to the monthly payments with a good chat, only pay 30 for what I need. As for the plug in.. no, that is free, in fact they have a few plugins for a couple of other forums as well.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 17700
Joined: Fri Aug 29, 2008 9:49 am

Re: Parachat Plugin for phpBB3

Post by Mick » Wed Dec 28, 2016 11:43 am

They're not that good that they support their product, obviously.
"The more connected we get the more alone we become" - Kyle Broflovski

Forza Garibaldi

User avatar
Lumpy Burgertushie
Registered User
Posts: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Parachat Plugin for phpBB3

Post by Lumpy Burgertushie » Wed Dec 28, 2016 4:51 pm

the point here is that it is not a phpbb issue at all. if you need to know how to install and operate software from them, you go to them. If they tell you that you should come here, then the person telling you that does not have a clue about what the error message means.


luck,
robert
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20191
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Parachat Plugin for phpBB3

Post by RMcGirr83 » Wed Dec 28, 2016 5:16 pm

trace1301t wrote:[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 30: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lesbianc'@'localhost' (using password: NO)

Code: Select all

$db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['enable']) . "' WHERE `setting` = 'enable_parachat';");
Oh holy god Nooooooooooo!!

The module is, quite simply, crap.

mysql_real_escape_string has absolutely zero to do with phpBB. Have parachat fix their crappy code.

PS they haven't coded it to be an extension...at all.
The chat.php and chatauth.php files should be uploaded to the root of your phpBB installation.
Uhmmm, no it should be handled via a controller.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
canonknipser
Registered User
Posts: 1078
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Parachat Plugin for phpBB3

Post by canonknipser » Wed Dec 28, 2016 5:41 pm

RMcGirr83 wrote:PS they haven't coded it to be an extension...at all.
There are no extensions in 3.0 ;) If you read the http://service.parachat.com/knowledgeba ... hpBB3.html, the instruction are for a 3.0 board (like this 4½ years old topic :roll: )
Greetings
Frank
phpbb.de support team member
English is not my native language
New arrival - Extensions and scripts for phpBB
no support via PM or mail

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20191
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Parachat Plugin for phpBB3

Post by RMcGirr83 » Wed Dec 28, 2016 6:19 pm

Whoops, I wish these forums would just close ;)
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

Grumpykitty
Registered User
Posts: 30
Joined: Thu Sep 08, 2016 7:26 pm

Re: Parachat Plugin for phpBB3

Post by Grumpykitty » Wed Dec 28, 2016 11:55 pm

That would be your opinion which you have the right to say but I'm rather fond of Parachat. But this is what I'm getting.

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 45: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 45: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 46: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 46: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 47: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 47: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 48: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 48: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 49: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 49: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 50: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 50: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 51: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 51: mysql_real_escape_string(): A link to the server could not be established
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 52: mysql_real_escape_string(): Access denied for user 'ensignred'@'localhost' (using password: NO)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/acp_parachat.php on line 52: mysql_real_escape_string(): A link to the server could not be established
And this is the includes/acp/acp_parachat.php.

Code: Select all

<?php

class acp_parachat
{

    var $u_action;
    var $new_config;

    function main($id, $mode)
    {
        global $db, $user, $auth, $template;
        global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

        // Run SQL queries if parachat table doesn't exist
        $result = $db->sql_query("SHOW TABLES LIKE '" . $table_prefix . "parachat'");
        if (!$result->num_rows) {
            $db->sql_query("
                CREATE TABLE IF NOT EXISTS `" . $table_prefix . "parachat`
                (
                    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                    `setting` varchar(32) NOT NULL,
                    `value` text NULL, PRIMARY KEY (`id`)
                ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9;");
            $db->sql_query("
                INSERT INTO `" . $table_prefix . "parachat` (`id`, `setting`, `value`) VALUES
                    (1, 'enable_parachat', '0'),
                    (2, 'site_id', ''),
                    (3, 'custom_applet_url', ''),
                    (4, 'room_width', '600'),
                    (5, 'room_height', '400'),
                    (6, 'default_room', 'Lobby'),
                    (7, 'additional_params', ''),
                    (8, 'allow_guests', '0');
            ");
        }

        switch ($mode) {
            case 'index':
                $this->page_title = 'ACP_PARACHAT';
                $this->tpl_name = 'acp_parachat';

                if ($_POST['submit']) {
                    $_POST['enable_parachat'] = (@$_POST['enable_parachat'] == "on") ? "1" : "0";
                    $_POST['allow_guests'] = (@$_POST['allow_guests'] == "on") ? "1" : "0";
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['enable']) . "' WHERE `setting` = 'enable_parachat';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['site_id']) . "' WHERE `setting` = 'site_id';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['applet_url']) . "' WHERE `setting` = 'custom_applet_url';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['width']) . "' WHERE `setting` = 'room_width';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['height']) . "' WHERE `setting` = 'room_height';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['room']) . "' WHERE `setting` = 'default_room';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['params']) . "' WHERE `setting` = 'additional_params';");
                    $db->sql_query("UPDATE `" . $table_prefix . "parachat` SET `value` = '" . mysql_real_escape_string($_POST['allow_guests']) . "' WHERE `setting` = 'allow_guests';");
                }

                $result = $db->sql_query("SELECT `setting`,`value` FROM `" . $table_prefix . "parachat`");
                $settings = array();
                while ($row = $db->sql_fetchrow($result)) {
                    $settings[$row['setting']] = $row['value'];
                }

                $template->assign_vars(array(
                    'ENABLE' => $settings['enable_parachat'],
                    'SITE_ID' => $settings['site_id'],
                    'APPLET_URL' => $settings['custom_applet_url'],
                    'WIDTH' => $settings['room_width'],
                    'HEIGHT' => $settings['room_height'],
                    'ROOM' => $settings['default_room'],
                    'PARAMS' => $settings['additional_params'],
                    'ALLOW_GUESTS' => $settings['allow_guests'])
                );
                break;
        }

    }
}

?>
I would like to have this working on my forum please and I do believe I owe someone an apology, they know who they are. I was having a bad week and was very frustrated. I could never figured out how to work that even with my updated forum which is now 3.0.14 I do not like the current version because it does not have the OP Mod Or View Arthur only which is what I need.


Thank you
Kitty.

User avatar
Lumpy Burgertushie
Registered User
Posts: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Parachat Plugin for phpBB3

Post by Lumpy Burgertushie » Thu Dec 29, 2016 12:23 am

you see this in the error: Access denied for user 'ensignred'@'localhost' ?

as mentioned above, that error means that your parachat file(s) need to access the database. whatever information you used for database username/password or database name etc., is apparently wrong. therefore, this is not a phpbb issue, it is an issue with the parachat installation or the phpbb plugin installation etc.

we have no idea about how parachat works or what it needs etc. the person that created this software and /or the plugin is the one you need to ask about this.

If their support will not help you then I suggest either asking for a higher level of support from their site, or simply not using this software if the company refuses to work with you to make it function properly.




luck,
robert
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

Grumpykitty
Registered User
Posts: 30
Joined: Thu Sep 08, 2016 7:26 pm

Re: Parachat Plugin for phpBB3

Post by Grumpykitty » Thu Dec 29, 2016 12:57 am

Ok thank you. You made it much clearer. :D

Locked

Return to “[3.0.x] Support Forum”

Who is online

Users browsing this forum: pkbarbiedoll and 78 guests

cron