function security_questions_get_answer_list in Security Questions 7.2

Same name and namespace in other branches

1. 6.2 security_questions.module \security_questions_get_answer_list()

Fetch a list of the user's answers from the database.

Parameters

$uid: The user's ID.

$sqid: (optional) A security question ID by which to filter the list.

Return value

An empty array if no answers are found for the user. Otherwise, an array of answer objects indexed by sqid.

4 calls to security_questions_get_answer_list()

security_questions_bypass_challenge in ./security_questions.module

Checks whether a user can bypass a security question challenge.

security_questions_get_answer in ./security_questions.module

Fetch a user's answer to a question from the database.

security_questions_user_form in ./security_questions.pages.inc

The user's security questions form.

security_questions_user_login_submit in ./security_questions.module

Submission handler for _security_questions_user_login_form_alter().

File

./security_questions.module, line 848

Main module file for security_questions.

Code

function security_questions_get_answer_list($uid, $sqid = NULL) {
  $select = db_select('security_questions_answers', 'a');
  $alias = $select
    ->join('security_questions', 'q', 'a.sqid = q.sqid AND a.uid = :uid', array(
    ':uid' => $uid,
  ));
  $select
    ->fields($alias, array(
    'question',
  ));
  $select
    ->fields('a');
  if (isset($sqid)) {
    $select
      ->condition('a.sqid', $sqid);
  }
  return $select
    ->execute()
    ->fetchAllAssoc('sqid');
}