//$NumFasi = array(64,48, 32,24, 16, 8, 4, 1); $NumFasi = array(64, 32, 16, 8, 4, 2, 1); $Start2FirstPhase = array(64 => 0, 48 => 0, 32 => 1, 24 => 1, 16 => 2, 8 => 3, 4 => 4, 2 => 5, 1 => 6, 0 => 6); $MyQuery = ""; if (isset($_REQUEST['Blank'])) { $model = empty($_REQUEST['Model']) ? '' : $_REQUEST['Model']; $MyQuery = "SELECT '' AS EvCode, '' AS EvEventName, EvFinalFirstPhase, EvMatchMode, EvMatchArrowsNo, " . " '' AS GrPosition, '' AS Athlete, '' AS CoCode, '' AS CoName, 0 as isBye, " . " '' AS s64,'' AS s32, '' AS s16, '' AS s8, '' AS s4, '' AS s2, '' AS sBr, '' AS sGo, " . " EvElimEnds, EvElimArrows, EvElimSO, EvFinEnds, EvFinArrows, EvFinSO" . " from Events where " . ($model ? "EvCode='{$model}' and" : '') . " EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=0 limit 1"; } else { $Events = array(); if (!empty($_REQUEST['Event'])) { if (!is_array($_REQUEST['Event'])) { $_REQUEST['Event'] = array($_REQUEST['Event']); } foreach ($_REQUEST['Event'] as $Event) { if (preg_match('//', $Event)) { $Events[] = strSafe_DB($Event); } } sort($Events); } $TmpJoinType = 'INNER'; if (isset($_REQUEST["IncEmpty"]) && $_REQUEST["IncEmpty"] == 1) { $TmpJoinType = 'LEFT'; } $MyQuery = 'SELECT ' . ' EvCode, EvEventName, EvFinalFirstPhase, EvMatchMode, EvMatchArrowsNo, ' . ' IF(EvFinalFirstPhase=48 || EvFinalFirstPhase=24,GrPosition2, GrPosition) as GrPosition, CONCAT(EnName, \' \', EnFirstName) as Athlete, (FinTie=2) as isBye, ' . ' CoCode, CoName, ' . ' NULLIF(s64.FSLetter,\'\') s64,NULLIF(s32.FSLetter,\'\') s32, NULLIF(s16.FSLetter,\'\') s16, NULLIF(s8.FSLetter,\'\') s8, NULLIF(s4.FSLetter,\'\') s4, NULLIF(s2.FSLetter,\'\') s2, NULLIF(sb.FSLetter,\'\') sBr, NULLIF(sg.FSLetter,\'\') sGo ' . " , EvElimEnds" . " , EvElimArrows" . " , EvElimSO" . " , EvFinEnds" . " , EvFinArrows" . " , EvFinSO" . ' FROM Events' . ' INNER JOIN Finals ON EvCode=FinEvent AND EvTournament=FinTournament' . ' INNER JOIN Grids ON FinMatchNo=GrMatchNo AND GrPhase=(IF(EvFinalFirstPhase=24,32, IF(EvFinalFirstPhase=48,64,EvFinalFirstPhase )))' . ' ' . $TmpJoinType . ' JOIN Entries ON FinAthlete=EnId AND FinTournament=EnTournament' . ' ' . $TmpJoinType . ' JOIN Countries on EnCountry=CoId AND EnTournament=CoTournament' . ' LEFT JOIN FinSchedule s64 ON EvCode=s64.FSEvent AND EvTeamEvent=s64.FSTeamEvent AND EvTournament=s64.FSTournament AND IF(EvFinalFirstPhase=64 OR EvFinalFirstPhase=48,FinMatchNo,-256)=s64.FSMatchNo' . ' LEFT JOIN FinSchedule s32 ON EvCode=s32.FSEvent AND EvTeamEvent=s32.FSTeamEvent AND EvTournament=s32.FSTournament AND IF(EvFinalFirstPhase=32 OR EvFinalFirstPhase=24,FinMatchNo,FLOOR(s64.FSMatchNo/2))=s32.FSMatchNo' . ' LEFT JOIN FinSchedule s16 ON EvCode=s16.FSEvent AND EvTeamEvent=s16.FSTeamEvent AND EvTournament=s16.FSTournament AND IF(EvFinalFirstPhase=16,FinMatchNo,FLOOR(s32.FSMatchNo/2))=s16.FSMatchNo' . ' LEFT JOIN FinSchedule s8 ON EvCode=s8.FSEvent AND EvTeamEvent=s8.FSTeamEvent AND EvTournament=s8.FSTournament AND IF(EvFinalFirstPhase=8,FinMatchNo,FLOOR(s16.FSMatchNo/2))=s8.FSMatchNo' . ' LEFT JOIN FinSchedule s4 ON EvCode=s4.FSEvent AND EvTeamEvent=s4.FSTeamEvent AND EvTournament=s4.FSTournament AND IF(EvFinalFirstPhase=4,FinMatchNo,FLOOR(s8.FSMatchNo/2))=s4.FSMatchNo' . ' LEFT JOIN FinSchedule s2 ON EvCode=s2.FSEvent AND EvTeamEvent=s2.FSTeamEvent AND EvTournament=s2.FSTournament AND IF(EvFinalFirstPhase=2,FinMatchNo,FLOOR(s4.FSMatchNo/2))=s2.FSMatchNo' . ' LEFT JOIN FinSchedule sb ON EvCode=sb.FSEvent AND EvTeamEvent=sb.FSTeamEvent AND EvTournament=sb.FSTournament AND FLOOR(s2.FSMatchNo/2)=sb.FSMatchNo' . ' LEFT JOIN FinSchedule sg ON EvCode=sg.FSEvent AND EvTeamEvent=sg.FSTeamEvent AND EvTournament=sg.FSTournament AND FLOOR(s2.FSMatchNo/2)-2=sg.FSMatchNo' . ' WHERE EvTournament=' . StrSafe_DB($_SESSION['TourId']) . ' AND EvTeamEvent=0 '; if ($Events) { $MyQuery .= "AND EvCode in (" . implode(',', $Events) . ") "; } $MyQuery .= ' ORDER BY EvCode, FinMatchNo '; } //DEBUG_svela($MyQuery, true);
print 8 - $Cols2Remove; ?> "><?php print get_text('IndFinal'); ?> </th></tr> <tr class="Divider"><td colspan="<?php print 8 - $Cols2Remove; ?> "></td></tr> <?php $QueryFilter = ''; // if a scheduled round has been sent, it superseeds everything if (!empty($_REQUEST['x_Session']) and $_REQUEST['x_Session'] != -1) { // get all the pairs event<=>phase for that scheduled time $QueryFilter .= "AND concat(FSTeamEvent, FSScheduledDate, ' ', FSScheduledTime)=" . strSafe_DB($_REQUEST['x_Session']) . " "; } elseif (!empty($_REQUEST['d_Event'])) { // creates the filter on the matching events and phase $tmp = array(); foreach ($_REQUEST['d_Event'] as $event) { $tmp[] = StrSafe_DB($event); } sort($tmp); if ($tmp) { $QueryFilter .= "AND FinEvent in (" . implode(',', $tmp) . ") "; } $QueryFilter .= "AND GrPhase=" . StrSafe_DB($_REQUEST['d_Phase']) . " "; } // Tiro fuori l'elenco degli eventi non spareggiati $Select = "SELECT distinct EvCode, EvEventName, EvMatchMode " . "FROM Finals " . "left JOIN FinSchedule ON FinEvent=FSEvent AND FsMatchNo=FinMatchNo AND FsTeamEvent='0' AND FsTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "INNER JOIN Events ON FinEvent=EvCode AND EvTeamEvent='0' AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "INNER JOIN Grids ON FinMatchNo=GrMatchNo " . "WHERE FinTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvShootOff='0' " . $QueryFilter . "ORDER BY EvProgr ASC,GrMatchNo ASC "; $Rs = safe_r_sql($Select);
require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Fun_HHT.local.inc.php'; if (!CheckTourSession() || !isset($_REQUEST['Id']) || !isset($_REQUEST['Event']) || !isset($_REQUEST['Value'])) { print get_text('CrackError'); exit; } $Errore = 0; if (!(IsBlocked(BIT_BLOCK_QUAL) && IsBlocked(BIT_BLOCK_IND) && IsBlocked(BIT_BLOCK_TEAM))) { $select = "SELECT HeEventCode FROM HhtEvents WHERE HeEventCode=" . StrSafe_DB($_REQUEST['Event']) . " AND HeTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND HeHhtId=" . StrSafe_DB($_REQUEST['Id']); $rs = safe_r_sql($select); // echo $select; //debug_svela(safe_num_rows($rs)); if (safe_num_rows($rs) == 0 && $_REQUEST['Value'] == "true") { list($what, $ses, $dist) = phaseDecode($_REQUEST['Event']); safe_w_sql("INSERT INTO HhtEvents set HeTournament=" . StrSafe_DB($_SESSION['TourId']) . ", HeEventCode=" . StrSafe_DB($_REQUEST['Event']) . ", HeHhtId=" . StrSafe_DB($_REQUEST['Id']) . ", HeSession=" . ($what == -1 ? $ses : 0) . ", HeFinSchedule=" . ($what != -1 ? strSafe_DB($ses) : '0') . ", HeTeamEvent=" . ($what == -1 ? 0 : $what)); } else { if (safe_num_rows($rs) == 1 && $_REQUEST['Value'] == "false") { safe_w_sql("Delete From HhtEvents WHERE HeTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND HeEventCode=" . StrSafe_DB($_REQUEST['Event']) . " AND HeHhtId=" . StrSafe_DB($_REQUEST['Id'])); } else { $Errore = 1; } } } else { $Errore = 1; } header('Content-Type: text/xml'); print '<response>' . "\n"; print '<error>' . $Errore . '</error>' . "\n"; print '<id>' . $_REQUEST['Id'] . '</id>' . "\n"; print '<event>' . $_REQUEST['Event'] . '</event>' . "\n";