Code Duplication    Length = 21-27 lines in 2 locations

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

@@ 1687-1713 (lines=27) @@
1684
            }
1685
1686
            // Delete existing users
1687
            if ($empty_users) {
1688
                foreach ($existingUsers as $existing_user) {
1689
                    if (!in_array($existing_user, $user_list)) {
1690
                        $sql = "DELETE FROM $tbl_session_rel_course_rel_user
1691
                                WHERE
1692
                                    session_id = $id_session AND
1693
                                    c_id = $courseId AND
1694
                                    user_id = $existing_user AND
1695
                                    status = 0 ";
1696
                        $result = Database::query($sql);
1697
1698
                        Event::addEvent(
1699
                            LOG_SESSION_DELETE_USER_COURSE,
1700
                            LOG_USER_ID,
1701
                            $existing_user,
1702
                            api_get_utc_datetime(),
1703
                            api_get_user_id(),
1704
                            $courseId,
1705
                            $id_session
1706
                        );
1707
1708
                        if (Database::affected_rows($result)) {
1709
                            $nbr_users--;
1710
                        }
1711
                    }
1712
                }
1713
            }
1714
1715
            // Replace with this new function
1716
            // insert new users into session_rel_course_rel_user and ignore if they already exist
@@ 1719-1739 (lines=21) @@
1716
            // insert new users into session_rel_course_rel_user and ignore if they already exist
1717
1718
            foreach ($user_list as $enreg_user) {
1719
                if (!in_array($enreg_user, $existingUsers)) {
1720
                    $enreg_user = Database::escape_string($enreg_user);
1721
                    $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user (session_id, c_id, user_id, visibility, status)
1722
                            VALUES($id_session, $courseId, $enreg_user, $session_visibility, 0)";
1723
                    $result = Database::query($sql);
1724
1725
                    Event::addEvent(
1726
                        LOG_SESSION_ADD_USER_COURSE,
1727
                        LOG_USER_ID,
1728
                        $enreg_user,
1729
                        api_get_utc_datetime(),
1730
                        api_get_user_id(),
1731
                        $courseId,
1732
                        $id_session
1733
                    );
1734
1735
                    if (Database::affected_rows($result)) {
1736
1737
                        $nbr_users++;
1738
                    }
1739
                }
1740
            }
1741
1742
            // Count users in this session-course relation