/**
* 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);
}
}
}
