/** * Updates the access_url_rel_course table with a given user list * @author Julio Montoya * @param array user list * @param int access_url_id * */ public static function update_urls_rel_usergroup($userGroupList, $urlId) { $table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP); $sql = "SELECT usergroup_id FROM {$table} WHERE access_url_id = " . intval($urlId); $result = Database::query($sql); $existingItems = array(); while ($row = Database::fetch_array($result)) { $existingItems[] = $row['usergroup_id']; } // Adding foreach ($userGroupList as $userGroupId) { if (!in_array($userGroupId, $existingItems)) { UrlManager::addUserGroupToUrl($userGroupId, $urlId); } } // Deleting old items foreach ($existingItems as $userGroupId) { if (!in_array($userGroupId, $userGroupList)) { UrlManager::delete_url_rel_usergroup($userGroupId, $urlId); } } }