lib/private/SubAdmin.php 2 locations
|
@@ 264-272 (lines=9) @@
|
| 261 |
|
* @param IUser $user |
| 262 |
|
* @return boolean |
| 263 |
|
*/ |
| 264 |
|
private function post_deleteUser($user) { |
| 265 |
|
$qb = $this->dbConn->getQueryBuilder(); |
| 266 |
|
|
| 267 |
|
$qb->delete('group_admin') |
| 268 |
|
->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID()))) |
| 269 |
|
->execute(); |
| 270 |
|
|
| 271 |
|
return true; |
| 272 |
|
} |
| 273 |
|
|
| 274 |
|
/** |
| 275 |
|
* delete all SubAdmins by $group |
|
@@ 279-287 (lines=9) @@
|
| 276 |
|
* @param IGroup $group |
| 277 |
|
* @return boolean |
| 278 |
|
*/ |
| 279 |
|
private function post_deleteGroup($group) { |
| 280 |
|
$qb = $this->dbConn->getQueryBuilder(); |
| 281 |
|
|
| 282 |
|
$qb->delete('group_admin') |
| 283 |
|
->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID()))) |
| 284 |
|
->execute(); |
| 285 |
|
|
| 286 |
|
return true; |
| 287 |
|
} |
| 288 |
|
} |
| 289 |
|
|
apps/dav/lib/DAV/Sharing/Backend.php 2 locations
|
@@ 105-111 (lines=7) @@
|
| 102 |
|
/** |
| 103 |
|
* @param $resourceId |
| 104 |
|
*/ |
| 105 |
|
public function deleteAllShares($resourceId) { |
| 106 |
|
$query = $this->db->getQueryBuilder(); |
| 107 |
|
$query->delete('dav_shares') |
| 108 |
|
->where($query->expr()->eq('resourceid', $query->createNamedParameter($resourceId))) |
| 109 |
|
->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType))) |
| 110 |
|
->execute(); |
| 111 |
|
} |
| 112 |
|
|
| 113 |
|
public function deleteAllSharesByUser($principaluri) { |
| 114 |
|
$query = $this->db->getQueryBuilder(); |
|
@@ 113-119 (lines=7) @@
|
| 110 |
|
->execute(); |
| 111 |
|
} |
| 112 |
|
|
| 113 |
|
public function deleteAllSharesByUser($principaluri) { |
| 114 |
|
$query = $this->db->getQueryBuilder(); |
| 115 |
|
$query->delete('dav_shares') |
| 116 |
|
->where($query->expr()->eq('principaluri', $query->createNamedParameter($principaluri))) |
| 117 |
|
->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType))) |
| 118 |
|
->execute(); |
| 119 |
|
} |
| 120 |
|
|
| 121 |
|
/** |
| 122 |
|
* @param IShareable $shareable |
lib/private/Files/Config/UserMountCache.php 2 locations
|
@@ 308-314 (lines=7) @@
|
| 305 |
|
* |
| 306 |
|
* @param IUser $user |
| 307 |
|
*/ |
| 308 |
|
public function removeUserMounts(IUser $user) { |
| 309 |
|
$builder = $this->connection->getQueryBuilder(); |
| 310 |
|
|
| 311 |
|
$query = $builder->delete('mounts') |
| 312 |
|
->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID()))); |
| 313 |
|
$query->execute(); |
| 314 |
|
} |
| 315 |
|
|
| 316 |
|
public function removeUserStorageMount($storageId, $userId) { |
| 317 |
|
$builder = $this->connection->getQueryBuilder(); |
|
@@ 325-331 (lines=7) @@
|
| 322 |
|
$query->execute(); |
| 323 |
|
} |
| 324 |
|
|
| 325 |
|
public function remoteStorageMounts($storageId) { |
| 326 |
|
$builder = $this->connection->getQueryBuilder(); |
| 327 |
|
|
| 328 |
|
$query = $builder->delete('mounts') |
| 329 |
|
->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT))); |
| 330 |
|
$query->execute(); |
| 331 |
|
} |
| 332 |
|
} |
| 333 |
|
|
lib/private/Settings/Mapper.php 1 location
|
@@ 137-143 (lines=7) @@
|
| 134 |
|
* @param $table Mapper::TABLE_ADMIN_SECTIONS or Mapper::TABLE_ADMIN_SETTINGS |
| 135 |
|
* @param $className |
| 136 |
|
*/ |
| 137 |
|
public function remove($table, $className) { |
| 138 |
|
$query = $this->dbc->getQueryBuilder(); |
| 139 |
|
$query->delete($table) |
| 140 |
|
->where($query->expr()->eq('class', $query->createNamedParameter($className))); |
| 141 |
|
|
| 142 |
|
$query->execute(); |
| 143 |
|
} |
| 144 |
|
|
| 145 |
|
/** |
| 146 |
|
* @param $table Mapper::TABLE_ADMIN_SECTIONS or Mapper::TABLE_ADMIN_SETTINGS |
apps/twofactor_backupcodes/lib/Db/BackupCodeMapper.php 1 location
|
@@ 55-62 (lines=8) @@
|
| 52 |
|
}, $rows); |
| 53 |
|
} |
| 54 |
|
|
| 55 |
|
public function deleteCodes(IUser $user) { |
| 56 |
|
/* @var IQueryBuilder $qb */ |
| 57 |
|
$qb = $this->db->getQueryBuilder(); |
| 58 |
|
|
| 59 |
|
$qb->delete('twofactor_backup_codes') |
| 60 |
|
->where($qb->expr()->eq('user_id', $qb->createNamedParameter($user->getUID()))); |
| 61 |
|
$qb->execute(); |
| 62 |
|
} |
| 63 |
|
|
| 64 |
|
} |
| 65 |
|
|
apps/federatedfilesharing/lib/Controller/RequestHandlerController.php 1 location
|
@@ 611-617 (lines=7) @@
|
| 608 |
|
* @param IShare $share |
| 609 |
|
* @param int $permissions |
| 610 |
|
*/ |
| 611 |
|
protected function updatePermissionsInDatabase(IShare $share, $permissions) { |
| 612 |
|
$query = $this->connection->getQueryBuilder(); |
| 613 |
|
$query->update('share') |
| 614 |
|
->where($query->expr()->eq('id', $query->createNamedParameter($share->getId()))) |
| 615 |
|
->set('permissions', $query->createNamedParameter($permissions)) |
| 616 |
|
->execute(); |
| 617 |
|
} |
| 618 |
|
|
| 619 |
|
/** |
| 620 |
|
* @NoCSRFRequired |
apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location
|
@@ 409-415 (lines=7) @@
|
| 406 |
|
* @param int $shareId |
| 407 |
|
* @param string $token |
| 408 |
|
*/ |
| 409 |
|
protected function updateSuccessfulReShare($shareId, $token) { |
| 410 |
|
$query = $this->dbConnection->getQueryBuilder(); |
| 411 |
|
$query->update('share') |
| 412 |
|
->where($query->expr()->eq('id', $query->createNamedParameter($shareId))) |
| 413 |
|
->set('token', $query->createNamedParameter($token)) |
| 414 |
|
->execute(); |
| 415 |
|
} |
| 416 |
|
|
| 417 |
|
/** |
| 418 |
|
* store remote ID in federated reShare table |
nextcloud /
server
