echo '<td width="50%" class="Center">';
// recupera per questo torneo quanti formati ci sono...
// $q=safe_r_sql("(select distinct EvMatchMode, EvElimEnds, EvElimArrows, EvElimSO from Events where EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=1 AND EvFinalFirstPhase!=0 )"
// . "UNION (select distinct EvMatchMode, EvFinEnds, EvFinArrows, EvFinSO from Events where EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=1 AND EvFinalFirstPhase!=0 )");
$query = "\r\n\t\tSELECT\r\n\t\t\tEvCode,EvFinalFirstPhase,EvMatchArrowsNo,\r\n\t\t\tEvElimEnds, EvElimArrows, EvElimSO,\r\n\t\t\tEvFinEnds, EvFinArrows, EvFinSO\r\n\t\tFROM\r\n\t\t\tEvents\r\n\t\tWHERE\r\n\t\t\tEvTournament={$_SESSION['TourId']} AND EvTeamEvent=1\r\n\t";
/*
* Per ogni evento scopro se le sue fasi prevedono o no l'uso dei parametri elim e fin.
* Se almeno una fase usa un tipo di parametri, memorizzo la terna in $list (purchè non l'abbia già messa prima).
* Poi per tutte le terne (che saranno diverse) preparo i link
*/
$q = safe_r_sql($query);
echo '<br><table width="100%" cellspacing="0" cellpadding="1">';
echo '<tr>';
$list = array();
while ($r = safe_fetch($q)) {
$elimFin = elimFinFromMatchArrowsNo($r->EvFinalFirstPhase, $r->EvMatchArrowsNo);
$arr = array($r->EvElimEnds, $r->EvElimArrows, $r->EvElimSO);
if ($elimFin[0] && !in_array($arr, $list)) {
$list[] = $arr;
}
$arr = array($r->EvFinEnds, $r->EvFinArrows, $r->EvFinSO);
if ($elimFin[1] && !in_array($arr, $list)) {
$list[] = $arr;
}
// echo '<td><a href="'.$CFG->ROOT_DIR.'Final/Team/PDFScoreMatch.php?Blank=1&Rows=' . $r->EvElimEnds . '&Cols='.$r->EvElimArrows.'&SO='.$r->EvElimSO.'" class="Link" target="PrintOut">';
// echo '<img src="'.$CFG->ROOT_DIR.'Common/Images/pdf.gif" alt="' . get_text('Score1Page1Match') . '" border="0"><br>';
// echo get_text('Score1Page1Match');
// echo '<br/>'. ($r->EvMatchMode?get_text('MatchMode_1').':</b> ':'') . get_text('EventDetails', 'Tournament', array($r->EvElimEnds, $r->EvElimArrows, $r->EvElimSO)) ;
// echo '</a></td>';
}
if (count($list) > 0) {
function eventHasScoreTypes($event, $team, $tour = null)
{
$tourId = $tour === null ? $_SESSION['TourId'] : $tour;
$q = "\n\t\tSELECT\n\t\t\tEvCode,EvTeamEvent,EvTournament,\n\t\t\tEvFinalFirstPhase,EvMatchArrowsNo\n\t\tFROM\n\t\t\tEvents\n\t\tWHERE\n\t\t\tEvTournament={$tourId}\n\t\t\tAND EvCode='{$event}'\n\t\t\tAND EvTeamEvent='{$team}'\n\t";
//print '<br><br>'.$q.'<br><br>';
$r = safe_r_sql($q);
if (!($r && safe_num_rows($r) == 1)) {
return false;
}
$row = safe_fetch($r);
return elimFinFromMatchArrowsNo($row->EvFinalFirstPhase, $row->EvMatchArrowsNo);
}
