Searching user profiles

http://www.argz.com/~dand/profileplus.zip

Let me know if it works for you...

Once enabled try going to

?q=search/profileplus

Cheers.

d_Ld

Hi Dldege,

i allready solved some of my problems. But I will rewrite that module.

1. I will implement a diiferent sql query. I need multiple keywords. But I don´t need user as nodes

2. I will change the admin settings, I want the admin to chose wich profile_fields will be included in the search (but this is optional)

I took over a job from a friend to develop a communityside. But normaly I´m working with Joomla or Ruby. Sunday I started with drupal and I found it quite different from the other CMS. My only problem is time, I have to present a stable version in four weeks.

And after four days allready I know that I need to review a lot of modules because there are not working, like image.module (its a side for photographers) the vcard is very bad but at least I made it run today not perfekt but a beginning. I still have just a vage idea what cck does, but i will need it etc......

But when I finish the profileplus.module i will post it back. Do you know how to do that? I think on Monday I will have a stable version of it. One more question the module is searching in the sql table profile_fields. My question is if it is not better to search in profile_value table? Because in my table profile_fields i have no categories defined. But i have in the other?

If you have a hint.....
I will post the test side on Monday, I let you know :)

Thanks for the help

Dirk

It had a few bugs in it but I was able to manually roll it into the modified version of profileplus I posted above. It seems like it could all be done with one query if your SQL was really good but I don't see a big problem doing the queries in a for loop.

/*
 * Implementation of hook_search()
 */
function profileplus_search($op = 'search', $keys = null) {
  global $user;
  switch ($op) {
    case 'name':
      if (user_access('access user profiles')) {
        return t('Profiles');
      }
    case 'search':
      if (user_access('access user profiles')) {
      
        // Check if a browse option was submitted
        $result = profileplus_get_browse_fields();
        while ($field = db_fetch_object($result)) {
          if ($value = search_query_extract($keys, $field->name)) {
            drupal_goto('profile/'.$field->name.'/'.urldecode($value));
            exit();
          }
        }
        
        //If not browsing do a normal search
        $find = array();
        
        // Replace wildcards with MySQL/PostgreSQL wildcards.
        $keys = preg_replace('!\*+!', '%', $keys);
        $keywords = explode(' ', check_plain(strip_tags($keys)));               
        $i = count($keywords);
               
        if ($i > 0) {
          $users = array();
          $match = array();
          while ($i > 0) {
            $j = $i - 1;
            if (user_access('administer users')) {
              //administrators don't have restrictions
              $sql = "FROM {users} u INNER JOIN {profile_values} pv ON u.uid = pv.uid INNER JOIN {profile_fields} pf ON pv.fid = pf.fid WHERE pv.value LIKE '%%%s%%' OR u.name LIKE '%%%s%%'";
              $result = db_query('SELECT DISTINCT u.* ' . $sql, $keywords[$j], $keywords[$j]);
            }
            else {
              //non-administrators can only search public fields and active users
              $sql = "FROM {users} u INNER JOIN {profile_values} pv ON u.uid = pv.uid INNER JOIN {profile_fields} pf ON pv.fid = pf.fid WHERE (pv.value LIKE '%%%s%%' OR u.name LIKE '%%%s%%') AND (pf.visibility IN (%d, %d) AND u.status = 1 AND u.uid > 1)";
              $result = db_query('SELECT DISTINCT u.* ' . $sql, $keywords[$j], $keywords[$j], PROFILE_PUBLIC, PROFILE_PUBLIC_LISTINGS);
            }

            //drupal_set_message($sql);
            //drupal_set_message($keywords[$j]);
            while ($auser = db_fetch_object($result)) {
              if (in_array($auser->uid,$users) && !in_array($auser->uid,$match))
                $match[] = $auser->uid;
              else
                $users[] = $auser->uid;
            } 
            $i = $i - 1;
          }
 
          if ($match)
            $items = $match;
          else
            $items = $users;
        }
        
        $fields = array();
        $fieldsresult = db_query('SELECT name, title, type, weight, page FROM {profile_fields} WHERE visibility = %d ORDER BY weight', PROFILE_PUBLIC_LISTINGS);
        while ($record = db_fetch_object($fieldsresult)) {
          $fields[] = $record;
        }
        
        //drupal_set_message('SELECT uid FROM {users} WHERE uid IN (' . implode(', ', $items) . ')');

        if (count($items) > 0) {
          $pager = pager_query('SELECT uid FROM {users} WHERE uid IN (' . implode(', ', $items) . ')', variable_get('profileplus_results_per_page', 5));
          while ($pageditems = db_fetch_object($pager)) {
            $account = user_load(array('uid'=>$pageditems->uid));
            $profile = _profile_update_user_fields($fields, $account);
            $find[] = array('snippet' => theme('profile_listing', $account, $profile));
          }
        }
        else
          $find[] = array('snippet' => "No matches were found.");

        return $find;
      }
    }
}

d_Ld