WordPress Popular Posts
[Plugin: WordPress Popular Posts] Excluding posts or changing their view count in database (4 posts)

  1. indyparker
    Posted 4 years ago #


    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.



  2. Hector Cabrera
    Plugin Author

    Posted 4 years 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
    Posted 4 years 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

  4. Hector Cabrera
    Plugin Author

    Posted 4 years 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

  • WordPress Popular Posts
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic