[RC] Search Custom Profile Field

[manic2]

Mod updated to v1.0.0

• Return searched paramater to template

See first post for download link

[manic2]

Mod updated to v1.0.0a

• Tested on phpBB3.0.9.
• Correct pagination when initial search results > 50.
• Used language file for label.

See first post for download link

[cutefan]

Hi,

I am looking for a way to search in multiple CPF.

For example let's say that I have 2 CPF named "speciality_one" and "speciality_two". Both are drop-list CPF with the same list.

Again for example let's say that my CPF has the following options:
1- Gaming
2- Cooking

When a user search for a member having the speciality "Gaming", I want PHPBB to search in both speciality_one and speciality_two.

If my guess is correct I have to modify my SQL request, so I tried this:

Code: Select all

$sql_where .= ($speciality_one) ? ' AND (fd.pf_speciality_one ) OR (fd.pf_speciality_two )'. $db->sql_like_expression(str_replace('*', $db->any_char, ($speciality_one))) . ' ': '';

Unfortunately this didn't work.

Any ideas?
Thanks

[manic2]

Bit of a guess but have you tried extra brackets, say:-

Code: Select all

$sql_where .= ($speciality_one) ? ' AND ((fd.pf_speciality_one ) OR (fd.pf_speciality_two ))'. $db->sql_like_expression(str_replace('*', $db->any_char, ($speciality_one))) . ' ': '';

untested.

[cutefan]

That code didn't work. The search would always give an empty result.

However, I managed to get the request work this way :

Code: Select all

$sql_where .= ($speciality_one) ? ' AND ((( fd.pf_speciality_one )'. $db->sql_like_expression(str_replace('*', $db->any_char, ($speciality_one))) . ' '.') OR (( fd.pf_speciality_two )'. $db->sql_like_expression(str_replace('*', $db->any_char, ($speciality_one))) . ')'.'OR (( fd.pf_speciality_three )'. $db->sql_like_expression(str_replace('*', $db->any_char, ($speciality_one))) . ')'.') ': ''; 

[master412160]

this mod works with 3.0.9?

[manic2]

this mod works with 3.0.9?

Yes, works fine with 3.0.9

[lintlin]

Hi and thanks for your mod!

I uploaded the mod with Automod and made sure to fix all fields to relate to my custom field PLZ (postal code in German, numbers only). The search box shows up fine, label is fine, but when I search for a postal code, I get all members shown to me, as if it doesn't do the search. All other search fields are working fine.

I would really appreciate it if you could point me in the right direction, where I should look for any mistakes on my part.

Thanks!

[manic2]

Obviously first check all your edits, I tried to keep these fairly simple to make installation & adapting as easy as possible.

Make sure you are using the correct Field Identification, i.e it's likely to be something like postal_code rather than Postal Code, or plz (lower case) rather than PLZ (uppercase).

[lintlin]

Weird double post, please disregard.

[manic2]

You asked the same question above & I answered 4 hours ago

[lintlin]

Sorry about that, I have no idea what happened there! I didn't post twice (on purpose, anyways).

OK, I will go through all the edits again, and get back to you either way.

Thanks!

[lintlin]

You were right, I had a capitalized PLZ where it should have been lower case. Thank you so much for your help!

[Tobias Claren]

Is it possible to search also via "drop boxes"?

Is it possible to get the memberposts (instead of members) as a result?
If not, that would be a very useful feature. All posts from the searched members.
You should be able to find posts on a narrowing of the search profile data of the members.

E.G. only male carpenters from Berlin with a red car .


thanks...

[manic2]

Is it possible to search also via "drop boxes"?

Yes.

Is it possible to get the memberposts (instead of members) as a result?

No.

You should be able to find posts on a narrowing of the search profile data of the members.

E.G. only male carpenters from Berlin with a red car .

You can!