chamilo / chamilo-lms

    * @param int url id

    * @return boolean true if success

    * */

    public static function relation_url_user_exist($user_id, $url_id)

    {

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

        $sql= "SELECT user_id FROM $table

               WHERE access_url_id = ".intval($url_id)." AND user_id = ".intval($user_id)." ";

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

        $num = Database::num_rows($result);

        return $num;

	}

    /**

    * Checks the relationship between an URL and a Course (return the num_rows)

    * @param int $urlId

    * @return boolean true if success

    * */

    public static function relation_url_course_exist($courseId, $urlId)

    {

        $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

        $sql= "SELECT c_id FROM $table_url_rel_course

               WHERE

                    access_url_id = ".intval($urlId)." AND

                    c_id = '".intval($courseId)."'";

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

        $num = Database::num_rows($result);

        return $num;

    }

    /**

     * Checks the relationship between an URL and a UserGr

     * @param int user receiver id

     * @return int

     */

    public static function get_message_number_invitation_by_user_id($user_receiver_id)

    {

        $tbl_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = 'SELECT COUNT(*) as count_message_in_box FROM '.$tbl_message.'

                WHERE

                    user_receiver_id='.intval($user_receiver_id).' AND

                    msg_status='.MESSAGE_STATUS_INVITATION_PENDING;

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

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

        return $row['count_message_in_box'];

    }

    /**

     * Get invitation list received by user

     * @param int $user_id The user id

     * @return Datetime The date when you obtained the certificate

     */

    public static function get_certificate_by_user_id($cat_id, $user_id)

    {

        $table_certificate = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CERTIFICATE);

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

                WHERE cat_id="' . intval($cat_id) . '" AND user_id="' . intval($user_id) . '"';

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

        $row = Database::fetch_array($result, 'ASSOC');

        return $row;

    }

    /**

     * Get list of users certificates

     * Returns the course name from a given code

     * @param string $code

     */

    public static function getCourseNameFromCode($code)

    {

        $tbl_main_categories = Database:: get_main_table(TABLE_MAIN_COURSE);

        $sql = 'SELECT title

                FROM ' . $tbl_main_categories . '

                WHERE code = "' . Database::escape_string($code) . '"';

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

        if ($col = Database::fetch_array($result)) {

            return $col['title'];

        }

    }

    /**

     * Generates a course code from a course title