See attached screeshot.
(The filter is fine, but at Parameters->Display I have the following settings:
Show Blocked - No
Show Banned - No
Show Unapproved- No
Show Unconfirmed -No
Still a user who is blocked and banned displays in the list.)
Was able to confirm your issue. Looks like those WHERE values aren't being added when advanced filtering is used. This is due to the OR in your filtering and the advanced filtering output missing its (). Add ( and ) brackets around your filtering and that should fix it. Alternatively you can apply the below quickfix.
IN: libraries/CBLib/CB/Legacy/cbUsersList.php
ON: Line 593
FROM:
Code:
$filterBy = ' AND ' . $cbUser->replaceUserVars( $filtering, array( $_CB_database, 'getEscaped' ), false );
TO:
Code:
$filterBy = ' AND ( ' . $cbUser->replaceUserVars( $filtering, array( $_CB_database, 'getEscaped' ), false ) . ' )';
ok, but I cannot create a basic filter with multiple criterias if I need a query with "OR". The only option today using basic filter is "AND" if i add another criteria. Perhaps it should be possible to choose between "AND" and "OR" when adding the criteria?
Basic filters are just that; basic. Adding AND/OR scenario to them would complicate the configuration and likely cause confusion with how they should behavior. For example is the OR an OR to the value previous to it or to all the other filters? For those usages I suggest using Advanced.
nant
