chamilo / chamilo-lms

     * @param int $urlId

     * @return int

     */

    public static function addCourseCategoryToUrl($categoryId, $urlId)

    {

        $exists = self::relationUrlCourseCategoryExist($categoryId, $urlId);

        if (empty($exists)) {

            $table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE_CATEGORY);

            $sql = "INSERT INTO $table

                    SET

                    course_category_id = '".intval($categoryId)."',

                    access_url_id = ".intval($urlId);

            Database::query($sql);

            return Database::insert_id();

        }

        return 0;

    }

    /**

     * Add a group of sessions into a group of URLs

     *

     * @return int|bool the status of the user in that course (or false if the user is not in that course)

     */

    public static function get_user_in_course_status($user_id, $course_code)

    {

        $courseInfo = api_get_course_info($course_code);

        $courseId = $courseInfo['real_id'];

        if (empty($courseId)) {

            return false;

        }

        $result = Database::fetch_array(

            Database::query(

                "SELECT status FROM " . Database::get_main_table(TABLE_MAIN_COURSE_USER) . "

                WHERE

                    c_id  = $courseId AND

                    user_id = " . intval($user_id)

            )

        );

        return $result['status'];

    }

    /**

     * @param int $userId