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