';
$count = $wpdb->get_var("
SELECT COUNT(meta_value) FROM $wpdb->commentmeta
LEFT JOIN $wpdb->comments ON $wpdb->commentmeta.comment_id = $wpdb->comments.comment_ID
WHERE meta_key = 'rating'
AND comment_post_ID = $post->ID
AND comment_approved = '1'
AND meta_value > 0
");
$rating = $wpdb->get_var("
SELECT SUM(meta_value) FROM $wpdb->commentmeta
LEFT JOIN $wpdb->comments ON $wpdb->commentmeta.comment_id = $wpdb->comments.comment_ID
WHERE meta_key = 'rating'
AND comment_post_ID = $post->ID
AND comment_approved = '1'
");
if ( $count > 0 ) :
$average = number_format($rating / $count, 2);
echo '
';
echo '
'.$average.' '.__('out of 5', 'alanah-free').'
';
echo '
'.sprintf( _n('%s review for %s', '%s reviews for %s', $count, 'alanah-free'), ''.$count.'', wptexturize($post->post_title) ).'
';
echo '
';
else :
echo '
'.__('Reviews', 'alanah-free').'
';
endif;
$title_reply = '';
if ( have_comments() ) :
echo '';
if ( get_comment_pages_count() > 1 && get_option( 'page_comments' ) ) : ?>
← Previous', 'alanah-free' ) ); ?>
→', 'alanah-free' ) ); ?>
';
$title_reply = __( 'Add a review', 'alanah-free' );
else :
$title_reply = __('Be the first to review', 'alanah-free').' “'.$post->post_title.'”';
echo '
'.__('There are no reviews yet, would you like to submit yours?', 'alanah-free').'
';
endif;
$commenter = wp_get_current_commenter();
echo '