$FillWithArrows = false;
if (isset($_REQUEST["ScoreFilled"]) && $_REQUEST["ScoreFilled"] == 1) {
$FillWithArrows = true;
}
$pdf->FillWithArrows = $FillWithArrows;
if (!(isset($_REQUEST["ScoreHeader"]) && $_REQUEST["ScoreHeader"] == 1)) {
$pdf->HideHeader();
}
if (!(isset($_REQUEST["ScoreLogos"]) && $_REQUEST["ScoreLogos"] == 1)) {
$pdf->HideLogo();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST["ScoreDraw"] == "Data") {
$pdf->NoDrawing();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST["ScoreDraw"] == "CompleteTotals") {
$pdf->PrintTotalColumns();
}
if (!empty($_REQUEST["ScoreBarcode"])) {
$pdf->PrintBarcode = true;
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST['ScoreDraw'] == "Draw") {
$pdf->AddPage();
for ($i = 1; $i <= $NumDistances; $i++) {
if ($i == 5) {
$pdf->AddPage();
}
$pdf->DrawScore($MisArray[$i][0], $MisArray[$i][1], $defScoreW, $defScoreH, $NumEnd, 3, array("tNo" => ''));
}
} else {
$MyQuery = 'SELECT SUBSTRING(at.AtTargetNo,2) as tNo, EnCode, EnDivision, EnClass, CoCode, CoName, Ath, Noc, Cat, Td1, Td2, Td3, Td4, Td5, Td6, Td7, Td8, ' . 'QuD1Arrowstring, QuD2Arrowstring, QuD3Arrowstring, QuD4Arrowstring, QuD5Arrowstring, QuD6Arrowstring, QuD7Arrowstring, QuD8Arrowstring, ' . 'QuD1Score, QuD2Score, QuD3Score, QuD4Score, QuD5Score, QuD6Score, QuD7Score, QuD8Score, ' . ' QuD1Gold, QuD1XNine, QuD2Gold, QuD2XNine, QuD3Gold, QuD3XNine, QuD4Gold, QuD4XNine, ' . ' QuD5Gold, QuD5XNine, QuD6Gold, QuD6XNine, QuD7Gold, QuD7XNine, QuD8Gold, QuD8XNine, ' . 'printD1gx, printD2gx, printD3gx, printD4gx, printD5gx, printD6gx, printD7gx, printD8gx ' . ' FROM AvailableTarget as at ' . ' ' . ($FillWithArrows ? 'INNER' : 'LEFT') . ' JOIN (' . ' SELECT EnCode, EnDivision, EnClass, CoCode, CoName, QuTargetNo, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, CONCAT(EnDivision, \' \', EnClass) AS Cat, ' . ' Td1, Td2, Td3, Td4, Td5, Td6, Td7, Td8,' . ' QuD1Arrowstring, QuD2Arrowstring, QuD3Arrowstring, QuD4Arrowstring, QuD5Arrowstring, QuD6Arrowstring, QuD7Arrowstring, QuD8Arrowstring, ' . ' QuD1Score, QuD2Score, QuD3Score, QuD4Score, QuD5Score, QuD6Score, QuD7Score, QuD8Score, ' . ' QuD1Gold, QuD1XNine, QuD2Gold, QuD2XNine, QuD3Gold, QuD3XNine, QuD4Gold, QuD4XNine, ' . ' QuD5Gold, QuD5XNine, QuD6Gold, QuD6XNine, QuD7Gold, QuD7XNine, QuD8Gold, QuD8XNine, ' . ' QuD1Gold+QuD1XNine as printD1gx, QuD2Gold+QuD2XNine as printD2gx, QuD3Gold+QuD3XNine as printD3gx, QuD4Gold+QuD4XNine as printD4gx, ' . ' QuD5Gold+QuD5XNine as printD5gx, QuD6Gold+QuD6XNine as printD6gx, QuD7Gold+QuD7XNine as printD7gx ,QuD8Gold+QuD8XNine as printD8gx ' . ' FROM Entries ' . ' INNER JOIN Qualifications ON EnId = QuId ' . ' INNER JOIN Countries ON EnCountry=CoId AND EnTournament=CoTournament ' . ' INNER JOIN Tournament ON EnTournament=ToId ' . ' INNER JOIN TournamentDistances ON ToType=TdType and TdTournament=ToId AND CONCAT(TRIM(EnDivision),TRIM(EnClass)) LIKE TdClasses ' . ' WHERE EnTournament = ' . StrSafe_DB($_SESSION['TourId']) . " AND QuTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND QuTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z' " . ') as Sqy ON at.AtTargetNo = Sqy.QuTargetNo ' . " WHERE at.AtTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . " AND at.AtTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND at.AtTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z' " . ' ORDER BY at.AtTargetNo ASC, Ath, Noc ';
//print $MyQuery;Exit;
