}
// 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)) {
safe_w_sql("DELETE FROM TVParams WHERE TVPId={$r->TVSContent} AND TVPTournament={$TourId}");
}
safe_w_sql("DELETE FROM TVRules WHERE TVRId={$IDrule} AND TVRTournament={$TourId}");
safe_w_sql("DELETE FROM TVSequence WHERE TVSRule={$IDrule} AND TVSTournament={$TourId}");
cd_redirect();
}
if (!empty($_GET['edit'])) {
$IDrule = intval($_GET['edit']);
// controlla che non sia una regola predefinita (IDtour = -1)
$q = safe_r_sql("SELECT * FROM TVRules WHERE TVRId={$IDrule} AND TVRTournament={$TourId}");
if (!($RULE = safe_fetch($q))) {
cd_redirect();
}
// non esiste la regola
define('IN_PHP', true);
include 'EditRule.php';
exit;
}
}
$JS_SCRIPT = array("<style>\n#Content .Tabella tr.alt {\n\tbackground-color:rgb(200,200,200)\n\t}\n</style>\n");
$PAGE_TITLE = get_text('TVOutRulesWithStart', 'Tournament');
include 'Common/Templates/head.php';
?>
<div align="center">
<div class="medium">
<form method="POST">
<table class="Tabella">
imagejpeg($img, $imgJPG, 95);
}
break;
case 'image/jpg':
case 'image/jpeg':
$imgJPG = $_FILES['JPG']['tmp_name'][$edit];
break;
default:
debug_svela($_FILES['JPG']);
cd_redirect('Countries.php#' . $edit);
}
$Image = addslashes(base64_encode(file_get_contents($imgJPG)));
safe_w_sql("insert into Flags set FlCode='{$edit}', FlJPG='{$Image}', FlTournament={$_SESSION['TourId']} " . " on duplicate key update FlJPG='{$Image}'");
unlink($imgJPG);
}
cd_redirect('Countries.php#' . $edit);
}
require_once 'Common/CheckPictures.php';
CheckPictures();
$PAGE_TITLE = get_text('TourCountries', 'Tournament');
include 'Common/Templates/head.php';
echo '<form method="POST" ENCTYPE="multipart/form-data">';
echo '<table class="Tabella">';
echo '<tr>';
echo '<td colspan="4">';
echo '<a href="../Final/Team/PrnName.php?TeamLabel=1" target="_blank">' . get_text('TeamPlace', 'Tournament') . '</a>';
echo ' <a href="../Final/Team/PrnName.php?TeamLabel=1&local=1" target="_blank">' . get_text('TeamPlaceLocal', 'Tournament') . '</a>';
echo '</td>';
echo '</tr>';
echo '<tr>';
echo '<th class="Title" width="15%" nowrap="nowrap">' . get_text('Country') . '</th>';
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
CheckTourSession(true);
require_once 'Common/Fun_FormatText.inc.php';
if (!empty($_FILES) and !empty($_FILES['ImportBackNumbers']['tmp_name'])) {
$Bns = unserialize(gzuncompress(implode('', file($_FILES['ImportBackNumbers']['tmp_name']))));
foreach ($Bns as $Bn) {
unset($Bn->BnTournament);
unset($Bn->BnFinal);
$sql = "replace into BackNumber set BnTournament={$_SESSION['TourId']}";
foreach ($Bn as $field => $value) {
$sql .= ", {$field}=" . StrSafe_DB($value);
}
$sql .= ", BnFinal=1";
safe_w_sql($sql);
}
cd_redirect(basename(__FILE__));
}
$JS_SCRIPT = array('<script type="text/javascript" src="../../Common/Fun_JS.inc.js"></script>', '<script type="text/javascript">', 'function DisableChkOther(NoDist, NumDist)', '{', ' if(NoDist)', ' {', ' if(document.getElementById(\'ChkDist0\').checked)', ' {', ' for(i=1; i<=NumDist; i++)', ' document.getElementById(\'ChkDist\'+i).checked=false;', ' }', ' }', ' else', ' {', ' for(i=1; i<=NumDist; i++)', ' {', ' if(document.getElementById(\'ChkDist\'+i).checked)', ' document.getElementById(\'ChkDist0\').checked=false;', ' }', ' }', '', '}', '</script>');
include 'Common/Templates/head.php';
echo '<table class="Tabella">';
echo '<tr><th class="Title" colspan="2">' . get_text('PrintBackNo', 'BackNumbers') . '</th></tr>';
//Parametri
echo '<tr>';
//Pettorali Personali
echo '<td class="Center" width="60%"><br><a href="PDFBackNumber.php" class="Link" target="PrintOut">';
echo '<img src="../../Common/Images/pdf.gif" alt="' . get_text('IndFinal') . '" border="0"><br>';
echo get_text('IndFinal');
echo '</a></td>';
echo '<td class="Center" width="40%" rowspan="2">';
$t = safe_r_sql("SELECT * FROM BackNumber WHERE BnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND BnFinal in (0,1) order by BnFinal desc");
if (safe_num_rows($t)) {
$_SESSION['OnlineAuth'] = stripslashes($_REQUEST['OnlineAuth']);
}
if ($varResponse[0] == 'OK' or $varResponse[0] == 'OK-2') {
$_SESSION['OnlineAuthA2A'] = stripslashes($_REQUEST['OnlineAuthA2A']);
}
$_SESSION['OnlineId'] = intval($_REQUEST['OnlineId']);
$_SESSION['OnlineEventCode'] = $code;
$return = 'Tournament/UploadResults.php';
if (!empty($_REQUEST['return'])) {
$return = $_REQUEST['return'];
}
// No header images for PDF...
$_SESSION['SendOnlinePDFImages'] = trim($varResponse[1]) ? false : true;
// sets the online code inside the tournament...
safe_w_SQL("update Tournament set ToOnlineId=" . intval($_REQUEST['OnlineId']) . " where ToId={$_SESSION['TourId']}");
cd_redirect($CFG->ROOT_DIR . $return);
} else {
$ErrorMessage = get_text($varResponse[0], 'Tournament');
}
}
}
$onlineId = empty($_SESSION['OnlineId']) ? '' : $_SESSION['OnlineId'];
$onlineAuth = empty($_SESSION['OnlineAuth']) ? '' : $_SESSION['OnlineAuth'];
$onlineAuthA2A = empty($_SESSION['OnlineAuthA2A']) ? '' : $_SESSION['OnlineAuthA2A'];
$onlineEventCode = empty($_SESSION['OnlineEventCode']) ? 0 : $_SESSION['OnlineEventCode'];
$PAGE_TITLE = get_text('SetCredentials', 'Tournament');
include 'Common/Templates/head.php';
?>
<div align="center">
<form name="Frm" method="POST" action="">
<input type="hidden" name="Command" value="OK">
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/Fun_FormatText.inc.php';
//print_r($_REQUEST);exit;
CheckTourSession(true);
$BackNoFinal = 0;
if (!empty($_REQUEST["BackNo"])) {
$BackNoFinal = max(0, intval($_REQUEST['BackNo']));
}
if ($BackNoFinal > 4) {
$BackNoFinal = 0;
}
if (isset($_REQUEST["deleteLayout"])) {
safe_w_sql("DELETE FROM BackNumber WHERE BnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND BnFinal=" . StrSafe_DB($BackNoFinal));
cd_redirect('BackNumber.php?BackNo=' . $BackNoFinal);
}
$RowBn = NULL;
$Select = "(SELECT BackNumber.*, LENGTH(BnBackground) as ImgSize, 1 as Customized " . "FROM BackNumber " . "WHERE BnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND BnFinal=" . StrSafe_DB($BackNoFinal) . ")" . "UNION " . "(SELECT BackNumber.*, LENGTH(BnBackground) as ImgSize, 0 as Customized " . "FROM BackNumber " . "WHERE BnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND BnFinal=0) " . "LIMIT 1";
$Rs = safe_r_sql($Select);
if (safe_num_rows($Rs) == 1) {
$RowBn = safe_fetch($Rs);
} else {
include 'Tournament/BackNumberEmpty.php';
$RowBn = emptyBackNumber();
}
if (isset($_REQUEST["Submit"])) {
$TmpUpdate = '';
foreach ($_REQUEST as $Key => $Value) {
if (substr($Key, 0, 2) == 'Bn') {
if (is_array($Value)) {
$multimedia[] = "TVSFullScreen=" . StrSafe_DB(isset($_POST['d_TVMultimediaFullScreen']));
// update the TVSequence to the correct media
if ($ChainId) {
safe_w_sql("UPDATE TVSequence SET " . implode(',', $multimedia) . " WHERE TVSId={$ChainId} AND TVSTournament={$TourId}");
} else {
$multimedia[] = "TVSRule={$RuleId}";
$multimedia[] = "TVSTable='MM'";
$multimedia[] = "TVSOrder={$NewOrder}";
$q = safe_r_sql("SELECT IFNULL(MAX(TVSId),0) AS CurID FROM TVSequence WHERE TVSTournament={$TourId}");
$ChainId = safe_fetch($q)->CurID + 1;
safe_w_sql("INSERT INTO TVSequence SET TVSId={$ChainId}, TVSTournament={$TourId}, " . implode(',', $multimedia));
}
}
}
unset($_GET['ChainId']);
cd_redirect(go_get(array('NewDb' => '', 'NewMm' => ''), true));
}
$JS_SCRIPT = array('<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/ajax/ObjXMLHttpRequest.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'TV/FuncRot.js"></script>', '<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/ColorPicker/302pop.js"></script>');
$PAGE_TITLE = get_text('TVManagingRule', 'Tournament', ManageHTML($RULE->TVRName));
if ($DBId) {
$Select = "SELECT * FROM TVParams " . "WHERE TVPId={$DBId} " . "AND TVPTournament={$TourId}";
$Rs = safe_r_sql($Select);
if ($r = safe_fetch($Rs)) {
$ONLOAD = ' onload="GetRuleSel(\'' . $r->TVPPage . '\', ' . $DBId . ')"';
}
}
include 'Common/Templates/head.php';
?>
<form name="Frm" method="post" action="" enctype="multipart/form-data" onsubmit="clearHiddenFields(this)">
<table class="Tabella">
<tr><th class="Title" colspan="2"><?php
* IF(evento) --> Finale individuale dell'evento (evento) (Rank)
* TF(evento) --> Finale a squadre dell'evento (Rank)
* IB(evento) --> Finale individuale dell'evento (evento) (Bracket)
* TB(evento) --> Finale a squadre dell'evento (evento) (Bracket)
*
* MEDSTD --> Medal standing
* MEDLST --> Medal list
*/
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Qualification/Fun_Qualification.local.inc.php';
CheckTourSession(true);
if (!empty($CFG->OVERRIDES) and !empty($CFG->SendToIanseo)) {
$URL = $CFG->SendToIanseo;
}
if (empty($_SESSION['OnlineId']) or empty($_SESSION['OnlineAuth']) and empty($_SESSION['OnlineAuthA2A']) or empty($_SESSION['OnlineEventCode'])) {
cd_redirect('SetCredentials.php?return=Tournament/' . basename(__FILE__));
}
$MSG = '';
$ORIS = $_SESSION['ISORIS'];
if ($_POST) {
//debug_svela($_POST);
$RET = new StdClass();
require_once 'Common/OrisFunctions.php';
// WE ONLY SEND ORIS STUFF
$ORIS = !empty($_POST['oris']);
//$ORIS=true;
if (!defined('PRINTLANG')) {
if ($ORIS) {
define('PRINTLANG', 'EN');
} else {
define('PRINTLANG', $_SESSION['TourPrintLang']);
}
}
if (!empty($_REQUEST['DoPrint'])) {
$FIELDS = "EnId";
$SORT = 'EnId';
require_once 'CommonCard.php';
$IDs = array();
$q = safe_r_sql($MyQuery);
while ($r = safe_fetch($q)) {
$IDs[] = $r->EnId;
}
sort($IDs);
if ($IDs) {
safe_w_sql("update Entries set EnBadgePrinted=now() where EnId in (" . implode(',', $IDs) . ") ");
}
cd_redirect($_SERVER['SCRIPT_NAME']);
}
$Badges = array();
$t = safe_r_sql("SELECT * FROM IdCards WHERE IcTournament=" . StrSafe_DB($_SESSION['TourId']));
if (safe_num_rows($t)) {
$Badges['CardCustom.php'] = get_text('BadgeCustom', 'BackNumbers');
}
$Badges['Card.php'] = get_text('BadgeStandard', 'Tournament');
$Badges['Cardx6.php'] = get_text('BadgeStandard6', 'Tournament');
// select sessions
$SesNo = 0;
$sessions = GetSessions('Q', true);
$JS_SCRIPT = array('<script type="text/javascript" src="' . $CFG->ROOT_DIR . 'Common/ajax/ObjXMLHttpRequest.js"></script>', '<script type="text/javascript" src="Fun_AJAX_IdCards.js"></script>');
$JS_SCRIPT[] = '<script type="text/javascript">';
$JS_SCRIPT[] = ' var SesNo=' . $SesNo . ';';
// $JS_SCRIPT[]=' Ext.onReady';
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
if (!empty($_REQUEST['SetCamUrl'])) {
setcookie("CamUrl", $_REQUEST['SetCamUrl'], strtotime("+1 year"));
/* expire in 1 year */
cd_redirect('Configuration.php');
}
/*
http://localhost:8080/requests/status.xml?command=pl_stop
http://localhost:8080/requests/status.xml?command=pl_pause&id=12
http://localhost:8080/requests/status.xml?command=in_play&input=v4l2%3A%2F%2F%2Fdev%2Fvideo0%20%20%20%20%3Asout%3D%23transcode{ vcodec=mjpg, fps=1, width=640, height=480 }:standard{ access=http, mux=mpjpeg, dst=0.0.0.0:8050/stream.mjpg }
*/
$JS_SCRIPT = array('<script type="text/javascript" src="Fun_AJAX_GetImage.js"></script>', '<script type="text/javascript" src="../Fun_JS.js"></script>');
$ONLOAD = ' onLoad="javascript:reloadPicture()"';
include 'Common/Templates/head.php';
?>
<style>
.Para {margin-top:1em;}
pre {border:1px solid black; padding:3px; margin:0;}
</style>
<form>
<table class="Tabella">
<tr>
<th class="Title"><?php
echo get_text('CamUrlSocket', 'Tournament');
?>
</th>
<th class="Title"><?php
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Common/Fun_Phases.inc.php';
CheckTourSession(true);
if (empty($_SESSION['OnlineAuthA2A'])) {
cd_redirect($CFG->ROOT_DIR . 'Tournament/SetCredentials.php?sector=A2A&return=Modules/UpdateWeb/UpdateWeb.php');
}
// VERSION 0.2010-07-13-08.25
/************************************
CONFIGURATION SECTION
*************************************/
// Error on video! Only debug purpose
define('ERROR_REPORT', true);
// Time between 2 reloads (only web interface and if Timed is selected!
$REFRESH = 20;
// array of web listeners
$LISTENERS = array('http://www.ianseo.net/TourGetArrows.php');
/******************************************
END CONFIGURATION
******************************************/
/**********************************************
GET VARIABLES from outside...
***********************************************/
// The Local DB will be updated to this time of syncro
function check_write_DB($tipo, $W_HOST, $W_USER, $W_PASS)
{
global $CFG, $WRIT_CON;
$a = safe_w_con(true);
// ritorna con l'errore di collegamento
$testi = $tipo == 'W' ? 'Write' : 'Read';
if ($a == 'CONNECTION_FAILED' or is_array($a)) {
// se è stata fornita la password di root, proviamo a collegarci come root
if (isset($_POST[$tipo . '_ROOT'])) {
$CFG->W_USER = '******';
$CFG->W_PASS = stripslashes(trim($_POST[$tipo . '_ROOT']));
$a = safe_w_con(true);
if ($a == 'CONNECTION_FAILED') {
$_SESSION['INSTALL']['CFG']['ERROR'] = get_text($testi . ' connection failed', 'Install');
cd_redirect('?step=2');
}
if (is_array($a) and $a[1] == 'NO_DATABASE') {
// beh... bisogna creare il DB :)
$WRIT_CON = $a[0];
safe_w_sql("CREATE DATABASE `{$CFG->DB_NAME}` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
// poi garantire l'accesso all'utente
safe_w_sql("grant all privileges on `" . $CFG->DB_NAME . "`.* to '{$W_USER}'@'{$W_HOST}' identified by '" . addslashes($W_PASS) . "';");
// infine inserire nel DB la struttura di base
// ma prima rimuovere la connessione per forzarne una nuova
$WRIT_CON = null;
$CFG->W_USER = $W_USER;
$CFG->W_PASS = $W_PASS;
install_blank_db();
// e ritorna falso (creato ex novo)
return false;
}
} elseif (is_array($a) and $a[1] == 'NO_DATABASE') {
$_SESSION['INSTALL']['CFG']['ERROR'] = get_text($testi . ' Database not present', 'Install');
cd_redirect('?step=2');
}
// in ogni caso ritorna sulla pagina via un get per eliminare i POST
$_SESSION['INSTALL']['CFG']['ERROR'] = get_text($testi . ' connection failed', 'Install');
cd_redirect('?step=2');
}
// se la connessione è stata stabilita senza problemi bisogna fare il dump
// quindi ritorna true!
return true;
}
define('debug', false);
// settare a true per l'output di debug
require_once dirname(dirname(__FILE__)) . '/config.php';
CheckTourSession(true);
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Fun_Sessions.inc.php';
if (isset($_REQUEST['Exec']) && $_REQUEST['Exec'] == 'OK') {
if (isset($_SESSION['chk_Turni'])) {
unset($_SESSION['chk_Turni']);
}
if (!empty($_REQUEST['chk_Turni']) && is_array($_REQUEST['chk_Turni'])) {
foreach ($_REQUEST['chk_Turni'] as $Key => $Value) {
$_SESSION['chk_Turni'][$Key] = $Value;
}
$_SESSION['AccOp'] = $_REQUEST['AccOp'];
cd_redirect('Accreditation.php');
exit;
}
}
include 'Common/Templates/head.php';
?>
<form name="FrmSelect" method="get" action="">
<input type="hidden" name="Exec" value="OK">
<table class="Tabella">
<tr><th class="Title" colspan="2"><?php
echo get_text('Accreditation', 'Tournament');
?>
</th></tr>
<tr>
<th class="Title" width="50%"><?php
echo get_text('Session');
