Beispiel #1
0
    $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');
Beispiel #2
0
         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);
Beispiel #3
0
     			. "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;
}
Beispiel #5
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;
Beispiel #6
0
        $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";