function security_questions_get_random_question in Security Questions 7

Same name and namespace in other branches

1. 6 security_questions.module \security_questions_get_random_question()

Helper function to return a random question from the database.

6 calls to security_questions_get_random_question()

security_questions_form_user_login_alter in ./security_questions.module

Implements hook_form_FORM_ID_alter() for user_login().

security_questions_form_user_pass_alter in ./security_questions.module

Implements hook_form_FORM_ID_alter() for user_pass().

security_questions_pass_reset_validate_account in ./security_questions.module

Validation handler for security_questions_form_user_pass_alter().

security_questions_user_answer_form in ./security_questions.module

Main form for answering questions.

security_questions_user_login_validate_both in ./security_questions.module

Validation handler for security_questions_form_user_login_alter(). both username and password

... See full list

File

./security_questions.module, line 1106

Main module file for security_questions.

Code

function security_questions_get_random_question($account) {

  // Get a random question from the database where the user has an answer.
  $question = db_query('SELECT q.* FROM {security_questions} q, {security_questions_answers} a
                        WHERE a.uid = :uid AND q.security_question_id = a.security_question_id
                        ORDER BY RAND() LIMIT 1', array(
    ':uid' => $account->uid,
  ))
    ->fetchObject();
  return $question;
}