<?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(); } }