$countsql .= $from.$where;
$attempts = $DB->get_records_sql($select.$from.$where, $params);
$questioncount = get_scorm_question_count($scorm->id);
+ $nbmaincolumns = count($columns);
for($id = 0; $id < $questioncount; $id++) {
if ($displayoptions['qtext']) {
$columns[] = 'question' . $id;
$row[] = $score;
}
// interaction data
- $i=0;
- $element='cmi.interactions_'.$i.'.id';
- while(isset($trackdata->$element)) {
+ for ($i=0; $i < $questioncount; $i++) {
if ($displayoptions['qtext']) {
$element='cmi.interactions_'.$i.'.id';
if (isset($trackdata->$element)) {
$row[] = ' ';
}
}
- $i++;
- $element = 'cmi.interactions_'.$i.'.id';
}
//---end of interaction data*/
} else {
} else {
$row[] = $strstatus;
}
+ // complete the empty cells
+ for ($i=0; $i < count($columns) - $nbmaincolumns; $i++) {
+ $row[] = ' ';
+ }
}
}
}