function quiz_get_user_results in Quiz 5.2
Same name and namespace in other branches
- 8.4 quiz.pages.inc \quiz_get_user_results()
- 5 quiz.module \quiz_get_user_results()
- 6.6 quiz.pages.inc \quiz_get_user_results()
- 6.2 quiz.pages.inc \quiz_get_user_results()
- 6.3 quiz.pages.inc \quiz_get_user_results()
- 6.4 quiz.pages.inc \quiz_get_user_results()
- 6.5 quiz.pages.inc \quiz_get_user_results()
- 7 quiz.pages.inc \quiz_get_user_results()
- 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.module, line 840
Code
function quiz_get_user_results() {
global $user;
$results = array();
$dbresult = db_query("SELECT\n n.nid as nid,\n n.title as title,\n u.name as name,\n qnrs.result_id as result_id,\n qnrs.time_start,\n qnrs.time_end\n FROM {node} n, {quiz_node_properties} qnp, {quiz_node_results} qnrs, {users} u\n WHERE\n n.type = 'quiz'\n AND\n n.nid = qnp.nid\n AND\n qnrs.nid = qnp.nid\n AND\n u.uid = qnrs.uid\n AND\n u.uid = " . $user->uid . "\n ORDER BY qnrs.result_id ASC");
// 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);
}