Hehe - The counting is no longer the problem...
I now have a problem with this code:
Code:
// ############################### start update4 ###############################
if ($action=="update4") {
$qid = intval($question4[qid]);
$question4 = intval($question4[question]);
$ganswer = intval($question4[ganswer]);
$sanswer = intval($question4[sanswer]);
$hanswer = intval($question4[hanswer]);
$ranswer = intval($question4[ranswer]);
$answer = intval($answer);
$answer1 = intval($answer1);
$answer2 = intval($answer2);
$answer3 = intval($answer3);
$answer4 = intval($answer4);
if ($answer==$ganswer) {
$whichscore = 'gscore';
}elseif ($answer==$sanswer) {
$whichscore = 'sscore';
}elseif ($answer==$hanswer) {
$whichscore = 'hscore';
}else{
$whichscore = 'rscore';
}
$score = $DB_site->query("SELECT $whichscore FROM *tablename*_questions WHERE qid='$qid'");
if ($bbuserinfo['usergroupid']==2)
{
$DB_site->query("UPDATE user SET question4='$qid',score4='$score[$whichscore]' WHERE userid='$bbuserinfo[userid]'");
}
$total = $DB_site->query("SELECT score1,score2,score3,score4 FROM user WHERE userid='$bbuserinfo[userid]'");
while($r1 = mysql_fetch_array($total)){
$score1=$r1['score1'];
$score2=$r1['score2'];
$score3=$r1['score3'];
$score4=$r1['score4'];
$subtotal1 = $score1 + $score2 ;
$subtotal2 = $subtotal1 + $score3 ;
$finaltotal = $subtotal2 + $score4 ;
}
if ($finaltotal<=6) {
$group=='9';
}elseif ($finaltotal>=7 AND $finaltotal<=10) {
$group=='11';
}elseif ($finaltotal>=11 AND $finaltotal<=13) {
$group=='10';
}else{
$group=='8';
}
$usergroupname = $DB_site->query("SELECT * FROM usergroup WHERE usergroupid='$group'");
$DB_site->query("UPDATE user SET usergroupid='$group' WHERE userid='$bbuserinfo[userid]'");
$goto="index.php?s=$session[sessionhash]";
eval("standardredirect(\"".gettemplate("congrats_sorted")."\",\"$goto\");");
}
$qid = the id of the question (doesn't appear to be intval'ing even though I have tried many different ways)
$question4 = the 4th question
$ganswer = one of the answer options
$sanswer = another answer option
$hanswer = another answer option
$ranswer = another answer option
$answer = the answer they selected
$answer1 = the 1st answer they could have chosen
$answer2 = the 2nd answer they could have chosen
$answer3 = the 3rd answer they could have chosen
$answer4 = the 4th answer they could have chosen
Thats pretty much all the explaination I can give - Here is the "question4" code:
Code:
// ############################### start *tablename* ###############################
if ($action=="sort4") {
$getqs4 = $DB_site->query("SELECT * FROM *tablename*_questions ORDER BY RAND() LIMIT 1");
while ($question4=$DB_site->fetch_array($getqs4)) {
$answers4 = array($question4[ganswer],$question4[sanswer]);
$answers24 = array($question4[hanswer],$question4[ranswer]);
$nbvalue4 = 1;
$answerd4 = array_rand($answers4,$nbvalue4);
if ($answerd4=="$question4[ganswer]") {
$answer1 = "$question4[ganswer]";
$answer2 = "$question4[sanswer]";
}else{
$answer1 = "$question4[sanswer]";
$answer2 = "$question4[ganswer]";
}
$answert4 = array_rand($answers24,$nbvalue4);
if ($answert4=="$question4[hanswer]") {
$answer3 = "$question4[hanswer]";
$answer4 = "$question4[ranswer]";
}else{
$answer3 = "$question4[ranswer]";
$answer4 = "$question4[hanswer]";
}
eval("\$thequestions .= \"".gettemplate('*tablename*_questions4')."\";");
}
eval("dooutput(\"".gettemplate('*tablename*_q4')."\");");
}
Here is the HTML code which is in "*tablename*_q4" and "*tablename*_questions4"
*tablename*_q4
Code:
<html>
<head>
<title>$bbtitle - *file name*</title>
$headinclude
</head>
$header
<body>
<!-- breadcrumb -->
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="100%"><br>
<normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a>
> *File name* - Question 4</b></normalfont></td>
</tr>
</table>
<!-- /breadcrumb -->
<form action="*filename*.php" method="post">
<input type="hidden" name="s" value="$session[sessionhash]">
$thequestions
<br>
<table cellpadding="2" cellspacing="0" border="0" width="95%" align="center">
<tr>
<td align="center"><normalfont>
<input type="hidden" name="action" value="update4">
<input type="submit" class="bginput" name="Submit" value="Submit">
<input type="reset" class="bginput" name="Reset" value="Reset">
</normalfont></td>
</tr>
</table>
</form>
$footer
</body>
</html>
*tablename*_questions4
Code:
<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E" width="95%" align="center"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr>
<td bgcolor="#1D6AA0" colspan="2"><normalfont color="#EEEEFF"><b>The Question</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#1C5780"><normalfont><b>Quesion: $question4[question]?</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#13486D"><normalfont>
<input type="radio" name="answer" value="answer1" checked>$answer1<br>
<input type="radio" name="answer" value="answer2">$answer2<br>
<input type="radio" name="answer" value="answer3">$answer3<br>
<input type="radio" name="answer" value="answer4">$answer4<br>
</normalfont></td>
</tr>
</table>
</td></tr></table>
Can you see anything wrong?
*tablename* = The name of the table
Problem I think it is: - "$qid" will not intval, so the"$whichscore" will not work
Satan
More Information