[waylandprod]

Like the product, just purchased pro. When I try to sort by highest individual score I get this error.

Originally Posted by VB

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT
q.*,
u.username,
t.taken_id,
t.completed,
t.completed_date,
t.final_result_text
FROM dbtech_vbquiz_quiz q
LEFT JOIN user u ON q.userid = u.userid
LEFT JOIN dbtech_vbquiz_taken t ON q.quiz_id = t.quiz_id
WHERE
t.userid = 67
ORDER BY
percent_score DESC
LIMIT
0, 5;

MySQL Error : Unknown column 'percent_score' in 'order clause'
Error Number : 1054
Request Date : Monday, September 19th 2011 @ 10:55:47 AM
Error Date : Monday, September 19th 2011 @ 10:55:47 AM
Script : http://www.zombiepodcast.com/forum/v...ort=high_score
Referrer : http://www.zombiepodcast.com/forum/v...erresults&u=67
IP Address : xxx.xxx.xxx.xxx
Username : TCM Revolver
Classname : vB_Database
MySQL Version : 5.0.84

Also is there a way to alter the way scores are displayed on the leaderboard?? It is set to percentage now, is there a way we could do it by total points scored?? The percentage basis seems to be a bit off. When you take 1 quiz and get every question right, only registers a score of 50%. After 34, not missing a question, only get score of 99%
Do I possibly have something set wrong?

Thanks in advance.