<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/ScorePDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
$pdf = new ScorePDF(true);
$NumEnd = 12;
$NumDistances = 1;
$defScoreX = $pdf->getSideMargin();
$defScoreX2 = ($pdf->GetPageWidth() + $pdf->getSideMargin()) / 2;
$defScoreY = $pdf->getSideMargin();
$defScoreY2 = ($pdf->GetPageHeight() + $pdf->getSideMargin()) / 2;
$defScoreW = ($pdf->GetPageWidth() - $pdf->getSideMargin() * 3) / 2;
$defScoreH = ($pdf->GetPageHeight() - $pdf->getSideMargin() * 3) / 2;
$MisArray = array(1 => array($defScoreX, $defScoreY), 2 => array($defScoreX2, $defScoreY), 3 => array($defScoreX, $defScoreY2), 4 => array($defScoreX2, $defScoreY2), 5 => array($defScoreX, $defScoreY), 6 => array($defScoreX2, $defScoreY), 7 => array($defScoreX, $defScoreY2), 8 => array($defScoreX2, $defScoreY2));
//$MyQuery = "SELECT TtNumEnds,TtNumDist FROM Tournament INNER JOIN Tournament*Type AS tt ON ToType=TtId WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$MyQuery = "SELECT ToNumEnds AS TtNumEnds,ToNumDist AS TtNumDist FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$NumEnd = $r->TtNumEnds;
$NumDistances = $r->TtNumDist;
}
$FillWithArrows = false;
if (isset($_REQUEST["ScoreFilled"]) && $_REQUEST["ScoreFilled"] == 1) {
$FillWithArrows = true;
}
$pdf->FillWithArrows = $FillWithArrows;
if (!(isset($_REQUEST["ScoreHeader"]) && $_REQUEST["ScoreHeader"] == 1)) {
$pdf->HideHeader();
}
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/ScorePDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Lib/ArrTargets.inc.php';
$pdf = new ScorePDF(true);
$defScoreX = $pdf->getSideMargin();
$defScoreY = $pdf->getSideMargin();
$defScoreY2 = ($pdf->GetPageHeight() + $pdf->getSideMargin()) / 2;
$defScoreW = $pdf->GetPageWidth() - $pdf->getSideMargin() * 2;
$defScoreH = ($pdf->GetPageHeight() - $pdf->getSideMargin() * 3) / 2;
$NumEnd = 10;
$subRule = '';
//$MyQuery = "SELECT TtNumEnds FROM Tournament INNER JOIN Tournament*Type AS tt ON ToType=TtId WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$MyQuery = "SELECT ToNumEnds AS TtNumEnds, ToTypeSubRule as subRule FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$NumEnd = $r->TtNumEnds;
$subRule = $r->subRule == 'Set1Dist1Arrow';
}
if (!empty($_REQUEST["ScoreBarcode"])) {
$pdf->PrintBarcode = true;
}
// gets the default target face for this tournament
$Target = getTarget($_SESSION['TourId']);
if (!(isset($_REQUEST["ScoreHeader"]) && $_REQUEST["ScoreHeader"] == 1)) {
$pdf->HideHeader();
}
if (!(isset($_REQUEST["ScoreLogos"]) && $_REQUEST["ScoreLogos"] == 1)) {
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/ScorePDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Fun_Sessions.inc.php';
if (isset($_REQUEST["PersonalScore"]) && $_REQUEST["PersonalScore"] == 1) {
$Tmp = "";
foreach ($_REQUEST as $key => $value) {
$Tmp .= '&' . $key . '=' . $value;
}
header('location: PDFScorePersonal.php' . '?' . substr($Tmp, 1));
exit;
}
$pdf = new ScorePDF(true);
$NumEnd = 12;
$session = 0;
//$MyQuery = "SELECT TtNumEnds FROM Tournament INNER JOIN Tournament*Type AS tt ON ToType=TtId WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$MyQuery = "SELECT ToNumEnds AS TtNumEnds FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if ($r = safe_fetch($Rs)) {
$NumEnd = $r->TtNumEnds;
}
$FillWithArrows = (isset($_REQUEST["ScoreFilled"]) && $_REQUEST["ScoreFilled"] == 1 or !empty($_REQUEST["GetScorecardAsString"]));
$pdf->FillWithArrows = $FillWithArrows;
if (empty($_REQUEST["GetScorecardAsString"])) {
if (empty($_REQUEST["ScoreHeader"])) {
$pdf->HideHeader();
}
if (empty($_REQUEST["ScoreLogos"])) {
$pdf->HideLogo();
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Fun_Sessions.inc.php';
// Works for collecting up to 12 ends of 3 arrows
// changing the define here to have 6 ends of 6 arrows
define('IANSEO_ARROWS', empty($_GET['arr']) ? 3 : intval($_GET['arr']));
// get how many athletes per target
$Ath4Target = 4;
$session = intval($_REQUEST['x_Session']);
if ($session > 0) {
$ses = GetSessions(null, false, array($session . '_Q'));
$Ath4Target = $ses[0]->SesAth4Target;
}
// Defines which kind of layout
$Portrait = $Ath4Target == 4;
// creates the PDF
$pdf = new ScorePDF($Portrait);
// get how many ends
$NumEnd = 12;
$MyQuery = "SELECT ToNumEnds AS TtNumEnds FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if ($r = safe_fetch($Rs)) {
$NumEnd = $r->TtNumEnds;
}
if (empty($_REQUEST["ScoreHeader"])) {
$pdf->HideHeader();
}
if (empty($_REQUEST["ScoreLogos"])) {
$pdf->HideLogo();
}
if (empty($_REQUEST["ScoreFlags"])) {
$pdf->HideFlags();
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/ScorePDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
$pdf = new ScorePDF(true);
$NumEnd = 8;
//$MyQuery = "SELECT TtNumEnds FROM Tournament INNER JOIN Tournament*Type AS tt ON ToType=TtId WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$MyQuery = "SELECT ToNumEnds AS TtNumEnds FROM Tournament WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$NumEnd = $r->TtNumEnds;
}
$NumEnd = !empty($_REQUEST['x_Session']) && $_REQUEST['x_Session'] == 1 ? 8 : 12;
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'] == "Draw") {
$pdf->AddPage();
$pdf->DrawScoreField(8, 8, 194, 132.5, $NumEnd / 2, 3, array("tNo" => '', "startTarget" => ''));
$pdf->DrawScoreField(8, 156.5, 194, 132.5, $NumEnd / 2, 3, array("tNo" => '', "startTarget" => ''));
} else {
$MyQuery = 'SELECT SUBSTRING(ElTargetNo,1,4) as tNo, SesName, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, ElEventCode AS Cat , ElElimPhase, IFNULL(SesFirstTarget,0) as FirstTarget ' . ", CoCode, CoName " . " FROM Eliminations AS q " . " INNER JOIN Entries AS e ON q.ElId=e.EnId AND EnAthlete=1 " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . " LEFT JOIN Session ON ElSession=SesOrder AND ElTournament=SesTournament AND SesType='E' " . " WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . (!(empty($_REQUEST['x_From']) && empty($_REQUEST['x_To'])) ? " AND ElTargetNo>='" . str_pad($_REQUEST['x_From'], '3', '0', STR_PAD_LEFT) . "A' AND ElTargetNo<='" . str_pad($_REQUEST['x_To'], '3', '0', STR_PAD_LEFT) . "Z' AND ElElimPhase= " . $_REQUEST['x_Session'] . " " : "") . (!empty($_REQUEST['x_ElimSession']) ? " AND ElSession=" . $_REQUEST['x_ElimSession'] . " " : "") . ' ORDER BY ElSession, SesOrder, ElElimPhase, ElTargetNo ASC, EnFirstName, EnName, CoCode';
$Rs = safe_r_sql($MyQuery);
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/ScorePDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
$pdf = new ScorePDF(true);
$NumEnd = 6;
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'] == "Draw") {
$pdf->AddPage();
$pdf->DrawScore3D(8, 8, 194, 132.5, $NumEnd, array("tNo" => ""), false);
$pdf->DrawScore3D(8, 156.5, 194, 132.5, $NumEnd, array("tNo" => ""), false);
} else {
$MyQuery = 'SELECT SUBSTRING(ElTargetNo,1,4) as tNo, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, ElEventCode AS Cat , ElElimPhase, ' . " EvElimEnds AS CalcEnds, EvElimArrows AS CalcArrows, EvElimSO AS CalcSO, SesName, IFNULL(SesFirstTarget,0) as FirstTarget " . " FROM Eliminations AS q " . " INNER JOIN Entries AS e ON q.ElId=e.EnId AND EnAthlete=1 AND q.ElTournament=e.EnTournament " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . " INNER JOIN Events AS ev ON ev.EvCode=q.ElEventCode AND ev.EvTournament=e.EnTournament AND ev.EvTeamEvent=0 " . " LEFT JOIN Session ON ElSession=SesOrder AND ElTournament=SesTournament AND SesType='E' " . " WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . (!(empty($_REQUEST['x_From']) && empty($_REQUEST['x_To'])) ? " AND ElTargetNo>='" . str_pad($_REQUEST['x_From'], '3', '0', STR_PAD_LEFT) . "A' AND ElTargetNo<='" . str_pad($_REQUEST['x_To'], '3', '0', STR_PAD_LEFT) . "Z' AND ElElimPhase= " . $_REQUEST['x_Session'] . " " : "") . (!empty($_REQUEST['x_ElimSession']) ? " AND ElSession=" . $_REQUEST['x_ElimSession'] . " " : "") . ' ORDER BY SesOrder, ElElimPhase, /*ElEventCode,*/ ElTargetNo ASC, EnFirstName, EnName, CoCode';
$Rs = safe_r_sql($MyQuery);
//debug_svela($MyQuery);
//print $MyQuery;exit;
if (safe_num_rows($Rs) > 0) {
$first = true;
while ($MyRow = safe_fetch($Rs)) {
$Value = array("tNo" => $MyRow->tNo, "startTarget" => substr($MyRow->tNo, 0, -1) * 1, "firstTarget" => $MyRow->FirstTarget, "Cat" => $MyRow->Cat, "Dist" => '', "Ath" => $MyRow->Ath . ' - ' . get_text('Eliminations_' . ($MyRow->ElElimPhase + 1)) . ($MyRow->SesName == '' || is_null($MyRow->SesName) ? '' : ' (' . $MyRow->SesName . ')'), "Noc" => $MyRow->Noc);
if (substr($Value["tNo"], -1, 1) == "A") {
$pdf->AddPage();
