function _opigno_tincan_api_get_multichoice_user_answers in Opigno TinCan API 7

1 call to _opigno_tincan_api_get_multichoice_user_answers()

opigno_tincan_api_quiz_statements_tincan_question_statement_multichoice_alter in modules/opigno_tincan_api_quiz_statements/opigno_tincan_api_quiz_statements.questions_alter.inc

File

modules/opigno_tincan_api_quiz_statements/opigno_tincan_api_quiz_statements.questions_alter.inc, line 300

Code

function _opigno_tincan_api_get_multichoice_user_answers($question_nid, $question_vid, $rid) {
  return db_query('
    SELECT quam.answer_id
    FROM {quiz_multichoice_user_answer_multi} quam
    INNER JOIN {quiz_multichoice_user_answers} qua ON qua.id = quam.user_answer_id
    WHERE qua.question_nid = :qnid
    AND qua.question_vid = :qvid
    AND qua.result_id = :rid
  ', array(
    ':qnid' => $question_nid,
    ':qvid' => $question_vid,
    ':rid' => $rid,
  ))
    ->fetchCol();
}