$rs = safe_w_sql($query);
$x = DeleteElimRows($event, 1);
$y = DeleteElimRows($event, 2);
if (!$x || !$y) {
$error = 1;
} else {
// distruggo la griglia delle finali
$query = "DELETE FROM Finals " . "WHERE FinTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND FinEvent = " . StrSafe_DB($event) . " ";
//print $query . '<br><br>';
$rs = safe_w_sql($query);
if (!$rs) {
$error = 1;
} else {
// ricreo le griglie eliminatorie
$x = CreateElimRows($event, 1);
$y = CreateElimRows($event, 2);
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 "
if (safe_num_rows($RsElim) == 1) {
$Row = safe_fetch($RsElim);
$Elim = $Row->TtElimination;
}
$xml .= '<elim>' . $Elim . '</elim>';
for ($i = 0; $i <= 2; $i++) {
$xml .= '<elim_id>' . $i . '</elim_id>' . '<elim_descr>' . get_text('Eliminations_' . $i) . '</elim_descr>';
}
$xml .= '<elim1>' . $_REQUEST['New_EvElim1'] . '</elim1>' . '<elim2>' . $_REQUEST['New_EvElim2'] . '</elim2>' . "\n";
for ($i = 0; $i <= 1; $i++) {
$xml .= '<matchmode_id>' . $i . '</matchmode_id>' . '<matchmode_descr>' . get_text('MatchMode_' . $i) . '</matchmode_descr>' . "\n";
}
// creo le griglie delle eliminatorie
for ($i = 1; $i <= 2; ++$i) {
if ($_REQUEST['New_EvElim' . $i] > 0) {
CreateElimRows($_REQUEST['New_EvCode'], $i);
}
}
// 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['New_EvCode']) . " ";
if ($_REQUEST['New_EvFinalFirstPhase'] != 0) {
$RsIns = safe_r_sql($Insert);
}
if (debug) {
print $Insert . '<br>';
}
if (!$RsIns) {
$Errore = 1;
}
}
} else {
