function security_questions_get_random_question in Security Questions 6

Same name and namespace in other branches

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

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_fetch_object(db_query("SELECT q.* FROM {security_questions} q, {security_questions_answers} a\n                        WHERE a.uid = '{$account->uid}' AND q.security_question_id = a.security_question_id\n                        ORDER BY RAND() LIMIT 1"));
  return $question;
}