public function Footer()
{
parent::Footer();
$this->SetXY(IanseoPdf::sideMargin, $this->h - $this->savedBottomMargin);
$this->MultiCell(70, 5, $this->copy2, 0, "L", 0);
//$this->Line(195, $this->tMargin, 195, $this->tMargin+50);
//$this->Line(195, $this->tMargin+60, 195, $this->tMargin+110);
$this->StartTransform();
$this->setXY(195, $this->tMargin + 50);
$this->Rotate(90);
$this->Cell(45, 5, get_text('OrgResponsible', 'Tournament'), 'T', 0, 'C');
$this->setXY(195, $this->tMargin + 100);
$this->Rotate(90);
$this->Cell(45, 5, get_text('Judge', 'Tournament'), 'T', 0, 'C');
$this->setXY(185, $this->tMargin + 175);
$this->Rotate(90);
$this->SetFont('barcode', '', 40);
$this->Cell(65, 15, IsBlocked(BIT_BLOCK_REPORT) ? '*' . str_replace(".", "", $this->validationCode) . '*' : '', 0, 0, 'C');
$this->setXY(185, $this->tMargin + 235);
$this->Rotate(90);
$this->SetFont($this->FontFix, 'B', 20);
$this->Cell(50, 15, IsBlocked(BIT_BLOCK_REPORT) ? $this->validationCode : get_text('TourNoBlock', 'Tournament'), 0, 0, 'C');
$this->StopTransform();
if (!IsBlocked(BIT_BLOCK_REPORT)) {
$this->WaterMark(get_text('TourNoBlock', 'Tournament'));
}
}
<?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";
<?php
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
if (!CheckTourSession() || !isset($_REQUEST['EvCode'])) {
printCrackError();
}
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Lib/ArrTargets.inc.php';
require_once 'Qualification/Fun_Qualification.local.inc.php';
require_once 'Common/Fun_Sessions.inc.php';
require_once 'Common/Fun_Various.inc.php';
if (isset($_REQUEST['DelRow']) && !IsBlocked(BIT_BLOCK_TOURDATA)) {
list($EcClass, $EcDivision) = explode('~', $_REQUEST['DelRow']);
//print $EcClass . ' - ' . $EcDivision . '<br>';exit;
$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
<?php
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Tournament/Fun_Tournament.local.inc.php';
if (!CheckTourSession() || !isset($_REQUEST['ClId']) || !isset($_REQUEST['Age']) || !isset($_REQUEST['FromTo']) || $_REQUEST['FromTo'] != 'From' && $_REQUEST['FromTo'] != 'To') {
print get_text('CrackError');
exit;
}
$Errore = 0;
if (!IsBlocked(BIT_BLOCK_TOURDATA) && !defined('dontEditClassDiv')) {
$Age = $_REQUEST['Age'];
$ClId = $_REQUEST['ClId'];
if (!is_numeric($Age)) {
$Errore = 1;
} else {
$ClDivAllowed = empty($_REQUEST['AlDivs']) ? '' : $_REQUEST['AlDivs'];
if (!CheckClassAge($ClId, $Age, $_REQUEST['FromTo'], $ClDivAllowed)) {
$Errore = 1;
}
}
if (!$Errore) {
$Update = "UPDATE Classes SET " . "ClAge" . $_REQUEST['FromTo'] . "=" . StrSafe_DB($Age) . " " . ", ClDivisionsAllowed=" . StrSafe_DB($ClDivAllowed) . " " . "WHERE ClId=" . StrSafe_DB($ClId) . " AND ClTournament=" . StrSafe_DB($_SESSION['TourId']) . "";
$Rs = safe_w_sql($Update);
$err = safe_w_error();
if ($err->errno != 0) {
$Errore = 1;
}
}
} else {
<?php
define('debug', false);
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Tournament/Fun_Tournament.local.inc.php';
if (!CheckTourSession() || !isset($_REQUEST['New_ClId']) || !isset($_REQUEST['New_ClSex']) || !isset($_REQUEST['New_ClDescription']) || !isset($_REQUEST['New_ClAthlete']) || !isset($_REQUEST['New_ClViewOrder']) || !isset($_REQUEST['New_ClAgeFrom']) || !isset($_REQUEST['New_ClAgeTo']) || !isset($_REQUEST['New_ClValidClass']) || !isset($_REQUEST['New_ClValidDivision'])) {
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";
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Lib/ArrTargets.inc.php';
require_once 'Common/Fun_Phases.inc.php';
require_once 'HHT/Fun_HHT.local.inc.php';
if (!CheckTourSession() || !isset($_REQUEST['d_Phase'])) {
PrintCrackError();
}
$Cols2Remove = isset($_REQUEST['d_Tie']) && $_REQUEST['d_Tie'] == 1 ? 0 : 2;
$Error = false;
$Tie_Error = array();
// Contiene gl'indici delle tendine Tie con errore
$Score_Error = array();
// contiene gl'indici degli score che superano il max
$Set_Error = array();
// contiene gl'indici dei set che superano il max
if (isset($_REQUEST['Command']) && $_REQUEST['Command'] == 'SAVE' && !IsBlocked(BIT_BLOCK_IND)) {
// Update dei punti e dei tie
$AllowedEvents = array();
foreach ($_REQUEST as $Key => $Value) {
if (strpos($Key, 'S_') === 0) {
if (!(is_numeric($Value) && $Value >= 0)) {
$Value = 0;
}
$ee = "";
$mm = "";
// evento e matchno estratti dal nome campo
list($ee, $mm) = explode('_', substr($Key, 2));
// get the match maximum values
$MaxScores = GetMaxScores($ee, $mm);
if (empty($AllowedEvents[$ee])) {
// dal matchno recupero la fase
<?php
/*
- UpdateFieldEventList.php -
Aggiorna il campo di Events passato in querystring.
*/
define('debug', false);
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Common/Fun_FormatText.inc.php';
if (!CheckTourSession() || !isset($_REQUEST['New_EvCode']) || !isset($_REQUEST['New_EvEventName']) || !isset($_REQUEST['New_EvProgr']) || !isset($_REQUEST['New_EvMatchMode']) || !isset($_REQUEST['New_EvFinalFirstPhase']) || !isset($_REQUEST['New_EvFinalTargetType']) || !isset($_REQUEST['New_EvTargetSize']) || !isset($_REQUEST['New_EvDistance'])) {
print get_text('CrackError');
exit;
}
$Errore = 0;
$xml = '';
if (!IsBlocked(BIT_BLOCK_TOURDATA)) {
// Aggiungo la nuova riga
$Insert = "INSERT INTO Events (EvCode,EvTeamEvent,EvTournament,EvEventName,EvProgr,EvShootOff,EvFinalFirstPhase,EvFinalTargetType,EvTargetSize,EvDistance,EvMatchMode) " . "VALUES(" . StrSafe_DB($_REQUEST['New_EvCode']) . "," . StrSafe_DB('1') . "," . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($_REQUEST['New_EvEventName']) . "," . StrSafe_DB($_REQUEST['New_EvProgr']) . "," . StrSafe_DB('0') . "," . StrSafe_DB($_REQUEST['New_EvFinalFirstPhase']) . "," . StrSafe_DB($_REQUEST['New_EvFinalTargetType']) . ", " . StrSafe_DB($_REQUEST['New_EvTargetSize']) . ", " . StrSafe_DB($_REQUEST['New_EvDistance']) . ", " . StrSafe_DB($_REQUEST['New_EvMatchMode']) . " " . ") ";
$RsIns = safe_w_sql($Insert);
set_qual_session_flags();
if (debug) {
print $Insert . '<br>';
}
if (!$RsIns) {
$Errore = 1;
} else {
/*
* imposto i parametri delle frecce.
* Sicuramente ho un evento team cumulativo e non mixed perchè il flag del mixed si
* gestisce dopo la creazione dell'evento
*/
* Se $_REQUEST['MatchNo'] è pari la coppia è data da lui e dal successivo
* altrimenti dal precedente e lui.
*/
$MatchSx = -1;
$MatchDx = -1;
if ($_REQUEST['MatchNo'] % 2 == 0) {
$MatchSx = $_REQUEST['MatchNo'];
$MatchDx = $_REQUEST['MatchNo'] + 1;
} else {
$MatchSx = $_REQUEST['MatchNo'] - 1;
$MatchDx = $_REQUEST['MatchNo'];
}
if (debug) {
print 'MatchNo ' . $MatchSx . ' - ' . $MatchDx . '<br>';
}
if (!IsBlocked(BIT_BLOCK_TEAM)) {
// Scrittura nel db
if (isset($_REQUEST['Command']) && $_REQUEST['Command'] == 'OK' || isset($_REQUEST["TargetSx_x"]) && isset($_REQUEST["TargetSx_y"]) || isset($_REQUEST["TargetDx_x"]) && isset($_REQUEST["TargetDx_y"])) {
// Estraggo le arrowstring coinvolte
$Select = "SELECT TfMatchNo AS MatchNo,TfEvent AS Event,TfArrowString AS ArrowString,TfTieBreak AS TieBreak,TfArrowPosition AS ArrPos,TfTiePosition AS TiePos " . "FROM TeamFinals " . "WHERE TfMatchNo IN(" . StrSafe_DB($MatchSx) . "," . StrSafe_DB($MatchDx) . ") AND TfEvent=" . StrSafe_DB($_REQUEST['Event']) . " " . "AND TfTournament=" . StrSafe_DB($_SESSION['TourId']) . " " . "ORDER BY TfMatchNo ASC ";
$Rs = safe_r_sql($Select);
if (debug) {
print $Select . '<br>';
}
//exit;
$MyRow = safe_fetch($Rs);
$ArrSx = str_pad($MyRow->ArrowString, 24);
$TieSx = str_pad($MyRow->TieBreak, $nSO);
$PosArrSx = explode('|', str_pad($MyRow->ArrPos, 24 - substr_count($MyRow->ArrPos, "|"), "|"));
$PosTieSx = explode('|', str_pad($MyRow->TiePos, 9 - substr_count($MyRow->TiePos, "|"), "|"));
$MyRow = safe_fetch($Rs);
}
if ($x < 0) {
$x = (imagesx($im) - $w - 2) / 2;
}
if ($y < 0) {
$y = imagesy($im) - $h - 2;
}
if ($x + $w > imagesx($im)) {
$x = imagesx($im) - $w - 2;
}
if ($y + $h > imagesy($im)) {
$y = imagesy($im) - $h - 2;
}
$lineColor = imagecolorallocate($im, 255, 255, 0);
imagesetthickness($im, 3);
if (!empty($_REQUEST['get']) && $_REQUEST['get'] == 1 && !IsBlocked(BIT_BLOCK_ACCREDITATION)) {
setcookie("getPhotoX", $x, time() + 24 * 60);
setcookie("getPhotoY", $y, time() + 24 * 60);
setcookie("getPhotoW", $w, time() + 24 * 60);
$dest = imagecreatetruecolor(MAX_WIDTH, MAX_HEIGHT);
if (!imagecopyresampled($dest, $im, 0, 0, $x, $y, MAX_WIDTH, MAX_HEIGHT, $w, $h)) {
$errMsg = get_text('PhotoDimError', 'Tournament', array(MAX_WIDTH, MAX_HEIGHT));
} else {
if (!empty($athId)) {
imagejpeg($dest, '/tmp/salvala', 90);
$image = addslashes(base64_encode(file_get_contents('/tmp/salvala')));
$query = "INSERT INTO Photos (PhEnId,PhPhoto,PhPhotoEntered) " . "VALUES(" . Strsafe_DB($athId) . ", " . "'" . $image . "', " . "NOW()" . ") " . "ON DUPLICATE KEY UPDATE " . "PhPhoto='" . $image . "', PhPhotoEntered=NOW() ";
//print $query . '<br>';
$rs = safe_w_sql($query);
$lineColor = imagecolorallocate($im, 0, 0, 255);
imagesetthickness($im, 10);
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Common/Fun_Number.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
CheckTourSession(true);
$ev = isset($_REQUEST['ev']) ? $_REQUEST['ev'] : null;
if (is_null($ev)) {
header('Location: ChangeComponents1.php');
exit;
}
$command = isset($_REQUEST['command']) ? $_REQUEST['command'] : null;
if (!is_null($command)) {
if ($command == 'Set' && !IsBlocked(BIT_BLOCK_TEAM)) {
$team = isset($_REQUEST['team']) ? $_REQUEST['team'] : null;
$subTeam = isset($_REQUEST['subTeam']) ? $_REQUEST['subTeam'] : null;
$oldId = isset($_REQUEST['oldId']) ? $_REQUEST['oldId'] : null;
$newId = isset($_REQUEST['newId']) ? $_REQUEST['newId'] : null;
//print $team . ' ' . $subTeam . ' ' . $oldId . ' ' . $newId;exit;
if (!is_null($team) && !is_null($subTeam) && !is_null($oldId) && !is_null($newId)) {
/*$query
= "UPDATE "
. "TeamFinComponent "
. "SET "
. "TfcId=" . StrSafe_DB($newId) . " "
. "WHERE "
. "TfcCoId=" . StrSafe_DB($team) . " AND TfcSubTeam=" . StrSafe_DB($subTeam) . " AND "
. "TfcTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND TfcEvent=" . StrSafe_DB($ev) . " AND "
. "TfcId=" . StrSafe_DB($oldId) . " ";
// print $query;exit;
$rs=safe_w_sql($query);*/
<?php
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
CheckTourSession(true);
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Fun_Phases.inc.php';
if (isset($_REQUEST['Command'])) {
if (!IsBlocked(BIT_BLOCK_TOURDATA) && $_REQUEST['Command'] == 'SAVE') {
$BitMask = 0;
foreach ($_REQUEST as $Key => $Value) {
if (substr($Key, 0, 19) == 'd_EvFinalAthTarget_') {
list(, , $e) = explode('_', $Key);
$BitMask += $Value * pow(2, $e);
//print $e . ' - ' . $Value . ' - ' . ($Value*pow(2,$e)) . '<br>';
/*
* Questa parte potrebbe essere risolta tramite una sola query.
* Occorre usare gli operatori bit a bit di mysql per trovare
* le fasi con il Bit=1
*/
if ($Value == 1) {
$Phase = floor(pow(2, $e) / 2);
//print '--> '. $e . ' - ' . $Phase . '<br>';
$Update = "UPDATE " . "FinSchedule AS fs1 LEFT JOIN FinSchedule AS fs2 ON fs1.FSMatchNo=(fs2.FSMatchNo-1) AND fs1.FSEvent=fs2.FSEvent AND fs1.FSTeamEvent=fs2.FSTeamEvent AND fs1.FSTournament=fs2.FSTournament " . "SET fs2.FSTarget = fs1.FSTarget " . "WHERE fs1.FSEvent=" . StrSafe_DB($_REQUEST['d_Event2Set']) . " AND fs1.FSTeamEvent='0' AND " . "fs1.FSTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (fs1.FSMatchNo% 2)=0 " . "AND fs1.FSMatchNO IN(SELECT GrMatchNo FROM Grids WHERE GrPhase=" . StrSafe_DB($Phase) . ") ";
$Rs = safe_w_sql($Update);
//print $Update . '<br>';
}
}
}
//exit;
require_once 'Tournament/Fun_Tournament.local.inc.php';
require_once 'Tournament/Fun_ManSessions.inc.php';
if (defined('hideSchedulerAndAdvancedSession')) {
header('location: ManSessions_kiss.php');
exit;
}
if (!CheckTourSession()) {
print get_text('CrackError');
exit;
}
$msg = "";
$tourId_safe = StrSafe_DB($_SESSION['TourId']);
$command = isset($_REQUEST['Command']) ? $_REQUEST['Command'] : null;
// tipi sessione
$sessionsTypes = GetSessionsTypes();
if (!is_null($command) && !IsBlocked(BIT_BLOCK_TOURDATA)) {
if ($command == 'SAVE') {
$myRequest = array('oldKey', 'd_SesOrder', 'd_SesType', 'd_SesName', 'd_SesTar4Session', 'd_SesAth4Target', 'd_SesFirstTarget', 'd_SesFollow');
$toSave = array();
foreach ($myRequest as $v) {
if (isset($_REQUEST[$v])) {
$toSave[$v] = $_REQUEST[$v];
} else {
$toSave[$v] = null;
}
}
/*print '<pre>';
print_r($toSave);
print '</pre>';exit;*/
// le var ci devono esser tutte
if (!in_array(null, $toSave, true)) {
<?php
define('debug', false);
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/Lib/ArrTargets.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Fun_Final.local.inc.php';
require_once 'Fun_ChangePhase.inc.php';
CheckTourSession(true);
$event = isset($_REQUEST['event']) ? $_REQUEST['event'] : null;
$team = isset($_REQUEST['team']) ? $_REQUEST['team'] : null;
$match = isset($_REQUEST['match']) ? $_REQUEST['match'] : null;
$Errore = 0;
$msg = get_text('CmdOk');
$ok = false;
$isBlocked = $team == 0 ? IsBlocked(BIT_BLOCK_IND) : IsBlocked(BIT_BLOCK_TEAM);
if (is_null($event) || is_null($team) || is_null($match) || $isBlocked) {
$Errore = 1;
} else {
if ($team == 0) {
$ok = move2NextPhase(null, $event, $match);
} else {
$ok = move2NextPhaseTeam(null, $event, $match);
}
if ($ok === false) {
$Errore = 1;
}
}
if ($Errore == 1) {
$msg = get_text('Error');
}
<?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 = 1;
$xml = '';
$cl = empty($_REQUEST['cl']) ? '' : $_REQUEST['cl'];
$TfName = empty($_REQUEST['TfName']) ? '' : $_REQUEST['TfName'];
$RegExp = empty($_REQUEST['RegExp']) ? '' : $_REQUEST['RegExp'];
if (!IsBlocked(BIT_BLOCK_TOURDATA) and ($cl or $RegExp) and $TfName) {
$ok = true;
$targets = array();
foreach ($_REQUEST['tdface'] as $dist => $face) {
if (!$face or empty($_REQUEST['tddiam'][$dist]) and !in_array($face, array(6, 8, 11))) {
$ok = false;
}
$targets[$face] = '';
}
// check if the rule hits one or more div/cl
$select = "SELECT " . "CONCAT(trim(DivId),trim(ClId)) as Ev " . "FROM " . "Divisions INNER JOIN Classes ON DivTournament=ClTournament " . "WHERE " . "CONCAT(trim(DivId),trim(ClId)) " . ($RegExp ? "RLIKE " . StrSafe_DB($RegExp) : "LIKE " . StrSafe_DB($cl)) . " AND DivTournament=" . StrSafe_DB($_SESSION['TourId']) . " ";
$rs = safe_r_sql($select);
if (safe_num_rows($rs) and $ok) {
$TfId = 1;
$q = safe_r_sql("select max(TfId) MaxId from TargetFaces where TfTournament={$_SESSION['TourId']}");
if ($r = safe_fetch($q)) {
$TfId = $r->MaxId + 1;
private function isBlocked()
{
$ret = false;
switch ($this->getPhase()) {
case ARF::QUALIFICATION:
$ret = IsBlocked(BIT_BLOCK_QUAL);
break;
case ARF::ELIMINATION:
$ret = IsBlocked(BIT_BLOCK_ELIM);
break;
case ARF::INDIVIDUAL_FINAL:
$ret = IsBlocked(BIT_BLOCK_IND);
break;
case ARF::TEAM_FINAL:
$ret = IsBlocked(BIT_BLOCK_TEAM);
break;
}
return $ret;
}
require_once 'Common/Lib/ArrTargets.inc.php';
require_once 'Common/Lib/Obj_RankFactory.php';
require_once 'Common/Fun_Phases.inc.php';
require_once 'Final/Fun_ChangePhase.inc.php';
CheckTourSession(true);
$Error = false;
$EventList = array();
$Events = array();
if (!empty($_REQUEST['EventCode'])) {
$Events = explode('|', $_REQUEST['EventCode']);
}
$rank = Obj_RankFactory::create('Abs', array('events' => $Events, 'dist' => 0));
$IdAffected = array();
$NotResolvedMsg = array();
// scrivo
if (isset($_REQUEST['Ok']) && $_REQUEST['Ok'] == 'OK' && !IsBlocked(BIT_BLOCK_IND)) {
$Ties = array();
$NotResolved = array();
$MaxRank = array();
// penso alle rank
$Events = array_keys($_REQUEST['R']);
foreach ($_REQUEST['R'] as $Event => $EnIds) {
$q = safe_r_sql("select EvFinalFirstPhase, EvMatchMode from Events where EvCode='{$Event}' and EvTeamEvent='0' and EvTournament='{$_SESSION['TourId']}'");
$r = safe_fetch($q);
$MaxRank[$Event] = $r->EvFinalFirstPhase * 2;
if ($r->EvFinalFirstPhase == 24 or $r->EvFinalFirstPhase == 48) {
$MaxRank[$Event] += 8;
}
// salva i primi 8
$NotResolved[$Event] = false;
asort($EnIds);
}
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
if ($id === null) {
exit;
}
$ses = null;
$tar = null;
if (isset($_REQUEST['ses']) && isset($_REQUEST['tar'])) {
$ses = $_REQUEST['ses'];
$tar = $_REQUEST['tar'];
}
$reload = 0;
// 0 non succede nulla all'opener;1 ricarica;2 ricarica e il popup si chiude
/* salvo */
if (isset($_REQUEST['Command'])) {
if (!IsBlocked(BIT_BLOCK_PARTICIPANT) && ($_REQUEST['Command'] == 'SAVE' || $_REQUEST['Command'] == 'SAVE_CONTINUE')) {
$EnCountries = array('' => 0, '2' => 0, '3' => 0);
$EnDob = '0000-00-00';
// country
foreach (array('', '2', '3') as $v) {
if (trim($_REQUEST['d_c_CoCode' . $v . '_'])) {
// Code is ALL CAPS
// Name is Title!
$CoCode = mb_convert_case(trim($_REQUEST['d_c_CoCode' . $v . '_']), MB_CASE_UPPER, "UTF-8");
$CoName = AdjustCaseTitle($_REQUEST['d_c_CoName' . $v . '_']);
// if code already exists, updates the name
$Select = "SELECT CoId,CoName " . "FROM Countries " . "WHERE CoCode='{$CoCode}' AND CoTournament=" . StrSafe_DB($_SESSION['TourId']) . " ";
$Rs = safe_r_sql($Select);
if ($myrow = safe_fetch($Rs)) {
$CoId = $myrow->CoId;
} else {
</td>
<td colspan="2" class="Bold Center"><input type="checkbox" name="BOOK" id="BOOK" onclick="SelectBook(this)"> <?php
print get_text('CompleteResultBook');
?>
</td>
<td class="Bold Center"><input type="checkbox" name="MEDLST" id="MEDLST"> <?php
print get_text('MedalList');
?>
</td>
</tr>
<tr class="Divider"><th colspan="4"></th></tr>
<tr><td class="Left" id="idStatus" colspan="4"> </td></tr>
<?php
if (!IsBlocked(BIT_BLOCK_PUBBLICATION)) {
echo '<tr><td colspan="4" class="Center"><input type="submit" id="btnOk" value="' . get_text('CmdOk') . '" onclick="document.getElementById(\'msg\').innerHTML=\' \'"></td></tr>';
}
?>
</table>
</div>
</div>
</form>
<?php
include 'Common/Templates/tail.php';
function getQueryResult($SQL, $BT = '')
{
$ret = array();
$q = safe_r_sql($SQL);
while ($r = safe_fetch($q)) {
$ret[] = $r;
print "<br>";
print GetTargetType($_REQUEST['Event']) . '<br>';
print ($MyTargetComplete ? 'Completo' : 'Non completo') . '<br>';
}
*/
/***********************
MatchNo dell'incontro
************************/
$MatchNo = isset($_REQUEST['MatchNo']) ? $_REQUEST['MatchNo'] : NULL;
$Event = isset($_REQUEST['Event']) ? $_REQUEST['Event'] : NULL;
$MatchSx = $MatchNo % 2 == 0 ? $MatchNo : $MatchNo - 1;
$MatchDx = $MatchSx + 1;
/*********************************
Gestione delle frecce in INPUT
*********************************/
if (!IsBlocked(BIT_BLOCK_IND)) {
// Scrittura nel db
if (isset($_REQUEST['Command']) && $_REQUEST['Command'] == 'OK' || isset($_REQUEST["TargetSx_x"]) && isset($_REQUEST["TargetSx_y"]) || isset($_REQUEST["TargetDx_x"]) && isset($_REQUEST["TargetDx_y"])) {
// Estraggo le arrowstring coinvolte
$Select = "SELECT f.FinMatchNo AS MatchNo, f2.FinMatchNo AS OppMatchNo, " . "f.FinArrowPosition AS ArrPos, f.FinTiePosition AS TiePos, " . "f2.FinArrowPosition AS OppArrPos, f2.FinTiePosition AS OppTiePos, " . "EvCode as Event, GrPhase as Phase, EvMatchMode as MatchMode, EvMatchArrowsNo " . "FROM Events " . "INNER JOIN Finals AS f ON EvTournament=f.FinTournament AND EvCode=f.FinEvent " . "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 Grids ON f.FinMatchNo=GrMatchNo " . "WHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvCode=" . StrSafe_DB($_REQUEST['Event']) . " AND EvTeamEvent='0' AND f.FinMatchNo=" . StrSafe_DB($MatchNo % 2 == 0 ? $MatchNo : $MatchNo - 1);
$Rs = safe_r_sql($Select);
$MyRow = safe_fetch($Rs);
$obj = getEventArrowsParams($MyRow->Event, $MyRow->Phase, 0);
$nEND = $obj->ends;
$nARR = $obj->arrows;
$maxArrows = $nEND * $nARR;
$nTieBreak = $obj->so;
$ArrStringSx = str_repeat(' ', $_REQUEST["Volee"] == 'T' ? $nTieBreak : $nARR);
$ArrStringDx = str_repeat(' ', $_REQUEST["Volee"] == 'T' ? $nTieBreak : $nARR);
$ArrowPositionSx = explode('|', str_pad($MyRow->{($_REQUEST["Volee"] == 'T' ? "Tie" : "Arr") . "Pos"}, ($_REQUEST["Volee"] == 'T' ? 6 : 18) - substr_count($MyRow->{($_REQUEST["Volee"] == 'T' ? "Tie" : "Arr") . "Pos"}, "|"), "|"));
$ArrowPositionDx = explode('|', str_pad($MyRow->{"Opp" . ($_REQUEST["Volee"] == 'T' ? "Tie" : "Arr") . "Pos"}, ($_REQUEST["Volee"] == 'T' ? 6 : 18) - substr_count($MyRow->{"Opp" . ($_REQUEST["Volee"] == 'T' ? "Tie" : "Arr") . "Pos"}, "|"), "|"));
foreach (GetSessions('Q') as $ses) {
$ComboSes .= '<option value="' . $ses->SesOrder . '"' . (isset($_REQUEST['x_Session']) && $_REQUEST['x_Session'] == $ses->SesOrder ? ' selected' : '') . '>' . $ses->Descr . '</option>' . "\n";
}
$ComboSes .= '</select>' . "\n";
for ($i = 1; $i <= $RowTour->TtNumDist; ++$i) {
$ComboDist .= '<option value="' . $i . '"' . (isset($_REQUEST['x_Dist']) && $_REQUEST['x_Dist'] == $i ? ' selected' : '') . '>' . $i . '</option>' . "\n";
}
$ComboDist .= '</select>' . "\n";
$TxtFrom = '<input type="text" name="x_From" id="x_From" size="5" maxlength="' . (TargetNoPadding + 1) . '" value="' . (isset($_REQUEST['x_From']) ? $_REQUEST['x_From'] : '') . '">';
$TxtTo = '<input type="text" name="x_To" id="x_To" size="5" maxlength="' . (TargetNoPadding + 1) . '" value="' . (isset($_REQUEST['x_To']) ? $_REQUEST['x_To'] : '') . '">';
$ChkG = '<input type="checkbox" name="x_Gold" id="x_Gold" value="1"' . (isset($_REQUEST['x_Gold']) && $_REQUEST['x_Gold'] == 1 ? ' checked' : '') . '>';
//$ChkA = '<input type="checkbox" name="x_Arrows" id="x_Arrows" value="1"' . (isset($_REQUEST['x_Arrows']) && $_REQUEST['x_Arrows']==1 ? ' checked' : '') . '>';
if (empty($_REQUEST['x_To']) && !empty($_REQUEST['x_From'])) {
$_REQUEST['x_To'] = $_REQUEST['x_From'];
}
if (isset($_REQUEST['x_Arrows']) && $_REQUEST['x_Arrows'] == 2 && isset($_REQUEST['Command']) && $_REQUEST['Command'] == 'OK' && $_REQUEST['x_Session'] > 0 && $_REQUEST['x_Dist'] > 0 && !IsBlocked(BIT_BLOCK_QUAL)) {
$v = 0;
if (isset($_REQUEST['x_AllArrows']) && preg_match('/^[0-9]{1,4}$/i', $_REQUEST['x_AllArrows'])) {
$v = $_REQUEST['x_AllArrows'];
$TargetFilter = "AND QuTargetNo >='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, '0', STR_PAD_LEFT) . "A' AND QuTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, '0', STR_PAD_LEFT) . "Z' ";
$Where = "WHERE " . "EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND QuSession=" . StrSafe_DB($_REQUEST['x_Session']) . " AND EnStatus<=1 " . $TargetFilter . " ";
$query = "UPDATE " . "Qualifications INNER JOIN Entries ON EnId=QuId " . "SET " . "QuD" . $_REQUEST['x_Dist'] . "Hits=" . StrSafe_DB($v) . " " . $Where;
$rs = safe_w_sql($query);
// somma
$query = "UPDATE " . "Qualifications INNER JOIN Entries ON EnId=QuId " . "SET " . "QuHits=QuD1Hits+QuD2Hits+QuD3Hits+QuD4Hits+QuD5Hits+QuD6Hits+QuD7Hits+QuD8Hits " . $Where;
// print $query;
$rs = safe_w_sql($query);
// per evitare puttanate riporto a zero la combo delle frecce
unset($_REQUEST['x_Arrows']);
}
}
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
CheckTourSession(true);
$event = isset($_REQUEST['d_Event']) ? $_REQUEST['d_Event'] : null;
$TeamEvent = isset($_REQUEST['d_Team']) ? $_REQUEST['d_Team'] : null;
$match = isset($_REQUEST['d_Match']) ? $_REQUEST['d_Match'] : null;
$Rev1 = isset($_REQUEST['Review1']) ? $_REQUEST['Review1'] : null;
$Rev2 = isset($_REQUEST['Review2']) ? $_REQUEST['Review2'] : null;
if ($match % 2 != 0) {
$match--;
}
$Errore = 0;
$msg = '';
$isBlocked = $TeamEvent == 0 ? IsBlocked(BIT_BLOCK_IND) : IsBlocked(BIT_BLOCK_TEAM);
if (is_null($event) || is_null($TeamEvent) || is_null($match) || $isBlocked) {
$Errore = 1;
} else {
if (strlen($Rev1) == 0 && strlen($Rev2) == 0) {
$sql = "DELETE FROM Reviews " . "WHERE RevEvent=" . StrSafe_DB($event) . " AND " . "RevMatchNo =" . $match . " AND " . "RevTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND " . "RevTeamEvent=" . StrSafe_DB($TeamEvent);
$Rs = safe_w_sql($sql);
} else {
$sql = "INSERT INTO Reviews (RevEvent, RevMatchNo, RevTournament, RevTeamEvent, RevLanguage1, RevLanguage2, RevDateTime) " . "VALUES(" . StrSafe_DB($event) . ", " . StrSafe_DB($match) . ", " . StrSafe_DB($_SESSION['TourId']) . ", " . StrSafe_DB($TeamEvent) . ", " . StrSafe_DB(urldecode($Rev1)) . ", " . StrSafe_DB(urldecode($Rev2)) . ", " . StrSafe_DB(date('Y-m-d H:i:s')) . ") " . "ON DUPLICATE KEY UPDATE RevLanguage1=" . StrSafe_DB(urldecode($Rev1)) . ", RevLanguage2=" . StrSafe_DB(urldecode($Rev2)) . ", RevDateTime=" . StrSafe_DB(date('Y-m-d H:i:s'));
$Rs = safe_w_sql($sql);
if (!safe_w_affected_rows()) {
$Errore = 1;
}
}
}
if ($Errore == 0) {
$msg = get_text('CmdOk');
<?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;
}
if (isset($_REQUEST['Command'])) {
if ($_REQUEST['Command'] == 'OK' && !IsBlocked(BIT_BLOCK_PUBBLICATION)) {
// Query per estrarre l'eventcode del torneo
$Select = "SELECT ToCode " . "FROM Tournament " . "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";
$Rs = safe_r_sql($Select);
$code = 0;
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$code = $r->ToCode;
}
$URL = "http://www.ianseo.net/TourCheckCodes.php";
if (!empty($CFG->OVERRIDES) and !empty($CFG->CheckCodes)) {
$URL = $CFG->CheckCodes;
}
$ch = curl_init($URL);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array("ToId" => intval($_REQUEST['OnlineId']), "Auth1" => stripslashes($_REQUEST['OnlineAuth']), "Auth2" => stripslashes($_REQUEST['OnlineAuthA2A']), "ToCode" => $code, "CheckImgs" => '1'));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$varResponse = explode('|', curl_exec($ch));
curl_close($ch);
if (substr($varResponse[0], 0, 2) == 'OK') {
$_SESSION['OnlineAuth'] = '';
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
if (!CheckTourSession() || !isset($_REQUEST['Id'])) {
print get_text('CrackError');
exit;
}
$Errore = 0;
if (!(IsBlocked(BIT_BLOCK_QUAL) && IsBlocked(BIT_BLOCK_IND) && IsBlocked(BIT_BLOCK_TEAM))) {
$delete = "DELETE FROM HhtEvents " . "WHERE HeHhtId=" . StrSafe_DB($_REQUEST['Id']) . " AND HeTournament=" . StrSafe_DB($_SESSION['TourId']) . " ";
$rs = safe_w_sql($delete);
$delete = "DELETE FROM HhtSetup " . "WHERE HsId=" . StrSafe_DB($_REQUEST['Id']) . " AND HsTournament=" . StrSafe_DB($_SESSION['TourId']) . " ";
$rs = safe_w_sql($delete);
if (!$rs) {
$Errore = 1;
}
} else {
$Errore = 1;
}
header('Content-Type: text/xml');
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<id>' . $_REQUEST['Id'] . '</id>' . "\n";
print '</response>' . "\n";
<?php
/*
- MakeTeams.php -
Genera le squadre
*/
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Qualification/Fun_Qualification.local.inc.php';
$Errore = 0;
if (!IsBlocked(BIT_BLOCK_QUAL)) {
$Errore = MakeTeams(NULL, NULL);
} else {
$Errore = 1;
}
// produco l'xml di ritorno
if (!debug) {
header('Content-Type: text/xml');
}
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<msg><![CDATA[' . get_text('ResultSqClass', 'Tournament') . "\n" . ($Errore == 1 ? get_text('MakeTeamsError', 'Tournament') : get_text('MakeTeamsOk', 'Tournament')) . ']]></msg>';
print '</response>' . "\n";
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Partecipants/Fun_Partecipants.local.inc.php';
require_once 'Qualification/Fun_Qualification.local.inc.php';
/****** Controller ******/
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
$status = isset($_REQUEST['status']) ? $_REQUEST['status'] : null;
if (!CheckTourSession()) {
print get_text('CrackError');
exit;
}
$error = 0;
$tourId = StrSafe_DB($_SESSION['TourId']);
if (!IsBlocked(BIT_BLOCK_PARTICIPANT)) {
$recalc = false;
$indFEvent = $teamFEvent = $country = $div = $cl = $zero = null;
// se cambio status ricalcolo gli spareggi
$query = "SELECT EnClass FROM Entries WHERE EnId=" . StrSafe_DB($id) . " AND EnStatus<>" . StrSafe_DB($status) . " ";
//print $query;exit;
$rs = safe_r_sql($query);
if ($rs && safe_num_rows($rs) == 1) {
$recalc = true;
$x = Params4Recalc($id);
if ($x !== false) {
list($indFEvent, $teamFEvent, $country, $div, $cl, $zero) = $x;
}
}
//Adesso aggiorno lo status
$query = "UPDATE " . "Entries " . "SET " . "EnStatus=" . StrSafe_DB($status) . " " . "WHERE " . "EnId=" . StrSafe_DB($id) . " ";
$rs = safe_w_sql($query);
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
if (!CheckTourSession() || !isset($_REQUEST['rowid']) || !isset($_REQUEST['cl']) || !isset($_REQUEST['ath']) || !isset($_REQUEST['col']) || !isset($_REQUEST['titlereverse']) || !isset($_REQUEST['area0']) || !isset($_REQUEST['area1']) || !isset($_REQUEST['area2']) || !isset($_REQUEST['area3']) || !isset($_REQUEST['area4']) || !isset($_REQUEST['area5']) || !isset($_REQUEST['area6']) || !isset($_REQUEST['area7']) || !isset($_REQUEST['areastar']) || !isset($_REQUEST['transport']) || !isset($_REQUEST['accomodation']) || !isset($_REQUEST['meal'])) {
print get_text('CrackError');
exit;
}
$Errore = 0;
if (!IsBlocked(BIT_BLOCK_ACCREDITATION)) {
if ($_REQUEST['cl'] != '' && preg_match('/^[01]{1,1}$/i', $_REQUEST['ath']) && preg_match('/^#[0-9A-Za-z]{6}$/i', $_REQUEST['col'])) {
$query = "REPLACE INTO AccColors (AcTournament,AcDivClass,AcColor,AcIsAthlete,AcTitleReverse, " . "AcArea0,AcArea1,AcArea2,AcArea3,AcArea4,AcArea5,AcArea6,AcArea7,AcAreaStar, " . "AcTransport, AcAccomodation, AcMeal) " . "VALUES(" . StrSafe_DB($_SESSION['TourId']) . "," . StrSafe_DB($_REQUEST['cl']) . "," . StrSafe_DB(substr($_REQUEST['col'], 1)) . "," . StrSafe_DB($_REQUEST['ath']) . ", " . StrSafe_DB($_REQUEST['titlereverse']) . ", " . StrSafe_DB($_REQUEST['area0']) . ", " . StrSafe_DB($_REQUEST['area1']) . ", " . StrSafe_DB($_REQUEST['area2']) . ", " . StrSafe_DB($_REQUEST['area3']) . ", " . StrSafe_DB($_REQUEST['area4']) . ", " . StrSafe_DB($_REQUEST['area5']) . ", " . StrSafe_DB($_REQUEST['area6']) . ", " . StrSafe_DB($_REQUEST['area7']) . ", " . StrSafe_DB($_REQUEST['areastar']) . ", " . StrSafe_DB($_REQUEST['transport']) . ", " . StrSafe_DB($_REQUEST['accomodation']) . ", " . StrSafe_DB($_REQUEST['meal']) . ") ";
//print $query;exit;
$rs = safe_w_sql($query);
if (!$rs) {
$Errore = 1;
}
} else {
$Errore = 1;
}
} else {
$Errore = 1;
}
header('Content-Type: text/xml');
print '<response>' . "\n";
print '<error>' . $Errore . '</error>' . "\n";
print '<rowid>' . $_REQUEST['rowid'] . '</rowid>';
print '<cl>' . $_REQUEST['cl'] . '</cl>';
print '<ath>' . ($_REQUEST['ath'] == 1 ? get_text('Yes') : get_text('No')) . '</ath>' . "\n";
print '<titlereverse>' . ($_REQUEST['titlereverse'] == 1 ? get_text('Yes') : get_text('No')) . '</titlereverse>' . "\n";
print '<col>' . substr($_REQUEST['col'], 1) . '</col>' . "\n";
print '<area><![CDATA[';
define('debug', false);
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Qualification/Fun_Qualification.local.inc.php';
require_once 'Common/Fun_Sessions.inc.php';
require_once 'Common/Lib/Obj_RankFactory.php';
if (!CheckTourSession()) {
print get_text('CrackError');
exit;
}
$Errore = 0;
$Cosa = "";
$Atleta = "";
$Fase = "";
foreach ($_REQUEST as $Key => $Value) {
if (substr($Key, 0, 2) == 'd_') {
if (!IsBlocked(BIT_BLOCK_ELIM)) {
list(, $Cosa, $Atleta, $Fase) = explode('_', $Key);
/*
Devo estrarre il vecchio valore dal db perchè solo se cambia qualcosa devo azzerare
il flag di shootoff. Dato che in ogni caso ho un update del timestamp, l'affected_rows ritornerebbe sempre 1.
*/
$Sel = "SELECT " . $Cosa . " AS OldValue " . "FROM Eliminations " . "WHERE ElId=" . StrSafe_DB($Atleta) . " AND ElElimPhase=" . StrSafe_DB($Fase);
$RsSel = safe_r_sql($Sel);
$OldValue = '';
if (safe_num_rows($RsSel) == 1) {
$rr = safe_fetch($RsSel);
$OldValue = $rr->OldValue;
}
// seleziono il max punteggio possibile se devo scrivere lo score
if (strpos($Key, 'Score') !== false) {
$MaxScore = 0;
// rank abs sulla distanza
CalcRank($Dist);
// rank abs totale
CalcRank(0);
// squadre
MakeTeams(NULL, NULL);
MakeTeamsAbs(NULL, null, null);
$Msg .= get_text('CmdImport', 'HTT') . ": " . get_text('CmdOk');
}
if (!empty($_SESSION['OvrHost'])) {
OvrExport($xSession, $Dist, $LastArr);
}
} else {
$Sql = "SELECT HhtData.* " . "FROM HhtData " . ($team == 0 ? "INNER JOIN Finals ON HdEvent=FinEvent AND HdMatchNo=FinMatchNo AND HdTournament=FinTournament AND HdTeamEvent=0 " : "INNER JOIN TeamFinals ON HdEvent=TfEvent AND HdMatchNo=TfMatchNo AND HdTournament=TfTournament AND HdTeamEvent=1 ") . "WHERE HdFinScheduling=" . StrSafe_DB($when) . " AND HdTeamEvent=" . StrSafe_DB($team) . " AND HdArrowStart=" . StrSafe_DB($FirstArr) . " AND HdTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND HdHhtId=" . StrSafe_DB($_REQUEST['x_Hht']) . " " . "ORDER BY HdTargetNo ASC ";
$Rs = safe_r_sql($Sql);
if (safe_num_rows($Rs) > 0 && !IsBlocked($team == 0 ? BIT_BLOCK_IND : BIT_BLOCK_TEAM)) {
while ($myRow = safe_fetch($Rs)) {
UpdateArrowString($myRow->HdMatchNo, $myRow->HdEvent, $myRow->HdTeamEvent, $myRow->HdArrowString, $myRow->HdArrowStart, $myRow->HdArrowEnd);
$Msg .= get_text('Importing', 'HTT', substr($myRow->HdTargetNo, 0)) . '...' . get_text('CmdOk') . '<br>';
}
}
}
} else {
$Msg = '<strong>' . get_text('SetDistanceError', 'HTT') . '</strong>';
}
}
//exit;
}
$PAGE_TITLE = get_text('CmdImport', 'HTT');
include 'Common/Templates/head.php';
?>
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'TV/Fun_HTML.local.inc.php';
$TourId = 0;
if (!empty($_SESSION['TourId'])) {
$TourId = $_SESSION['TourId'];
}
if (!empty($_REQUEST['TourId'])) {
$TourId = $_REQUEST['TourId'];
}
if (!IsBlocked(BIT_BLOCK_MEDIA)) {
if ($TourId and !empty($_POST['NewRule'])) {
$q = safe_r_sql("SELECT IFNULL(MAX(TVRId),0) AS CurID FROM TVRules WHERE TVRTournament={$TourId}");
$newID = safe_fetch($q)->CurID + 1;
safe_w_sql("INSERT INTO TVRules set TVRId={$newID}, TVRTournament={$TourId}, TVRName=" . strsafe_DB($_POST['NewRule']));
$_GET = array();
cd_redirect(go_get('edit', $newID));
}
// cancella la regola e le sue associazioni
if (!empty($_GET['delete'])) {
$IDrule = intval($_GET['delete']);
// controlla che non sia una regola predefinita (IDtour = -1)
$q = safe_r_sql("SELECT * FROM TVRules WHERE TVRId={$IDrule} AND TVRTournament={$TourId}");
if (!($r = safe_fetch($q))) {
cd_redirect();
}
// non esiste la regola o
$q = safe_r_sql("SELECT * FROM TVSequence WHERE TVSTable='DB' AND TVSRule={$IDrule} AND TVSTournament={$TourId}");
while ($r = safe_fetch($q)) {
$UpdateFinsReview = isset($_GET['UpdateFinsReview']);
$UpdateTeamReview = isset($_GET['UpdateTeamReview']);
$Timed = isset($_GET['Timed']);
if (isset($_GET['EventName'])) {
$EventName = stripslashes($_GET['EventName']);
}
if (isset($_GET['EventPhase'])) {
$EventPhase = stripslashes($_GET['EventPhase']);
}
if (isset($_GET['TimeStamp'])) {
$TimeStamp = stripslashes($_GET['TimeStamp']);
}
$UpdateTourImg = isset($_GET['UpdateTourImg']);
$UpdateFinImg = isset($_GET['UpdateFinImg']);
}
if (IsBlocked(BIT_BLOCK_PUBBLICATION) or !$AllParamGood or !$UpdateBase and !$UpdateFinImg and !$UpdateTourImg and !$UpdateFins and !$UpdateTeam and !$UpdateFinsReview and !$UpdateTeamReview) {
if (isset($argv)) {
echo "\n\nSyntax: " . basename(__FILE__) . " [UpdateBase] [UpdateTourImg] [UpdateFins] [UpdateTeam] [UpdateFinsReview] [UpdateTeamReview] [Timed | TimeStamp=n] [TournamentId=n] [EventName=n] [EventPhase=n]\n\n";
} else {
print_config();
}
die;
}
// array of Data to send
$DATA = array('OnlineId' => $_SESSION['OnlineId'], 'OnlineEventCode' => $_SESSION['OnlineEventCode'], 'OnlineAuth' => $_SESSION['OnlineAuthA2A'], 'QUERIES' => array(), 'IMG' => array());
if ($UpdateTourImg) {
// Updates Tour Images!
$q = safe_r_sql("select * from Tournament where ToId={$_SESSION['TourId']}");
$r = safe_fetch($q);
if ($r->ToImgL) {
$DATA['IMG']['TOPLEFT'] = $r->ToImgL;
