chamilo / chamilo-lms

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

    }