The error I'll answer here since it could happen with both lite and pro and because I love anything zombie.
Open dbtech/vbquiz/actions/userresults.php
About line 218 you'll find
Code:
$quiz_query = $vbulletin->db->query_read("
SELECT
q.*,
u.username,
t.taken_id,
t.completed,
t.completed_date,
t.final_result_text
FROM " . TABLE_PREFIX . "dbtech_vbquiz_quiz q
LEFT JOIN " . TABLE_PREFIX . "user u ON q.userid = u.userid
LEFT JOIN " . TABLE_PREFIX . "dbtech_vbquiz_taken t ON q.quiz_id = t.quiz_id
WHERE
t.userid = " . intval($u) . "
ORDER BY
" . $query_vars . "
LIMIT
" . ($limitlower - 1) . ", " . $perpage
);
replace with
Code:
$quiz_query = $vbulletin->db->query_read("
SELECT
q.*,
u.username,
t.taken_id,
t.completed,
t.completed_date,
t.final_result_text ,
(t. final_score/t.possible_score) as percent_score
FROM " . TABLE_PREFIX . "dbtech_vbquiz_quiz q
LEFT JOIN " . TABLE_PREFIX . "user u ON q.userid = u.userid
LEFT JOIN " . TABLE_PREFIX . "dbtech_vbquiz_taken t ON q.quiz_id = t.quiz_id
WHERE
t.userid = " . intval($u) . "
ORDER BY
" . $query_vars . "
LIMIT
" . ($limitlower - 1) . ", " . $perpage
);
For the other problem, can you create a thread on the DBT site? It could involve things not available in the lite version and saves on confusion. Thanks.
Dylan