function quiz_get_user_results in Quiz 6.6

Same name and namespace in other branches

1. 8.4 quiz.pages.inc \quiz_get_user_results()
2. 5.2 quiz.module \quiz_get_user_results()
3. 5 quiz.module \quiz_get_user_results()
4. 6.2 quiz.pages.inc \quiz_get_user_results()
5. 6.3 quiz.pages.inc \quiz_get_user_results()
6. 6.4 quiz.pages.inc \quiz_get_user_results()
7. 6.5 quiz.pages.inc \quiz_get_user_results()
8. 7 quiz.pages.inc \quiz_get_user_results()
9. 7.4 quiz.pages.inc \quiz_get_user_results()

Displays all the quizzes the user has taken part in.

Return value

HTML output for page.

1 string reference to 'quiz_get_user_results'

quiz_menu in ./quiz.module

Implementation of hook_menu().

File

./quiz.pages.inc, line 45

User pages.

Code

function quiz_get_user_results($user_id) {
  global $user;
  if ($user_id == $user->uid || user_access('view user results')) {
    $results = array();
    $sql = "SELECT n.nid, n.title, u.name, qnrs.result_id, qnrs.time_start, qnrs.time_end\n      FROM {node} n\n      INNER JOIN {quiz_node_properties} qnp ON n.nid = qnp.nid\n      INNER JOIN {quiz_node_results} qnrs ON qnrs.nid = qnp.nid\n      INNER JOIN {users} u ON u.uid = qnrs.uid\n      WHERE n.type = 'quiz'\n        AND u.uid = %d\n      ORDER BY qnrs.result_id ASC";
    $dbresult = db_query($sql, $user_id);

    // Create an array out of the results.
    while ($line = db_fetch_array($dbresult)) {
      $results[$line['result_id']] = $line;
    }
    return theme('quiz_get_user_results', $results);
  }
  else {
    return 'You have no permission to view the results of this user.';
  }
}