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