Rate all posts

  • Resolved Pedro A.

    (@phcaraujo)


    6 years ago

    Could you provide me with an SQL command to put voting on all my posts?

    Random number of votes between 1 ~ 5
    And stars between 3 ~ 5

    Post type = downloads

    • This topic was modified 6 years ago by Pedro A..
Viewing 1 replies (of 1 total)
  • Plugin Support Blaz K.

    (@blazk)

    5 years, 12 months ago

    Hi @phcaraujo,

    that is a relatively complicated SQL command, but I can guide you in the right direction. So, the plugin stores votes in post meta. There are 3 fields that are relevant: rmp_vote_count, rmp_rating_val_sum and rmp_avg_rating. rmp_rating_val_sum / rmp_vote_count should equal rmp_avg_rating with a max one decimal. I hope this will help you.

    Regards,
    Blaz

Viewing 1 replies (of 1 total)

The topic ‘Rate all posts’ is closed to new replies.