Ritorna i matchno di una fase di un evento. */ define('debug', false); require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Common/Fun_FormatText.inc.php'; require_once 'Fun_Final.local.inc.php'; $Ev = isset($_REQUEST['Ev']) ? $_REQUEST['Ev'] : null; $Ph = isset($_REQUEST['Ph']) ? $_REQUEST['Ph'] : null; $Team = isset($_REQUEST['TeamEvent']) ? $_REQUEST['TeamEvent'] : 0; if (is_null($Ev) || is_null($Ph) || !CheckTourSession()) { print get_text('CrackError'); exit; } $Errore = 0; // tiro fuori i match $rs = GetFinMatches($Ev, $Ph, null, $Team, true); //$rs=safe_r_sql($query); if (!$rs) { $Errore = 1; } if (!debug) { header('Content-Type: text/xml'); } $xml = '<response>' . "\n"; $xml .= '<error>' . $Errore . '</error>' . "\n"; if ($Errore == 0) { while ($row = safe_fetch($rs)) { $Target = ltrim($row->target1, '0'); if ($row->target1 != $row->target2) { $Target .= '/' . ltrim($row->target2, '0'); }
} // if($arrow==='0') $arrow='M'; // elseif($arrow==='0*') $arrow='M*'; //Se ho i valori di freccia, indice della textbox e tipo textbox (std o so) procedo con il salvataggio dei punti if (!(is_null($what) || is_null($arrow) || is_null($index) || !preg_match('/^[st]{1}$/i', $what))) { // Verifico la arrow se il valore è valido per il target selezionato if (array_key_exists(strtoupper(GetLetterFromPrint($arrow, $CurrentTarget)), $validData["Arrows"])) { $arrow = GetLetterFromPrint($arrow, $CurrentTarget); } else { $arrow = ' '; } // conti $ArrowStart = $index + 1; // se però ho mandato il tie devo rifare i conti if ($what == 't') { $rs = GetFinMatches($event, null, $queryMatch, $TeamEvent, false); $myRow = safe_fetch($rs); list($rows, $cols, $so) = CalcScoreRowsColsSO($myRow); $ArrowStart = $rows * $cols + 1 + $index; } UpdateArrowString($match2edit, $event, $TeamEvent, $arrow, $ArrowStart, $ArrowStart); if ($arrow == ' ') { UpdateArrowPosition($match2edit, $event, $TeamEvent, '', '', ($what == 's' ? '0' : '1') . "|" . $index); } $spotLimit[0] = $what == 's' ? 0 : 1; } $Select = ''; if ($TeamEvent == 0) { $Select = "SELECT " . "f.FinEvent as EvCode, f.FinMatchNo as MatchNo, f2.FinMatchNo as OppMatchNo, EvMatchMode, EvMatchArrowsNo, " . "IF(f.FinDateTime>=f2.FinDateTime, f.FinDateTime, f2.FinDateTime) AS DateTime," . "f.FinScore AS Score, f.FinSetScore AS SetScore, f.FinTie as Tie, f.FinArrowString as ArString, f.FinTieBreak as TbString, " . "f2.FinScore AS OppScore, f2.FinSetScore AS OppSetScore, f2.FinTie as OppTie, f2.FinArrowString as OppArString, f2.FinTieBreak as OppTbString, " . "GrPhase, EvMaxTeamPerson " . "FROM Finals AS f " . "INNER JOIN Finals AS f2 ON f.FinEvent=f2.FinEvent AND f.FinMatchNo=IF((f.FinMatchNo % 2)=0,f2.FinMatchNo-1,f2.FinMatchNo+1) AND f.FinTournament=f2.FinTournament " . "INNER JOIN Events ON f.FinEvent=EvCode AND f.FinTournament=EvTournament AND EvTeamEvent=0 " . "INNER JOIN Grids ON f.FinMatchNo=GrMatchNo " . "WHERE f.FinTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (f.FinMatchNo % 2)=0 AND GrMatchNo=" . StrSafe_DB($queryMatch) . " AND f.FinEvent=" . StrSafe_DB($event) . " " . "ORDER BY f.FinEvent, f.FinMatchNo "; } else { $Select = "SELECT " . "f.TfEvent as EvCode, f.TfMatchNo as MatchNo, f2.TfMatchNo as OppMatchNo, EvMatchMode, EvMatchArrowsNo, " . "IF(f.TfDateTime>=f2.TfDateTime, f.TfDateTime, f2.TfDateTime) AS DateTime," . "f.TfScore AS Score, f.TfSetScore AS SetScore, f.TfTie as Tie, f.TfArrowString as ArString, f.TfTieBreak as TbString, " . "f2.TfScore AS OppScore, f2.TfSetScore AS OppSetScore, f2.TfTie as OppTie, f2.TfArrowString as OppArString, f2.TfTieBreak as OppTbString, " . "GrPhase, EvMaxTeamPerson " . "FROM TeamFinals AS f " . "INNER JOIN TeamFinals AS f2 ON f.TfEvent=f2.TfEvent AND f.TfMatchNo=IF((f.TfMatchNo % 2)=0,f2.TfMatchNo-1,f2.TfMatchNo+1) AND f.TfTournament=f2.TfTournament " . "INNER JOIN Events ON f.TfEvent=EvCode AND f.TfTournament=EvTournament AND EvTeamEvent=1 " . "INNER JOIN Grids ON f.TfMatchNo=GrMatchNo " . "WHERE f.TfTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (f.TfMatchNo % 2)=0 AND GrMatchNo=" . StrSafe_DB($queryMatch) . " AND f.TfEvent=" . StrSafe_DB($event) . " " . "ORDER BY f.TfEvent, f.TfMatchNo ";
} $q = safe_r_sql("(select '0' as Team, FinEvent as Event, FinMatchNo as MatchNo, UNIX_TIMESTAMP(FinDateTime) DateTime, UNIX_TIMESTAMP(FinDateTime)>{$LastUpdated} Updated from Finals where FinTournament={$TourId} and FinLive='1')\n\t\tUNION\n\t\t(select '1' as Team, TfEvent as Event, TfMatchNo as MatchNo, UNIX_TIMESTAMP(TfDateTime) DateTime, UNIX_TIMESTAMP(TfDateTime)>{$LastUpdated} Updated from TeamFinals where TfTournament={$TourId} and TfLive='1') order by MatchNo"); if (!($r = safe_fetch($q))) { $Error = 'no match now'; } $XML = '<r>' . '<e>' . intval(!empty($Error)) . '</e>' . '<t>' . ($Error ? 0 : $r->DateTime) . '</t>' . '<c><![CDATA[' . $Error . ']]></c>' . '</r>'; // No changes so exits immediately if ($Error or !$r->Updated) { header('Content-Type: text/xml'); die($XML); } $d_Event = $r->Event; $d_Match = $r->MatchNo; $team = $r->Team; // tiro fuori le info x lo scontro $rs = GetFinMatches($d_Event, null, $d_Match, $team, false, $TourId); //Carico il vettore dei dati validi $validData = GetMaxScores($d_Event, $d_Match, $team, $TourId); if (safe_num_rows($rs) != 1) { exit; } $EnCours = false; $myRow = safe_fetch($rs); // debug_svela($myRow, true); // righe e colonne e so nel caso di individuali cumulativi $rows = 4; $cols = 3; $so = 1; list($rows, $cols, $so) = CalcScoreRowsColsSO($myRow, $TourId); // i due score da stampare a video $scores = array(1 => '', 2 => '');
require_once 'HHT/serial.php'; require_once 'HHT/Fun_HHT.local.inc.php'; require_once 'Common/Lib/ArrTargets.inc.php'; require_once 'Common/Fun_Phases.inc.php'; $event = isset($_REQUEST['event']) ? $_REQUEST['event'] : null; $team = isset($_REQUEST['team']) ? $_REQUEST['team'] : null; $match = isset($_REQUEST['match']) ? $_REQUEST['match'] : null; $line = isset($_REQUEST['line']) ? $_REQUEST['line'] : null; $type = isset($_REQUEST['type']) ? $_REQUEST['type'] : null; $contrast = isset($_REQUEST['contrast']) ? $_REQUEST['contrast'] : 9; $Errore = 0; if (is_null($event) || is_null($team) || is_null($match) || is_null($line) || is_null($type)) { $Errore = 1; } if ($Errore == 0) { $rs = GetFinMatches($event, null, $match, $team, false); $myRow = safe_fetch($rs); $obj = getEventArrowsParams($myRow->event, $myRow->phase, $myRow->teamEvent); /* echo "<pre>"; print_r($myRow); print_r($obj); echo "</pre>"; */ $lArr = ""; $rArr = ""; $lSum = ""; $rSum = ""; $lTot = ""; $rTot = ""; $dLeft = "";
require_once 'Common/Fun_FormatText.inc.php'; require_once 'Common/Lib/ArrTargets.inc.php'; require_once 'Fun_Final.local.inc.php'; CheckTourSession(true); $d_Event = isset($_REQUEST['d_Event']) ? $_REQUEST['d_Event'] : null; $d_Match = isset($_REQUEST['d_Match']) ? $_REQUEST['d_Match'] : null; $team = isset($_REQUEST['d_Team']) ? $_REQUEST['d_Team'] : 0; $chunkMode = isset($_REQUEST['d_Mode']) ? $_REQUEST['d_Mode'] : 0; if (is_null($d_Event) || is_null($d_Match) || !CheckTourSession()) { exit; } if ($d_Match == '' || $d_Event == '') { exit; } // tiro fuori le info x lo scontro $rs = GetFinMatches($d_Event, null, $d_Match, $team, false); //Carico il vettore dei dati validi $validData = GetMaxScores($d_Event, $d_Match, $team); if (safe_num_rows($rs) != 1) { exit; } $myRow = safe_fetch($rs); // righe e colonne e so nel caso di individuali cumulativi $rows = 4; $cols = 3; $so = 1; list($rows, $cols, $so) = CalcScoreRowsColsSO($myRow); // i due score da stampare a video $scores = array(1 => '', ''); /* * $setPoints contiene contiene i progressivi dei set.