Support » Plugin: WP Voting » [Plugin: WP Voting] Post Ranking

  • Resolved vusisindane


    Hi there, I’m trying to get the ‘rank’ of a post according to the number of votes it has. e.g. let’s say I have 3 posts.
    POSTA = 10 votes
    POSTB = 20 votes
    POSTC = 30 votes.

    Then POSTC should be ranked #1, POSTB #2 etc. I want to write a function that gets that rank. Is there an easier way to get this done? or should I just go ahead and hack the plugin?

Viewing 15 replies - 1 through 15 (of 33 total)
  • Plugin Author David Chew



    I am going to do as a widget or shortcode. It will be included in next release.


    Hey tristanmin.

    When do you will release the new version with ranking?
    I need it for a project for my university.

    Greetings from Germany!

    I’ve actually implemented it. If you want I can give you the code…
    please see

    Wow! That would be pretty cool!
    It looks very nice!

    My Emailadress:

    Thank you very much!
    Greetings from Germany!

    What I will do is build an independent plugin that hooks into this one so that we can allow the original author to continue working on his plugin without disturbing the process.

    Please give me until Saturday to do this for you…

    Greetings from South Africa 🙂

    Wow! That is so cool! With a rank the WP Vote Plugin is perfect!
    Thank you very much for your engagement!

    I will post my project with both plugins, when I finsh it.

    Best regards from Germany! 🙂


    Do you have the solution?
    It would be nice, when you could give me the code.
    I just need the code to paste it in the loop.

    I have two loops.

    The normal loop:
    The random loop:

    And now I need the code for “The ranking loop” with a ranking of the votes of WP Voting.

    When you or tristanmin could help me, then it would be pretty cool!!

    Greetings from Germany!

    Sorry, my weekend turned out to be a disaster. I’m working on it as we speak. Will send it through.

    things have been super hectic. so please accept this code rather than the entire widget. you can look up on wordpress codex on how to make a widget

    function b1_get_post_rank($post)
    	global $wpdb;
    	$total_posts = $wpdb->get_var('SELECT COUNT( DISTINCT vote_count)
    					   	FROM ' . $wpdb->prefix . 'wpv_voting');
    	$total_smaller = $wpdb->get_var('SELECT COUNT( DISTINCT vote_count )
    					   	FROM ' . $wpdb->prefix . 'wpv_voting
    						WHERE vote_count < (SELECT vote_count
    											FROM ' . $wpdb->prefix . 'wpv_voting
    											WHERE post_id = ' . $post->ID . ')');
    	$rank = $total_posts - $total_smaller;
    	return $rank;

    Feel free to improve it and let me know (and let the plugin author know) if you do.

    Thank you very much!
    How can I get the ranking?

    <?php b1_get_post_rank($post) ?> doesn’t work.

    I also tried to get the rank into this loop:

    Template Name: Ranking
    <?php get_header(); ?>
        if (is_page('ranking')) {
        } else { ?>
    <!--Page Content-->
        <?php } ?>
    <?php get_footer(); ?>

    But it doesn’t work!

    Thank you very much for your code-solution.
    I hope, you can help me again! :-/

    Best regards,

    1. you must paste that code I gave you in your functions.php
    2. in your template (or in your loop) you can call that function i.e.

    <?php echo b1_get_post_rank($post) ?>

    It should return an int (number), that number is the rank of the post. One thing though, just make sure the $post is actually a valid variable. if $post is null, then it won’t work. one way to get the post is to use <?php global $post; ?> (provided wordpress has declared it)

    Plugin Author David Chew


    Oh guys! I didn’t know that you guys are implementing top voted feature. I got a lot of work to do at my primary job. So I couldn’t check this blog post lately. If I knew it early, that make me a lot easier to develop the top voted widget. Anyway, I’ve finished the top voted widget and which is included in version 1.7. Please let me know if you need my help.

    Thanks for all the contributors and supporters.


    Will definitely check it out.

    Hey! I couldn’t get it to work! 😀
    With the solution of vusisindane it works, that I get a number of the rank.
    But I’m just a PHP rookie and I can’t make a loop-ranking site with all posts in a ranking.

    I’m working on a project-site for my university and need a site, where I can sort the projects ( = posts/blogarticles) by the ranking

    So I’m happy, when you release 1.7.
    When is the release-date?

    Greetings from Germany!

Viewing 15 replies - 1 through 15 (of 33 total)
  • The topic ‘[Plugin: WP Voting] Post Ranking’ is closed to new replies.