Hi Mikko
I tried either [code:1]WHERE published=1 AND system=0 AND onprofile=1"«»);[/code:1] nor [code:1]WHERE published=1 AND sys=0 AND onprofile=1"«»);[/code:1] but still no result:huh:
In the sql, add system = 0 to the where clause (It is possible that it was sys=0, check the columns in the fields tab). Sorry for posting a bad version.
-Mikko
Great little mini-plugin Mikko! I was wondering the same thing that scubaguy was... how to have it search CB fields other than just name and username. I played around with what you suggested above in the SQL query with no luck. Could you be a little bit more specific?