| @@ 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 |
|