<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/OrisFunctions.php';
require_once 'Common/pdf/PdfChunkLoader.php';
// ATTENTION!
// MUST BE called $PdfData
$PdfData = getStartListByCountries(true, isset($_GET['Athletes']));
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF($PdfData->Code, $PdfData->Description);
} else {
$pdf->setOrisCode('', $PdfData->Description);
}
require_once PdfChunkLoader('OrisCountry.inc.php');
if (!isset($isCompleteResultBook)) {
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
} else {
$pdf->Output();
}
}
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF('C32B', 'Entries by Event');
} else {
$pdf->setOrisCode('', 'Entries by Event');
}
$TmpWhere = "";
if (isset($_REQUEST["CountryName"]) && preg_match("/^[-,0-9A-Z]*\$/i", str_replace(" ", "", $_REQUEST["CountryName"]))) {
foreach (explode(",", $_REQUEST["CountryName"]) as $Value) {
$Tmp = NULL;
if (preg_match("/^([A-Z0-9]*)-([A-Z0-9]*)\$/i", str_replace(" ", "", $Value), $Tmp)) {
$TmpWhere .= "(CoCode >= " . StrSafe_DB(stripslashes($Tmp[1])) . " AND CoCode <= " . StrSafe_DB(stripslashes($Tmp[2] . chr(255))) . ") OR ";
} else {
$TmpWhere .= "CoCode LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";
}
}
$TmpWhere = substr($TmpWhere, 0, -3);
}
$MyQuery = "SELECT IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode, EnCode as Bib, EnName AS Name, upper(EnFirstName) AS FirstName, QuSession AS Session, SUBSTRING(QuTargetNo,2) AS TargetNo, CoCode AS NationCode, CoName AS Nation, IFNULL(EvEventName,CONCAT('|',DivDescription, '| |', ClDescription)) as EventName, cNumber ";
$MyQuery .= "FROM Entries AS e ";
$MyQuery .= "INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament ";
$MyQuery .= "INNER JOIN Qualifications AS q ON e.EnId=q.QuId ";
$MyQuery .= "INNER JOIN ( ";
$MyQuery .= "SELECT EnCountry AS cCode, COUNT(EnId) AS cNumber FROM `Entries` ";
$MyQuery .= "WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " GROUP BY EnCountry ";
$MyQuery .= ") as sqy ON e.EnCountry=sqy.cCode ";
$MyQuery .= "LEFT JOIN Individuals AS i on e.EnId=i.IndId AND e.EnTournament=i.IndTournament ";
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/OrisFunctions.php';
require_once 'Common/pdf/PdfChunkLoader.php';
// ATTENTION!
// MUST BE called $PdfData
$PdfData = getStartList(true, '', true);
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF('C51A', 'Start List by Target');
} else {
$pdf->setOrisCode('', 'Start List by Target');
}
require_once PdfChunkLoader('OrisElimStartList.inc.php');
if (!isset($isCompleteResultBook)) {
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
} else {
$pdf->Output();
}
}
