By Mist on Sunday, 14 February 2016
Posted in General Issues
Likes 0
Views 416
Votes 0
Hi guys,
In what table is EasySocial storing the information for "following" (people i follow).

I want to figure out a sql query that will get from database joomla articles posted by the people i follow in EasySocial. So any information on where to get this information within the DB (people followed by a user) will help me a lot.

Basically i have a primary user id, i want to retrieve from DB all the users he is following in EasySocial and then get all the articles posted by his "following" from joomla articles table (latest first)


PS: Even better if you have an excess of kindness )))) an example query will be great. I know this is out of support scope, so i don't mind if i will not get it

Thanks !
Hello Mist,

You can use this to get the list of users that the particular user is following:

$options = array('limit'=>10);
$userId = 13; // the user Id that you want to get the following details.
$model = FD::model( 'Followers' );
$users = $model->getFollowing( $userId , $options );


Hope this helps.
·
Monday, 15 February 2016 11:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Cool ! Thank you so much Nik !
·
Monday, 15 February 2016 13:05
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Mist
·
Monday, 15 February 2016 13:12
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post