Code Duplication    Length = 21-27 lines in 2 locations

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

@@ 1811-1837 (lines=27) @@
1808
            }
1809
1810
            // Delete existing users
1811
            if ($empty_users) {
1812
                foreach ($existingUsers as $existing_user) {
1813
                    if (!in_array($existing_user, $user_list)) {
1814
                        $sql = "DELETE FROM $tbl_session_rel_course_rel_user
1815
                                WHERE
1816
                                    session_id = $id_session AND
1817
                                    c_id = $courseId AND
1818
                                    user_id = $existing_user AND
1819
                                    status = 0 ";
1820
                        $result = Database::query($sql);
1821
1822
                        Event::addEvent(
1823
                            LOG_SESSION_DELETE_USER_COURSE,
1824
                            LOG_USER_ID,
1825
                            $existing_user,
1826
                            api_get_utc_datetime(),
1827
                            api_get_user_id(),
1828
                            $courseId,
1829
                            $id_session
1830
                        );
1831
1832
                        if (Database::affected_rows($result)) {
1833
                            $nbr_users--;
1834
                        }
1835
                    }
1836
                }
1837
            }
1838
1839
            // Replace with this new function
1840
            // insert new users into session_rel_course_rel_user and ignore if they already exist
@@ 1843-1863 (lines=21) @@
1840
            // insert new users into session_rel_course_rel_user and ignore if they already exist
1841
1842
            foreach ($user_list as $enreg_user) {
1843
                if (!in_array($enreg_user, $existingUsers)) {
1844
                    $enreg_user = Database::escape_string($enreg_user);
1845
                    $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user (session_id, c_id, user_id, visibility, status)
1846
                            VALUES($id_session, $courseId, $enreg_user, $session_visibility, 0)";
1847
                    $result = Database::query($sql);
1848
1849
                    Event::addEvent(
1850
                        LOG_SESSION_ADD_USER_COURSE,
1851
                        LOG_USER_ID,
1852
                        $enreg_user,
1853
                        api_get_utc_datetime(),
1854
                        api_get_user_id(),
1855
                        $courseId,
1856
                        $id_session
1857
                    );
1858
1859
                    if (Database::affected_rows($result)) {
1860
1861
                        $nbr_users++;
1862
                    }
1863
                }
1864
            }
1865
1866
            // Count users in this session-course relation