Example #1
0
        }
    }
    $FirstTarget = min($DayFirstTargets);
    $LastTarget = max($DayLastTargets);
}
if (!$FirstTarget and !$LastTarget) {
    exit;
}
list($a, $FirstTarget) = each($DayFirstTargets);
list($a, $LastTarget) = each($DayLastTargets);
// $FirstTarget=1; // che senso ha???
// debug_svela($DayFirstTargets);
$pdf = new ResultPDF(get_text('FopSetup'), $LastTarget - $FirstTarget < 21);
error_reporting(E_ALL);
$pdf->SetCellPadding(0.25);
$DimTarget = min(10, ($pdf->getpagewidth() - 20 - ColName) / ($LastTarget - $FirstTarget + 1));
$MyQuery = "(SELECT '' as Warmup, FSEvent," . " FSTeamEvent," . " GrPhase," . " FsMatchNo," . " FsTarget," . " '' as TargetTo," . " EvMatchArrowsNo, EvMatchMode, EvMixedTeam, EvTeamEvent, " . " UNIX_TIMESTAMP(FSScheduledDate) as SchDate," . " DATE_FORMAT(FSScheduledTime,'" . get_text('TimeFmt') . "') as SchTime, " . " EvFinalFirstPhase," . " @bit:=pow(2, ceil(log2(GrPhase))+1) & EvMatchArrowsNo," . " IF(@bit=0,EvFinEnds,EvElimEnds) AS `ends`," . " IF(@bit=0,EvFinArrows,EvElimArrows) AS `arrows`," . " IF(@bit=0,EvFinSO,EvElimSO) AS `so`," . " EvMaxTeamPerson," . " FSScheduledDate," . " FSScheduledTime, EvDistance " . " FROM FinSchedule" . " INNER JOIN Grids ON FSMatchNo=GrMatchNo" . " INNER JOIN Events ON FSEvent=EvCode AND FSTeamEvent=EvTeamEvent AND FSTournament=EvTournament " . " WHERE FSTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (FSScheduledDate!='0000-00-00' && (FSTarget*1)>0) AND GrPhase<=if(EvFinalFirstPhase=24, 32, if(EvFinalFirstPhase=48, 64, EvFinalFirstPhase)) " . ") UNION (" . "SELECT '1' as Warmup, '" . get_text('WarmUp', 'Tournament') . "'," . " ''," . " FwEvent ," . " ''," . " FwTargets, " . " FwOptions," . " '--' as EvMatchArrowsNo, 0 as EvMatchMode, 0, 0, " . " UNIX_TIMESTAMP(FwDay) as SchDate," . " DATE_FORMAT(FwTime,'" . get_text('TimeFmt') . "') as SchTime," . " 0," . " 0," . " 0 AS `ends`," . " 0 AS `arrows`," . " 0 AS `so`," . " 0," . " FwDay," . " FwTime, EvDistance " . " FROM FinWarmup" . " INNER JOIN Events ON FwEvent=EvCode AND FwTeamEvent=EvTeamEvent AND FwTournament=EvTournament " . " WHERE FwTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND FwDay>0 and FwTargets>''" . " )" . " ORDER BY FSScheduledDate ASC, FSScheduledTime ASC, Warmup ASC, FSTarget ASC, FSMatchNo ASC";
// 	debug_svela($MyQuery);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) > 0) {
    $OldSched = '';
    $OldDate = '';
    $OldEvent = '';
    $OldTarget = '';
    $TmpColor = array(255, 255, 255);
    $PrintEvent = true;
    $TgText = '';
    $TgFirst = 0;
    $TgNo = 0;
    $TgTop = 0;
    $TopPos = 35 - RowH;