Hello,

I am integrating FreiChat in a custom social networking website... i found some bugs in version 9.6 regarding to table prefix... FreiChat is now integrated with my with user base now i want to connect it to friendship table so that chat box should show online friend friends only.. Kindly help me in this...

Edit:

here is table structure for my friendship table
id | to_id | from_id | time_sent | time_accepted | staus | relation

id = auto increment .
to_id = id of user who sent the friend request.
from_id = id of user who recieved the friend request.
time_sent = time on which the request was initiated.
time_accepted = time on which both became friends.
status = confirmed or awaiting.

Also i am unable to buy freichat due to lack of money if you can provide me a limitation free edition of FreiChat with video chat then i will include powered by codologic in footer or about page as demanded by admin or owner of frichat. If you are interested in this then kindly email me...

Regards,

Mehroz Anjum

Hi,

You need to edit the queries in get_users(), get_guests() in the file freichat/server/drivers/Custom.php

For reference, you can have a look at the function get_buddies() in the files JSocial.php</code> and <code>JCB.php in the freichat/server/drivers folder.

Hi,

You need to edit the queries in get_users(), get_guests() in the file freichat/server/drivers/Custom.php

For reference, you can have a look at the function get_buddies() in the files JSocial.php</code> and <code>JCB.php in the freichat/server/drivers folder.

i am own custom social network which is not based on joomla... here is my query to get online friends from friendship table & users table:

$viewer_id= $_SESSION['user_id'] ;

SELECT user_id, first_name, last_name FROM users WHERE (user_id IN(SELECT to_id FROM friendship WHERE from_id='$viewer_id' AND status='confirmed' ) OR user_id IN(SELECT from_id FROM friendship WHERE to_id='$viewer_id' AND status='confirmed' )) AND last_seen>=(NOW() - INTERVAL 3 MINUTE)

how can i modify this query to for get_buddies()??

i am own custom social network which is not based on joomla.

The files that you mentioned have a table structure very much similar to your custom website, that was the reason we mentioned for your reference.

how can i modify this query to for get_buddies()??

Looking at the query, it already is filtering users based on the 'freindship' table .

ok i will carefully look at those files also....

yes exactly this query is already filtering online users but it is not compatible with FreiChat... so little customization needed to connect it to FreiChat.

also what is the difference between session_id and permanent_id in freichat table ??

Successfully integrated my friend list in freichat...