How do I get the vote result in Vote API?

Question

I have installed the rate module, and found out that the votes associated to a node are stored in the votingapi_vote table.
Is there a function to use to get the sum of all the votes for a node?

Answer 1

As you have installed the Rate module, then you can use the function rate_get_results(), which can be called as rate_get_results('node', $nid, $widget_id); $nid is the node ID of the node for which you want to get the result, and $widget_id is the identifier of the widget used to cast the vote.
The result is an array that contains many values (some of them are present only for a particular widget); in particular $output['rating'] is the rating, and $output['count'] is the number of the votes.
If the widget saves the sum of the votes, then $output['rating'] (where $output contains the result returned from rate_get_results('node', $nid, $widget_id)) contains the sum of the votes, which is what you are looking for.

Answer 2

Just use _votingapi_get_standard_results()!

Answer 3

First create the followings relationships:

Content: Vote results -- Value type: No filtering -- Aggregation function: Average vote.

Second, create the same relationship again changing the Aggregate function to: Number of votes and the identifier to: Vote result (rank.)

Third, add the following Sort criterion: Vote results: Value (desc.)

Last, add another sort criterion identical to the one you just created except that you will select the second relationship (Vote result (rank.) The sort order is also descending.

That will give you the desired results: The nodes are now properly ranked.

You can test this by enabling Text to display under the stars: Both user's and average vote in the rating field.

Answer 4

With Drupal 7, you can get vote information programatically using the function votingapi_select_results().

Ex:

$criteria = array();
$criteria["entity_id"] = $nid;
$criteria["entity_type"] = "node";
$criteria["value_type"] = "points";
$criteria["tag"] = "hopper";
//$criteria["function"] = "count";   // don't set, and get an array of all.

$res = votingapi_select_results($criteria);

If you then examine (ex: dpm($res)) you can see that $res is an array of all the information you will need for each "function" of your voting widget.

To figure out which "value_type" and "tag" to use, look at the votingapi_cache table.