WordPress.org

Ready to get started?Download WordPress

Forums

WTI Like Post
[resolved] Order / Sort posts by Likes? (8 posts)

  1. Pete
    Member
    Posted 2 years ago #

    Where are likes stored? I know of a few plugins that can sort by custom meta, so i'd like to know where the Likes are stored? I haven't opened up the db yet to look through the tables but any insight would be helpful

    Thanks

    http://wordpress.org/extend/plugins/wti-like-post/

  2. webtechideas
    Member
    Plugin Author

    Posted 2 years ago #

    The like details are stored inside wti_like_post table. You can do the sorted posts by using custom query. As far as the meta data is concerned, its not storing anything in terms of metadata. I will be adding this in the next release so that you can make use of that.

  3. n8lauscher
    Member
    Posted 1 year ago #

    Dear Webtechideas,

    first you have made a perfekt light like plugin!

    i give you my wordpress like ;)

    The like details are stored inside wti_like_post table. You can do the sorted posts by using custom query. As far as the meta data is concerned, its not storing anything in terms of metadata. I will be adding this in the next release so that you can make use of that.

    please can you add this feature as soon as possible? sorry? but i need it very quick! This is a really nice feature.
    it would be nice when we can choose for which categorie i can turn on the sort function an also for turning on and off for the starting page.

    Thank you so much !

  4. m_disseny
    Member
    Posted 1 year ago #

    Any news on this? I am also interested in this feature, it would be great to sort most liked posts per category.

    Thanks Chitta for this great plugin.

  5. webtechideas
    Member
    Plugin Author

    Posted 1 year ago #

    There is a pro version coming up which will have some exciting features like

    • Functionality to store like counts as post meta which can be used to show posts sorted by like counts
    • Functionality to show most liked posts from a selected category on Most Liked Posts widget
    • Option to have default message to encourage users to like posts
    • Functionality to see like count for each post in admin post list/edit section
    • Functionality to see users who liked a post
    • Fade out functionality for the message shown after clicking the like/dislike button
  6. alxvallejo
    Member
    Posted 1 year ago #

    Again this is not a resolved topic. It's important to maintain the integrity of these forums if an issue is going to be "resolved".

    THis is a poorly structure plugin if you ask me - Instead of adding to the count of a post id, the plugin creates a whole new row for each like. This requires a SUM(value) variable query and thus, causes headaches for ordering based on likes/dislikes.

    It would be of great use as to know where exactly to look --- you seemed to have solved the sort query in the Admin options --- but it's not available on the front-end.

    I may have to create my own where you keep the database normalized.

  7. webtechideas
    Member
    Plugin Author

    Posted 1 year ago #

    Please check my last message where I have given the solution to sort the posts by like count in terms of a PRO version. That's the reason I marked this topic as resolved. So please wait for a week or so for the pro version to be released.

    Whenever a plugin is developed by a single developer, he has his own views/specs which he follows. So it may not exactly match with everybody's requirement. When the developer receives suggestions/requirements from users, then he adds those in the later version.

    This plugin has its own table wti_like_post to store all the like counts. It creates a new record for a post if the ip where user is voting from has not already been recorded in the table. If its the same ip, then the like count for the same post will be updated. I will be glad if you can further normalize the table and send me the structure. I will really appreciate that.

    If this still does not match with your requirement, you are always welcomed to customize it as per your requirement.

  8. blueagle1829
    Member
    Posted 1 year ago #

    Unless I'm missing something, I have two issues that I can't figure out...

    First, the category pages will not display the posts until they have created an entry in wp_wti_like_posts. If there is a record of any kind for a post, it shows up fine and does sort correctly... however- it doesn't show up until there is a record. This seems to be true in every template, both standard themes and ones I created. The category widget from WordPress counts the posts, but it doesn't show the posts on the page (see attached screen shot).

    Second, the sort order seems to be only based off the positive like count, and not by the total of likes minus dislikes. Is there a way to make it sort by this total equation, and not just the positive likes? If not, it doesn't really make sense to leave the dislike option enabled, and that's something I'd definitely like to keep if I can.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.