chamilo / chamilo-lms

                // subscribe all the users from the session to this course inside the session

                $nbr_users = 0;

                foreach ($user_list as $enreg_user) {

                    $enreg_user_id = intval($enreg_user['user_id']);

                    $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user (session_id, c_id, user_id)

                            VALUES ($sessionId, $courseId, $enreg_user_id)";

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

                    Event::addEvent(

                        LOG_SESSION_ADD_USER_COURSE,

                        LOG_USER_ID,

                        $enreg_user_id,

                        api_get_utc_datetime(),

                        api_get_user_id(),

                        $courseId,

                        $sessionId

                    );

                    if (Database::affected_rows($result)) {

                        $nbr_users++;

                    }

                }

                $sql = "UPDATE $tbl_session_rel_course

                        SET nbr_users = $nbr_users

                        WHERE session_id = $sessionId AND c_id = $courseId";

        $orig_course_id_value[] = implode(',', $course_list);

        foreach ($courseIdList as $courseId) {

            $courseId = intval($courseId);

            Database::query("DELETE FROM $tbl_session_rel_course

                            WHERE c_id ='$courseId' AND session_id='$id_session'");

            $result = Database::query("DELETE FROM $tbl_session_rel_course_rel_user WHERE c_id='$courseId' AND session_id = '$id_session'");

            Event::addEvent(

                LOG_SESSION_DELETE_COURSE,

                LOG_COURSE_ID,

                $courseId,

                api_get_utc_datetime(),

                api_get_user_id(),

                $courseId,

                $id_session

            );

            $return = Database::affected_rows($result);

        }

        $nbr_courses = 0;

        $sql = "SELECT nbr_courses FROM $tbl_session WHERE id = '$id_session'";