Beiträge von 1stein

### Function: Display Highest Rated Page/Post
if(!function_exists('get_highest_rated')) {
    function get_highest_rated($mode = '', $limit = 10, $chars = 0) {
        global $wpdb, $post;
        $ratings_image = get_settings('postratings_image');
        $ratings_max = intval(get_settings('postratings_max'));
        $where = '';
        if($mode == 'post') {
            $where = 'post_status = \'publish\'';
        } elseif($mode == 'page') {
            $where = 'post_status = \'static\'';
        } else {
            $where = '(post_status = \'publish\' OR post_status = \'static\')';
        }
        $highest_rated = $wpdb->get_results("SELECT $wpdb->posts.ID, post_title, post_name, post_status, post_date, (meta_value+0.00) AS ratings_average FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date < '".current_time('mysql')."' AND $where AND meta_key = 'ratings_average' AND post_password = '' ORDER BY ratings_average DESC LIMIT $limit");
        if($highest_rated) {
            foreach($highest_rated as $post) {
                // Variables
                $post_ratings_images = '';
                $post_title = htmlspecialchars(stripslashes($post->post_title));
                $post_ratings_average = $post->ratings_average;
                $post_ratings_whole = intval($post_ratings_average);
                $post_ratings = floor($post_ratings_average);
                // Check For Half Star
                $insert_half = 0;
                $average_diff = $post_ratings_average-$post_ratings_whole;
                if($average_diff >= 0.25 && $average_diff <= 0.75) {
                    $insert_half = $post_ratings_whole+1;
                } elseif($average_diff > 0.75) {
                    $post_ratings = $post_ratings+1;
                }
                // Display Start Of Rating Image
                if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif')) {
                    $post_ratings_images .= '<img src="'.get_settings('siteurl').'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_start.gif" alt="" />';
                }
                // Display Rated Images
                for($i=1; $i <= $ratings_max; $i++) {
                    if($i <= $post_ratings) {
                        $post_ratings_images .= '<img src="'.get_settings('siteurl').'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_on.gif" alt="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" title="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" />';        
                    } elseif($i == $insert_half) {                        
                        $post_ratings_images .= '<img src="'.get_settings('siteurl').'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_half.gif" alt="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" title="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" />';
                    } else {
                        $post_ratings_images .= '<img src="'.get_settings('siteurl').'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_off.gif" alt="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" title="'.__('Average: ').$post_ratings_average.__(' out of ').$ratings_max.'" />';
                    }
                }
                // Display End Of Rating Image
                if(file_exists(ABSPATH.'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif')) {
                    $post_ratings_images .= '<img src="'.get_settings('siteurl').'/wp-content/plugins/postratings/images/'.$ratings_image.'/rating_end.gif" alt="" />';
                }
                if($chars > 0) {
                    echo "<li><a href=\"".get_permalink()."\">".snippet_chars($post_title, $chars)."</a> ".$post_ratings_images."</li>\n";
                } else {
                    echo "<li><a href=\"".get_permalink()."\">$post_title</a> ".$post_ratings_images." ($post_ratings_average".__(' out of ')."$ratings_max)</li>\n";
                }
            }
        } else {
            echo '<li>'.__('N/A').'</li>';
        }
    }
}