} // 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');