$Delete = "DELETE FROM EventClass " . "WHERE EcCode=" . StrSafe_DB($_REQUEST['EvCode']) . " AND EcClass=" . StrSafe_DB($EcClass) . " AND EcDivision=" . StrSafe_DB($EcDivision) . " " . "AND EcTeamEvent!='0' AND EcTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; //print $Delete;exit; $Rs = safe_w_sql($Delete); // calcolo il numero massimo di persone nel team calcMaxTeamPerson(array($_REQUEST['EvCode'])); // cancello le righe di Team per l'evento passato $queries[] = "DELETE FROM Teams WHERE TeTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND TeFinEvent=1 AND TeEvent=" . StrSafe_DB($_REQUEST['EvCode']) . " "; // cancello i nomi $queries[] = "DELETE FROM TeamComponent WHERE TcTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND TcFinEvent=1 AND TcEvent=" . StrSafe_DB($_REQUEST['EvCode']) . " "; // cancello i nomi fin $queries[] = "DELETE FROM TeamFinComponent WHERE TfcTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND TfcEvent=" . StrSafe_DB($_REQUEST['EvCode']) . " "; // elimino le griglie $queries[] = "DELETE FROM TeamFinals " . "WHERE TfEvent=" . StrSafe_DB($_REQUEST['EvCode']) . " AND TfTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; $Rs = safe_w_sql($Delete); // reset shootoff ResetShootoff($_REQUEST['EvCode'], 1, 0); // teamabs MakeTeamsAbs(null, null, null); header('Location: SetEventRules.php?EvCode=' . $_REQUEST['EvCode']); exit; } $JS_SCRIPT = array('<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/ajax/ObjXMLHttpRequest.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Final/Team/Fun_AJAX_SetEventRules.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/Fun_JS.inc.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Final/Team/Fun_JS.js"></script>'); $PAGE_TITLE = get_text('TeamDefinition'); include 'Common/Templates/head.php'; ?> <div align="center"> <div class="medium"> <table class="Tabella" id="MyTable"> <tbody id="tbody"> <tr><th class="Title" colspan="5"><?php print get_text('TeamDefinition');
Obj_RankFactory::create('ElimInd', array('eventsC' => array($ev . '@' . ($Fase + 1))))->calculate(); } // azzero gli shootoff /*$Update = "UPDATE Events INNER JOIN EventClass ON EvCode=EcCode AND EvTeamEvent='0' AND EcTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "INNER JOIN Entries ON EcDivision=EnDivision AND EcClass=EnClass AND EnId=" . StrSafe_DB($Atleta) . " " . "SET EvShootOff='0' " . ($Fase==0 ? ", EvE2ShootOff='0' " : "") . "WHERE EvTeamEvent='0' AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; $Rs=safe_w_sql($Update); set_qual_session_flags();*/ $q = "\r\n\t\t\t\t\t\tSELECT EvCode\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tEvents\r\n\t\t\t\t\t\t\tINNER JOIN\r\n\t\t\t\t\t\t\t\tEventClass\r\n\t\t\t\t\t\t\tON EvCode=EcCode AND EvTeamEvent='0' AND EcTournament={$_SESSION['TourId']}\r\n\t\t\t\t\t\t\tINNER JOIN\r\n\t\t\t\t\t\t\t\tEntries\r\n\t\t\t\t\t\t\tON EcDivision=EnDivision AND EcClass=EnClass AND EnId={$Atleta}\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t EvTeamEvent='0' AND EvTournament={$_SESSION['TourId']}\r\n\t\t\t\t\t"; $Rs = safe_w_sql($q); if ($Rs && safe_num_rows($Rs) > 0) { while ($row = safe_fetch($Rs)) { //print $Fase.'<br>'; ResetShootoff($row->EvCode, 0, $Fase == 0 ? 1 : 2); } } if (debug) { print $Update . '<br>'; } } // estraggo i totali $Select = "SELECT ElId, ElElimPhase, " . $Cosa . " " . "FROM Eliminations WHERE ElId=" . StrSafe_DB($Atleta) . " AND ElElimPhase=" . StrSafe_DB($Fase); $Rs = safe_r_sql($Select); //print $Select; $Errore = 0; // no error $MyRow = NULL; if (safe_num_rows($Rs) == 1) { $MyRow = safe_fetch($Rs);
. "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " "; $Rs=safe_w_sql($Update);*/ // azzero gli shootoff /*$Update = "UPDATE Events INNER JOIN EventClass ON EvCode=EcCode AND (EvTeamEvent='0' OR EvTeamEvent='1') AND EcTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "INNER JOIN Entries ON EcDivision=EnDivision AND EcClass=EnClass AND EnId=" . StrSafe_DB($_REQUEST['Id']) . " " . "SET EvShootOff='0' " . "WHERE (EvTeamEvent='0' AND EnIndFEvent='1') OR (EvTeamEvent='1' AND EnTeamFEvent='1') AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; $Rs=safe_w_sql($Update); set_qual_session_flags();*/ $q = "\n\t\t\t\t\t\t\t\t\tSELECT DISTINCT EvCode,EvTeamEvent\n\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\tEvents\n\t\t\t\t\t\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\t\t\t\t\t\tEventClass\n\t\t\t\t\t\t\t\t\t\tON EvCode=EcCode AND (EvTeamEvent='0' OR EvTeamEvent='1') AND EcTournament={$_SESSION['TourId']}\n\t\t\t\t\t\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\t\t\t\t\t\tEntries\n\t\t\t\t\t\t\t\t\t\tON TRIM(EcDivision)=TRIM(EnDivision) AND TRIM(EcClass)=TRIM(EnClass) AND EnId={$_REQUEST['Id']}\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t (EvTeamEvent='0' AND EnIndFEvent='1') OR (EvTeamEvent='1' AND EnTeamFEvent='1') AND EvTournament={$_SESSION['TourId']}\n\t\t\t\t\t\t\t\t"; //print $q;exit; $Rs = safe_r_sql($q); if ($Rs && safe_num_rows($Rs) > 0) { while ($row = safe_fetch($Rs)) { ResetShootoff($row->EvCode, $row->EvTeamEvent, 0); } } if (debug) { print $Update . '<br>'; } } if ($RsUp) { // tiro fuori lo score totale $Select = "SELECT QuScore, QuGold, QuXnine " . "FROM Qualifications " . "WHERE QuId=" . StrSafe_DB($_REQUEST['Id']) . " "; if (debug) { print $Select . '<br>'; } $Rs = safe_r_sql($Select); if (safe_num_rows($Rs) == 1) { $MyRow = safe_fetch($Rs);
/** * Per gli eventi in $events imposta lo shootoff a zero * @param $string[] $events: eventi * @return int: 0 ok; 1 errore */ function SetupShootoff($events) { if (count($events) > 0) { /*$query = "UPDATE " . "Events " . "SET " . "EvShootOff=0 " . "WHERE " . "EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=1 " . "AND EvCode IN(" . implode(',',$events). ") "; $Rs=safe_w_sql($query); if (!$Rs) return 1;*/ foreach ($events as $e) { $x = ResetShootoff($e, 1, 0); if (!$x) { return 1; } } } return 0; }
if ($x && $y) { // ricreo la griglia distrutta $query = "INSERT INTO Finals (FinEvent,FinMatchNo,FinTournament,FinDateTime) " . "SELECT EvCode,GrMatchNo," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB(date('Y-m-d H:i')) . " " . "FROM Events INNER JOIN Grids ON GrPhase<=EvFinalFirstPhase AND EvTeamEvent='0' " . "AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "WHERE EvCode = " . StrSafe_DB($event); //print $query . '<br><br>'; $rs = safe_w_sql($query); if (!$rs) { $error = 1; } else { // azzero i flags di shootoff /*$query = "UPDATE " . "Events " . "SET " . "EvShootOff=0,EvE1ShootOff=0,EvE2ShootOff=0 " . "WHERE " . "EvCode=" . StrSafe_DB($event) . " AND EvTeamEvent=0 AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; $rs=safe_w_sql($query); set_qual_session_flags();*/ if (!ResetShootoff($event, 0, 0)) { $error = 1; } } } else { $error = 1; } } } } $xml .= '<response>' . "\n" . '<error>' . $error . '</error>' . "\n" . '<event>' . $event . '</event>' . "\n" . '</response>' . "\n"; header('Content-Type: text/xml; charset=UTF-8'); print $xml;
$Delete = "DELETE FROM Finals " . "WHERE FinEvent=" . StrSafe_DB($_REQUEST['EvCode']) . " AND FinTournament=" . StrSafe_DB($_SESSION['TourId']) . " "; $Rs = safe_w_sql($Delete); if ($Rs) { // Deletes unused warmups $delSchedule = "DELETE FROM FinWarmup USING\n\t\t\t\t\tEvents\n\t\t\t\t\tINNER JOIN FinSchedule ON EvCode = FsEvent AND EvTeamEvent = FsTeamEvent AND EvTournament = FsTournament\n\t\t\t\t\tINNER JOIN Grids ON GrMatchNo = FsMatchNo\n\t\t\t\t\tINNER JOIN FinWarmup on FsEvent=FwEvent and FsTeamEvent=FwTeamEvent and FsTournament=FwTournament and FsScheduledDate=FwDay and FsScheduledTime=FwMatchTime\n\t\t\t\t\tWHERE EvFinalFirstPhase < GrPhase\n\t\t\t\t\tAND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent='0' AND EvCode=" . StrSafe_DB($_REQUEST['EvCode']); $RsDel = safe_w_sql($delSchedule); //Cancello lo schedule non in uso $delSchedule = "DELETE FROM FinSchedule USING\n\t\t\t\t\tEvents\r\n\t\t\t\t\tINNER JOIN FinSchedule ON EvCode = FsEvent AND EvTeamEvent = FsTeamEvent AND EvTournament = FsTournament\r\n\t\t\t\t\tINNER JOIN Grids ON GrMatchNo = FsMatchNo\r\n\t\t\t\t\tWHERE EvFinalFirstPhase < GrPhase\n\t\t\t\t\tAND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent='0' AND EvCode=" . StrSafe_DB($_REQUEST['EvCode']); $RsDel = safe_w_sql($delSchedule); // Creo la griglia $Insert = "INSERT INTO Finals (FinEvent,FinMatchNo,FinTournament,FinDateTime) " . "SELECT EvCode,GrMatchNo," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB(date('Y-m-d H:i:s')) . " " . "FROM Events INNER JOIN Grids ON GrPhase<=if(EvFinalFirstPhase=24, 32, IF(EvFinalFirstPhase=48,64, EvFinalFirstPhase)) AND EvTeamEvent='0' " . "AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "WHERE EvCode=" . StrSafe_DB($_REQUEST['EvCode']) . " "; if ($_REQUEST['NewPhase'] != 0) { $RsIns = safe_w_sql($Insert); } // Azzero il flag di spareggio ResetShootoff($_REQUEST['EvCode'], 0, 3); } else { $Errore = 1; } } else { $Errore = 1; } } else { $Errore = 1; } if (!debug) { header('Content-Type: text/xml'); } print '<response>' . "\n"; print '<error>' . $Errore . '</error>' . "\n"; print '<event>' . $_REQUEST['EvCode'] . '</event>' . "\n";