chamilo / chamilo-lms

                                    // Deleting all course teachers and adding the only coach as teacher.

                                    $teacherList = CourseManager::get_teacher_list_from_course_code($course_code);

                                    if (!empty($teacherList)) {

                                        foreach ($teacherList as $teacher) {

                                            if (!in_array($teacher['user_id'], $teacherToAdd)) {

                                                $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)."

                                                        WHERE

                                                            user_id = ".$teacher['user_id']." AND

                                                            course_code = '".$course_code."'

                                                        ";

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

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

                                                $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData;

                                                $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)."

                                                    WHERE

                                                        user_id = ".$teacher['user_id']." AND

                                                        c_id = '".$courseInfo['real_id']."'

                                                    ";

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

                                                while ($groupData = Database::fetch_array($result, 'ASSOC')) {

                                                    $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData;

                                                }

                                                $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)."

                                                        WHERE

                                                            user_id = ".$teacher['user_id']." AND

                                                            c_id = '".$courseInfo['real_id']."'

                                                        ";

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

                                                while ($groupData = Database::fetch_array($result, 'ASSOC')) {

                                                    $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData;

                                                }

                                                CourseManager::unsubscribe_user(

                                                    $teacher['user_id'],

                                                    $course_code

                                                );

                                            }

                                        }

                                    }

                                    foreach ($teacherToAdd as $teacherId) {

                                        $userCourseCategory = '';

                                // Un subscribe everyone that's not in the list.

                                $teacherList = CourseManager::get_teacher_list_from_course_code($course_code);

                                if (!empty($teacherList)) {

                                    foreach ($teacherList as $teacher) {

                                        if ($teacherToAdd != $teacher['user_id']) {

                                            $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)."

                                                    WHERE

                                                        user_id = ".$teacher['user_id']." AND

                                                        course_code = '".$course_code."'

                                                    ";

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

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

                                            $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData;

                                            $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)."

                                                    WHERE

                                                        user_id = ".$teacher['user_id']." AND

                                                        c_id = '".$courseInfo['real_id']."'

                                                    ";

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

                                            while ($groupData = Database::fetch_array($result, 'ASSOC')) {

                                                $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData;

                                            }

                                            $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)."

                                                    WHERE

                                                        user_id = ".$teacher['user_id']." AND

                                                        c_id = '".$courseInfo['real_id']."'

                                                    ";

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

                                            while ($groupData = Database::fetch_array($result, 'ASSOC')) {

                                                $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData;

                                            }

                                            CourseManager::unsubscribe_user(

                                                $teacher['user_id'],

                                                $course_code

                                            );

                                        }

                                    }

                                }

                                if (!empty($teacherToAdd)) {

                                    SessionManager::updateCoaches($session_id, $courseId, array($teacherToAdd), true);