function realname_registration_get_mname in Realname registration 6.2

Implementation of realname_registration_get_mname();

Determine where the middle name values are located and return the middle name.

Parameters

&$account: The user object on which the operation is being performed.

1 call to realname_registration_get_mname()

realname_registration_token_values in ./realname_registration.module

Implementation of hook_tokens().

File

./realname_registration.module, line 658

For using real names during registration.

Code

function realname_registration_get_mname($account) {
  $c = realname_registration_load_settings();
  if (module_exists('content_profile_registration')) {
    $content_profile_type_count = db_result(db_query("\n      SELECT COUNT(DISTINCT type_name) FROM {content_node_field_instance} \n      WHERE field_name = '%s'", $c->mname->field));
  }
  if (!empty($c->mname->field)) {
    if (!$c->mname->use_content_profile) {
      $middlename = db_result(db_query("\n        SELECT profile_values.value\n        FROM {profile_values}\n        INNER JOIN {profile_fields}\n        ON profile_values.fid = profile_fields.fid\n        WHERE profile_fields.name = '%s'\n        AND profile_values.uid = %d", $c->mname->field, $account->uid));
    }
    else {
      if ($content_profile_type_count > 1) {
        $middlename = db_result(db_query("\n          SELECT %s\n          FROM {node} AS n\n          LEFT JOIN {content_%s} AS c\n          ON n.nid = c.nid\n          WHERE n.uid = %d\n          AND n.type = '%s'\n          LIMIT 0, 1", $c->mname->field . '_value', $c->mname->field, $account->uid, $c->mname->content_node));
      }
      else {
        $middlename = db_result(db_query("\n          SELECT %s\n          FROM {content_type_%s} AS c\n          LEFT JOIN {node} AS n\n          ON c.nid =  n.nid\n          WHERE n.uid = %d\n          LIMIT 0, 1", $c->mname->field . '_value', $c->mname->content_node, $account->uid));
      }
    }
  }
  return $middlename;
}