Search members by custom profile fields

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? )

[TECK]

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

[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

PHP Code:

 $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:

PHP Code:

  $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/memb...?action=search

[KuraFire]

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