Code Duplication    Length = 21-27 lines in 2 locations

main/inc/lib/sessionmanager.lib.php 2 locations

@@ 1864-1890 (lines=27) @@
1861
            }
1862
1863
            // Delete existing users
1864
            if ($empty_users) {
1865
                foreach ($existingUsers as $existing_user) {
1866
                    if (!in_array($existing_user, $user_list)) {
1867
                        $sql = "DELETE FROM $tbl_session_rel_course_rel_user
1868
                                WHERE
1869
                                    session_id = $id_session AND
1870
                                    c_id = $courseId AND
1871
                                    user_id = $existing_user AND
1872
                                    status = 0 ";
1873
                        $result = Database::query($sql);
1874
1875
                        Event::addEvent(
1876
                            LOG_SESSION_DELETE_USER_COURSE,
1877
                            LOG_USER_ID,
1878
                            $existing_user,
1879
                            api_get_utc_datetime(),
1880
                            api_get_user_id(),
1881
                            $courseId,
1882
                            $id_session
1883
                        );
1884
1885
                        if (Database::affected_rows($result)) {
1886
                            $nbr_users--;
1887
                        }
1888
                    }
1889
                }
1890
            }
1891
1892
            // Replace with this new function
1893
            // insert new users into session_rel_course_rel_user and ignore if they already exist
@@ 1896-1916 (lines=21) @@
1893
            // insert new users into session_rel_course_rel_user and ignore if they already exist
1894
1895
            foreach ($user_list as $enreg_user) {
1896
                if (!in_array($enreg_user, $existingUsers)) {
1897
                    $enreg_user = Database::escape_string($enreg_user);
1898
                    $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user (session_id, c_id, user_id, visibility, status)
1899
                            VALUES($id_session, $courseId, $enreg_user, $session_visibility, 0)";
1900
                    $result = Database::query($sql);
1901
1902
                    Event::addEvent(
1903
                        LOG_SESSION_ADD_USER_COURSE,
1904
                        LOG_USER_ID,
1905
                        $enreg_user,
1906
                        api_get_utc_datetime(),
1907
                        api_get_user_id(),
1908
                        $courseId,
1909
                        $id_session
1910
                    );
1911
1912
                    if (Database::affected_rows($result)) {
1913
                        $nbr_users++;
1914
                    }
1915
                }
1916
            }
1917
1918
            // Count users in this session-course relation
1919
            $sql = "SELECT COUNT(user_id) as nbUsers