function security_questions_get_answer_list in Security Questions 6.2

Same name and namespace in other branches

1. 7.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.

5 calls to security_questions_get_answer_list()

security_questions_answer_save in ./security_questions.module

Saves a user's answer to the database.

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_final_validate in ./security_questions.module

Validation handler for _security_questions_user_login_form_alter().

File

./security_questions.module, line 867

Main module file for security_questions.

Code

function security_questions_get_answer_list($uid, $sqid = NULL) {
  $query = "SELECT a.uid, a.sqid, a.answer, q.question\n    FROM {security_questions_answers} a\n    INNER JOIN {security_questions} q\n    ON a.sqid = q.sqid AND a.uid = %d";
  $values = array(
    $uid,
  );
  if (isset($sqid)) {
    $query .= " WHERE a.sqid = %d";
    $values[] = $sqid;
  }
  $result = db_query($query, $values);
  $return = array();
  while ($row = db_fetch_object($result)) {
    $return[$row->sqid] = $row;
  }
  return $return;
}