} } $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;