@@ -392,7 +392,7 @@ discard block  | 
                                                    ||
| 392 | 392 | }  | 
                                                        
| 393 | 393 | |
| 394 | 394 |  		if ($circle->getDisplayName() !== '') { | 
                                                        
| 395 | -			$this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); | 
                                                        |
| 395 | +			$this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); | 
                                                        |
| 396 | 396 | }  | 
                                                        
| 397 | 397 |  		if ($circle->getSource() > 0) { | 
                                                        
| 398 | 398 |  			$this->limitInt('source', $circle->getSource()); | 
                                                        
@@ -414,7 +414,7 @@ discard block  | 
                                                    ||
| 414 | 414 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance)  | 
                                                        
| 415 | 415 | ->leftJoin(  | 
                                                        
| 416 | 416 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance,  | 
                                                        
| 417 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance')  | 
                                                        |
| 417 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance')  | 
                                                        |
| 418 | 418 | );  | 
                                                        
| 419 | 419 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 420 | 420 | }  | 
                                                        
@@ -466,7 +466,7 @@ discard block  | 
                                                    ||
| 466 | 466 | $expr = $this->expr();  | 
                                                        
| 467 | 467 | $this->leftJoin(  | 
                                                        
| 468 | 468 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote,  | 
                                                        
| 469 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 469 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 470 | 470 | );  | 
                                                        
| 471 | 471 | }  | 
                                                        
| 472 | 472 | |
@@ -494,12 +494,12 @@ discard block  | 
                                                    ||
| 494 | 494 | $this->leftJoin(  | 
                                                        
| 495 | 495 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember,  | 
                                                        
| 496 | 496 | $expr->andX(  | 
                                                        
| 497 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 497 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 498 | 498 | $expr->eq(  | 
                                                        
| 499 | - $aliasRemoteMember . '.instance',  | 
                                                        |
| 499 | + $aliasRemoteMember.'.instance',  | 
                                                        |
| 500 | 500 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 501 | 501 | ),  | 
                                                        
| 502 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 502 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 503 | 503 | )  | 
                                                        
| 504 | 504 | );  | 
                                                        
| 505 | 505 | }  | 
                                                        
@@ -531,21 +531,21 @@ discard block  | 
                                                    ||
| 531 | 531 | $this->leftJoin(  | 
                                                        
| 532 | 532 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle,  | 
                                                        
| 533 | 533 | $expr->andX(  | 
                                                        
| 534 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 535 | - $expr->emptyString($aliasRemoteCircle . '.instance'),  | 
                                                        |
| 536 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 534 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 535 | + $expr->emptyString($aliasRemoteCircle.'.instance'),  | 
                                                        |
| 536 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 537 | 537 | )  | 
                                                        
| 538 | 538 | );  | 
                                                        
| 539 | 539 | $this->leftJoin(  | 
                                                        
| 540 | 540 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner,  | 
                                                        
| 541 | 541 | $expr->andX(  | 
                                                        
| 542 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'),  | 
                                                        |
| 542 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'),  | 
                                                        |
| 543 | 543 | $expr->eq(  | 
                                                        
| 544 | - $aliasRemoteCircleOwner . '.instance',  | 
                                                        |
| 544 | + $aliasRemoteCircleOwner.'.instance',  | 
                                                        |
| 545 | 545 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 546 | 546 | ),  | 
                                                        
| 547 | 547 | $expr->eq(  | 
                                                        
| 548 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 548 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 549 | 549 | )  | 
                                                        
| 550 | 550 | )  | 
                                                        
| 551 | 551 | );  | 
                                                        
@@ -578,16 +578,16 @@ discard block  | 
                                                    ||
| 578 | 578 | $expr = $this->expr();  | 
                                                        
| 579 | 579 | $orX = $expr->orX();  | 
                                                        
| 580 | 580 | $orX->add(  | 
                                                        
| 581 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 581 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 582 | 582 | );  | 
                                                        
| 583 | 583 | |
| 584 | 584 | $orExtOrPassive = $expr->orX();  | 
                                                        
| 585 | 585 | $orExtOrPassive->add(  | 
                                                        
| 586 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 586 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 587 | 587 | );  | 
                                                        
| 588 | 588 |  		if (!$sensitive) { | 
                                                        
| 589 | 589 | $orExtOrPassive->add(  | 
                                                        
| 590 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 590 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 591 | 591 | );  | 
                                                        
| 592 | 592 |  		} else { | 
                                                        
| 593 | 593 |  			if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { | 
                                                        
@@ -596,8 +596,8 @@ discard block  | 
                                                    ||
| 596 | 596 | }  | 
                                                        
| 597 | 597 | |
| 598 | 598 | $orInstance = $expr->orX();  | 
                                                        
| 599 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance'));  | 
                                                        |
| 600 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance'));  | 
                                                        |
| 599 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance'));  | 
                                                        |
| 600 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance'));  | 
                                                        |
| 601 | 601 | |
| 602 | 602 | $andExternal = $expr->andX();  | 
                                                        
| 603 | 603 | $andExternal->add($orExtOrPassive);  | 
                                                        
@@ -606,13 +606,13 @@ discard block  | 
                                                    ||
| 606 | 606 | $orExtOrTrusted = $expr->orX();  | 
                                                        
| 607 | 607 | $orExtOrTrusted->add($andExternal);  | 
                                                        
| 608 | 608 | $orExtOrTrusted->add(  | 
                                                        
| 609 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 609 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 610 | 610 | );  | 
                                                        
| 611 | 611 | |
| 612 | 612 | $andTrusted = $expr->andX();  | 
                                                        
| 613 | 613 | $andTrusted->add($orExtOrTrusted);  | 
                                                        
| 614 | 614 |  		$andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); | 
                                                        
| 615 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance'));  | 
                                                        |
| 615 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance'));  | 
                                                        |
| 616 | 616 | $orX->add($andTrusted);  | 
                                                        
| 617 | 617 | |
| 618 | 618 | $this->andWhere($orX);  | 
                                                        
@@ -639,7 +639,7 @@ discard block  | 
                                                    ||
| 639 | 639 | }  | 
                                                        
| 640 | 640 | $this->innerJoin(  | 
                                                        
| 641 | 641 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 642 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id')  | 
                                                        |
| 642 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id')  | 
                                                        |
| 643 | 643 | );  | 
                                                        
| 644 | 644 | |
| 645 | 645 | $this->filterDirectMembership($aliasMember, $member);  | 
                                                        
@@ -664,12 +664,12 @@ discard block  | 
                                                    ||
| 664 | 664 | $aliasCircle,  | 
                                                        
| 665 | 665 | 'circles_membership',  | 
                                                        
| 666 | 666 | $aliasMembership,  | 
                                                        
| 667 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id')  | 
                                                        |
| 667 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id')  | 
                                                        |
| 668 | 668 | );  | 
                                                        
| 669 | 669 | |
| 670 | 670 | $this->andWhere(  | 
                                                        
| 671 | 671 | $this->expr()->eq(  | 
                                                        
| 672 | - $aliasMembership . '.single_id',  | 
                                                        |
| 672 | + $aliasMembership.'.single_id',  | 
                                                        |
| 673 | 673 | $this->createNamedParameter($federatedUser->getSingleId())  | 
                                                        
| 674 | 674 | )  | 
                                                        
| 675 | 675 | );  | 
                                                        
@@ -690,19 +690,19 @@ discard block  | 
                                                    ||
| 690 | 690 | |
| 691 | 691 |  		if ($member->getUserId() !== '') { | 
                                                        
| 692 | 692 | $andX->add(  | 
                                                        
| 693 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 693 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 694 | 694 | );  | 
                                                        
| 695 | 695 | }  | 
                                                        
| 696 | 696 | |
| 697 | 697 |  		if ($member->getSingleId() !== '') { | 
                                                        
| 698 | 698 | $andX->add(  | 
                                                        
| 699 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 699 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 700 | 700 | );  | 
                                                        
| 701 | 701 | }  | 
                                                        
| 702 | 702 | |
| 703 | 703 |  		if ($member->getUserType() > 0) { | 
                                                        
| 704 | 704 | $andX->add(  | 
                                                        
| 705 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 705 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 706 | 706 | );  | 
                                                        
| 707 | 707 | }  | 
                                                        
| 708 | 708 | |
@@ -711,7 +711,7 @@ discard block  | 
                                                    ||
| 711 | 711 |  		if ($member->getLevel() > 0) { | 
                                                        
| 712 | 712 | $andX->add(  | 
                                                        
| 713 | 713 | $expr->gte(  | 
                                                        
| 714 | - $aliasMember . '.level',  | 
                                                        |
| 714 | + $aliasMember.'.level',  | 
                                                        |
| 715 | 715 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT)  | 
                                                        
| 716 | 716 | )  | 
                                                        
| 717 | 717 | );  | 
                                                        
@@ -752,7 +752,7 @@ discard block  | 
                                                    ||
| 752 | 752 | $helperAlias,  | 
                                                        
| 753 | 753 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 754 | 754 | $aliasCircle,  | 
                                                        
| 755 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field)  | 
                                                        |
| 755 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field)  | 
                                                        |
| 756 | 756 | );  | 
                                                        
| 757 | 757 | |
| 758 | 758 |  		if (!is_null($initiator)) { | 
                                                        
@@ -783,7 +783,7 @@ discard block  | 
                                                    ||
| 783 | 783 | $this->generateCircleSelectAlias($aliasInvitedBy)  | 
                                                        
| 784 | 784 | ->leftJoin(  | 
                                                        
| 785 | 785 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy,  | 
                                                        
| 786 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id')  | 
                                                        |
| 786 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id')  | 
                                                        |
| 787 | 787 | );  | 
                                                        
| 788 | 788 | |
| 789 | 789 | $this->leftJoinOwner($aliasInvitedBy);  | 
                                                        
@@ -814,7 +814,7 @@ discard block  | 
                                                    ||
| 814 | 814 | $this->generateCircleSelectAlias($aliasBasedOn)  | 
                                                        
| 815 | 815 | ->leftJoin(  | 
                                                        
| 816 | 816 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn,  | 
                                                        
| 817 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id')  | 
                                                        |
| 817 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id')  | 
                                                        |
| 818 | 818 | );  | 
                                                        
| 819 | 819 | |
| 820 | 820 |  		if (!is_null($initiator)) { | 
                                                        
@@ -847,9 +847,9 @@ discard block  | 
                                                    ||
| 847 | 847 | ->leftJoin(  | 
                                                        
| 848 | 848 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 849 | 849 | $expr->andX(  | 
                                                        
| 850 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 850 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 851 | 851 | $expr->eq(  | 
                                                        
| 852 | - $aliasMember . '.level',  | 
                                                        |
| 852 | + $aliasMember.'.level',  | 
                                                        |
| 853 | 853 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT)  | 
                                                        
| 854 | 854 | )  | 
                                                        
| 855 | 855 | )  | 
                                                        
@@ -887,10 +887,10 @@ discard block  | 
                                                    ||
| 887 | 887 | ->leftJoin(  | 
                                                        
| 888 | 888 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 889 | 889 | $expr->andX(  | 
                                                        
| 890 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId),  | 
                                                        |
| 891 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId),  | 
                                                        |
| 890 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId),  | 
                                                        |
| 891 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId),  | 
                                                        |
| 892 | 892 | $expr->gte(  | 
                                                        
| 893 | - $aliasMember . '.level',  | 
                                                        |
| 893 | + $aliasMember.'.level',  | 
                                                        |
| 894 | 894 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT)  | 
                                                        
| 895 | 895 | )  | 
                                                        
| 896 | 896 | )  | 
                                                        
@@ -923,7 +923,7 @@ discard block  | 
                                                    ||
| 923 | 923 | |
| 924 | 924 | $this->leftJoin(  | 
                                                        
| 925 | 925 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 926 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)  | 
                                                        |
| 926 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)  | 
                                                        |
| 927 | 927 | );  | 
                                                        
| 928 | 928 | |
| 929 | 929 |  //		if (!$this->getBool('getData', $options, false)) { | 
                                                        
@@ -937,8 +937,8 @@ discard block  | 
                                                    ||
| 937 | 937 | ->leftJoin(  | 
                                                        
| 938 | 938 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 939 | 939 | $expr->andX(  | 
                                                        
| 940 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'),  | 
                                                        |
| 941 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id')  | 
                                                        |
| 940 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'),  | 
                                                        |
| 941 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id')  | 
                                                        |
| 942 | 942 | )  | 
                                                        
| 943 | 943 | );  | 
                                                        
| 944 | 944 | |
@@ -955,12 +955,12 @@ discard block  | 
                                                    ||
| 955 | 955 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options);  | 
                                                        
| 956 | 956 | $this->leftJoin(  | 
                                                        
| 957 | 957 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership,  | 
                                                        
| 958 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 958 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 959 | 959 | );  | 
                                                        
| 960 | 960 | |
| 961 | 961 | $orX = $expr->orX(  | 
                                                        
| 962 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 963 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId))  | 
                                                        |
| 962 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 963 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId))  | 
                                                        |
| 964 | 964 | );  | 
                                                        
| 965 | 965 | |
| 966 | 966 | $this->andWhere($orX);  | 
                                                        
@@ -981,11 +981,11 @@ discard block  | 
                                                    ||
| 981 | 981 | |
| 982 | 982 | $expr = $this->expr();  | 
                                                        
| 983 | 983 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS);  | 
                                                        
| 984 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 984 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 985 | 985 |  		if ($level > 1) { | 
                                                        
| 986 | 986 | $this->andWhere(  | 
                                                        
| 987 | 987 | $expr->gte(  | 
                                                        
| 988 | - $aliasMembership . '.level',  | 
                                                        |
| 988 | + $aliasMembership.'.level',  | 
                                                        |
| 989 | 989 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT)  | 
                                                        
| 990 | 990 | )  | 
                                                        
| 991 | 991 | );  | 
                                                        
@@ -1013,8 +1013,8 @@ discard block  | 
                                                    ||
| 1013 | 1013 | $this->leftJoin(  | 
                                                        
| 1014 | 1014 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 1015 | 1015 | $expr->andX(  | 
                                                        
| 1016 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field),  | 
                                                        |
| 1017 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id')  | 
                                                        |
| 1016 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field),  | 
                                                        |
| 1017 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id')  | 
                                                        |
| 1018 | 1018 | )  | 
                                                        
| 1019 | 1019 | );  | 
                                                        
| 1020 | 1020 | |
@@ -1027,8 +1027,8 @@ discard block  | 
                                                    ||
| 1027 | 1027 | ->leftJoin(  | 
                                                        
| 1028 | 1028 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom,  | 
                                                        
| 1029 | 1029 | $expr->andX(  | 
                                                        
| 1030 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'),  | 
                                                        |
| 1031 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id')  | 
                                                        |
| 1030 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'),  | 
                                                        |
| 1031 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id')  | 
                                                        |
| 1032 | 1032 | )  | 
                                                        
| 1033 | 1033 | );  | 
                                                        
| 1034 | 1034 | }  | 
                                                        
@@ -1068,7 +1068,7 @@ discard block  | 
                                                    ||
| 1068 | 1068 | |
| 1069 | 1069 | $this->leftJoin(  | 
                                                        
| 1070 | 1070 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken,  | 
                                                        
| 1071 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field)  | 
                                                        |
| 1071 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field)  | 
                                                        |
| 1072 | 1072 | );  | 
                                                        
| 1073 | 1073 | }  | 
                                                        
| 1074 | 1074 | |
@@ -1110,14 +1110,14 @@ discard block  | 
                                                    ||
| 1110 | 1110 |  		try { | 
                                                        
| 1111 | 1111 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options);  | 
                                                        
| 1112 | 1112 | $this->selectAlias(  | 
                                                        
| 1113 | - $aliasConfig . '.config',  | 
                                                        |
| 1114 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config'  | 
                                                        |
| 1113 | + $aliasConfig.'.config',  | 
                                                        |
| 1114 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config'  | 
                                                        |
| 1115 | 1115 | );  | 
                                                        
| 1116 | 1116 | $this->leftJoin(  | 
                                                        
| 1117 | 1117 | $alias,  | 
                                                        
| 1118 | 1118 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 1119 | 1119 | $aliasConfig,  | 
                                                        
| 1120 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id')  | 
                                                        |
| 1120 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id')  | 
                                                        |
| 1121 | 1121 | );  | 
                                                        
| 1122 | 1122 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 1123 | 1123 | }  | 
                                                        
@@ -1155,7 +1155,7 @@ discard block  | 
                                                    ||
| 1155 | 1155 | $aliasMembership,  | 
                                                        
| 1156 | 1156 | $expr->andX(  | 
                                                        
| 1157 | 1157 |  				$this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), | 
                                                        
| 1158 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1158 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1159 | 1159 | )  | 
                                                        
| 1160 | 1160 | );  | 
                                                        
| 1161 | 1161 | |
@@ -1174,11 +1174,11 @@ discard block  | 
                                                    ||
| 1174 | 1174 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options);  | 
                                                        
| 1175 | 1175 | $orXMembershipCircle = $expr->orX();  | 
                                                        
| 1176 | 1176 | array_map(  | 
                                                        
| 1177 | -				function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1177 | +				function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1178 | 1178 | $orXMembershipCircle->add(  | 
                                                        
| 1179 | 1179 | $this->expr()->eq(  | 
                                                        
| 1180 | - $alias . '.circle_id',  | 
                                                        |
| 1181 | - $aliasMembershipCircle . '.unique_id'  | 
                                                        |
| 1180 | + $alias.'.circle_id',  | 
                                                        |
| 1181 | + $aliasMembershipCircle.'.unique_id'  | 
                                                        |
| 1182 | 1182 | )  | 
                                                        
| 1183 | 1183 | );  | 
                                                        
| 1184 | 1184 | },  | 
                                                        
@@ -1210,7 +1210,7 @@ discard block  | 
                                                    ||
| 1210 | 1210 | $aliasDirectInitiator,  | 
                                                        
| 1211 | 1211 | $expr->andX(  | 
                                                        
| 1212 | 1212 |  							 $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), | 
                                                        
| 1213 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1213 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1214 | 1214 | )  | 
                                                        
| 1215 | 1215 | );  | 
                                                        
| 1216 | 1216 |  			} catch (RequestBuilderException $e) { | 
                                                        
@@ -1224,8 +1224,8 @@ discard block  | 
                                                    ||
| 1224 | 1224 | $this->leftJoin(  | 
                                                        
| 1225 | 1225 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator,  | 
                                                        
| 1226 | 1226 | $expr->andX(  | 
                                                        
| 1227 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'),  | 
                                                        |
| 1228 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id')  | 
                                                        |
| 1227 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'),  | 
                                                        |
| 1228 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id')  | 
                                                        |
| 1229 | 1229 | )  | 
                                                        
| 1230 | 1230 | );  | 
                                                        
| 1231 | 1231 | |
@@ -1233,8 +1233,8 @@ discard block  | 
                                                    ||
| 1233 | 1233 | $this->leftJoin(  | 
                                                        
| 1234 | 1234 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 1235 | 1235 | $expr->andX(  | 
                                                        
| 1236 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'),  | 
                                                        |
| 1237 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id')  | 
                                                        |
| 1236 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'),  | 
                                                        |
| 1237 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id')  | 
                                                        |
| 1238 | 1238 | )  | 
                                                        
| 1239 | 1239 | );  | 
                                                        
| 1240 | 1240 | |
@@ -1285,7 +1285,7 @@ discard block  | 
                                                    ||
| 1285 | 1285 | $orX->add(  | 
                                                        
| 1286 | 1286 | $expr->andX(  | 
                                                        
| 1287 | 1287 |  					$this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), | 
                                                        
| 1288 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1288 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1289 | 1289 | )  | 
                                                        
| 1290 | 1290 | );  | 
                                                        
| 1291 | 1291 | }  | 
                                                        
@@ -1295,10 +1295,10 @@ discard block  | 
                                                    ||
| 1295 | 1295 | $orXLevelCheck = $expr->orX();  | 
                                                        
| 1296 | 1296 | |
| 1297 | 1297 | array_map(  | 
                                                        
| 1298 | -			function (string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1298 | +			function(string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1299 | 1299 | $orXLevelCheck->add(  | 
                                                        
| 1300 | 1300 | $this->expr()->gte(  | 
                                                        
| 1301 | - $alias . '.level',  | 
                                                        |
| 1301 | + $alias.'.level',  | 
                                                        |
| 1302 | 1302 | $this->createNamedParameter($minimumLevel)  | 
                                                        
| 1303 | 1303 | )  | 
                                                        
| 1304 | 1304 | );  | 
                                                        
@@ -1388,21 +1388,21 @@ discard block  | 
                                                    ||
| 1388 | 1388 | $expr = $this->expr();  | 
                                                        
| 1389 | 1389 | $andPassive = $expr->andX();  | 
                                                        
| 1390 | 1390 | $andPassive->add(  | 
                                                        
| 1391 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1391 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1392 | 1392 | );  | 
                                                        
| 1393 | 1393 | |
| 1394 | 1394 | $orMemberOrLevel = $expr->orX();  | 
                                                        
| 1395 | 1395 | $orMemberOrLevel->add(  | 
                                                        
| 1396 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance')  | 
                                                        |
| 1396 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance')  | 
                                                        |
| 1397 | 1397 | );  | 
                                                        
| 1398 | 1398 | // TODO: do we need this ? (display members from the local instance)  | 
                                                        
| 1399 | 1399 | $orMemberOrLevel->add(  | 
                                                        
| 1400 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance')  | 
                                                        |
| 1400 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance')  | 
                                                        |
| 1401 | 1401 | );  | 
                                                        
| 1402 | 1402 | |
| 1403 | 1403 | $orMemberOrLevel->add(  | 
                                                        
| 1404 | 1404 | $expr->eq(  | 
                                                        
| 1405 | - $this->getDefaultSelectAlias() . '.level',  | 
                                                        |
| 1405 | + $this->getDefaultSelectAlias().'.level',  | 
                                                        |
| 1406 | 1406 | $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        
| 1407 | 1407 | )  | 
                                                        
| 1408 | 1408 | );  | 
                                                        
@@ -1439,11 +1439,11 @@ discard block  | 
                                                    ||
| 1439 | 1439 | )  | 
                                                        
| 1440 | 1440 | ->leftJoin(  | 
                                                        
| 1441 | 1441 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache,  | 
                                                        
| 1442 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid')  | 
                                                        |
| 1442 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid')  | 
                                                        |
| 1443 | 1443 | )  | 
                                                        
| 1444 | 1444 | ->leftJoin(  | 
                                                        
| 1445 | 1445 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages,  | 
                                                        
| 1446 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id')  | 
                                                        |
| 1446 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id')  | 
                                                        |
| 1447 | 1447 | );  | 
                                                        
| 1448 | 1448 | }  | 
                                                        
| 1449 | 1449 | |
@@ -1465,8 +1465,8 @@ discard block  | 
                                                    ||
| 1465 | 1465 | $this->leftJoin(  | 
                                                        
| 1466 | 1466 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild,  | 
                                                        
| 1467 | 1467 | $expr->andX(  | 
                                                        
| 1468 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'),  | 
                                                        |
| 1469 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id')  | 
                                                        |
| 1468 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'),  | 
                                                        |
| 1469 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id')  | 
                                                        |
| 1470 | 1470 | )  | 
                                                        
| 1471 | 1471 | );  | 
                                                        
| 1472 | 1472 | |
@@ -1516,13 +1516,13 @@ discard block  | 
                                                    ||
| 1516 | 1516 | $this->leftJoin(  | 
                                                        
| 1517 | 1517 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint,  | 
                                                        
| 1518 | 1518 | $expr->andX(  | 
                                                        
| 1519 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'),  | 
                                                        |
| 1520 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id')  | 
                                                        |
| 1519 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'),  | 
                                                        |
| 1520 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id')  | 
                                                        |
| 1521 | 1521 | )  | 
                                                        
| 1522 | 1522 | );  | 
                                                        
| 1523 | 1523 | |
| 1524 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint');  | 
                                                        |
| 1525 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash');  | 
                                                        |
| 1524 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint');  | 
                                                        |
| 1525 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash');  | 
                                                        |
| 1526 | 1526 | }  | 
                                                        
| 1527 | 1527 | |
| 1528 | 1528 | |
@@ -1626,10 +1626,10 @@ discard block  | 
                                                    ||
| 1626 | 1626 | */  | 
                                                        
| 1627 | 1627 |  	public function generateAlias(string $base, string $extension, ?array &$options = []): string { | 
                                                        
| 1628 | 1628 |  		$search = str_replace('_', '.', $base); | 
                                                        
| 1629 | - $path = $search . '.' . $extension;  | 
                                                        |
| 1629 | + $path = $search.'.'.$extension;  | 
                                                        |
| 1630 | 1630 | if (!$this->validKey($path, self::$SQL_PATH)  | 
                                                        
| 1631 | 1631 |  			&& !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { | 
                                                        
| 1632 | - throw new RequestBuilderException($extension . ' not found in ' . $search);  | 
                                                        |
| 1632 | + throw new RequestBuilderException($extension.' not found in '.$search);  | 
                                                        |
| 1633 | 1633 | }  | 
                                                        
| 1634 | 1634 | |
| 1635 | 1635 |  		if (!is_array($options)) { | 
                                                        
@@ -1638,15 +1638,15 @@ discard block  | 
                                                    ||
| 1638 | 1638 | |
| 1639 | 1639 | $optionPath = '';  | 
                                                        
| 1640 | 1640 |  		foreach (explode('.', $path) as $p) { | 
                                                        
| 1641 | - $optionPath = trim($optionPath . '.' . $p, '.');  | 
                                                        |
| 1641 | + $optionPath = trim($optionPath.'.'.$p, '.');  | 
                                                        |
| 1642 | 1642 | $options = array_merge(  | 
                                                        
| 1643 | 1643 | $options,  | 
                                                        
| 1644 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH),  | 
                                                        |
| 1645 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options)  | 
                                                        |
| 1644 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH),  | 
                                                        |
| 1645 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options)  | 
                                                        |
| 1646 | 1646 | );  | 
                                                        
| 1647 | 1647 | }  | 
                                                        
| 1648 | 1648 | |
| 1649 | - return $base . '_' . $extension;  | 
                                                        |
| 1649 | + return $base.'_'.$extension;  | 
                                                        |
| 1650 | 1650 | }  | 
                                                        
| 1651 | 1651 | |
| 1652 | 1652 | |
@@ -1666,7 +1666,7 @@ discard block  | 
                                                    ||
| 1666 | 1666 |  			} else { | 
                                                        
| 1667 | 1667 | $k = $arr;  | 
                                                        
| 1668 | 1668 | }  | 
                                                        
| 1669 | - $path[$k] = $prefix . '_' . $k . '_';  | 
                                                        |
| 1669 | + $path[$k] = $prefix.'_'.$k.'_';  | 
                                                        |
| 1670 | 1670 | }  | 
                                                        
| 1671 | 1671 | |
| 1672 | 1672 | return $path;  |