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

	 *

	 * @return array()

	 */

	public static function display_rating($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);

	}

	/**

	 * Shows the rating form if not already rated by that user

 * @param integer $user_id

 * @return int the value of the highest sort of the user_course_category

 */

function api_max_sort_value($user_course_category, $user_id)

{

    $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);

    $sql = "SELECT max(sort) as max_sort FROM $tbl_course_user

            WHERE

                user_id='".intval($user_id)."' AND

                relation_type<>".COURSE_RELATION_TYPE_RRHH." AND

                user_course_cat='".intval($user_course_category)."'";

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

    if (Database::num_rows($result_max) == 1) {

        $row_max = Database::fetch_array($result_max);

        return $row_max['max_sort'];

    }

    return 0;

}

/**

 * This function converts the string "true" or "false" to a boolean true or false.