$pdf->SetFont($pdf->FontStd, '', 10);
$pdf->Cell(40, 7, get_text('TourCommitee', 'Tournament') . ": ", 'L', 0, 'L', 0);
$pdf->SetFont($pdf->FontStd, 'B', 10);
$pdf->Cell(150, 7, $RowTournament->ToCommitee . " - " . $RowTournament->ToComDescr, 'R', 1, 'L', 0);
//Luogo e data di Svolgimento
$pdf->SetFont($pdf->FontStd, '', 10);
$pdf->Cell(40, 7, get_text('TourWhen', 'Tournament') . ": ", 'L', 0, 'L', 0);
$pdf->SetFont($pdf->FontStd, 'B', 10);
$pdf->Cell(50, 7, TournamentDate2String($RowTournament->DtFrom, $RowTournament->DtTo), 0, 0, 'L', 0);
$pdf->SetFont($pdf->FontStd, '', 10);
$pdf->Cell(30, 7, get_text('TourWhere', 'Tournament') . ": ", 0, 0, 'R', 0);
$pdf->SetFont($pdf->FontStd, 'B', 10);
$pdf->Cell(70, 7, $RowTournament->ToWhere, 'R', 1, 'L', 0);
$pdf->SetFont($pdf->FontStd, 'B', 1);
$pdf->Cell(190, 0.5, '', 1, 1, 'L', 1);
$pdf->SetXY($pdf->GetX(), $pdf->GetY() + 5);
//Parte di Report vera e propria
/*$MySql = "SELECT FrqId, FrqStatus, FrqQuestion, FrqTip, FrqType, FrqOptions, TtCategory "
. "FROM FinalReportQ "
. "INNER JOIN Tournament ON ToId=" . StrSafe_DB($_SESSION['TourId']) . " "
. "INNER JOIN Tournament*Type ON TtId=ToType ";
if($AllQuestions)
$MySql .= "WHERE FrqStatus > 0 ";
else
$MySql .= "WHERE (FrqStatus & TtCategory) > 0 ";
$MySql .= "ORDER BY FrqId";*/
$MySql = "SELECT FrqId, FrqStatus, FrqQuestion, FrqTip, FrqType, FrqOptions, ToCategory AS TtCategory " . "FROM FinalReportQ " . "INNER JOIN Tournament ON ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";
if ($AllQuestions) {
$MySql .= "WHERE FrqStatus > 0 ";
} else {
$MySql .= "WHERE (FrqStatus & ToCategory) > 0 ";
if ($CurTeam != $MyRow->NationCode) {
// Sicuramente devo incrementare la posizione
$MyPos++;
// Se non ho parimerito il ranking � uguale alla posizione
if (!($MyRow->TeScore == $MyScoreOld && $MyRow->TeGold == $MyGoldOld && $MyRow->TeXnine == $MyXNineOld)) {
$MyRank = $MyPos;
}
if ($MyRank <= 3) {
$pdf->SetFont($pdf->FontStd, 'B', 8);
$pdf->Cell(20, 4 * $MyRow->Quanti, $MyRank == 1 ? get_text('MedalGold') : ($MyRank == 2 ? get_text('MedalSilver') : ($MyRank == 3 ? get_text('MedalBronze') : "")), 1, 0, 'L', 0);
$pdf->SetFont($pdf->FontStd, '', 7);
$pdf->Cell(10, 4 * $MyRow->Quanti, $MyRow->NationCode, 'LTB', 0, 'C', 0);
$pdf->Cell(75, 4 * $MyRow->Quanti, $MyRow->Nation, 'RTB', 0, 'L', 0);
}
} else {
$pdf->SetX($pdf->GetX() + 105);
}
if ($MyRank <= 3) {
$pdf->SetFont($pdf->FontStd, '', 7);
$pdf->Cell(50, 4, $MyRow->FirstName . ' ' . $MyRow->Name, 'TRB', 0, 'L', 0);
$pdf->SetFont($pdf->FontFix, '', 6);
$pdf->Cell(8, 4, number_format($MyRow->QuScore, 0, '', get_text('NumberThousandsSeparator')), 1, 0, 'R', 0);
if ($CurTeam != $MyRow->NationCode) {
$CurTeam = $MyRow->NationCode;
$pdf->SetFont($pdf->FontFix, 'B', 8);
$pdf->Cell(11, 4 * $MyRow->Quanti, number_format($MyRow->TeScore, 0, '', get_text('NumberThousandsSeparator')), 'TB', 0, 'R', 0);
$pdf->SetFont($pdf->FontFix, '', 7);
$pdf->Cell(8, 4 * $MyRow->Quanti, $MyRow->TeGold, 'TB', 0, 'R', 0);
$pdf->Cell(8, 4 * $MyRow->Quanti, $MyRow->TeXnine, 'TBR', 0, 'R', 0);
}
$pdf->Cell(0.5, 4, '', 0, 1, 'C', 0);
