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;
}
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;
}
