Devel

lib/Db/OC/FilecacheMapper.php

@@ -130,13 +130,17 @@ class FilecacheMapper extends ExtMapper {
 	private function joinUserAccounts(IQueryBuilder $query) {
 		if ($this->accountsState != 0) {
 			$query->join('fc', StoragesMapper::STORAGES_TABLE, 's', 's.numeric_id = fc.storage')
-				->join('s', AccountsMapper::ACCOUNTS_TABLE, 'a', "CONCAT('home::', a.user_id) = s.id");
+				->join('s', PreferencesMapper::PREFERENCES_TABLE, 'p', "CONCAT('home::', p.userid) = s.id");
 		}
 	}
 
 	private function addUserAccountsCondition(IQueryBuilder $query) {
 		if ($this->accountsState != 0) {
-			$query->andWhere($query->expr()->eq('a.state', $query->createPositionalParameter($this->accountsState, IQueryBuilder::PARAM_INT)));
+			$query->andWhere(
+				$query->expr()->andX($query->expr()->eq('configkey',
+					$query->createParameter('enabled')),
+					$query->expr()->in('configvalue', $query->createParameter('true'))
+				));
 		}
 	}