Пример #1
0
function SetTargetDb($Key, $Value)
{
    $ret = '';
    $Errore = 0;
    $Target = '';
    $Phase = '';
    $firstPhase = '';
    $realPhase = '';
    $Event = '';
    $Which = $Key;
    $Campo = '';
    $ee = '';
    $mm = '';
    // matchno estratto
    $ath = '';
    // ath per bersaglio (0 --> 1; 1 --> 2)
    list(, $Campo, $ee, $mm, $ath) = explode('_', $Key);
    $Event = $ee;
    // cerco la fase del matchno
    $Select = "SELECT GrPhase FROM Grids WHERE GrMatchNo=" . StrSafe_DB($mm) . " ";
    $Rs = safe_r_sql($Select);
    if (safe_num_rows($Rs) == 1) {
        $MyRow = safe_fetch($Rs);
        $Phase = $MyRow->GrPhase;
        $realPhase = $Phase;
        $firstPhase = getFirstPhase($Event, 0);
        if (valueFirstPhase($firstPhase) != $firstPhase && $Phase > 16) {
            $realPhase = $Phase == 32 ? 24 : ($Phase == 64 ? 48 : $Phase);
        }
    }
    // if target is followed by a "+" sign fills up the phase from this point up to the last with increments of 1
    if (substr($Value, -1) == '+') {
        $Value = intval($Value);
        $val = $Value;
        foreach (range($mm, $Phase * 4 - 1, $ath + 1) as $n) {
            $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $n . '_' . $ath, $val++);
        }
        return $ret;
    } elseif (substr($Value, -1) == '*') {
        $Value = intval($Value);
        $mm = 2 * floor($mm / 2);
        $val = $Value;
        $z = 1;
        foreach (range($mm, $Phase * 4 - 1, $ath + 1) as $n) {
            $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $n . '_' . $ath, $val++);
            $z = 1 - $z;
            if ($z) {
                $val++;
            }
        }
        return $ret;
    } elseif (substr($Value, -1) == '-') {
        // recupera gli scontri senza bye...
        // lo scontro parte da un numero pari
        $mm = 2 * floor($mm / 2);
        $Value = intval($Value);
        $val = $Value;
        // cerca i byes, quindi va a prendere la differenza tra il numero di atleti della fase e gli atleti presenti in quell'evento
        $MyQuery = "SELECT COUNT(EnId) as Quanti, EvFinalFirstPhase as FirstPhase\r\n\t\t\tFROM Events\r\n\t\t\tINNER JOIN EventClass ON EvCode=EcCode AND EvTeamEvent=EcTeamEvent AND EvTournament=EcTournament\r\n\t\t\tINNER JOIN Individuals ON EvCode=IndEvent AND EvTournament=IndTournament\r\n\t\t\tINNER JOIN Entries ON EnId=IndId AND EnTournament=IndTournament AND EcClass=EnClass AND EcDivision=EnDivision\r\n\t\t\tWHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EcCode=" . StrSafe_DB($ee) . " AND EvTeamEvent=0 AND ((EnIndFEvent=1 AND EnStatus<=1) OR EnId IS NULL)";
        $q = safe_r_sql($MyQuery);
        $r = safe_fetch($q);
        //debug_svela($MyQuery, true);
        $tmpQuanti = $r->Quanti;
        $tmpSaved = $Phase <= 16 ? 0 : (valueFirstPhase($r->FirstPhase) == $r->FirstPhase ? 0 : 8);
        $tmpQuantiIn = maxPhaseRank($realPhase);
        $tmpQuantiOut = $tmpQuanti - $tmpQuantiIn;
        $tmpBye = ($tmpQuantiOut < 0 ? abs($tmpQuantiOut) : 0) + $tmpSaved;
        //echo $Phase . ",". $tmpQuanti . "," . $tmpSaved . "," . $tmpQuantiIn . "," . $tmpQuantiOut . "," . $tmpBye; exit;
        //		if($tmpBye<=0 && $tmpSaved<=0) {
        // NON ci sono byes, quindi fa il responso normale...
        //debug_svela(array($Key, $Value));
        //			return SetTargetDb($Key, $Value.'+');
        //		}
        // ci sono byes, quindi va a riempire solo i matchno dei match pieni cioè con una rank superiore all'ultimo bye!
        // esempio: 1/8, 13 presenti, sono 3 byes, quindi si parte dal 4° in ranking...
        //
        $MyQuery = 'SELECT distinct ' . ' GrMatchNo, ' . ($firstPhase == 48 || $firstPhase == 24 ? 'GrPosition2' : 'GrPosition') . '  as Position' . ' FROM Grids' . ' WHERE ' . " GrPhase = '{$Phase}' " . " AND GrMatchNo>= {$mm} " . ' ORDER BY GrMatchNo ASC';
        $q = safe_r_sql($MyQuery);
        while ($r = safe_fetch($q)) {
            $butt = $r->Position <= $tmpBye || $r->Position > $tmpQuanti ? '' : $val;
            if (!$ath or !($r->GrMatchNo % 2)) {
                if ($r->Position > $tmpBye) {
                    $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $r->GrMatchNo . '_' . $ath, $butt);
                    if ($butt) {
                        $val++;
                    }
                } else {
                    $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $r->GrMatchNo . '_' . $ath, '');
                    $ret .= '<field>';
                    $ret .= '<error>0</error>' . "\n";
                    $ret .= '<org>d_' . $Campo . '_' . $ee . '_' . $r->GrMatchNo . '_' . $ath . ' - </org>' . "\n";
                    $ret .= '<which><![CDATA[d_' . $Campo . '_' . $ee . '_' . $r->GrMatchNo . '_' . $ath . ']]></which>' . "\n";
                    $ret .= '<target><![CDATA[]]></target>' . "\n";
                    $ret .= '<phase><![CDATA[' . $Phase . ']]></phase>' . "\n";
                    $ret .= '<event><![CDATA[' . $Event . ']]></event>' . "\n";
                    $ret .= '</field>';
                }
            }
        }
        return $ret;
    }
    // verifico che il target sia un numero vero
    if (preg_match('/^[0-9]{1,' . TargetNoPadding . '}$/i', $Value) || strlen(trim($Value)) == 0) {
        if (strlen(trim($Value)) > 0) {
            $Target = str_pad($Value, TargetNoPadding, '0', STR_PAD_LEFT);
        }
        // scrivo il target
        $Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament,FSTarget, FSLetter) " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('0') . "," . StrSafe_DB($mm) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($Target) . "," . StrSafe_DB($Target ? $Target : '') . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=" . StrSafe_DB($Target) . "," . "FSGroup=FSGroup," . "FSLetter=" . StrSafe_DB($Target ? $Target : '') . ", " . "FSScheduledTime=FSScheduledTime ";
        $Rs = safe_w_sql($Insert);
        if (debug) {
            print $Insert . '<br>';
        }
        if (!$Rs) {
            $Errore = 1;
        } else {
            if ($ath == 1) {
                $Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament,FSTarget, FSLetter) " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('0') . "," . StrSafe_DB($mm + 1) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($Target) . "," . StrSafe_DB($Target ? $Target . 'B' : '') . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=" . StrSafe_DB($Target) . "," . "FSGroup=FSGroup," . "FSLetter=" . StrSafe_DB($Target ? $Target . 'B' : '') . ", " . "FSScheduledTime=FSScheduledTime ";
                $Rs = safe_w_sql($Insert);
                if (!$Rs) {
                    $Errore = 1;
                }
                $Update = "update FinSchedule " . " SET " . " FSLetter=" . StrSafe_DB($Target ? $Target . 'A' : '') . " " . "WHERE" . " FSEvent= " . StrSafe_DB($ee) . " AND FSTeamEvent= " . StrSafe_DB('0') . " AND FSMatchNo= " . StrSafe_DB($mm) . " AND FSTournament= " . StrSafe_DB($_SESSION['TourId']);
                $Rs = safe_w_sql($Update);
                if (!$Rs) {
                    $Errore = 1;
                }
            }
        }
    } else {
        $Errore = 1;
    }
    $ret .= '<field>';
    $ret .= '<error>' . $Errore . '</error>' . "\n";
    $ret .= '<org>' . $Key . ' - ' . $Value . '</org>' . "\n";
    $ret .= '<which><![CDATA[' . $Which . ']]></which>' . "\n";
    $ret .= '<target><![CDATA[' . $Target . ']]></target>' . "\n";
    $ret .= '<phase><![CDATA[' . $Phase . ']]></phase>' . "\n";
    $ret .= '<event><![CDATA[' . $Event . ']]></event>' . "\n";
    $ret .= '</field>';
    return $ret;
}
Пример #2
0
function SetTargetDb($Key, $Value)
{
    $ret = '';
    $Errore = 0;
    $Target = '';
    $Which = $Key;
    $Campo = '';
    $ee = '';
    $mm = '';
    $ath = '';
    // ath per bersaglio (0 --> 1; 1 --> 2)
    list(, $Campo, $ee, $mm, $ath) = explode('_', $Key);
    // cerco la fase del matchno
    $Select = "SELECT GrPhase FROM Grids WHERE GrMatchNo=" . StrSafe_DB($mm) . " ";
    $Rs = safe_r_sql($Select);
    if (safe_num_rows($Rs) == 1) {
        $MyRow = safe_fetch($Rs);
        $Phase = $MyRow->GrPhase;
    }
    $Event = $ee;
    // if target is followed by a "+" sign fills up the phase from this point up to the last with increments of 1
    if (substr($Value, -1) == '+') {
        $Value = intval($Value);
        $val = $Value;
        foreach (range($mm, $Phase * 4 - 1, $ath + 1) as $n) {
            $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $n . '_' . $ath, $val++);
        }
        return $ret;
    } elseif (substr($Value, -1) == '*') {
        $Value = intval($Value);
        $mm = 2 * floor($mm / 2);
        $val = $Value;
        $z = 1;
        foreach (range($mm, $Phase * 4 - 1, $ath + 1) as $n) {
            $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $n . '_' . $ath, $val++);
            $z = 1 - $z;
            if ($z) {
                $val++;
            }
        }
        return $ret;
    } elseif (substr($Value, -1) == '-') {
        // recupera gli scontri senza bye...
        $Value = intval($Value);
        // recupera se la squadra è mixed oppure no
        //		$q=safe_r_sql("select * from Events where EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=1 "
        //			. " and EvCode='$ee' ");
        //		$r=safe_fetch($q);
        //
        //		if($r->EvMixedTeam) {
        //			// TODO:
        //		} else {
        $Sql = "SELECT DISTINCT EcCode, EcTeamEvent, EcNumber FROM EventClass WHERE EcCode='{$ee}' AND EcTeamEvent!=0 AND EcTournament=" . StrSafe_DB($_SESSION['TourId']);
        $RsEc = safe_r_sql($Sql);
        $RuleCnt = 0;
        $Sql = "Select * ";
        while ($MyRowEc = safe_fetch($RsEc)) {
            $Sql .= ++$RuleCnt == 1 ? "FROM " : "INNER JOIN ";
            $Sql .= "(SELECT EnCountry as C" . $RuleCnt . "\n\t\t\t\t\t  FROM Entries\n\t\t\t\t\t  INNER JOIN EventClass ON EnClass=EcClass AND EnDivision=EcDivision AND EnTournament=EcTournament AND EcTeamEvent=" . $MyRowEc->EcTeamEvent . " AND EcCode='{$ee}'\n\t\t\t\t\t  WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EnTeamFEvent=1\n\t\t\t\t\t  group by EnCountry\n\t\t\t\t\t  HAVING COUNT(EnId)>=" . $MyRowEc->EcNumber . ") as sqy";
            $Sql .= $RuleCnt == 1 ? " " : $RuleCnt . " ON C1=C" . $RuleCnt . " ";
        }
        $Rs = safe_r_sql($Sql);
        $Quanti = $Phase * 2 - safe_num_rows($Rs);
        //		}
        if (!$Quanti) {
            // no byes, so normal check
            return SetTargetDb($Key, $Value . '+');
        }
        // we have byes, so we go on with the
        $val = $Value;
        $mm = 2 * floor($mm / 2);
        $MyQuery = 'SELECT ' . ' GrMatchNo, GrPosition ' . ' FROM Grids' . ' WHERE ' . " GrPhase = '{$Phase}' " . " AND GrMatchNo>= {$mm} " . " AND GrPosition <= " . ($Phase * 2 - $Quanti) . ' ORDER BY GrMatchNo ASC' . ' LIMIT ' . ($Phase * 2 - $Quanti);
        $q = safe_r_sql($MyQuery);
        while ($r = safe_fetch($q)) {
            $butt = $r->GrPosition > $Quanti ? $val : '';
            if (!$ath or !($r->GrMatchNo % 2)) {
                $ret .= SetTargetDb('d_' . $Campo . '_' . $ee . '_' . $r->GrMatchNo . '_' . $ath, $butt);
                if ($butt) {
                    $val++;
                }
            }
        }
        return $ret;
    }
    // verifico che il target sia un numero vero
    if (preg_match('/^[0-9]{1,' . TargetNoPadding . '}$/i', $Value) || strlen(trim($Value)) == 0) {
        if (strlen(trim($Value)) > 0) {
            $Target = str_pad($Value, TargetNoPadding, '0', STR_PAD_LEFT);
        }
        // scrivo il target
        $Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament,FSTarget, FSLetter) " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('1') . "," . StrSafe_DB($mm) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($Target) . "," . StrSafe_DB($Target ? $Target . 'A' : '') . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=" . StrSafe_DB($Target) . "," . "FSGroup=FSGroup," . "FSScheduledTime=FSScheduledTime ";
        $Rs = safe_w_sql($Insert);
        if (!$Rs) {
            $Errore = 1;
        } else {
            if ($ath == 1) {
                $Insert = "INSERT INTO FinSchedule (FSEvent,FSTeamEvent,FSMatchNo,FSTournament,FSTarget, FSLetter) " . "VALUES(" . StrSafe_DB($ee) . "," . StrSafe_DB('1') . "," . StrSafe_DB($mm + 1) . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($Target) . "," . StrSafe_DB($Target ? $Target . 'B' : '') . "" . ") " . "ON DUPLICATE KEY UPDATE " . "FSTarget=" . StrSafe_DB($Target) . "," . "FSGroup=FSGroup," . "FSScheduledTime=FSScheduledTime ";
                $Rs = safe_w_sql($Insert);
                if (!$Rs) {
                    $Errore = 1;
                }
            }
        }
    } else {
        $Errore = 1;
    }
    $ret .= '<field>';
    $ret .= '<error>' . $Errore . '</error>' . "\n";
    $ret .= '<which><![CDATA[' . $Which . ']]></which>' . "\n";
    $ret .= '<target><![CDATA[' . $Target . ']]></target>' . "\n";
    $ret .= '<phase><![CDATA[' . $Phase . ']]></phase>' . "\n";
    $ret .= '<event><![CDATA[' . $Event . ']]></event>' . "\n";
    $ret .= '</field>';
    return $ret;
}