//echo $MyQuery;exit;
$Rs = safe_r_sql($MyQuery);
$pdf->SetDataHeader(array("NOC", "Country", "Back No.", "Name"), array(20, 40, 20, 110));
if ($Rs) {
$OldTeam = '#@#@#';
$OldEvent = '#@#@#';
while ($MyRow = safe_fetch($Rs)) {
if ($OldEvent != $MyRow->EventCode) {
$pdf->setEvent(get_text($MyRow->EventName, '', '', true));
$pdf->AddPage();
$pdf->setOrisCode('C32B', 'Entries by Event');
$OldTeam = '#@#@#';
$OldEvent = $MyRow->EventCode;
}
if ($OldTeam != $MyRow->NationCode) {
$pdf->SamePage($MyRow->cNumber + 1);
$pdf->lastY += 3.5;
$pdf->printDataRow(array($MyRow->NationCode, $MyRow->Nation, $MyRow->TargetNo, $MyRow->FirstName . ' ' . $MyRow->Name));
$OldTeam = $MyRow->NationCode;
} else {
$pdf->printDataRow(array("", "", $MyRow->TargetNo, $MyRow->FirstName . ' ' . $MyRow->Name));
}
}
}
if (!isset($isCompleteResultBook)) {
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
$pdf->Cell(13, 6, get_text('Date', 'Tournament'), 1, 0, 'L');
$pdf->Cell(8, 6, get_text('Time', 'Tournament'), 1, 0, 'L');
$pdf->Cell(25, 6, get_text('Event'), 1, 0, 'L');
$pdf->Cell(6, 6, get_text('Phase'), 1, 0, 'L');
$pdf->Cell(6, 6, get_text('MatchNo'), 1, 0, 'L');
//$pdf->Cell(3, 4, get_text('Court', 'Tournament'), 1, 0, 'L');
$pdf->Cell(5, 6, get_text('Rank'), 1, 0, 'L');
$pdf->Cell($W + 10, 6, get_text('ParticipantSchedule', 'Tournament', 1), 1, 0, 'L');
$pdf->Cell(6, 6, get_text('TargetShort', 'Tournament'), 1, 0, 'L');
$pdf->Cell(5, 6, get_text('Rank'), 1, 0, 'L');
$pdf->Cell($W + 10, 6, get_text('ParticipantSchedule', 'Tournament', 2), 1, 0, 'L');
$pdf->Cell(6, 6, get_text('TargetShort', 'Tournament'), 1, 1, 'L');
$pdf->SetFont('', '');
$header = false;
}
if (!$pdf->SamePage(8)) {
$DateBorder .= 'B';
$TimeBorder .= 'B';
$EventBorder .= 'B';
$PhaseBorder .= 'B';
$header = true;
}
$pdf->Cell(13, 5, $Date, $DateBorder, 0, 'L');
$pdf->Cell(8, 5, $Time, $TimeBorder, 0, 'L');
$pdf->Cell(25, 5, $Event, $EventBorder, 0, 'L');
$pdf->Cell(6, 5, $Phase, $PhaseBorder, 0, 'C');
$pdf->Cell(6, 5, $r->FinMatchNo / 2 + 1, 1, 0, 'R');
// $pdf->Cell(3, 4, '', 1, 0, 'L');
$pdf->Cell(5, 5, $r->Rank, 1, 0, 'L');
$pdf->Cell($W, 5, strtoupper($r->FirstName) . ' ' . $r->Name, 1, 0, 'L');
$pdf->Cell(10, 5, $r->Country, 1, 0, 'L');
