owncloud / core

	$connection = \OC_DB::getConnection();

	$chunkedPermissionList = array_chunk($updatedRows, $chunkSize, true);

	foreach ($chunkedPermissionList as $subList) {

		$statement = "UPDATE `*PREFIX*share` SET `permissions` = CASE `id` ";

		//update share table

		$ids = implode(',', array_keys($subList));

		foreach ($subList as $id => $permission) {

			$statement .= "WHEN " . $connection->quote($id, \PDO::PARAM_INT) . " THEN " . $permission . " ";

		}

		$statement .= ' END WHERE `id` IN (' . $ids . ')';

		$query = OCP\DB::prepare($statement);

		$query->execute();

	}

}

		$chunkedShareList = array_chunk($shares, $chunkSize, true);

		$connection = \OC_DB::getConnection();

		foreach ($chunkedShareList as $subList) {

			$statement = "UPDATE `*PREFIX*share` SET `file_target` = CASE `id` ";

			//update share table

			$ids = implode(',', array_keys($subList));

			foreach ($subList as $id => $target) {

				$statement .= "WHEN " . $connection->quote($id, \PDO::PARAM_INT) . " THEN " . $connection->quote('/Shared' . $target, \PDO::PARAM_STR);

			}

			$statement .= ' END WHERE `id` IN (' . $ids . ')';

			$query = OCP\DB::prepare($statement);

			$query->execute(array());

		}

		// set config to keep the Shared folder as the default location for new shares

		\OCA\Files_Sharing\Helper::setShareFolder('/Shared');