function set_calendar_vars2($calendar_id, $db)
{
$sql = "select * from registered_students where id='{$calendar_id}' LIMIT 1";
$result = DB_query($sql, $db);
$row = DB_fetch_array($result);
$this->calendar_id = $calendar_id;
// set status var
$subjects_array = tep_get_exam_mode2($db);
foreach ($subjects_array as $r => $s) {
$this->exam_mode[] = array("id" => $s['id'], "tmarks" => tep_get_exam_mode_marks2($s['id'], $this->calendar_id, $db));
}
}
$YPos += 20;
$YPos -= $line_height;
//Note, this is ok for multilang as this is the value of a Select, text in option is different
$YPos -= 12 * $line_height;
$pdf->line($Left_Margin, $YPos + $line_height, $Page_Width - $Right_Margin, $YPos + $line_height);
$YPos -= 50;
$YPos -= $line_height;
$Left_Margin2 = 100;
$pdf->line($Left_Margin2, $YPos + $line_height, 500, $YPos + $line_height);
$line_width = 40;
$XPos = 160;
$YPos2 = $YPos;
$count = 0;
$i = 0;
$bus_report2 = new bus_report2($_POST['class_id'], $_POST['period_id'], $_POST['subject_id'], $db);
$subjects_array = tep_get_exam_mode2($db);
$current_student = '';
foreach ($subjects_array as $r => $s) {
$LeftOvers = $pdf->addTextWrap($XPos + 70, $YPos, 300, $FontSize, $s['title']);
$XPos += 1.5 * $line_width;
}
$YPos -= 10;
$rank = 0;
$YPos -= $line_height;
$count = 0;
foreach ($bus_report2->scheduled_students as $a => $b) {
$count = $count + 1;
$scheduled2 = new scheduled2($b['student_id'], $db);
$scheduled2->set_calendar_vars2($b['id'], $db);
$LeftOvers = $pdf->addTextWrap($Left_Margin2 + 3, $YPos, 300, $FontSize, $scheduled2->debtorno);
$pdf->line($Left_Margin2, $YPos + $line_height, 500, $YPos + $line_height);