Search members by custom profile fields

[Admin]

Here's another quick hack, allows your users (you can already do this in the Admin CP) to find other members using custom profile fields.
This hack will use all the fields you have set up, except those that are marked as "Hidden".

For a demo, I attached a screen shot of this in post #2.

Have fun! :)

[Admin]

Demo...
(What do you say about my drawing skills, eh? :D)

[TECK]

lol.. anyway, sheila will be happy right? another happy user :D

[Reeve of shinra]

Out of idle curiousity, if you happen to have alot of custom fields, will this add any lag time?

[Admin]

No.

[neal]

lookng great, another good one chen!

[incursio]

If the search produces more than 1 page of results, the hack doesn't work for subsequent pages - FYI.

[incursio]

An easy fix (adds another query, but I don't care):

in memberslist.php, find


$pagenav = getpagenav($totalusers,"memberlist.php?s=$session[sessionhash]&action=$action&what=$what&ltr=$ltr&perpage=$perpage&orde
rby=$orderby&ausername=$ausername&ahomepage=$ahomepage&aicq=$aicq&aaim=$aaim&ayahoo=$ayahoo&joindateafter=$joindateafter&joindatebef
ore=$joindatebefore&lastpostafter=$lastpostafter&lastpostbefore=$lastpostbefore&postslower=$postslower&postsupper=$postsupper&direct
ion=$direction$extra_stuff");


First, add the "$extra_stuff" to the end. Then right above this line, add:


$bgcounter=0;
$tmprc=$DB_site->query("SELECT profilefieldid FROM profilefield WHERE hidden=0");

while ($profilefield=$DB_site->fetch_array($tmprc) and ++$bgcounter) {
$fldname = "fields[" . $bgcounter . "]";
$realfld = "$fields[$bgcounter]";
$extra_stuff .= "&" . $fldname . "=" . urlencode($realfld);
}
if($tmprc) $DB_site->free_result($tmprc);


Seems to work for me.

[rx7forums.com]

Just installed and nothing happens when I search via a locaton. What could be wrong take a look here. http://www.rx7forums.com/forums/memberlist.php?action=search

[KuraFire]

Thanks man, this hack is great, and seems to work just fine :):up:

[Takara]

I modified this just a bit so that it only searches one extra profile feild, and it works great.

Thanks ^_^ :bunny:

[roxics]

Hey this is great. Thanks

Just curious though. How could I integrate some of these search fields into a table on the front page of my website?

[Admin]

I'm not sure what you mean, roxics.

[roxics]

Well lets say I go into Advanced members search on the board. But I want to take a few of these seach fields and stick them on the front page of the site. So that when people arrive at the site they see some fields on the left in a table called "Seach members by location"

Just a way of making the seach fields more accessable.

[Admin]

Copy the form you see in the search page, and remove the fields you don't need.

[roxics]

Wow that was super easy. Thanks. I don't know why I thought it would be more complicated then that. :)

[Keith]

Hi Chen,

A long time ago I requested a hack similar to this. The actual request was for admin level only, to be able to search and find members based on a custom profile field, and generate a mail list for it.

It was based on identifying members with boats under 24 feet for instance so we could send a custom email. But I think it may have been posted before VBulletin.Org started. May have posted the request on VBulleting.com.

Anyways, how can I edit this code to simply allow the admin only to do the search on custom fields to generate an email list?

[cobradude]

Works like a charm on 2.2.7

Thanks FireFly!

[aadvani]

For which vB version is this hack?
I have vB 2.2.7 and the memberlist.php file does NOT contain any code such as what is mentioned in your [FireFly] attached file "search_mlist_2.0.txt".
AA

[aadvani]

Figured it out, finally!
GREAT hack, FireFly - thanks!
AA

[telc]

will this be part of v3

[USODJA]

Is there a working version for 2.2.9 .... some parts of the code are different

[zimmerm]

is there anyway to modify this so that you can access a new search page that will allow you to only search one of the custom fields?

[Gutspiller]

I have an older board and I got all the way through the instructions, but the last step:

In the "memberlistsearch" template, add $customfields right *above* this:

<tr>
<td bgcolor="{tableheadbgcolor}" colspan="2"><normalfont color="{tableheadtextcolor}"><b>Options</b></normalfont></td>
</tr>

I don't have a "memberlistsearch" template. Can anybody help me on where I might add this last step on an older board?

Please Help. :(

[lemarsu]

It is a bit unrelated to this thread... but in another way it is very much so related.....

Is there a way to add the custom profile fields in the search of Email Users in the admin section ?

Thanks
LeMarsu

[floridaideal]

Hi all

I have set this great hack up but would like the users to be able to search just one profile field, can anyone tell me what I need to change to do this.

Thank you

Stuart

[themonarch]

Got a parse error on vBulletin 2.3.2.

[gmarik]

Oh, I would love to have it working on 2.3 as well. Chen?!

[Robert Basil]

Oh, I would love to have it working on 2.3 as well. Chen?!

(In my best AOL voice)..... Me too! ;)

[Tilmanitou]

(In my best AOL voice)..... Me too! ;)

Me too! seems it is not working on v2.3.? Please let us know Chen! :nervous:

[ricker]

GOOD STUFF
*installs*

[Tilmanitou]

GOOD STUFF
*installs*

did you get it to run on vb 2.3.3 ?
please let us know!

[Emmy2]

I just installed this on vb2.3.4 and it works perfectly.

[John Diver]

Sorry to bring up such an old thread, is this available for vb3?