@@ -398,8 +398,8 @@ discard block  | 
                                                    ||
| 398 | 398 |  			foreach (explode(' ', $circle->getDisplayName()) as $word) { | 
                                                        
| 399 | 399 | $andX->add(  | 
                                                        
| 400 | 400 | $expr->iLike(  | 
                                                        
| 401 | - $this->getDefaultSelectAlias() . '.' . 'display_name',  | 
                                                        |
| 402 | -						$this->createNamedParameter('%' . $word . '%') | 
                                                        |
| 401 | + $this->getDefaultSelectAlias().'.'.'display_name',  | 
                                                        |
| 402 | +						$this->createNamedParameter('%'.$word.'%') | 
                                                        |
| 403 | 403 | )  | 
                                                        
| 404 | 404 | );  | 
                                                        
| 405 | 405 | }  | 
                                                        
@@ -410,8 +410,8 @@ discard block  | 
                                                    ||
| 410 | 410 |  			foreach (explode(' ', $circle->getDescription()) as $word) { | 
                                                        
| 411 | 411 | $orDescription->add(  | 
                                                        
| 412 | 412 | $expr->iLike(  | 
                                                        
| 413 | - $this->getDefaultSelectAlias() . '.' . 'description',  | 
                                                        |
| 414 | -						$this->createNamedParameter('%' . $word . '%') | 
                                                        |
| 413 | + $this->getDefaultSelectAlias().'.'.'description',  | 
                                                        |
| 414 | +						$this->createNamedParameter('%'.$word.'%') | 
                                                        |
| 415 | 415 | )  | 
                                                        
| 416 | 416 | );  | 
                                                        
| 417 | 417 | }  | 
                                                        
@@ -441,7 +441,7 @@ discard block  | 
                                                    ||
| 441 | 441 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance)  | 
                                                        
| 442 | 442 | ->leftJoin(  | 
                                                        
| 443 | 443 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance,  | 
                                                        
| 444 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance')  | 
                                                        |
| 444 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance')  | 
                                                        |
| 445 | 445 | );  | 
                                                        
| 446 | 446 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 447 | 447 | }  | 
                                                        
@@ -493,7 +493,7 @@ discard block  | 
                                                    ||
| 493 | 493 | $expr = $this->expr();  | 
                                                        
| 494 | 494 | $this->leftJoin(  | 
                                                        
| 495 | 495 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote,  | 
                                                        
| 496 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 496 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 497 | 497 | );  | 
                                                        
| 498 | 498 | }  | 
                                                        
| 499 | 499 | |
@@ -521,12 +521,12 @@ discard block  | 
                                                    ||
| 521 | 521 | $this->leftJoin(  | 
                                                        
| 522 | 522 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember,  | 
                                                        
| 523 | 523 | $expr->andX(  | 
                                                        
| 524 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 524 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 525 | 525 | $expr->eq(  | 
                                                        
| 526 | - $aliasRemoteMember . '.instance',  | 
                                                        |
| 526 | + $aliasRemoteMember.'.instance',  | 
                                                        |
| 527 | 527 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 528 | 528 | ),  | 
                                                        
| 529 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 529 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 530 | 530 | )  | 
                                                        
| 531 | 531 | );  | 
                                                        
| 532 | 532 | }  | 
                                                        
@@ -558,21 +558,21 @@ discard block  | 
                                                    ||
| 558 | 558 | $this->leftJoin(  | 
                                                        
| 559 | 559 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle,  | 
                                                        
| 560 | 560 | $expr->andX(  | 
                                                        
| 561 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 562 | - $expr->emptyString($aliasRemoteCircle . '.instance'),  | 
                                                        |
| 563 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 561 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 562 | + $expr->emptyString($aliasRemoteCircle.'.instance'),  | 
                                                        |
| 563 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 564 | 564 | )  | 
                                                        
| 565 | 565 | );  | 
                                                        
| 566 | 566 | $this->leftJoin(  | 
                                                        
| 567 | 567 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner,  | 
                                                        
| 568 | 568 | $expr->andX(  | 
                                                        
| 569 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'),  | 
                                                        |
| 569 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'),  | 
                                                        |
| 570 | 570 | $expr->eq(  | 
                                                        
| 571 | - $aliasRemoteCircleOwner . '.instance',  | 
                                                        |
| 571 | + $aliasRemoteCircleOwner.'.instance',  | 
                                                        |
| 572 | 572 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 573 | 573 | ),  | 
                                                        
| 574 | 574 | $expr->eq(  | 
                                                        
| 575 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 575 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 576 | 576 | )  | 
                                                        
| 577 | 577 | )  | 
                                                        
| 578 | 578 | );  | 
                                                        
@@ -605,16 +605,16 @@ discard block  | 
                                                    ||
| 605 | 605 | $expr = $this->expr();  | 
                                                        
| 606 | 606 | $orX = $expr->orX();  | 
                                                        
| 607 | 607 | $orX->add(  | 
                                                        
| 608 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 608 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 609 | 609 | );  | 
                                                        
| 610 | 610 | |
| 611 | 611 | $orExtOrPassive = $expr->orX();  | 
                                                        
| 612 | 612 | $orExtOrPassive->add(  | 
                                                        
| 613 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 613 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 614 | 614 | );  | 
                                                        
| 615 | 615 |  		if (!$sensitive) { | 
                                                        
| 616 | 616 | $orExtOrPassive->add(  | 
                                                        
| 617 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 617 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 618 | 618 | );  | 
                                                        
| 619 | 619 |  		} else { | 
                                                        
| 620 | 620 |  			if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { | 
                                                        
@@ -623,8 +623,8 @@ discard block  | 
                                                    ||
| 623 | 623 | }  | 
                                                        
| 624 | 624 | |
| 625 | 625 | $orInstance = $expr->orX();  | 
                                                        
| 626 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance'));  | 
                                                        |
| 627 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance'));  | 
                                                        |
| 626 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance'));  | 
                                                        |
| 627 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance'));  | 
                                                        |
| 628 | 628 | |
| 629 | 629 | $andExternal = $expr->andX();  | 
                                                        
| 630 | 630 | $andExternal->add($orExtOrPassive);  | 
                                                        
@@ -633,13 +633,13 @@ discard block  | 
                                                    ||
| 633 | 633 | $orExtOrTrusted = $expr->orX();  | 
                                                        
| 634 | 634 | $orExtOrTrusted->add($andExternal);  | 
                                                        
| 635 | 635 | $orExtOrTrusted->add(  | 
                                                        
| 636 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 636 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 637 | 637 | );  | 
                                                        
| 638 | 638 | |
| 639 | 639 | $andTrusted = $expr->andX();  | 
                                                        
| 640 | 640 | $andTrusted->add($orExtOrTrusted);  | 
                                                        
| 641 | 641 |  		$andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); | 
                                                        
| 642 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance'));  | 
                                                        |
| 642 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance'));  | 
                                                        |
| 643 | 643 | $orX->add($andTrusted);  | 
                                                        
| 644 | 644 | |
| 645 | 645 | $this->andWhere($orX);  | 
                                                        
@@ -666,7 +666,7 @@ discard block  | 
                                                    ||
| 666 | 666 | }  | 
                                                        
| 667 | 667 | $this->innerJoin(  | 
                                                        
| 668 | 668 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 669 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id')  | 
                                                        |
| 669 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id')  | 
                                                        |
| 670 | 670 | );  | 
                                                        
| 671 | 671 | |
| 672 | 672 | $this->filterDirectMembership($aliasMember, $member);  | 
                                                        
@@ -691,12 +691,12 @@ discard block  | 
                                                    ||
| 691 | 691 | $aliasCircle,  | 
                                                        
| 692 | 692 | 'circles_membership',  | 
                                                        
| 693 | 693 | $aliasMembership,  | 
                                                        
| 694 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id')  | 
                                                        |
| 694 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id')  | 
                                                        |
| 695 | 695 | );  | 
                                                        
| 696 | 696 | |
| 697 | 697 | $this->andWhere(  | 
                                                        
| 698 | 698 | $this->expr()->eq(  | 
                                                        
| 699 | - $aliasMembership . '.single_id',  | 
                                                        |
| 699 | + $aliasMembership.'.single_id',  | 
                                                        |
| 700 | 700 | $this->createNamedParameter($federatedUser->getSingleId())  | 
                                                        
| 701 | 701 | )  | 
                                                        
| 702 | 702 | );  | 
                                                        
@@ -717,19 +717,19 @@ discard block  | 
                                                    ||
| 717 | 717 | |
| 718 | 718 |  		if ($member->getUserId() !== '') { | 
                                                        
| 719 | 719 | $andX->add(  | 
                                                        
| 720 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 720 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 721 | 721 | );  | 
                                                        
| 722 | 722 | }  | 
                                                        
| 723 | 723 | |
| 724 | 724 |  		if ($member->getSingleId() !== '') { | 
                                                        
| 725 | 725 | $andX->add(  | 
                                                        
| 726 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 726 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 727 | 727 | );  | 
                                                        
| 728 | 728 | }  | 
                                                        
| 729 | 729 | |
| 730 | 730 |  		if ($member->getUserType() > 0) { | 
                                                        
| 731 | 731 | $andX->add(  | 
                                                        
| 732 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 732 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 733 | 733 | );  | 
                                                        
| 734 | 734 | }  | 
                                                        
| 735 | 735 | |
@@ -738,7 +738,7 @@ discard block  | 
                                                    ||
| 738 | 738 |  		if ($member->getLevel() > 0) { | 
                                                        
| 739 | 739 | $andX->add(  | 
                                                        
| 740 | 740 | $expr->gte(  | 
                                                        
| 741 | - $aliasMember . '.level',  | 
                                                        |
| 741 | + $aliasMember.'.level',  | 
                                                        |
| 742 | 742 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT)  | 
                                                        
| 743 | 743 | )  | 
                                                        
| 744 | 744 | );  | 
                                                        
@@ -779,7 +779,7 @@ discard block  | 
                                                    ||
| 779 | 779 | $helperAlias,  | 
                                                        
| 780 | 780 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 781 | 781 | $aliasCircle,  | 
                                                        
| 782 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field)  | 
                                                        |
| 782 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field)  | 
                                                        |
| 783 | 783 | );  | 
                                                        
| 784 | 784 | |
| 785 | 785 |  		if (!is_null($initiator)) { | 
                                                        
@@ -810,7 +810,7 @@ discard block  | 
                                                    ||
| 810 | 810 | $this->generateCircleSelectAlias($aliasInvitedBy)  | 
                                                        
| 811 | 811 | ->leftJoin(  | 
                                                        
| 812 | 812 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy,  | 
                                                        
| 813 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id')  | 
                                                        |
| 813 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id')  | 
                                                        |
| 814 | 814 | );  | 
                                                        
| 815 | 815 | |
| 816 | 816 | $this->leftJoinOwner($aliasInvitedBy);  | 
                                                        
@@ -841,7 +841,7 @@ discard block  | 
                                                    ||
| 841 | 841 | $this->generateCircleSelectAlias($aliasBasedOn)  | 
                                                        
| 842 | 842 | ->leftJoin(  | 
                                                        
| 843 | 843 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn,  | 
                                                        
| 844 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id')  | 
                                                        |
| 844 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id')  | 
                                                        |
| 845 | 845 | );  | 
                                                        
| 846 | 846 | |
| 847 | 847 |  		if (!is_null($initiator)) { | 
                                                        
@@ -874,9 +874,9 @@ discard block  | 
                                                    ||
| 874 | 874 | ->leftJoin(  | 
                                                        
| 875 | 875 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 876 | 876 | $expr->andX(  | 
                                                        
| 877 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 877 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 878 | 878 | $expr->eq(  | 
                                                        
| 879 | - $aliasMember . '.level',  | 
                                                        |
| 879 | + $aliasMember.'.level',  | 
                                                        |
| 880 | 880 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT)  | 
                                                        
| 881 | 881 | )  | 
                                                        
| 882 | 882 | )  | 
                                                        
@@ -914,10 +914,10 @@ discard block  | 
                                                    ||
| 914 | 914 | ->leftJoin(  | 
                                                        
| 915 | 915 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 916 | 916 | $expr->andX(  | 
                                                        
| 917 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId),  | 
                                                        |
| 918 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId),  | 
                                                        |
| 917 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId),  | 
                                                        |
| 918 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId),  | 
                                                        |
| 919 | 919 | $expr->gte(  | 
                                                        
| 920 | - $aliasMember . '.level',  | 
                                                        |
| 920 | + $aliasMember.'.level',  | 
                                                        |
| 921 | 921 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT)  | 
                                                        
| 922 | 922 | )  | 
                                                        
| 923 | 923 | )  | 
                                                        
@@ -950,7 +950,7 @@ discard block  | 
                                                    ||
| 950 | 950 | |
| 951 | 951 | $this->leftJoin(  | 
                                                        
| 952 | 952 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 953 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)  | 
                                                        |
| 953 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)  | 
                                                        |
| 954 | 954 | );  | 
                                                        
| 955 | 955 | |
| 956 | 956 |  //		if (!$this->getBool('getData', $options, false)) { | 
                                                        
@@ -964,8 +964,8 @@ discard block  | 
                                                    ||
| 964 | 964 | ->leftJoin(  | 
                                                        
| 965 | 965 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 966 | 966 | $expr->andX(  | 
                                                        
| 967 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'),  | 
                                                        |
| 968 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id')  | 
                                                        |
| 967 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'),  | 
                                                        |
| 968 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id')  | 
                                                        |
| 969 | 969 | )  | 
                                                        
| 970 | 970 | );  | 
                                                        
| 971 | 971 | |
@@ -982,12 +982,12 @@ discard block  | 
                                                    ||
| 982 | 982 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options);  | 
                                                        
| 983 | 983 | $this->leftJoin(  | 
                                                        
| 984 | 984 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership,  | 
                                                        
| 985 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 985 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 986 | 986 | );  | 
                                                        
| 987 | 987 | |
| 988 | 988 | $orX = $expr->orX(  | 
                                                        
| 989 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 990 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId))  | 
                                                        |
| 989 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 990 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId))  | 
                                                        |
| 991 | 991 | );  | 
                                                        
| 992 | 992 | |
| 993 | 993 | $this->andWhere($orX);  | 
                                                        
@@ -1008,11 +1008,11 @@ discard block  | 
                                                    ||
| 1008 | 1008 | |
| 1009 | 1009 | $expr = $this->expr();  | 
                                                        
| 1010 | 1010 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS);  | 
                                                        
| 1011 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 1011 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 1012 | 1012 |  		if ($level > 1) { | 
                                                        
| 1013 | 1013 | $this->andWhere(  | 
                                                        
| 1014 | 1014 | $expr->gte(  | 
                                                        
| 1015 | - $aliasMembership . '.level',  | 
                                                        |
| 1015 | + $aliasMembership.'.level',  | 
                                                        |
| 1016 | 1016 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT)  | 
                                                        
| 1017 | 1017 | )  | 
                                                        
| 1018 | 1018 | );  | 
                                                        
@@ -1040,8 +1040,8 @@ discard block  | 
                                                    ||
| 1040 | 1040 | $this->leftJoin(  | 
                                                        
| 1041 | 1041 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 1042 | 1042 | $expr->andX(  | 
                                                        
| 1043 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field),  | 
                                                        |
| 1044 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id')  | 
                                                        |
| 1043 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field),  | 
                                                        |
| 1044 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id')  | 
                                                        |
| 1045 | 1045 | )  | 
                                                        
| 1046 | 1046 | );  | 
                                                        
| 1047 | 1047 | |
@@ -1054,8 +1054,8 @@ discard block  | 
                                                    ||
| 1054 | 1054 | ->leftJoin(  | 
                                                        
| 1055 | 1055 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom,  | 
                                                        
| 1056 | 1056 | $expr->andX(  | 
                                                        
| 1057 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'),  | 
                                                        |
| 1058 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id')  | 
                                                        |
| 1057 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'),  | 
                                                        |
| 1058 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id')  | 
                                                        |
| 1059 | 1059 | )  | 
                                                        
| 1060 | 1060 | );  | 
                                                        
| 1061 | 1061 | }  | 
                                                        
@@ -1095,7 +1095,7 @@ discard block  | 
                                                    ||
| 1095 | 1095 | |
| 1096 | 1096 | $this->leftJoin(  | 
                                                        
| 1097 | 1097 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken,  | 
                                                        
| 1098 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field)  | 
                                                        |
| 1098 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field)  | 
                                                        |
| 1099 | 1099 | );  | 
                                                        
| 1100 | 1100 | }  | 
                                                        
| 1101 | 1101 | |
@@ -1137,14 +1137,14 @@ discard block  | 
                                                    ||
| 1137 | 1137 |  		try { | 
                                                        
| 1138 | 1138 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options);  | 
                                                        
| 1139 | 1139 | $this->selectAlias(  | 
                                                        
| 1140 | - $aliasConfig . '.config',  | 
                                                        |
| 1141 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config'  | 
                                                        |
| 1140 | + $aliasConfig.'.config',  | 
                                                        |
| 1141 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config'  | 
                                                        |
| 1142 | 1142 | );  | 
                                                        
| 1143 | 1143 | $this->leftJoin(  | 
                                                        
| 1144 | 1144 | $alias,  | 
                                                        
| 1145 | 1145 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 1146 | 1146 | $aliasConfig,  | 
                                                        
| 1147 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id')  | 
                                                        |
| 1147 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id')  | 
                                                        |
| 1148 | 1148 | );  | 
                                                        
| 1149 | 1149 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 1150 | 1150 | }  | 
                                                        
@@ -1182,7 +1182,7 @@ discard block  | 
                                                    ||
| 1182 | 1182 | $aliasMembership,  | 
                                                        
| 1183 | 1183 | $expr->andX(  | 
                                                        
| 1184 | 1184 |  				$this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), | 
                                                        
| 1185 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1185 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1186 | 1186 | )  | 
                                                        
| 1187 | 1187 | );  | 
                                                        
| 1188 | 1188 | |
@@ -1201,11 +1201,11 @@ discard block  | 
                                                    ||
| 1201 | 1201 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options);  | 
                                                        
| 1202 | 1202 | $orXMembershipCircle = $expr->orX();  | 
                                                        
| 1203 | 1203 | array_map(  | 
                                                        
| 1204 | -				function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1204 | +				function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1205 | 1205 | $orXMembershipCircle->add(  | 
                                                        
| 1206 | 1206 | $this->expr()->eq(  | 
                                                        
| 1207 | - $alias . '.circle_id',  | 
                                                        |
| 1208 | - $aliasMembershipCircle . '.unique_id'  | 
                                                        |
| 1207 | + $alias.'.circle_id',  | 
                                                        |
| 1208 | + $aliasMembershipCircle.'.unique_id'  | 
                                                        |
| 1209 | 1209 | )  | 
                                                        
| 1210 | 1210 | );  | 
                                                        
| 1211 | 1211 | },  | 
                                                        
@@ -1237,7 +1237,7 @@ discard block  | 
                                                    ||
| 1237 | 1237 | $aliasDirectInitiator,  | 
                                                        
| 1238 | 1238 | $expr->andX(  | 
                                                        
| 1239 | 1239 |  							 $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), | 
                                                        
| 1240 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1240 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1241 | 1241 | )  | 
                                                        
| 1242 | 1242 | );  | 
                                                        
| 1243 | 1243 |  			} catch (RequestBuilderException $e) { | 
                                                        
@@ -1251,8 +1251,8 @@ discard block  | 
                                                    ||
| 1251 | 1251 | $this->leftJoin(  | 
                                                        
| 1252 | 1252 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator,  | 
                                                        
| 1253 | 1253 | $expr->andX(  | 
                                                        
| 1254 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'),  | 
                                                        |
| 1255 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id')  | 
                                                        |
| 1254 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'),  | 
                                                        |
| 1255 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id')  | 
                                                        |
| 1256 | 1256 | )  | 
                                                        
| 1257 | 1257 | );  | 
                                                        
| 1258 | 1258 | |
@@ -1260,8 +1260,8 @@ discard block  | 
                                                    ||
| 1260 | 1260 | $this->leftJoin(  | 
                                                        
| 1261 | 1261 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 1262 | 1262 | $expr->andX(  | 
                                                        
| 1263 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'),  | 
                                                        |
| 1264 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id')  | 
                                                        |
| 1263 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'),  | 
                                                        |
| 1264 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id')  | 
                                                        |
| 1265 | 1265 | )  | 
                                                        
| 1266 | 1266 | );  | 
                                                        
| 1267 | 1267 | |
@@ -1312,7 +1312,7 @@ discard block  | 
                                                    ||
| 1312 | 1312 | $orX->add(  | 
                                                        
| 1313 | 1313 | $expr->andX(  | 
                                                        
| 1314 | 1314 |  					$this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), | 
                                                        
| 1315 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1315 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1316 | 1316 | )  | 
                                                        
| 1317 | 1317 | );  | 
                                                        
| 1318 | 1318 | }  | 
                                                        
@@ -1322,10 +1322,10 @@ discard block  | 
                                                    ||
| 1322 | 1322 | $orXLevelCheck = $expr->orX();  | 
                                                        
| 1323 | 1323 | |
| 1324 | 1324 | array_map(  | 
                                                        
| 1325 | -			function (string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1325 | +			function(string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1326 | 1326 | $orXLevelCheck->add(  | 
                                                        
| 1327 | 1327 | $this->expr()->gte(  | 
                                                        
| 1328 | - $alias . '.level',  | 
                                                        |
| 1328 | + $alias.'.level',  | 
                                                        |
| 1329 | 1329 | $this->createNamedParameter($minimumLevel)  | 
                                                        
| 1330 | 1330 | )  | 
                                                        
| 1331 | 1331 | );  | 
                                                        
@@ -1415,21 +1415,21 @@ discard block  | 
                                                    ||
| 1415 | 1415 | $expr = $this->expr();  | 
                                                        
| 1416 | 1416 | $andPassive = $expr->andX();  | 
                                                        
| 1417 | 1417 | $andPassive->add(  | 
                                                        
| 1418 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1418 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1419 | 1419 | );  | 
                                                        
| 1420 | 1420 | |
| 1421 | 1421 | $orMemberOrLevel = $expr->orX();  | 
                                                        
| 1422 | 1422 | $orMemberOrLevel->add(  | 
                                                        
| 1423 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance')  | 
                                                        |
| 1423 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance')  | 
                                                        |
| 1424 | 1424 | );  | 
                                                        
| 1425 | 1425 | // TODO: do we need this ? (display members from the local instance)  | 
                                                        
| 1426 | 1426 | $orMemberOrLevel->add(  | 
                                                        
| 1427 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance')  | 
                                                        |
| 1427 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance')  | 
                                                        |
| 1428 | 1428 | );  | 
                                                        
| 1429 | 1429 | |
| 1430 | 1430 | $orMemberOrLevel->add(  | 
                                                        
| 1431 | 1431 | $expr->eq(  | 
                                                        
| 1432 | - $this->getDefaultSelectAlias() . '.level',  | 
                                                        |
| 1432 | + $this->getDefaultSelectAlias().'.level',  | 
                                                        |
| 1433 | 1433 | $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        
| 1434 | 1434 | )  | 
                                                        
| 1435 | 1435 | );  | 
                                                        
@@ -1466,11 +1466,11 @@ discard block  | 
                                                    ||
| 1466 | 1466 | )  | 
                                                        
| 1467 | 1467 | ->leftJoin(  | 
                                                        
| 1468 | 1468 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache,  | 
                                                        
| 1469 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid')  | 
                                                        |
| 1469 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid')  | 
                                                        |
| 1470 | 1470 | )  | 
                                                        
| 1471 | 1471 | ->leftJoin(  | 
                                                        
| 1472 | 1472 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages,  | 
                                                        
| 1473 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id')  | 
                                                        |
| 1473 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id')  | 
                                                        |
| 1474 | 1474 | );  | 
                                                        
| 1475 | 1475 | }  | 
                                                        
| 1476 | 1476 | |
@@ -1492,8 +1492,8 @@ discard block  | 
                                                    ||
| 1492 | 1492 | $this->leftJoin(  | 
                                                        
| 1493 | 1493 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild,  | 
                                                        
| 1494 | 1494 | $expr->andX(  | 
                                                        
| 1495 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'),  | 
                                                        |
| 1496 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id')  | 
                                                        |
| 1495 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'),  | 
                                                        |
| 1496 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id')  | 
                                                        |
| 1497 | 1497 | )  | 
                                                        
| 1498 | 1498 | );  | 
                                                        
| 1499 | 1499 | |
@@ -1543,13 +1543,13 @@ discard block  | 
                                                    ||
| 1543 | 1543 | $this->leftJoin(  | 
                                                        
| 1544 | 1544 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint,  | 
                                                        
| 1545 | 1545 | $expr->andX(  | 
                                                        
| 1546 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'),  | 
                                                        |
| 1547 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id')  | 
                                                        |
| 1546 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'),  | 
                                                        |
| 1547 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id')  | 
                                                        |
| 1548 | 1548 | )  | 
                                                        
| 1549 | 1549 | );  | 
                                                        
| 1550 | 1550 | |
| 1551 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint');  | 
                                                        |
| 1552 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash');  | 
                                                        |
| 1551 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint');  | 
                                                        |
| 1552 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash');  | 
                                                        |
| 1553 | 1553 | }  | 
                                                        
| 1554 | 1554 | |
| 1555 | 1555 | |
@@ -1653,10 +1653,10 @@ discard block  | 
                                                    ||
| 1653 | 1653 | */  | 
                                                        
| 1654 | 1654 |  	public function generateAlias(string $base, string $extension, ?array &$options = []): string { | 
                                                        
| 1655 | 1655 |  		$search = str_replace('_', '.', $base); | 
                                                        
| 1656 | - $path = $search . '.' . $extension;  | 
                                                        |
| 1656 | + $path = $search.'.'.$extension;  | 
                                                        |
| 1657 | 1657 | if (!$this->validKey($path, self::$SQL_PATH)  | 
                                                        
| 1658 | 1658 |  			&& !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { | 
                                                        
| 1659 | - throw new RequestBuilderException($extension . ' not found in ' . $search);  | 
                                                        |
| 1659 | + throw new RequestBuilderException($extension.' not found in '.$search);  | 
                                                        |
| 1660 | 1660 | }  | 
                                                        
| 1661 | 1661 | |
| 1662 | 1662 |  		if (!is_array($options)) { | 
                                                        
@@ -1665,15 +1665,15 @@ discard block  | 
                                                    ||
| 1665 | 1665 | |
| 1666 | 1666 | $optionPath = '';  | 
                                                        
| 1667 | 1667 |  		foreach (explode('.', $path) as $p) { | 
                                                        
| 1668 | - $optionPath = trim($optionPath . '.' . $p, '.');  | 
                                                        |
| 1668 | + $optionPath = trim($optionPath.'.'.$p, '.');  | 
                                                        |
| 1669 | 1669 | $options = array_merge(  | 
                                                        
| 1670 | 1670 | $options,  | 
                                                        
| 1671 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH),  | 
                                                        |
| 1672 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options)  | 
                                                        |
| 1671 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH),  | 
                                                        |
| 1672 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options)  | 
                                                        |
| 1673 | 1673 | );  | 
                                                        
| 1674 | 1674 | }  | 
                                                        
| 1675 | 1675 | |
| 1676 | - return $base . '_' . $extension;  | 
                                                        |
| 1676 | + return $base.'_'.$extension;  | 
                                                        |
| 1677 | 1677 | }  | 
                                                        
| 1678 | 1678 | |
| 1679 | 1679 | |
@@ -1693,7 +1693,7 @@ discard block  | 
                                                    ||
| 1693 | 1693 |  			} else { | 
                                                        
| 1694 | 1694 | $k = $arr;  | 
                                                        
| 1695 | 1695 | }  | 
                                                        
| 1696 | - $path[$k] = $prefix . '_' . $k . '_';  | 
                                                        |
| 1696 | + $path[$k] = $prefix.'_'.$k.'_';  | 
                                                        |
| 1697 | 1697 | }  | 
                                                        
| 1698 | 1698 | |
| 1699 | 1699 | return $path;  |