[banshee]

I installed this hack and love it, however I use the quiz for contests for prizes. So it is hard to see what peoples scores are so i modified the quiz.php so it sorts the usernames and shows the %. Making it easy to see who the top Members are.

I hope this isn't against the rules if it is just delete the post

Modify the SQL statment to order the results by score so the highest scores are listed at the top.

 // Get All The Results
                $Get_Results = $DB->query("
                select u.username,
                r.r_userid,r.r_score
                from ".TABLE_PREFIX."quiz_results r
                left join ".TABLE_PREFIX."user u on(u.userid=r.r_userid)
                where r.r_forquiz = '{$Quiz['qid']}' ORDER BY r.r_score DESC
                ");

Change the Result display so it formats and shows the % correct.

 $Results[] = "<tr><td><a href='quiz.php?$session[sessionurl]do=UserStat&userid={$Result['r_userid']}&id={$Quiz['qid']}'>{$Result['username']}
</a></td> <td>{$Result['r_score']}%</td></tr>";

Hopefully everyone finds this useful like I do.