function QuizzViewScore()
{
global $qid,$nblots,$db,$xoopsConfig,$myts,$xoopsModule;

$result = $db->query("select quizzTitle, voters from ".$db->prefix("quizz_admin")." where quizzID='$qid'");
list($quizzTitle, $nbscore) = $db->fetch_row($result);

xoops_cp_header();
OpenTable();
echo "<b>"._QUIZZ_LISTSCORE."</b><BR>";

$result = $db->query("SELECT username, score FROM ".$db->prefix("quizz_check")." WHERE qid='$qid' ORDER BY score DESC,time DESC LIMIT $nbscore ");
print "<table>";
while(list($username,$score) = $db->fetch_row($result))
{
print "<tr><td>".$myts->MakeTboxData4Show($username)." :</td><td> $score</td></tr>";
}
print "</table><BR><BR>";


# display the drawings lots
print "<table width='100%'>";
print "<form method='post'action='".XOOPS_URL."/modules/quizz/admin/index.php'>";
print "<INPUT type='hidden' name='act' value='QuizzViewScore'>";
print "<INPUT type='hidden' name='qid' value='$qid'>";



# perform the drawings lots if needed
if (isset($nblots))
{
print "<tr><td colspan=2><B>"._QUIZZ_ANDTHEWINNERSARE." :</B></td></tr>";
$result = $db->query("SELECT username, score, email FROM ".$db->prefix("quizz_check")." WHERE qid='$qid' ORDER BY score DESC, RAND() LIMIT $nblots");
print "<tr><td>";
while(list($username,$score,$email) = $db->fetch_row($result))
{
print "".$myts->MakeTboxData4Show($username)." ($score) : <A HREF=\"mailto:".$myts->makeTboxData4Show($email)."\">".$myts->makeTboxData4Show($email)."</A><br>";
}
print "</td></tr>";
}
else
{
$nblots=10;
}

print "<tr><td align='left'><BR><form>"._QUIZZ_NBWINNERS." <input type='text' name='nblots' value='$nblots' size=3> <input type='submit' class=button value='"._QUIZZ_LAUNCH."'></td></tr>";
print "</form>";
print "<tr><td><BR><center><a href=\"".XOOPS_URL."/modules/quizz/admin/index.php?act=QuizzAdmin\"> [ "._QUIZZ_ADMIN." ]</a></center></td></tr>";
print "</table>";
CloseTable();

xoops_cp_footer();
}