chamilo / chamilo-lms

        // Check whether the user has not been already subscribed to the course.

        if (empty($session_id)) {

            if (Database::num_rows(Database::query("

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

                    WHERE user_id = '$user_id' AND relation_type<>" . COURSE_RELATION_TYPE_RRHH . " AND c_id = '$courseId'")) > 0

            ) {

                // The user has been already subscribed to the course.

                return false;

            }

        }

        if (!empty($session_id)) {

            SessionManager::subscribe_users_to_session_course(array($user_id), $session_id, $courseCode);

        // Is he/she subscribed to the session's course?

        // A user?

        if (Database::num_rows(Database::query("SELECT user_id

                FROM " . Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER) . "

                WHERE session_id='" . $session_id . "'

                AND user_id ='$user_id'"))

        ) {

            return true;

        }

        // A course coach?

        if (Database::num_rows(Database::query("SELECT user_id

        }

        // A course coach?

        if (Database::num_rows(Database::query("SELECT user_id

                FROM " . Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER) . "

                WHERE session_id='" . $session_id . "'

                AND user_id = '$user_id' AND status = 2

                AND c_id ='$courseId'"))

        ) {

            return true;

        }

        // A session coach?

        if (Database::num_rows(Database::query("SELECT id_coach

        }

        // A session coach?

        if (Database::num_rows(Database::query("SELECT id_coach

                FROM " . Database::get_main_table(TABLE_MAIN_SESSION) . " AS session

                WHERE session.id='" . $session_id . "'

                AND id_coach='$user_id'"))

        ) {

            return true;

        }

        return false;

    }