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