<?php
    function coolness($user_id, $stats = 0)
    {
        return 0;
        $communities_threads = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM communities_threads WHERE user_id = '" . $user_id . "'"));
        $communities_replies = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM communities_replies WHERE user_id = '" . $user_id . "'"));
        $events_images = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM events_images WHERE user_id = '" . $user_id . "'"));
        $flyers_images = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM flyers_images WHERE user_id = '" . $user_id . "'"));
        $gallery_images = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM gallery_images WHERE user_id = '" . $user_id . "'"));
        $friends = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM friends WHERE friend_id = '" . $user_id . "'"));
        $events_attending = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM events_attending WHERE user_id = '" . $user_id . "'"));
        $events_posted = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM events WHERE posted_by = '" . $user_id . "'"));
        $events_modified = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM events WHERE posted_by = '" . $user_id . "'"));
        $profile_owner = mysqli_fetch_assoc(mysqli_query_logged("SELECT COUNT(*) AS count FROM promoters_owner WHERE user_id = '" . $user_id . "'"));
        $coolness = ($communities_threads['count'] * 10) +
                    ($communities_replies['count'] * 5) +
                    ($events_images['count'] * 10) +
                    ($flyers_images['count'] * 50) +
                    ($gallery_images['count'] * 3) +
                    ($friends['count'] * 25) +
                    ($events_attending['count'] * 25) +
                    ($events_posted['count'] * 20) +
                    ($events_modified['count'] * 5) +
                    ($profile_owner['count'] * 100);
        if ($stats == 1)
        {
            $return = array();
            $return['communities_threads'] = $communities_threads['count'] * 10;
            $return['communities_replies'] = $communities_replies['count'] * 5;
            $return['events_images'] = $events_images['count'] * 10;
            $return['flyers_images'] = $flyers_images['count'] * 50;
            $return['gallery_images'] = $gallery_images['count'] * 3;
            $return['friends'] = $friends['count'] * 25;
            $return['events_attending'] = $events_attending['count'] * 25;
            $return['events_posted'] = $events_posted['count'] * 20;
            $return['events_modified'] = $events_modified['count'] * 5;
            $return['profile_owner'] = $profile_owner['count'] * 100;
            $return['total'] = $coolness;
            return $return;
        }
        else
        {
            return $coolness;
        }
    }
?>