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