Module

Developer
Supported

EE 1
EE 2
LikEE

Back to this add-on's main page
View Other Add-ons From Booyant

LikEE  >  Thread
     

You must be logged in to post.

Tag to show a member’s like history?

Feature Request

billy2011
Posted: 22 December 2011 03:27 PM
billy2011

Hi Michael,

Just wonder is there any tag to show what a member Liked, working as the reverse of Liker tag? If non-existence, is it possible you add that?

Thanks a lot!
 
Booyant, Inc
Posted: 22 December 2011 04:54 PM # 1
Developer
Booyant, Inc

Hey Billy,

You could pretty easily do this - but you’d need a little knowledge of MySQL. If you have experience with MySQL, then just use EE’s Query module and check out the LikEE tables. It is very straightforward.

Unfortunately, due to the amount of client work at the moment we are not really making changes to this addon. Hopefully if we get a chance to breath we will come back to visit it at this point, but I wouldn’t be able to commit to when.

Michael
 
billy2011
Posted: 22 December 2011 11:51 PM # 2
billy2011

Michael, got it! I will do that by myself. I’m quite good at MySQL:)
Thank a lot for your quick response and tips. Really helps.
 
Bert Sinnema
Posted: 09 January 2012 04:33 AM # 3
Bert Sinnema

@billy

Could you post a query for this feature for the les fortunate on MySQL knowledge?

Cheers.
 
billy2011
Posted: 09 January 2012 04:51 AM # 4
billy2011

Hi Bert, I have not implemented that yet, but the ideas here:

The query:
SELECT entry_id
    , (SELECT title
      FROM
      exp_channel_titles ct
      WHERE
      ct.entry_id = el.entry_id) AS TITLE
FROM
  exp_likee el
WHERE
  member_id = {member_id} AND liked = 1

Notes:
1. {member_id} is the tag to get member id I guess, maybe you can use segment_2 or whatever.
2. The query is verified.
3. “liked =1” could be replaced by “disliked = 1”
4. I didn’t not use JOIN in the SQL. This is less efficient but could allow Pagination.
3. TITLE is a sample field, you can add whatever fields according to this format.

Hope that helps.
 
Bert Sinnema
Posted: 09 January 2012 04:57 AM # 5
Bert Sinnema

Great!  thanks a bunch!
 
     
 
← Failed to load resource: the server responded with a status of 500 (Internal Server Error)