[Plugin: WP Voting] Post Ranking

Hi,

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

Cheers!

Hey tristanmin.

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

Greetings from Germany!
Alex

I’ve actually implemented it. If you want I can give you the code…
please see https://www.be1idea.org/ideas/the-joy-of-physics/

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

My Emailadress:
elecsander[at]gmail.com

Thank you very much!
Greetings from Germany!
Alex

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…

P.S
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! ??

Hey!

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: https://goo.gl/WjtHF
The random loop: https://goo.gl/dibKA

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:

<?php
/*
Template Name: Ranking
*/
?>
<?php get_header(); ?>
    <?php
    if (is_page('ranking')) {
    b1_get_post_rank($post);
    include(TEMPLATEPATH."/index.php");
    } 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,
Razz

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)

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.

Cheers!

Thanks.
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

https://goo.gl/a8JeO

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

Greetings from Germany!