chamilo / chamilo-lms

     * @param    int

     * @return   String

     */

    public static function get_course_id_by_link_id($id_link)

    {

        $course_table = Database::get_main_table(TABLE_MAIN_COURSE);

        $tbl_grade_links = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = 'SELECT c.id FROM ' . $course_table . ' c

                INNER JOIN ' . $tbl_grade_links . ' l

                ON c.code = l.course_code

                WHERE l.id=' . intval($id_link) . ' OR l.category_id=' . intval($id_link);

        $res = Database::query($sql);

        $array = Database::fetch_array($res, 'ASSOC');

        return $array['id'];

    }

    /**

     * @param $type

     * @param Integer $item_id

     * @return array

     */

    public static function displayRating($type, $blog_id, $item_id)

    {

        $tbl_blogs_rating = Database::get_course_table(TABLE_BLOGS_RATING);

        $course_id = api_get_course_int_id();

        // Calculate rating

        $sql = "SELECT AVG(rating) as rating FROM $tbl_blogs_rating

                WHERE

                    c_id = $course_id AND

                    blog_id = '".(int) $blog_id."' AND

                    item_id = '".(int) $item_id."' AND

                    rating_type = '".Database::escape_string($type)."' ";

        $result = Database::query($sql);

        $result = Database::fetch_array($result);

        return round($result['rating'], 2);

    }

    /**