function SetElimArrowValue($Phase, $Event, $Target, $ArIndex, $ArSymbol, $Output = 'XML', $CompId = '')
{
require_once 'Common/Lib/Obj_RankFactory.php';
$JsonResult = array();
$JsonResult['error'] = 1;
$JsonResult['qutarget'] = $_REQUEST['qutarget'];
$JsonResult['distnum'] = $_REQUEST['distnum'];
$JsonResult['arrowindex'] = $_REQUEST['arrowindex'];
$JsonResult['arrowsymbol'] = '';
$JsonResult['curscore'] = '';
$JsonResult['curgold'] = '';
$JsonResult['curxnine'] = '';
$JsonResult['score'] = '';
$JsonResult['gold'] = '';
$JsonResult['xnine'] = '';
if (empty($CompId)) {
$CompId = $_SESSION['TourId'];
}
$q = safe_r_sql("select * from Eliminations\r\n\t\twhere ElElimPhase=" . ($Phase[1] - 1) . "\r\n\t\tand ElEventCode='{$Event}'\r\n\t\tand ElTargetNo='{$Target}'\r\n\t\tand ElTournament={$CompId}\r\n\t\t");
if ($r = safe_fetch($q)) {
$Arrowstring = str_pad($r->ElArrowString, $ArIndex + 1, ' ', STR_PAD_RIGHT);
$xx = GetLetterFromPrint($ArSymbol);
$Arrowstring[$ArIndex] = str_pad($xx, 1, ' ', STR_PAD_RIGHT);
list($CurScore, $CurGold, $CurXNine) = ValutaArrowStringGX($Arrowstring);
safe_w_sql("update Eliminations\r\n\t\t\tset ElArrowString='{$Arrowstring}',\r\n\t\t\tElScore={$CurScore},\r\n\t\t\tElGold={$CurGold},\r\n\t\t\tElXnine={$CurXNine}\r\n\t\t\twhere ElElimPhase=" . ($Phase[1] - 1) . "\r\n\t\t\tand ElEventCode='{$Event}'\r\n\t\t\tand ElTargetNo='{$Target}'\r\n\t\t\tand ElTournament={$CompId}");
if (safe_w_affected_rows()) {
if ($Phase[1] == 1) {
require_once 'Common/Fun_Sessions.inc.php';
ResetElimRows($Event, 2);
}
Obj_RankFactory::create('ElimInd', array('tournament' => $CompId, 'eventsC' => array($Event . '@' . $Phase[1])))->calculate();
}
$JsonResult['error'] = 0;
$JsonResult['arrowsymbol'] = $xx ? strtoupper($ArSymbol) : '';
$JsonResult['curscore'] = $CurScore;
$JsonResult['curgold'] = $CurGold;
$JsonResult['curxnine'] = $CurXNine;
$JsonResult['score'] = $CurScore;
$JsonResult['gold'] = $CurGold;
$JsonResult['xnine'] = $CurXNine;
}
return $JsonResult;
}
function SetAccreditation($Id, $SetRap = 0, $return = 'RicaricaOpener', $TourId = 0, $AccOp = 0)
{
$RicaricaOpener = false;
if (!$TourId) {
$TourId = $_SESSION['TourId'];
}
if (!$AccOp) {
$AccOp = $_SESSION['AccOp'];
}
/*
* Devo prevenire l'insert se l'id è in stato 7.
* Per farlo cerco lo stato del tizio.
* Se è 7 vuol dire che uno ha cliccato sul bottone dopo aver aperto il popup e io non scrivo in db
*/
$Select = "SELECT EnId FROM Entries\n\t\tWHERE EnId=" . StrSafe_DB($Id) . " AND EnTournament={$TourId} AND EnStatus='7' ";
$Rs = safe_r_sql($Select);
//TODO Patchare la query per supportare bene IpV6
if (safe_num_rows($Rs) == 0) {
$Insert = "INSERT INTO AccEntries\n\t\t\t(AEId,AEOperation,AETournament,AEWhen,AEFromIp,AERapp)\n\t\t\tVALUES(\n\t\t\t\t{$Id}," . StrSafe_DB($AccOp) . "," . StrSafe_DB($TourId) . "," . StrSafe_DB(date('Y-m-d H:i')) . "," . "INET_ATON('" . ($_SERVER['REMOTE_ADDR'] != '::1' ? $_SERVER['REMOTE_ADDR'] : '127.0.0.1') . "'), " . StrSafe_DB($SetRap) . "" . ") ON DUPLICATE KEY UPDATE " . "AEWhen=" . StrSafe_DB(date('Y-m-d H:i')) . "," . "AEFromIp=INET_ATON('" . ($_SERVER['REMOTE_ADDR'] != '::1' ? $_SERVER['REMOTE_ADDR'] : '127.0.0.1') . "') ";
$RsIns = safe_w_sql($Insert);
$RicaricaOpener = $return == 'RicaricaOpener' ? true : (safe_w_affected_rows() ? 'AccreditationOK' : 'AccreditationTwice');
}
return $RicaricaOpener;
}
/**
* Viene chiamata per fare i passaggi di fase delle finali
*
* @param array int $keys: vettore delle chiavi per il passaggio di fase
* @param array int $team: 0 individuali 1 squadre
* @param boolean &$error: true se il post processo genera un errore
*/
private function nextPhase($keys, $team, &$error)
{
/*
* Se non ci sono $keys buone non ho passaggi di fase e il post-processing fallisce
*/
if (count($keys) == 0) {
$error = true;
return;
}
foreach ($keys as $key => $value) {
$events = implode(',', array_keys($value));
$query = "";
if ($team == 0) {
$query = "SELECT GrPhase AS Phase,GrPosition AS Position,\t/* Grids*/ " . "FinMatchNo AS MatchNo,FinEvent AS Event, FinAthlete AS Id, FinScore AS Score,FinTie AS Tie, " . "IF(GrPhase>2, FLOOR(FinMatchNo/2),FLOOR(FinMatchNo/2)-2) AS NextMatchNo " . "FROM Finals INNER JOIN Grids ON FinMatchNo=GrMatchNo AND GrPhase=" . StrSafe_DB($key) . " " . "LEFT JOIN Entries ON FinAthlete=EnId AND FinEvent IN(" . $events . ') ' . "WHERE FinTournament=" . $this->getTourId() . " " . "ORDER BY FinEvent, NextMatchNo ASC, FinScore DESC, FinTie DESC ";
} else {
$query = "SELECT GrPhase AS Phase,GrPosition AS Position,\t/* Grids*/ " . "TfTeam AS Id,TfMatchNo AS MatchNo,TfEvent AS Event, TfScore AS Score,TfTie AS Tie, " . "IF(GrPhase>2, FLOOR(TfMatchNo/2),FLOOR(TfMatchNo/2)-2) AS NextMatchNo " . "FROM TeamFinals INNER JOIN Grids ON TfMatchNo=GrMatchNo AND GrPhase=" . StrSafe_DB($key) . " " . "WHERE TfTournament=" . $this->getTourId() . " AND TfEvent IN (" . $events . ") " . "ORDER BY TfEvent, NextMatchNo ASC, TfScore DESC, TfTie DESC ";
}
//print $query . '<br>';exit;
$rs = safe_r_SQL($query);
$myNextMatchNo = 'xx';
$row = array();
if (safe_num_rows($rs) > 0) {
while ($row0 = safe_fetch($rs)) {
$row1 = safe_fetch($rs);
$athProp = 0;
$myUpQuery = "";
if ($row0->Phase >= 2) {
if (($row0->Score > 0 || $row0->Tie > 0) && ($row0->Score != $row1->Score || $row0->Tie != $row1->Tie)) {
if ($team == 0) {
$myUpQuery = "UPDATE Finals SET ";
$myUpQuery .= "FinAthlete =" . StrSafe_DB($row0->Id) . ", ";
$myUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row0->Event) . " AND FinMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND FinTournament=" . $this->getTourId() . " ";
} else {
$myUpQuery = "UPDATE TeamFinals SET ";
$myUpQuery .= "TfTeam =" . StrSafe_DB($row0->Id) . ", ";
$myUpQuery .= "TfDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE TfEvent=" . StrSafe_DB($row0->Event) . " AND TfMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND TfTournament=" . $this->getTourId() . " ";
}
//print $myUpQuery . '<br><br>';
$rsUp = safe_w_sql($myUpQuery);
$athProp = $row0->Id;
} else {
if ($team == 0) {
$myUpQuery = "UPDATE Finals SET ";
$myUpQuery .= "FinAthlete ='0', ";
$myUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row0->Event) . " AND FinMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND FinTournament=" . $this->getTourId() . " ";
} else {
$myUpQuery = "UPDATE TeamFinals SET ";
$myUpQuery .= "TfTeam ='0', ";
$myUpQuery .= "TfDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE TfEvent=" . StrSafe_DB($row0->Event) . " AND TfMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND TfTournament=" . $this->getTourId() . " ";
}
$rsUp = safe_w_sql($myUpQuery);
}
}
if ($row1->Phase == 2) {
if (($row1->Score > 0 || $row1->Tie > 0) && ($row0->Score != $row1->Score || $row0->Tie != $row1->Tie)) {
if ($team == 0) {
$myUpQuery = "UPDATE Finals SET ";
$myUpQuery .= "FinAthlete =" . StrSafe_DB($row1->Id) . ", ";
$myUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row1->Event) . " AND FinMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND FinTournament=" . $this->getTourId() . " ";
} else {
$myUpQuery = "UPDATE TeamFinals SET ";
$myUpQuery .= "TfTeam =" . StrSafe_DB($row1->Id) . ", ";
$myUpQuery .= "TfDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE TfEvent=" . StrSafe_DB($row1->Event) . " AND TfMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND TfTournament=" . $this->getTourId() . " ";
}
$rsUp = safe_w_sql($myUpQuery);
$athProp = $Row1->FinAthlete;
} else {
if ($team == 0) {
$myUpQuery = "UPDATE Finals SET ";
$myUpQuery .= "FinAthlete =" . StrSafe_DB($row1->Id) . ", ";
// 0
$myUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row1->Event) . " AND FinMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND FinTournament=" . $this->getTourId() . " ";
} else {
$myUpQuery = "UPDATE TeamFinals SET ";
$myUpQuery .= "TfTeam =" . StrSafe_DB($row1->Id) . ", ";
// 0
$myUpQuery .= "TfDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$myUpQuery .= "WHERE TfEvent=" . StrSafe_DB($row1->Event) . " AND TfMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND TfTournament=" . $this->getTourId() . " ";
}
$rsUp = safe_w_sql($myUpQuery);
}
// Devo fare la propagazione del nome se il matchno>7 (fase>2)
$oldId = $athProp != 0 ? StrSafe_DB($row1->Id) : StrSafe_DB($row0->Id) . ',' . StrSafe_DB($row1->Id);
$update = "";
if ($team == 0) {
$update = "UPDATE Finals SET " . "FinAthlete=" . StrSafe_DB($athProp) . " " . "WHERE FinAthlete IN (" . $oldId . ") AND FinTournament=" . $this->getTourId() . " AND FinEvent=" . StrSafe_DB($row0->Event) . " AND FinMatchNo<" . StrSafe_DB($row0->NextMatchNo) . " AND (FinScore<>0 OR FinTie<>0) ";
} else {
$update = "UPDATE TeamFinals SET " . "TfTeam=" . StrSafe_DB($athProp) . " " . "WHERE TfTeam IN (" . $oldId . ") AND TfTournament=" . $this->getTourId() . " AND TfEvent=" . StrSafe_DB($row0->Event) . " AND TfMatchNo<" . StrSafe_DB($row0->NextMatchNo) . " AND (TfScore<>0 OR TfTie<>0) ";
}
//print $update . '<br><br>';
$rsProp = safe_w_sql($update);
if (safe_w_affected_rows() > 0) {
$error = false;
}
}
}
}
}
}
* purchè il flag di partecipazione alle finali ind sia a 1.
* Se una persona rispetta il filtro ma non partecipa alle finali ind, il bersaglio NON
* viene toccato
*/
$query = "UPDATE " . "Entries " . "INNER JOIN " . "Qualifications " . "ON EnId=QuId AND EnIndFEvent=1 " . "INNER JOIN " . "EventClass " . "ON EnDivision=EcDivision AND EnClass=EcClass AND EnTournament=EcTournament AND EcTeamEvent=0 " . "SET " . "Qualifications.QuTargetNo='', QuBacknoPrinted=0 ";
if ($delSession == 1) {
$query .= ",Qualifications.QuSession=0 ";
}
$query .= "WHERE " . "Entries.EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "AND EcCode LIKE " . StrSafe_DB($filter) . " ";
if ($session != 0) {
$query .= " AND Qualifications.QuSession=" . StrSafe_DB($session) . " ";
}
}
$rs = safe_w_SQL($query);
if ($rs) {
if (safe_w_affected_rows() > 0) {
$msg = get_text('TargetDeleted');
} else {
$msg = get_text('NoTargetFound');
}
} else {
$msg = get_text('Error');
}
} else {
$msg = get_text('Error');
}
} else {
$msg = get_text('Error');
}
}
$JS_SCRIPT = array(phpVars2js(array('StrAreYouSure' => get_text('MsgAreYouSure'))), '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Partecipants/Fun_DeleteTarget.js"></script>');
/**
* MakeIndividuals()
* Aggiunge o toglie le righe ad Individuals.
*
* @param string[] $affected: contiene gli eventi assoluti che hanno subito una modifica (aggiunte o cancellazioni)
* @param int $tournament: contiene il torneo su cui lavorare. se null prende dalla sessione
* @return bool: true in caso di errore, false altrimenti
*/
function MakeIndividuals(&$affected, $tournament = null)
{
if (is_null($tournament)) {
$tournament = $_SESSION['TourId'];
}
// get the QT nations
//Se esiste il quota tournament cancello i "non elegible"
$dbValues = array();
$QTNations = array();
$QTDates = array();
if (module_exists('QuotaTournament')) {
$tmp = getModuleParameter("QuotaTournament", "allowedIOC", '');
if (strlen($tmp) > 0) {
$dbValues = unserialize($tmp);
foreach ($dbValues as $k => $v) {
if (substr($k, 0, 3) == 'ev_') {
$evCode = explode("_", $k);
$evCode = $evCode[2];
$QTNations[$evCode] = $v;
}
}
}
}
//Mi prendo gli eventi a cui agigungerò qualcuno
$q = "\r\n\t\tSELECT DISTINCT\r\n\t\t\tEcCode, CoCode\r\n\t\tFROM\r\n\t\t\tEntries\r\n\t\tINNER JOIN\r\n\t\t\tEventClass ON EnTournament=EcTournament AND EcTeamEvent=0 AND EnDivision=EcDivision AND EnClass=EcClass\r\n\t\tINNER JOIN\r\n\t\t\tCountries ON CoId=EnCountry\r\n\t\tLEFT JOIN\r\n\t\t\tIndividuals ON IndId=EnId AND IndTournament=EnTournament AND IndEvent=EcCode\r\n\t\tWHERE EnTournament = {$tournament} AND IndEvent IS NULL AND EnIndFEvent=1 AND EnStatus<=1";
$r = safe_r_sql($q);
//print $q;exit;
if (safe_num_rows($r) > 0) {
while ($myRow = safe_fetch($r)) {
if (!in_array($myRow->EcCode, $affected, true) and !(!empty($QTNations[$myRow->EcCode]) and !in_array($myRow->CoCode, $QTNations[$myRow->EcCode]))) {
$affected[] = $myRow->EcCode;
}
}
//Siccome il nume_rows era >0, aggiungo chi mi manca
$q = "\r\n\t\t\tINSERT INTO\r\n\t\t\t\tIndividuals (IndId,IndEvent,IndTournament,IndTimestamp)\r\n\t\t\tSELECT\r\n\t\t\t\tEnId, EcCode, EnTournament, NOW()\r\n\t\t\tFROM\r\n\t\t\t\tEntries\r\n\t\t\tINNER JOIN\r\n\t\t\t\tEventClass ON EnTournament=EcTournament AND EcTeamEvent=0 AND EnDivision=EcDivision AND EnClass=EcClass\r\n\t\t\tLEFT JOIN\r\n\t\t\t\tIndividuals ON IndId=EnId AND IndTournament=EnTournament AND IndEvent=EcCode\r\n\t\t\tWHERE EnTournament = {$tournament} AND IndEvent IS NULL AND EnIndFEvent=1 AND EnStatus<=1";
$r = safe_w_sql($q);
}
//Mi prendo gli eventi da cancellare
$q = "\r\n\t\tSELECT DISTINCT\r\n\t\t\tIndEvent\r\n\t\tFROM\r\n\t\t\tIndividuals\r\n\t\tLEFT JOIN\r\n\t\t\t(SELECT\r\n\t\t\t\tEnId, EcCode\r\n\t\t\tFROM\r\n\t\t\t\tEntries\r\n\t\t\tINNER JOIN\r\n\t\t\t\tEventClass ON EnTournament = EcTournament AND EcTeamEvent =0 AND EnDivision = EcDivision AND EnClass = EcClass\r\n\t\t\tWHERE\r\n\t\t\t\tEnTournament = {$tournament} AND EnIndFEvent=1 AND EnStatus<=1\r\n\t\t\t) AS sq ON IndId = EnId AND IndEvent = EcCode\r\n\t\tWHERE\r\n\t\t\tIndTournament = {$tournament} AND EnId IS NULL";
$r = safe_r_sql($q);
if (safe_num_rows($r) > 0) {
while ($myRow = safe_fetch($r)) {
if (!in_array($myRow->IndEvent, $affected, true)) {
$affected[] = $myRow->IndEvent;
}
}
//Siccome il nume_rows era >0, tolgo chi cresce
$q = "\r\n\t\t\tDELETE Individuals FROM\r\n\t\t\t\tIndividuals\r\n\t\t\tLEFT JOIN\r\n\t\t\t\t(SELECT\r\n\t\t\t\t\tEnId, EcCode\r\n\t\t\t\tFROM\r\n\t\t\t\t\tEntries\r\n\t\t\t\tINNER JOIN\r\n\t\t\t\t\tEventClass ON EnTournament = EcTournament AND EcTeamEvent =0 AND EnDivision = EcDivision AND EnClass = EcClass\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tEnTournament = {$tournament} AND EnIndFEvent=1 AND EnStatus<=1\r\n\t\t\t\t) AS sq ON IndId = EnId AND IndEvent = EcCode\r\n\t\t\tWHERE\r\n\t\t\t\tIndTournament = {$tournament} AND EnId IS NULL";
$r = safe_w_sql($q);
}
//Se esiste il quota tournament cancello i "non elegible"
if (module_exists('QuotaTournament')) {
$dbValues = array();
$tmp = getModuleParameter("QuotaTournament", "allowedIOC", '');
if (strlen($tmp) > 0) {
$dbValues = unserialize($tmp);
foreach ($dbValues as $k => $v) {
if (substr($k, 0, 3) == 'ev_') {
$evCode = explode("_", $k);
$evCode = $evCode[2];
$q = "DELETE FROM Individuals\r\n\t\t\t\t\t\tUSING Individuals\r\n\t\t\t\t\t\tINNER JOIN Entries ON IndId = EnId AND IndTournament=EnTournament\r\n\t\t\t\t\t\tINNER JOIN Countries ON EnCountry=CoId AND EnTournament=CoTournament\r\n\t\t\t\t\t\tINNER JOIN EventClass ON EnTournament = EcTournament AND EcTeamEvent =0 AND\r\n\t\t\t\t\t\tEnDivision = EcDivision AND EnClass = EcClass AND IndEvent = EcCode\r\n\t\t\t\t\t\tWHERE EnTournament = {$tournament} AND EnIndFEvent=1 AND EnStatus<=1 AND EcCode='{$evCode}'\r\n\t\t\t\t\t\tAND CoCode NOT IN ('" . implode("', '", $v) . "')";
$r = safe_w_sql($q);
if (safe_w_affected_rows()) {
if (!in_array($k, $affected, true)) {
$affected[] = $k;
}
}
} else {
if (substr($k, 0, 4) == 'dob_') {
$evCode = explode("_", $k);
$dobType = $evCode[1];
$evCode = $evCode[2];
$q = "DELETE FROM Individuals\r\n\t\t\t\t\t\tUSING Individuals\r\n\t\t\t\t\t\tINNER JOIN Entries ON IndId = EnId AND IndTournament=EnTournament\r\n\t\t\t\t\t\tINNER JOIN Countries ON EnCountry=CoId AND EnTournament=CoTournament\r\n\t\t\t\t\t\tINNER JOIN EventClass ON EnTournament = EcTournament AND EcTeamEvent =0 AND\r\n\t\t\t\t\t\tEnDivision = EcDivision AND EnClass = EcClass AND IndEvent = EcCode\r\n\t\t\t\t\t\tWHERE EnTournament = {$tournament} AND EnIndFEvent=1 AND EnStatus<=1 AND EcCode='{$evCode}'\r\n\t\t\t\t\t\tAND EnDob " . ($dobType == 's' ? "<=" : ">=") . " '{$v}'";
$r = safe_w_sql($q);
if (safe_w_affected_rows()) {
if (!in_array($k, $affected, true)) {
$affected[] = $k;
}
}
}
}
}
}
}
return false;
}
/**
* setRow().
* Imposta le ElRank degli elementi passati.
*
* Questo è il metodo da chiamare quando si risolvono gli spareggi perchè chi non passa ha la rank a posto
* grazie a calculate() e gli altri (sia quelli a cavallo che i buoni di sicuro) vanno impostati a mano.
*
*
* @param mixed $items: array degli elementi da scrivere.
* La struttra è la seguente:
* array(
* array(
* ath => <id> (chiave)
* event => <ev> (chiave)
* phase => <phase> (chiave)
* rank => <rank>
* so => <so>
* )
* )
* con <id> l'id della persona <ev> l'evento, <phase> il girone eliminatorio (0 vuol dire primo girone, 1 il secondo),
* <rank> la rank da impostare (opzionale), e <so> un flag che vale 1 se ci sono spareggi (gialli o rossi, opzionale).
*
* Deve essere presente almeno un campo opzionale se no il metodo ritorna errore.
*
* NOTA BENE
* Qui phase ha i valori del db quindi 0->I girone, 1->II girone!!!!
*
* @return mixed: ritorna le affected_rows oppure false se c'è qualche errore
* (non salva gli eventuali elementi successivi a quello che ha generato l'errore)
*/
public function setRow($items = array())
{
// campi mandatory per $item
$params = array('ath', 'event', 'phase');
$affected = 0;
foreach ($items as $item) {
/*print '<pre>';
print_r($item);
print '</pre>';*/
$paramsOk = true;
$canUp = false;
/*
* controllo che ci siano i campi mandatory
*/
foreach ($params as $p) {
if (!array_key_exists($p, $item)) {
$paramsOk = false;
$ret = false;
break;
}
}
if (!$paramsOk) {
continue;
}
$date = date('Y-m-d H:i:s');
$q = "UPDATE " . "Eliminations " . "SET " . "ElDateTime='{$date}' ";
/* campi opzionali e basta */
if (array_key_exists('rank', $item)) {
$canUp = true;
$q .= ",ElRank={$item['rank']}";
}
if (array_key_exists('so', $item)) {
$canUp = true;
$q .= ",ElSO={$item['so']}";
}
if (array_key_exists('tiebreak', $item)) {
$canUp = true;
$q .= ",ElTiebreak='{$item['tiebreak']}' ";
}
$phase = $item['phase'];
$q .= " WHERE " . "ElId=" . $item['ath'] . " AND ElTournament=" . $this->tournament . " AND ElElimPhase={$phase} AND ElEventCode='{$item['event']}'";
//print $q.'<br><br>';
if (!$canUp) {
return false;
}
$r = safe_w_sql($q);
if (!$r) {
$affected = false;
} else {
$affected += safe_w_affected_rows();
}
}
return $affected;
}
// campo 2 da usare come chiave per l'update
foreach ($_REQUEST as $Key => $Value) {
$Field = '';
$Id = '';
$ClDivAllowed = '';
if (substr($Key, 0, 2) == 'd_') {
$tmp = explode('_', $Key);
$Field = $tmp[1];
$Id = $tmp[2];
if (!empty($tmp[3])) {
$ClDivAllowed = $tmp[3];
}
$Which = $Key;
$Update = "UPDATE " . $tt . " SET " . $Field . "=" . StrSafe_DB($Value) . " " . "WHERE " . $kk . "=" . StrSafe_DB($Id) . " AND " . $kk2 . "=" . StrSafe_DB($_SESSION['TourId']) . " " . ($kk3 ? " AND {$kk3} = " . StrSafe_DB($ClDivAllowed) : '');
$Rs = safe_w_sql($Update);
if (safe_w_affected_rows() and ($Field == 'ClAthlete' or $Field == 'DivAthlete')) {
// avvenuto un cambio di status di atleta!!!
if ($Value) {
if ($Field == 'ClAthlete') {
safe_w_sql("Update Entries left join Divisions on EnTournament=DivTournament and EnDivision=DivId set EnAthlete=DivAthlete+0 where EnTournament={$_SESSION['TourId']} and EnClass='{$Id}'");
} elseif ($Field == 'DivAthlete') {
safe_w_sql("Update Entries left join Classes on EnTournament=ClTournament and EnClass=ClId set EnAthlete=ClAthlete+0 where EnTournament={$_SESSION['TourId']} and EnDivision='{$Id}'");
}
} else {
if ($Field == 'ClAthlete') {
safe_w_sql("Update Entries set EnAthlete='' where EnTournament={$_SESSION['TourId']} and EnClass='{$Id}'");
} elseif ($Field == 'DivAthlete') {
safe_w_sql("Update Entries set EnAthlete='' where EnTournament={$_SESSION['TourId']} and EnDivision='{$Id}'");
}
}
}
function NextPhaseInd($t = null, $e = null, $p = null, $m = null)
{
$tour = !is_null($t) ? $t : $_SESSION['TourId'];
$eventFilter = !is_null($e) ? "AND FinEvent=" . StrSafe_DB($e) . " " : "";
$joinFilter = "";
if (!is_null($p)) {
$joinFilter = " AND GrPhase=" . StrSafe_DB($p) . " ";
}
if (!is_null($m)) {
$m1 = -1;
$m2 = -1;
if ($m % 2 == 0) {
$m1 = $m;
$m2 = $m + 1;
} else {
$m1 = $m - 1;
$m2 = $m;
}
$joinFilter = "AND (GrMatchNo=" . $m1 . " OR GrMatchNo=" . $m2 . ") ";
}
$query = "";
$query = "SELECT CONCAT(EnFirstName,' ',SUBSTRING(EnName,1,1),'.') AS Atleta," . "CoCode,CoName," . "GrPhase,\t/* Grids*/ " . "FinMatchNo AS MatchNo,FinEvent AS `Event`, FinAthlete AS Athlete, FinScore AS Score,FinTie AS Tie, " . "IF(GrPhase>2, FLOOR(FinMatchNo/2),FLOOR(FinMatchNo/2)-2) AS NextMatchNo " . "FROM Finals INNER JOIN Grids ON FinMatchNo=GrMatchNo " . $joinFilter . " " . "LEFT JOIN Entries ON FinAthlete=EnId " . "WHERE FinTournament=" . StrSafe_DB($tour) . " " . $eventFilter . " " . "ORDER BY FinEvent, NextMatchNo ASC, FinScore DESC, FinTie DESC ";
$propagato = 0;
$athProp = 0;
$rs = safe_r_sql($query);
if (safe_num_rows($rs) && safe_num_rows($rs) % 2 == 0) {
while ($row0 = safe_fetch($rs)) {
$row1 = safe_fetch($rs);
$athProp = 0;
if ($row0->GrPhase >= 2) {
if (($row0->Score > 0 || $row0->Tie > 0) && ($row0->Score != $row1->Score || $row0->Tie != $row1->Tie)) {
$MyUpQuery = "UPDATE Finals SET ";
$MyUpQuery .= "FinAthlete =" . StrSafe_DB($row0->Athlete) . ", ";
$MyUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$MyUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row0->Event) . " AND FinMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND FinTournament=" . StrSafe_DB($tour) . " ";
$RsUp = safe_w_sql($MyUpQuery);
//print '1 ' . $MyUpQuery . '<br>';
$athProp = $row0->Athlete;
} else {
$MyUpQuery = "UPDATE Finals SET ";
$MyUpQuery .= "FinAthlete ='0', ";
$MyUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$MyUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row0->Event) . " AND FinMatchNo=" . StrSafe_DB($row0->NextMatchNo) . " AND FinTournament=" . StrSafe_DB($tour) . " ";
$RsUp = safe_w_sql($MyUpQuery);
//print '2 ' . $MyUpQuery . '<br>';
}
}
if ($row1->GrPhase == 2) {
if (($row1->Score > 0 || $row1->Tie > 0) && ($row0->Score != $row1->Score || $row0->Tie != $row1->Tie)) {
//print $row0->score.' - ' .$row1->score . ' + '. $row0->tie.' - ' .$row1->tie .'<br>';
$MyUpQuery = "UPDATE Finals SET ";
$MyUpQuery .= "FinAthlete =" . StrSafe_DB($row1->Athlete) . ", ";
$MyUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$MyUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row1->Event) . " AND FinMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND FinTournament=" . StrSafe_DB($tour) . " ";
$RsUp = safe_w_sql($MyUpQuery);
//print '3 ' . $MyUpQuery . '<br>';
$athProp = $row1->Athlete;
} else {
$MyUpQuery = "UPDATE Finals SET ";
$MyUpQuery .= "FinAthlete =" . StrSafe_DB($row1->Athlete) . ", ";
// 0
$MyUpQuery .= "FinDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " ";
$MyUpQuery .= "WHERE FinEvent=" . StrSafe_DB($row1->Event) . " AND FinMatchNo=" . StrSafe_DB($row1->NextMatchNo + 2) . " AND FinTournament=" . StrSafe_DB($tour) . " ";
$RsUp = safe_w_sql($MyUpQuery);
}
//print '4 ' . $MyUpQuery . '<br>';
}
}
// propagazione
$propaga = true;
if (!is_null($e) && !is_null($m) && $m <= 7) {
$propaga = false;
}
if ($propaga) {
$oldId = $athProp != 0 ? StrSafe_DB($row1->Athlete) : StrSafe_DB($row0->Athlete) . ',' . StrSafe_DB($row1->Athlete);
$Update = "UPDATE Finals SET " . "FinAthlete=" . StrSafe_DB($athProp) . " " . "WHERE FinAthlete IN (" . $oldId . ") AND FinTournament=" . StrSafe_DB($tour) . " AND FinEvent=" . StrSafe_DB($e) . " AND FinMatchNo<" . StrSafe_DB($row0->NextMatchNo) . " AND (FinScore<>0 OR FinTie<>0) ";
$RsProp = safe_w_sql($Update);
if (safe_w_affected_rows() > 0) {
$propagato = 1;
}
}
}
if (!is_null($e) && !is_null($m)) {
return array($row0, $row1, $athProp, $propagato);
} else {
return false;
}
}
<?php
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(__FILE__)) . '/config.php';
if (!CheckTourSession()) {
print get_text('CrackError');
exit;
}
$Errore = 2;
if (!IsBlocked(BIT_BLOCK_TOURDATA) and $q = safe_r_sql("select * from TargetFaces where TfTournament={$_SESSION['TourId']}") and safe_num_rows($q) > 1) {
// targets can be deleted only if there are targets left!
$delete = "DELETE FROM TargetFaces " . "WHERE TfTournament={$_SESSION['TourId']} AND TfId=" . intval($_REQUEST['tfid']);
$rs = safe_w_sql($delete);
$Errore = safe_w_affected_rows() ? 0 : 2;
}
if (!debug) {
header('Content-Type: text/xml');
}
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<row>' . $_REQUEST['row'] . '</row>' . "\n";
print '</response>' . "\n";
/**
* setRow().
* Imposta le IndRank degli elementi passati.
*
* Questo è il metodo da chiamare quando si risolvono gli spareggi perchè chi non passa ha la rank a posto
* grazie a calculate() e gli altri (sia quelli a cavallo che i buoni di sicuro) vanno impostati a mano.
*
*
* @param mixed $items: array degli elementi da scrivere.
* La struttra è la seguente:
* array(
* array(
* ath => <id> (chiave)
* event => <ev> (chiave)
* dist => <dist> (chiave)
* rank => <rank>
* tiebreak => <arrowstring>
* so => <so>
* )
* )
* con <id> l'id della persona <ev> l'evento, <arrowstring> l'arrowstring delle frecce di tie (opzionale), <dist> la distanza (0 vuol dire IndRank),
* <rank> la rank da impostare (opzionale), e e <so> prima degli spareggi vale come la rank se non ci sono spareggi; 0 per chi non passa e negativo come la rank in caso di gialli (opzionale).
* L'arrowstring, e l'so comunque sono considerati solo se <dist>==0
*
* Deve essere presente almeno un campo opzionale se no il metodo ritorna errore.
*
*
* @return mixed: ritorna le affected_rows oppure false se c'è qualche errore
* (non salva gli eventuali elementi successivi a quello che ha generato l'errore)
*/
public function setRow($items = array())
{
// campi mandatory per $item
$params = array('ath', 'event', 'dist');
$affected = 0;
foreach ($items as $item) {
/*print '<pre>';
print_r($item);
print '</pre>';*/
$paramsOk = true;
$canUp = false;
/*
* controllo che ci siano i campi mandatory
*/
foreach ($params as $p) {
if (!array_key_exists($p, $item)) {
$paramsOk = false;
$ret = false;
break;
}
}
if (!$paramsOk) {
continue;
}
$dd = $item['dist'] ? 'D' . $item['dist'] : '';
$date = date('Y-m-d H:i:s');
$q = "UPDATE " . "Individuals " . "SET " . "IndTimestamp='{$date}' ";
/* campi opzionali e basta */
if (array_key_exists('rank', $item)) {
$canUp = true;
$q .= ",Ind{$dd}Rank={$item['rank']}";
}
/*
* campi opzionali (se dist==0).
* In ogni caso i valori vengono scritti se e solo se la rank nuova è diversa dalla vecchia!
*/
if ($item['dist'] == 0) {
if (array_key_exists('tiebreak', $item)) {
$canUp = true;
$q .= ",IndTiebreak='{$item['tiebreak']}'";
}
if (array_key_exists('so', $item)) {
$canUp = true;
$q .= ",IndSO={$item['so']}";
}
}
$q .= " WHERE " . "IndId=" . $item['ath'] . " AND IndEvent='" . $item['event'] . "' AND IndTournament=" . $this->tournament . " ";
//print $q.'<br><br>';
if (!$canUp) {
return false;
}
$r = safe_w_sql($q);
if (!$r) {
$affected = false;
} else {
$affected += safe_w_affected_rows();
}
if (empty($item['fist']) && array_key_exists('rank', $item) && array_key_exists('hits', $item) && $item['hits'] % 3 == 0) {
$q = "INSERT INTO IndOldPositions (IopId, IopEvent, IopTournament, IopHits, IopRank) " . "VALUES(" . $item['ath'] . ",'" . $item['event'] . "'," . $this->tournament . "," . $item['hits'] . "," . $item['rank'] . ") " . "ON DUPLICATE KEY UPDATE IopRank=" . $item['rank'];
safe_w_sql($q);
}
}
return $affected;
}
$Rs = safe_r_sql($Select);
if (safe_num_rows($Rs) == 1) {
$MyRow = safe_fetch($Rs);
$OldValue = $MyRow->OldScore;
} else {
$Errore = 1;
}
if ($Errore == 0) {
// Aggiorno i totali della distanza
$Update = "UPDATE Qualifications SET " . "QuD" . $_REQUEST['Dist'] . "ArrowString=" . StrSafe_DB($ArrowString) . "," . "QuD" . $_REQUEST['Dist'] . "Score=" . StrSafe_DB($CurScore) . ", " . "QuD" . $_REQUEST['Dist'] . "Gold=" . StrSafe_DB($CurGold) . ", " . "QuD" . $_REQUEST['Dist'] . "Xnine=" . StrSafe_DB($CurXNine) . ", " . "QuD" . $_REQUEST['Dist'] . "Hits=" . StrSafe_DB(strlen(rtrim($ArrowString))) . ", " . "QuScore=QuD1Score+QuD2Score+QuD3Score+QuD4Score+QuD5Score+QuD6Score+QuD7Score+QuD8Score," . "QuGold=QuD1Gold+QuD2Gold+QuD3Gold+QuD4Gold+QuD5Gold+QuD6Gold+QuD7Gold+QuD8Gold," . "QuXnine=QuD1Xnine+QuD2Xnine+QuD3Xnine+QuD4Xnine+QuD5Xnine+QuD6Xnine+QuD7Xnine+QuD8Xnine, " . "QuHits=QuD1Hits+QuD2Hits+QuD3Hits+QuD4Hits+QuD5Hits+QuD6Hits+QuD7Hits+QuD8Hits, " . "QuTimestamp=" . StrSafe_DB(date('Y-m-d H:i:s')) . " " . "WHERE QuId=" . StrSafe_DB($_REQUEST['Id']) . " ";
$RsUp = safe_w_sql($Update);
if (debug) {
print $Update . '<br>';
}
if ($PageOutput != 'JSON' or !$BlockApi) {
if (safe_w_affected_rows() == 1 && $OldValue != $CurScore) {
// Resetto il flag per gli spareggi
/*$Update
= "UPDATE Tournament SET "
. "ToMadeIndShootOff='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";
}
} else {
$Errore = 1;
}
if (debug) {
print 'Errore prima di aggiornare: ' . $Errore . '<br>';
}
if ($Errore == 0) {
// scrivo il dato e aggiorno i totali
$Update = "UPDATE Eliminations SET " . $Cosa . "=" . StrSafe_DB($Value) . ", " . "ElDateTime=" . StrSafe_DB(date('Y-m-d H:i:s')) . " " . "WHERE ElId=" . StrSafe_DB($Atleta) . " AND ElElimPhase=" . StrSafe_DB($Fase);
$RsUp = safe_w_sql($Update);
if (debug) {
print $Update . ' <br><br>';
}
//print '..' . safe_w_affected_rows() . '<br>';
if (safe_w_affected_rows() == 1 && $OldValue != $Value) {
/*
* QUI il reset della fase successiva delle elim (se c'è)
* e il calcolo della rank elim della fase attuale.
*
* Se fase è 0 sicuramente ho anche la 1 perchè in caso di solo un girone l'unica fase buona è la 1
*/
$q = "SELECT ElEventCode FROM Eliminations WHERE ElId={$Atleta} AND ElElimPhase={$Fase}";
$r = safe_r_sql($q);
$ev = '';
$row = safe_fetch($r);
$ev = $row->ElEventCode;
if ($ev != '') {
if ($Fase == 0) {
ResetElimRows($ev, 2);
}
function ArcherAssign($Archer, $Target, $Country)
{
if (!empty($_REQUEST['DoAssign'])) {
$UpdateQry = "UPDATE Qualifications SET QuTargetNo=" . StrSafe_DB($_REQUEST['Session'] . $Target) . " WHERE QuId = {$Archer}";
$RsUpd = safe_w_sql($UpdateQry);
if (safe_w_affected_rows()) {
safe_w_sql("UPDATE Qualifications SET QuBacknoPrinted=0 WHERE QuId = {$Archer}");
}
}
$q = safe_r_sql("select * from Entries where EnID={$Archer}");
$r = safe_fetch($q);
return get_text('TargetAssigned', 'Tournament', $Target) . ' - ' . $Country . " - {$r->EnDivision}{$r->EnClass} ({$r->EnName} {$r->EnFirstName})";
}
$rs = safe_r_sql($query);
if ($rs) {
if (safe_num_rows($rs) == 1) {
$myRow = safe_fetch($rs);
if ($num4session < $myRow->HowMany + 1) {
$tooMany = 1;
$msg = get_text('NoMoreAth4Session', 'Tournament');
}
}
}
}
if ($tooMany == 0) {
$query = "UPDATE " . "Qualifications " . "SET " . "QuSession=" . StrSafe_DB($session) . " " . "WHERE " . "QuId=" . StrSafe_DB($id) . " ";
$rs = safe_w_sql($query);
// se la riga è stata aggiornata significa che la session è cambiata quindi annullo il target
if (safe_w_affected_rows() == 1) {
$query = "UPDATE " . "Qualifications " . "SET " . "QuTargetNo='', QuBacknoPrinted=0 " . "WHERE " . "QuId=" . StrSafe_DB($id) . " ";
$rs = safe_w_sql($query);
$resetTarget = 1;
}
}
} else {
$error = 1;
}
} else {
$error = 1;
}
} else {
$error = 1;
}
/****** End Controller ******/
print get_text('CrackError');
exit;
}
$Errore = intval(IsBlocked(BIT_BLOCK_TOURDATA) && !defined('dontEditClassDiv'));
$MsgErrore = '';
if (!$Errore) {
if (!is_numeric($_REQUEST['New_ClAgeFrom']) || !is_numeric($_REQUEST['New_ClAgeTo']) || $_REQUEST['New_ClAgeFrom'] <= 0 || $_REQUEST['New_ClAgeTo'] <= 0 || $_REQUEST['New_ClAgeFrom'] > $_REQUEST['New_ClAgeTo']) {
$Errore = 1;
}
}
if (!$Errore) {
// Aggiungo la nuova riga
$Insert = "INSERT IGNORE INTO Classes (ClId,ClTournament,ClDescription,ClAthlete,ClViewOrder,ClAgeFrom,ClAgeTo,ClValidClass,ClDivisionsAllowed,ClSex) " . "VALUES(" . StrSafe_DB($_REQUEST['New_ClId']) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($_REQUEST['New_ClDescription']) . "," . StrSafe_DB(intval($_REQUEST['New_ClAthlete'])) . "," . StrSafe_DB($_REQUEST['New_ClViewOrder']) . ", " . StrSafe_DB($_REQUEST['New_ClAgeFrom']) . ", " . StrSafe_DB($_REQUEST['New_ClAgeTo']) . ", " . StrSafe_DB(CreateValidClass($_REQUEST['New_ClId'], $_REQUEST['New_ClValidClass'])) . ", " . StrSafe_DB($_REQUEST['New_ClValidDivision']) . ", " . StrSafe_DB($_REQUEST['New_ClSex']) . " " . ") ";
$RsIns = safe_w_sql($Insert);
//duplicate entries is OK
if (!safe_w_affected_rows()) {
$Errore = 2;
$MsgErrore = get_text('DuplicateEntry', 'Tournament');
}
}
header('Content-Type: text/xml');
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<errormsg><![CDATA[' . $MsgErrore . ']]></errormsg>' . "\n";
print '<new_clid><![CDATA[' . $_REQUEST['New_ClId'] . ']]></new_clid>' . "\n";
print '<new_cldescr><![CDATA[' . ManageHTML($_REQUEST['New_ClDescription']) . ']]></new_cldescr>' . "\n";
print '<new_clathleteyes><![CDATA[' . ManageHTML(get_text('Yes')) . ']]></new_clathleteyes>' . "\n";
print '<new_clathleteno><![CDATA[' . ManageHTML(get_text('No')) . ']]></new_clathleteno>' . "\n";
print '<new_clathlete><![CDATA[' . $_REQUEST['New_ClAthlete'] . ']]></new_clathlete>' . "\n";
print '<new_clprogr>' . $_REQUEST['New_ClViewOrder'] . '</new_clprogr>' . "\n";
print '<new_clagefrom>' . $_REQUEST['New_ClAgeFrom'] . '</new_clagefrom>' . "\n";
/**
* setRow().
* Imposta le IndRank degli elementi passati.
*
* Questo è il metodo da chiamare quando si risolvono gli spareggi perchè chi non passa ha la rank a posto
* grazie a calculate() e gli altri (sia quelli a cavallo che i buoni di sicuro) vanno impostati a mano.
*
*
* @param mixed $items: array degli elementi da scrivere.
* La struttra è la seguente:
* array(
* array(
* team => <id> (chiave)
* subteam => <subteam> (chiave)
* event => <ev> (chiave)
* rank => <rank>
* tiebreak => <arrowstring>
* so => <so>
* )
* )
* con <id> l'id della squadra,<subteam> il subteam, <ev> l'evento, <arrowstring> l'arrowstring delle frecce di tie (opzionale),
* <rank> la rank da impostare (opzionale), e <so> prima degli spareggi vale come la rank se non ci sono spareggi; 0 per chi non passa e negativo come la rank in caso di gialli (opzionale).
* L'arrowstring, e l'so comunque sono considerati solo se <dist>==0
*
* Deve essere presente almeno un campo opzionale se no il metodo ritorna errore.
*
*
* @return mixed: ritorna le affected_rows oppure false se c'è qualche errore
* (non salva gli eventuali elementi successivi a quello che ha generato l'errore)
*/
public function setRow($items = array())
{
// campi mandatory per $item
$params = array('team', 'subteam', 'event');
$affected = 0;
foreach ($items as $item) {
/*print '<pre>';
print_r($item);
print '</pre>';*/
$paramsOk = true;
$canUp = false;
/*
* controllo che ci siano i campi mandatory
*/
foreach ($params as $p) {
if (!array_key_exists($p, $item)) {
$paramsOk = false;
$ret = false;
break;
}
}
if (!$paramsOk) {
continue;
}
$date = date('Y-m-d H:i:s');
$q = "UPDATE " . "Teams " . "SET " . "TeTimeStamp='{$date}' ";
/* campi opzionali e basta */
if (array_key_exists('rank', $item)) {
$canUp = true;
$q .= ",TeRank={$item['rank']}";
}
if (array_key_exists('tiebreak', $item)) {
$canUp = true;
$q .= ",TeTiebreak='{$item['tiebreak']}'";
}
if (array_key_exists('so', $item)) {
$canUp = true;
$q .= ",TeSO={$item['so']}";
}
$q .= " WHERE " . "TeCoId=" . $item['team'] . " AND TeSubTeam=" . $item['subteam'] . " AND TeFinEvent=1 AND TeEvent='" . $item['event'] . "' AND TeTournament=" . $this->tournament . " ";
//print $q.'<br><br>';
if (!$canUp) {
return false;
}
$r = safe_w_sql($q);
if (!$r) {
$affected = false;
} else {
$affected += safe_w_affected_rows();
}
if (!$canUp) {
return false;
}
$r = safe_w_sql($q);
if (!$r) {
$affected = false;
} else {
$affected += safe_w_affected_rows();
}
}
return $affected;
}
function MatchTotal($MatchNo, $EvCode, $TeamEvent = 0)
{
if (is_null($MatchNo) || is_null($EvCode)) {
//Devono esistere sia il MatchNo che l'evento
return;
}
$MatchFinished = false;
// serve per vedere se il match è finito
$TablePrefix = "Fin";
$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, IFNULL(f.FinArrowString,'') as ArString, IFNULL(f.FinTieBreak,'') as TbString, " . "f2.FinScore AS OppScore, f2.FinSetScore AS OppSetScore, f2.FinTie as OppTie, IFNULL(f2.FinArrowString,'') as OppArString, IFNULL(f2.FinTieBreak,'') as OppTbString, " . "GrPhase " . "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($MatchNo % 2 == 0 ? $MatchNo : $MatchNo - 1) . " AND f.FinEvent=" . StrSafe_DB($EvCode) . " " . "ORDER BY f.FinEvent, f.FinMatchNo ";
if ($TeamEvent) {
$TablePrefix = "Tf";
$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, IFNULL(f.TfArrowString,'') as ArString, IFNULL(f.TfTieBreak,'') as TbString, " . "f2.TfScore AS OppScore, f2.TfSetScore AS OppSetScore, f2.TfTie as OppTie, IFNULL(f2.TfArrowString,'') as OppArString, IFNULL(f2.TfTieBreak,'') as OppTbString, " . "GrPhase " . "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($MatchNo % 2 == 0 ? $MatchNo : $MatchNo - 1) . " AND f.TfEvent=" . StrSafe_DB($EvCode) . " " . "ORDER BY f.TfEvent, f.TfMatchNo ";
}
//print $Select . "<br>";exit;
$MatchUpdated = false;
// serve per aggiornare il timestamp
$Rs = safe_r_sql($Select);
if (safe_num_rows($Rs) == 1) {
$MyRow = safe_fetch($Rs);
$obj = getEventArrowsParams($MyRow->EvCode, $MyRow->GrPhase, $TeamEvent);
$TotArrows = $obj->ends * $obj->arrows;
$Winner = -1;
// set winner... of Ties
if ($MyRow->Tie) {
$Winner = $MyRow->MatchNo;
$MatchFinished = true;
} elseif ($MyRow->OppTie) {
$Winner = $MyRow->OppMatchNo;
$MatchFinished = true;
}
$Score = ValutaArrowString(substr($MyRow->ArString, 0, $TotArrows));
$OppScore = ValutaArrowString(substr($MyRow->OppArString, 0, $TotArrows));
if ($MyRow->EvMatchMode == 0) {
//Sistema Cumulativo
if (strlen(str_replace(' ', '', $MyRow->ArString)) == $TotArrows and strlen(str_replace(' ', '', $MyRow->OppArString)) == $TotArrows and strlen(str_replace(' ', '', $MyRow->TbString)) == strlen(str_replace(' ', '', $MyRow->OppTbString))) {
$MatchFinished = true;
// if match is over establish the winner
// only if not already decided by the tie
// and if there are no doubts
// and no SO are going on
if ($Winner == -1 and $MyRow->ArString == strtoupper($MyRow->ArString) and $MyRow->OppArString == strtoupper($MyRow->OppArString) and strlen(trim($MyRow->TbString)) == strlen(trim($MyRow->OppTbString))) {
if ($Score > $OppScore) {
$Winner = $MyRow->MatchNo;
} elseif ($Score < $OppScore) {
$Winner = $MyRow->OppMatchNo;
}
}
}
$query = "UPDATE " . ($TeamEvent == 0 ? "Finals" : "TeamFinals") . " " . "SET " . "{$TablePrefix}WinLose=" . ($Winner == $MyRow->MatchNo ? '1' : '0') . ", " . "{$TablePrefix}Score=" . $Score . ", " . "{$TablePrefix}SetScore=0, " . "{$TablePrefix}SetPoints='', " . "{$TablePrefix}DateTime={$TablePrefix}DateTime " . "WHERE " . " {$TablePrefix}Event=" . StrSafe_DB($MyRow->EvCode) . " " . " AND {$TablePrefix}MatchNo=" . StrSafe_DB($MyRow->MatchNo) . " " . " AND {$TablePrefix}Tournament=" . StrSafe_DB($_SESSION['TourId']);
safe_w_sql($query);
$MatchUpdated = ($MatchUpdated or safe_w_affected_rows());
//print $query.'<br><br>';
$query = "UPDATE " . ($TeamEvent == 0 ? "Finals" : "TeamFinals") . " " . "SET " . "{$TablePrefix}WinLose=" . ($Winner == $MyRow->OppMatchNo ? '1' : '0') . ", " . "{$TablePrefix}Score=" . $OppScore . ", " . "{$TablePrefix}SetScore=0, " . "{$TablePrefix}SetPoints='', " . "{$TablePrefix}DateTime={$TablePrefix}DateTime " . "WHERE " . " {$TablePrefix}Event=" . StrSafe_DB($MyRow->EvCode) . " " . " AND {$TablePrefix}MatchNo=" . StrSafe_DB($MyRow->OppMatchNo) . " " . " AND {$TablePrefix}Tournament=" . StrSafe_DB($_SESSION['TourId']);
safe_w_sql($query);
$MatchUpdated = ($MatchUpdated or safe_w_affected_rows());
//print $query.'<br><br>';
} else {
//Sistema a Set
$SetPointsAth = array();
$SetPointsOpp = array();
$SetAth = 0;
$SetOpp = 0;
$SetAthWin = 0;
$SetOppWin = 0;
$WinnerId = -1;
for ($i = 0; $i < $TotArrows; $i = $i + $obj->arrows) {
//Cicla per tutte le volee dell'incontro
$AthEndString = substr($MyRow->ArString, $i, $obj->arrows);
$OppEndString = substr($MyRow->OppArString, $i, $obj->arrows);
$MatchString = $AthEndString . $OppEndString;
$AthSetPoints = ValutaArrowString($AthEndString);
$OppSetPoints = ValutaArrowString($OppEndString);
$SetPointsAth[] = $AthSetPoints;
$SetPointsOpp[] = $OppSetPoints;
if (strpos($MatchString, ' ') === false and ctype_upper($MatchString)) {
if ($AthSetPoints > $OppSetPoints) {
$SetAth += 2;
$SetAthWin++;
} elseif ($AthSetPoints < $OppSetPoints) {
$SetOpp += 2;
$SetOppWin++;
} else {
$SetAth++;
$SetOpp++;
}
}
}
if ($SetAth == $SetOpp && !empty($MyRow->TbString) && !empty($MyRow->OppTbString) && strlen(trim($MyRow->TbString)) == strlen(trim($MyRow->OppTbString))) {
//Verifico le stringhe CASE INSENSITIVE - in questo momento me ne frego degli "*"
$AthTbValue = ValutaArrowString($MyRow->TbString);
$OppTbValue = ValutaArrowString($MyRow->OppTbString);
if ($AthTbValue < $OppTbValue) {
$Winner = $MyRow->OppMatchNo;
//OppTbString è maggiore di TbString --> il secondo vince
$WinnerId = $MyRow->OppMatchNo;
//OppTbString è maggiore di TbString --> il secondo vince
$SetOpp++;
} elseif ($AthTbValue > $OppTbValue) {
$Winner = $MyRow->MatchNo;
//TbString è maggiore di OppTbString --> il primo vince
$WinnerId = $MyRow->MatchNo;
//TbString è maggiore di OppTbString --> il primo vince
$SetAth++;
} elseif ($AthTbValue > 0 and $OppTbValue > 0) {
//le stringhe CASE INSENSITIVE sono uguali
if (!ctype_upper(trim($MyRow->OppTbString)) and ctype_upper(trim($MyRow->TbString))) {
// Verifico gli "*" e lo star è nella stringa del secondo (è maggiore)
$Winner = $MyRow->OppMatchNo;
$WinnerId = $MyRow->OppMatchNo;
$SetOpp++;
} elseif (ctype_upper(trim($MyRow->OppTbString)) and !ctype_upper(trim($MyRow->TbString))) {
// Verifico gli "*" e lo star è nella stringa del primo (è maggiore)
$Winner = $MyRow->MatchNo;
$WinnerId = $MyRow->MatchNo;
$SetAth++;
}
}
} elseif ($SetAth >= $obj->winAt) {
$Winner = $MyRow->MatchNo;
} elseif ($SetOpp >= $obj->winAt) {
$Winner = $MyRow->OppMatchNo;
}
$query = "UPDATE " . ($TeamEvent == 0 ? "Finals" : "TeamFinals") . " " . "SET " . "{$TablePrefix}WinLose=" . ($Winner == $MyRow->MatchNo ? '1' : '0') . ", " . "{$TablePrefix}Score=" . $Score . ", " . "{$TablePrefix}SetScore=" . $SetAth . ", " . "{$TablePrefix}SetPoints=" . StrSafe_DB(implode($SetPointsAth, '|')) . ", " . "{$TablePrefix}WinnerSet=" . $SetAthWin . ", " . "{$TablePrefix}Tie=" . ($WinnerId == $MyRow->MatchNo ? '1' : '0') . ", " . "{$TablePrefix}DateTime={$TablePrefix}DateTime " . "WHERE " . "{$TablePrefix}Event=" . StrSafe_DB($MyRow->EvCode) . " " . "AND {$TablePrefix}MatchNo=" . StrSafe_DB($MyRow->MatchNo) . " " . "AND {$TablePrefix}Tournament=" . StrSafe_DB($_SESSION['TourId']);
// debug_svela($Winner==$MyRow->MatchNo, true);
safe_w_sql($query);
$MatchUpdated = ($MatchUpdated or safe_w_affected_rows());
$query = "UPDATE " . ($TeamEvent == 0 ? "Finals" : "TeamFinals") . " " . "SET " . "{$TablePrefix}WinLose=" . ($Winner == $MyRow->OppMatchNo ? '1' : '0') . ", " . "{$TablePrefix}Score=" . $OppScore . ", " . "{$TablePrefix}SetScore=" . $SetOpp . ", " . "{$TablePrefix}SetPoints=" . StrSafe_DB(implode($SetPointsOpp, '|')) . ", " . "{$TablePrefix}WinnerSet=" . $SetOppWin . ", " . "{$TablePrefix}Tie=" . ($WinnerId == $MyRow->OppMatchNo ? '1' : '0') . ", " . "{$TablePrefix}DateTime={$TablePrefix}DateTime " . "WHERE " . "{$TablePrefix}Event=" . StrSafe_DB($MyRow->EvCode) . " " . "AND {$TablePrefix}MatchNo=" . StrSafe_DB($MyRow->OppMatchNo) . " " . "AND {$TablePrefix}Tournament=" . StrSafe_DB($_SESSION['TourId']);
safe_w_sql($query);
$MatchUpdated = ($MatchUpdated or safe_w_affected_rows());
if ($SetAth >= $obj->winAt || $SetOpp >= $obj->winAt) {
$MatchFinished = true;
}
}
if ($MatchUpdated) {
$query = "UPDATE " . ($TeamEvent == 0 ? "Finals" : "TeamFinals") . " " . "SET " . "{$TablePrefix}DateTime=now() " . "WHERE " . " {$TablePrefix}Event=" . StrSafe_DB($MyRow->EvCode) . " " . "AND {$TablePrefix}MatchNo in (" . StrSafe_DB($MyRow->MatchNo) . ',' . StrSafe_DB($MyRow->OppMatchNo) . ") " . "AND {$TablePrefix}Tournament=" . StrSafe_DB($_SESSION['TourId']);
safe_w_sql($query);
}
//Serve per ricalcolare le ranking, solo medaglie
if ($MatchNo < 4 and $MatchFinished) {
if ($TeamEvent) {
move2NextPhaseTeam(NULL, $EvCode, $MatchNo);
} else {
move2NextPhase(NULL, $EvCode, $MatchNo);
}
}
}
return $MatchFinished;
}
