[RC] Search Custom Profile Field

[4_seven]

i believe it. in the version named in this post this and other things are fixed: so may wait a bit or may manic2 fix it meanwhile..

[manic2]

Code: Select all

$sql_where .= ($family_name) ? ' AND fd.pf_family_name ' . $db->sql_like_expression(str_replace('*', $db->any_char, $family_name)) . ' ' : '';

... now im having a similair problem as someone else i think i read on this thread, is the search is Case-Sensitive!

Can you try making that line in this format (adjusting family_name to name if that's your CPF)

Code: Select all

$sql_where .= strtolower($family_name) ? ' AND LOWER(fd.pf_family_name) ' . $db->sql_like_expression(str_replace('*', $db->any_char, strtolower($family_name))) . ' ' : '';

[manic2]

Mod updated to version 0.0.2 to be case insensitive, download link on first page.

[Cubguy501]

YEP! that seems to work perfect! i tried all combinations and it always got the same results!

[mattconley2011]

Possibilty to make it so you don't have to put the * if you are searching part of the name only?

[manic2]

Possibilty to make it so you don't have to put the * if you are searching part of the name only?

I'd rather leave it the way that the rest of the memberlist search works:-

To match partial data use * as a wildcard.

but if you really want to do it:-

Open memberlist.php
Find:-

Code: Select all

$family_name		= request_var('family_name', '');

Add after:-

Code: Select all

$family_name = $family_name  . '*';

[pld32]

I'm installing and getting this error. I'm running as the administrator and I'm the one who setup the forum.

The file ./../memberlist.php could not be copied into place.

Any idea's please.

[manic2]

I'm installing and getting this error. I'm running as the administrator and I'm the one who setup the forum.

The file ./../memberlist.php could not be copied into place.

Any idea's please.

It's not a problem with the actual mod.

How are you doing the edits? It's best to use an ftp programme like filezilla to download any files, make the edits with a file editor such as notepad++ then re-upload them with filezilla.

Alternatively if you are using Automod to install this then you need to ask over in the Automod section.

[manic2]

See discussion here for when using with Field type of 'Dropdown box':-
http://www.phpbb.com/community/viewtopi ... &t=2133967

[cutefan]

Hi,

I have a problem with accents.
For example I have a CPF 'name'. Let's say that the name is "Stéphane", in that case, the user search won't work.
When a user search the name "Stéphane" it will not find any result, but "St*" works well.
My char-set is in UTF8.

I tried :

Code: Select all

$name        =  utf8_encode(request_var('name', '') . '*');
 

Code: Select all

$name        =  utf8_decode(request_var('name', '') . '*');
  

Echo ($name) gives "st??phane"

Any ideas?
Thanks,

[4_seven]

read from here
http://www.phpbb.com/community/viewtopi ... #p13008321
may it is the reason.

utf8_decode + utf8_encode is no solution

[4_seven]

i forget...

try

Code: Select all

$name        =  request_var('name', '', true) . '*'); 

for multibyte support

[cutefan]

Worked like a charm, thx

[cutefan]

Hey,

I am facing another problem, the CPF values are reset when the page reloads.

I noticed that this URL works: http://test.net/forum/memberlist.php?us ... r&name=cat (name is my CPF)

So I did the following change to memberlist.php, and I managed to add the CPF to the URL:

Code: Select all

 $check_params = array(
 'name'            => array('name', '', true),
 

However, even if the CPF value is in the URL I couldn't get it to show the value in the input area.
I tried value="{NAME}" without sucess.

Any ideas?
Thanks,

[manic2]

In your HTML file which is something close to this:-

Code: Select all

<dd><input type="text" name="name" id="name" value="" class="inputbox" /></dd>

In line find:-

Code: Select all

value=""

Replace with:-

Code: Select all

value="{NAME}" 

Then in your memberlist.php file
Find:-

Code: Select all

'ICQ'		=> $icq,

Add after:-

Code: Select all

'NAME'	=> $name,

This is from memory so come back here if it doesn't work.