WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
Excluding posts or changing their view count in database (4 posts)

  1. indyparker
    Member
    Posted 1 year ago #

    Hi,

    Firstly thanks for an excellent plugin to measure popular posts.

    I have an issue where a very old news story is still in the popularity table due to the huge hits it got in short period around the news breaking. But now that story is from 2011!!

    And I do not want it to overtake stories which are current. Can I exclude posts from the popular posts? How do I do this? Or can I cange data in the database to 'demote' the story i.e. reduce views.

    Help with this will be highly appreciated.

    Thanks
    IndyP

    http://wordpress.org/extend/plugins/wordpress-popular-posts/

  2. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    Hi IndyP,

    Currently there's no way to exclude posts from the listing, so you'll need to get your hands dirty and modify the entry directly in your database. The tables you need to look for are wp_popularpostsdata and wp_popularpostsdatacache.

  3. indyparker
    Member
    Posted 1 year ago #

    Hi Hector,

    Thanks for you reply.

    I've looked in these tables and the view count is different in the cache table to the data table. So, how do I correlate the two to make sure what U change is okay to do.

    Which fields in the tables and what can I reduce the numbers by?

    Many Thanks
    IndyP

  4. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    All time views count comes from the first table I mentioned. The latter contains a bunch of records from the past 30 days from the date so it doesn't necessarily will match.

    If you're listing your most popular posts of all times you should edit the first one, otherwise you need to work on the second one.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic