<?php
    function image_overall_type($id)
    {
        $vote_count = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM images_categories_rating WHERE image_id = '" . $id . "'"));
        if (intval($vote_count['num']))
        {
            $votes = mysqli_query_logged("SELECT COUNT(*) AS num, category_id FROM images_categories_rating WHERE image_id = '" . $id . "' GROUP BY category_id ORDER BY num DESC LIMIT 2");
            $highest = mysqli_fetch_array($votes);
            if (mysqli_num_rows($votes) == 2)
            {
                $second = mysqli_fetch_array($votes);
                $difference = intval($highest['num']) - intval($second['num']);
            }
            else
            {    
                $difference = intval($highest['num']);
            }            
            $category = mysqli_fetch_array(mysqli_query_logged('SELECT name, worksafe FROM images_categories WHERE id="'.$highest['category_id'].'"'));
            return '<span class="' . ($category['worksafe'] == 1 ? 'notice_good' : 'notice_error') . '">' . $category['name'] . ' [' . $difference . ']</span>';
        }
        else
        {
            return 'No Type [0]';
        }
    }
    
    function image_overall_type_id($id)
    {
        $vote_count = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM images_categories_rating WHERE image_id = '" . $id . "'"));
        if (intval($vote_count['num']))
        {
            $votes = mysqli_query_logged("SELECT COUNT(*) AS num, category_id FROM images_categories_rating WHERE image_id = '" . $id . "' GROUP BY category_id ORDER BY num DESC LIMIT 1");
            $highest = mysqli_fetch_array($votes);
            return $highest['category_id'];
        }
        else
        {
            return 0;
        }
    }

    function image_overall_type_worksafe($id)
    {
        $vote_count = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num FROM images_categories_rating WHERE image_id = '" . $id . "'"));
        if (intval($vote_count['num']))
        {
            $highest = mysqli_fetch_array(mysqli_query_logged("SELECT COUNT(*) AS num, category_id FROM images_categories_rating WHERE image_id = '" . $id . "' GROUP BY category_id ORDER BY num DESC LIMIT 1"));
            $category = mysqli_fetch_array(mysqli_query_logged("SELECT worksafe FROM images_categories WHERE id = '" . $highest['category_id'] . "'"));
            return $category['worksafe'] == 1 ? true : false;
        }
        else
        {
            return true;
        }
    }
?>