Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Stats

11 years 1 month ago
Licenses:
JomSocial Active

I wanna make make a query in database to know what users or posts has more likes...

I see theres a table: xxxx_community_likes that storage the likes.. but the problem with the query is that all the people who like a post... are in the same column.... so I dont know how to count that...

Attachments:
11 years 1 month ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Victor,

You should explode that "like" record first, and then you can get the value one by one (with explode code you will get array result), and then you parse that array result, then you will get "like id", create another query and link it to table community_activities, community_photos, or community_photos_album, depend the "element" on table community_like.. well this is very tehnical, you should have good php and mysql knowladge to achve this.

cheers!

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW