MySQL & website Integration ?

[elfaus]

Hi there,

i've tried to integrate this new release to my website using mysql after read the documentation but it seems not up to date about the 2.x :s
i would like integrate him using my users table like that :
id => int, pseudo => varchar, password => varchar

ID from each users are stored into a SESSION, that the only var which stored about an user

and this structure

index => going to look for a module.php which integrate a view file (default.php or chat.php or something else) into a chat folder.
in this folder there are a js folder with the phpfreechat.js and the jquery.js

and last, i've a functions folder with everything else.

I now where put the .html file with <div id="mychat"><a href=""></a></div>
I now where put the phpfreechat.js and the jquery.js

but where can i put other files ?

[phpfreechat]

Did you look at this documentation ?
https://github.com/kerphi/phpfreechat#pfcbeforeauth

You need to add a phpfreechat hook to connect the chat auth system to your mysql auth system.

[elfaus]

what are :
$app, $req, $res ?

[phpfreechat]

app is a slim framework application instance.
req : http://docs.slimframework.com/pages/request-overview/
res : http://docs.slimframework.com/pages/response-overview/

I think you don't need it to return your login from the $_SESSION array

[elfaus]

I've do something like that :

Code: Select all

$GLOBALS['pfc_hooks']['pfc.before.auth'][5] = function ($app, $req, $res) {
    return function ($hr) use ($app, $req, $res) {
   
        if (isset($_SESSION['id'])) {
            $query = $db->prepare("THE QUERY");
            $query->bindParam(':id',$_SESSION['id'],PDO::PARAM_INT);
            $query->execute();
            $data = $query->fetch(PDO::FETCH_OBJ);
            $hr->login = $data->pseudo;
        } else {
            $hr->login = 'Anon'.rand(1,1000);
        }
        return $hr->login;
    };
};

Does it correct ?

How can I add color on users depend of rights ?
And how can I add macro ? I don't view any files to do that :s

[phpfreechat]

Yes it seems to be correct. Does it work ?

Concerning the colors depending on the user's rôle, the feature is not yet implemented. Don't hesitate to vote for the user role feature cause it is needed to have things depending on the role.

Last thing is about "macro", please could you explain what is a macro ?

[elfaus]

Yes it works

about color, can i keep some modification on the code to make it possible for the moment ?
currently each group has a color information store in my DB and i use it to keep the good color to an user depending his role

http://momcards.fr/chat.html

about macro, on my current chat which i've dev, i've those function

/clear => flush every messages
/system [msg] => add an announce on the top of chat
/ban [user] => ban a user on the chat
/unban [user] => unban a user who's ban

what about smiley too ?

[phpfreechat]

Ok so what you call "macro" is a chat command. This is also features which are not implemented yet.

To know the currently implemented features, have a look to this page: https://github.com/kerphi/phpfreechat#features

The code is opensource so if you have skills, you can patch the code to add your own features, don't hesitate to fork the github repository.

You can also vote for the features you whould like to be implemented in the next release: https://phpfreechat.uservoice.com/

Finaly you can also contribute with a donation, it will help the futurs developments: http://www.phpfreechat.net/donate

[rick001]

I just want a simple integration into my site. I though i would achieve this using an <iframe> but there are some complexities that arises out of it. The most important being the chat wont work in IE if loaded using an <iframe> so was wondering what would be the most effective way to integrate this into my existing site?

[phpfreechat]

I don't understand why do you integrate the chat with an iframe ? thanks to the phpfreechat jquery plugin you can easily integrate wherever you want in your website.

[rick001]

Wanted to try iframes coz when i use jquery the chat works fine for almost every browser in there other than IE so wanted to see if an iframe would help but well its the same thing. when the is integrated into the site then IE has trouble with it. however if i load just the example chat or a chat which is not integrated into another page then it works fine even in IE

[phpfreechat]

Could you show me an example with a classic integration on your web site (without iframe integration) that do not work with IE ?
And please use the phpfreechat-2.0.5-debug.zip so that I'll see which lines of code are problematic.

[rick001]

ok i tried to use the debug chat and integrate it into a page. Now the chat wont even load. I dont see what i am doing wrong, because i already did integrate the other one and it works just fine even now in all browser other than IE. here are the links.

http://www.techbreeze.in/test/phpfreechat-2.0.5/examples/default this is just to check that the debug chat was installed properly and is working.

http://www.techbreeze.in/test this the page where i did the integration the chat wont load in here

http://www.techbreeze.in/chat this the page where i did the integration of the normal version of the chat, which works in almost all browser other than IE

[phpfreechat]

In http://www.techbreeze.in/test you included the wrong files:

Code: Select all

<script src="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/lib/jquery-1.8.2.min.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/themes/default/jquery.phpfreechat.min.css" />
<script src="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/jquery.phpfreechat.min.js" type="text/javascript"></script>


It should be:

Code: Select all

<script src="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/lib/jquery-1.8.2.min.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/themes/default/jquery.phpfreechat.css" />
<script src="http://www.techbreeze.in/test/phpfreechat-2.0.5/client/jquery.phpfreechat.js" type="text/javascript"></script>


[rick001]

OK i have corrected that, but the problem with IE still persists. Please check