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.id = l.c_id

                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 $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;

}

/**

 * Transforms a number of seconds in hh:mm:ss format

 * @author Julian Prud'homme

     * @param int $user_id The user id

     * @return boolean

     */

    public static function is_user_certified($cat_id, $user_id)

    {

        $table_certificate = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CERTIFICATE);

        $sql = 'SELECT path_certificate FROM '.$table_certificate.'

                WHERE

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

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

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

        $row = Database::fetch_array($rs);

        if ($row['path_certificate'] == '' || is_null($row['path_certificate'])) {

            return false;

        } else {

            return true;

        }

    }

    /**

     * Gets the info about a gradebook certificate for a user by course