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

  • 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

    https://www.ads-software.com/extend/plugins/wordpress-popular-posts/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    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.

    Thread Starter indyparker

    (@indyparker)

    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

    Plugin Author Hector Cabrera

    (@hcabrera)

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: WordPress Popular Posts] Excluding posts or changing their view count in database’ is closed to new replies.