Notifications - Show subscribers and followers - Cobalt 7

Quote

Total posts: 3,837
10 Aug 2012 20:05

Re-Creation of my older topic: [6G] Events System | subscribing, following... show followers ?

The older topic was discussed before Cobalt had Notifications. The comments also mentioned "audit trail" etc. So, here we go again... any news? What are the possibilities? Can the current Notifications serve as a basis?

Example with "Who favourited...":

Just a sample visualization.

Could be with or without avatars.

Could be "Who is following..."

Could be "Who subscribed..."

Could be "Who is watching..."

soundcloud example:

Last Modified: 02 Mar 2014

Quote

Sergey

Total posts: 13,748
11 Aug 2012 07:18

That is what we will do for Cobalt 8. First we need integration with Social extensions and then we can create module upon this integrations, so it correctly shows like jomSocial or CB style.

Quote

pepperstreet VIP

Total posts: 3,837
17 Sep 2012 01:45

Any tips, how to retrieve and build such a follower/watcher list with Cobalt7 and the "watch" status ?

Quote

Sergey

Total posts: 13,748
18 Sep 2012 18:51

Find one who bookmarked

$db = JFactory::getDbo();

$id = JRequest::getInt('id');

$db->setQuery("SELECT user_id FROM #__js_res_favorite WHERE record_id = $id");

$users = $db->loadObjectList();

Find one who rated

$db = JFactory::getDbo();

$id = JRequest::getInt('id');

$db->setQuery("SELECT user_id FROM #__js_res_vote WHERE record_id = $id");

$users = $db->loadObjectList();

Why is this answer "private" ?

Quote

Sergey

Total posts: 13,748
19 Sep 2012 04:14

But that is not related. Those queries select records/articles form #_js_res_record and this one users. And records table not even touched.

Quote

Sergey

Total posts: 13,748
19 Sep 2012 08:55

the records field

You talk about cobalt field or database table field?

Now I am lost where we call records as DB entries and were we call it Cobalt articles :S

Notifications - Show subscribers and followers

Login (copy)