Ok, thanks for confirming that Kort. Than I will have to adjust my idea a bit ;)
Added 1 year later:
Currently I am trying to add the ratings to the pagelist plugin. I am doing that cause I want to be able to sort pages in a nice list on its rating.
I think I am nearly there cause all tags are already available (which I can see by using ?tpl_debug=1) but the plugin is currently showing an error.
But first let me show what I did:
I have copied the pagelist.comments.loop and changed it to the following:
$cns_join_columns.= ", (SELECT COUNT(*) FROM `$db_ratings` WHERE rating_area = 'page' AND rating_code = p.page_id) AS rating_average";
}
?>
I named this pagelist.ratings.query.php.
I am sure I did something wrong but not sure what cause now I get this error:
D:\Dropbox\Xampp\htdocs\new_armaholic\plugins\ratings\inc\ratings.functions.php on line 196
I am not sure if the joincolums SQL is correct or maybe the error is somewhere else and hope someone here can help me to get this working.