$pdf->SetAuthor('http://www.ianseo.net');
$pdf->SetCreator('Software Design by Ianseo');
$pdf->SetTitle('IANSEO - Integrated Result System');
$pdf->SetSubject('Final Athlete Name');
$pdf->SetTextColor(0x0, 0x0, 0x0);
$pdf->SetDrawColor(0x33, 0x33, 0x33);
$pdf->SetFillColor(0xe8, 0xe8, 0xe8);
$pdf->setCellMargins(0, 0, 0, 0);
$pdf->SetCellPadding(0);
$Height = array(0, 0, 0);
$Height[1] = $pdf->getPageHeight() / 3;
$Height[2] = $Height[1] * 2;
$Width = $pdf->getPageWidth() - 65;
$CellHeight = $Height[1] - 10;
// 5 top and bottom
$fontname = $pdf->addTTFfont($CFG->DOCUMENT_PATH . 'Common/tcpdf/fonts/ariblk.ttf');
$pdf->SetFont($fontname);
$Filter = '';
if (!empty($_REQUEST['x_Session'])) {
$Filter .= " and QuSession={$_REQUEST['x_Session']}";
}
if (!empty($_REQUEST['x_From'])) {
$Filter .= " and substr(QuTargetNo,2)>='" . str_pad($_REQUEST['x_From'], 3, '0', STR_PAD_LEFT) . "'";
}
if (!empty($_REQUEST['x_To'])) {
$Filter .= " and substr(QuTargetNo,2)<='" . str_pad($_REQUEST['x_To'], 3, '0', STR_PAD_LEFT) . "'";
}
$Rs = safe_r_SQL("select EnName, EnFirstName, QuTargetNo\n\tfrom Entries\n\tinner join Qualifications on EnId=QuId {$Filter} where EnTournament={$_SESSION['TourId']}\n\torder by QuTargetNo");
error_reporting(E_ALL);
$n = 0;
while ($MyRow = safe_fetch($Rs)) {