[support] Username vs. real name in CCK userreference module

[Walter Garcia-Fontes]

* Walter Garcia-Fontes [20/06/07 16:58]:
> I've been trying to use CCK userreference to set up a field and a
> content type form where users can be chosen. My idea is to have a
> "meeting" content type, and "participants" would be a field where
> users participating in the meeting (from the ones registered in the
> site) can be chosen. 
> 
> CCK userreference is showing the usernames, but I'd like the "real
> name" to be chosen. I've set up a field in the profile of each user
> showing the real name. 
> 
> I've managed the real name to show in the "submitted by" tags by using
> the discussion in:
> http://drupal.org/node/147188
> 
> But this does not change the usernames in the CCK userreference field. 
> 
> Does anybody know a way of achieving this?
> 

I finally hacked the CCK userreference module to achieve
this. I created a name field (lastname, name) for the users in their
profiles. Then I changed the references to the user tables to the
profile tables in userreference.module. 

At line 187:
            $items[$delta]['default user_name'] =
	    db_result(db_query("SELECT value FROM {profile_values}
	    WHERE uid = '%d'", $items[$delta]['uid']));

At line 265:
   if (empty($roles) || in_array(DRUPAL_AUTHENTICATED_RID, $roles)) {
    $result = db_query('SELECT u.value, u.uid FROM {profile_values} u
    WHERE uid > 0 ORDER BY u.value ASC');
  }
  else {
    $result = db_query('SELECT u.value, u.uid FROM {profile_values} u
    LEFT JOIN {users_roles} r ON u.uid = r.uid WHERE u.uid > 0 AND
    r.rid IN ('. implode($roles, ',') .') ORDER BY u.value ASC');
  }
  else {
    $result = db_query('SELECT u.value, u.uid FROM {profile_values} u
    LEFT JOIN {users_roles} r ON u.uid = r.uid WHERE u.uid > 0 AND
    r.rid IN ('. implode($roles, ',') .') ORDER BY u.value ASC');
  }

  $users = array();
  while ($user = db_fetch_object($result)) {
    $users[$user->uid] = $user->value;
  }
  return $users;
}

Now I get the real names in the userreference field created by CCK. 

-- 
Walter Garcia-Fontes
Barcelona