//$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";
