function decode_chain($row, $edit = true) { $ret = ''; $ret .= '<tr>'; $ret .= '<td>' . $row->TVSOrder . '</td>'; if ($edit) { $ret .= '<td>'; $ret .= '<a href="' . go_get('ChainId', $row->TVSId) . '">edit</a>'; $ret .= ' <a href="' . go_get('ChainDel', $row->TVSId) . '" onclick="return confirm(\'' . get_text('MsgAreYouSure') . '\')">del</a>'; if ($row->TVSOrder != 1) { $ret .= ' <a href="' . go_get(array('ChainId' => $row->TVSId, 'from' => $row->TVSOrder, 'to' => $row->TVSOrder - 1)) . '">up</a>'; } else { $ret .= ' <i>up</i>'; } if (!$row->last) { $ret .= ' <a href="' . go_get(array('ChainId' => $row->TVSId, 'from' => $row->TVSOrder, 'to' => $row->TVSOrder + 1)) . '">down</a>'; } else { $ret .= ' <i>down</i>'; } $ret .= '</td>'; } if ($row->TVSTable == 'DB') { $q = safe_r_sql("select * from TVParams where TVPId={$row->TVSContent} AND TVPTournament={$row->TVSTournament}"); if ($r = safe_fetch($q)) { $ret .= '<td>' . get_text('Tournament', 'Tournament') . '</td>'; $ret .= '<td>' . $r->TVPPage . '</td>'; $w = array(); if (strlen($r->TVPEventInd)) { $w[] = 'Events: ' . $r->TVPEventInd; } if (strlen($r->TVPEventTeam)) { $w[] = 'Events: ' . $r->TVPEventTeam; } if (strlen($r->TVPPhasesInd)) { $w[] = 'Phases: ' . $r->TVPPhasesInd; } if (strlen($r->TVPPhasesTeam)) { $w[] = 'Phases: ' . $r->TVPPhasesTeam; } if ($r->TVPColumns) { $w[] = 'Columns: ' . $r->TVPColumns; } $ret .= '<td>' . ($w ? implode('<br/>', $w) : ' ') . '</td>'; $ret .= '<td>' . ($r->TVP_Carattere ? ' ' : 'X') . '</td>'; } } elseif ($row->TVSTable == 'MM') { $q = safe_r_sql("select * from TVContents where TVCId={$row->TVSContent} AND TVCTournament=" . ($row->TVSCntSameTour == 1 ? $row->TVSTournament : '-1')); if ($r = safe_fetch($q)) { $ret .= '<td>' . get_text('Multimedia', 'Tournament') . '</td>'; $ret .= '<td>' . $r->TVCName . '</td>'; $ret .= '<td>' . $row->TVSTime . '</td>'; $ret .= '<td>' . $row->TVSScroll . '</td>'; } } $ret .= '</tr>'; return $ret; }
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)) { 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}");
// Data passata header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1 header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); //Impostazione del Coockie per il linguaggio if (isset($_REQUEST["SetLanguage"]) && preg_match("/^[A-Z]{2}(-[A-Z]{2})*\$/i", $_REQUEST["SetLanguage"])) { $TmpLang = strtolower($_REQUEST["SetLanguage"]); if (!file_exists($CFG->LANGUAGE_PATH . $TmpLang . '/' . $TmpLang . '.txt')) { $TmpLang = "en"; } setcookie("UseLanguage", strtoupper($TmpLang), time() + 604800, '/'); $_COOKIE["UseLanguage"] = strtoupper($TmpLang); set_collation(get_text('MySqlCollation')); header("Location: " . $_SERVER['PHP_SELF'] . go_get('SetLanguage', '', true)); } // funzione per l'internazionalizzazione function get_text($text, $module = 'Common', $a = '', $translate = false, $force = false, $ForceLang = '') { static $_LANG; global $Arr_StrStatus, $CFG; if ($module == 'ReturnLangArray') { return $_LANG; } if ($ForceLang) { $lingua = strtolower($ForceLang); } else { $lingua = strtolower(SelectLanguage($force)); } if (!$module) {
$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
?> </th> <td> <table> <?php $ActId = $MMId; if (isset($CHAIN->TVSCntSameTour)) { $ActId .= '|' . $CHAIN->TVSCntSameTour; } while ($r = safe_fetch($q)) { $sel = $r->TVCId . '|' . ($r->TVCTournament != -1 ? '1' : '0'); echo '<tr><td><input type="radio" name="d_TVMultimedia" value="' . $sel . '"' . ($sel == $ActId ? ' checked="checked"' : '') . '></td>'; echo '<td>' . $r->TVCName . '</td>'; echo '<td>'; if ($r->TVCTournament != -1) { echo '<a href="' . go_get('contdel', $r->TVCId) . '"><img src="../Common/Images/drop.png" border="0"></a>'; } else { echo ' '; } echo '</td></tr>'; } ?> </table> </td> <td><?php print get_text('TVSelectMultimediaDescr', 'Tournament'); ?> </td> </tr> <tr>
if ($quadro < $RuleOrder) { $pagina = ''; } } $Styles[$quadro] = $Event['style']; $quadro++; if (!empty($pagina)) { break 2; } } } if (!$pagina) { $pagina = $firstdiv; $quadro = 0; } $NextRule = $CFG->ROOT_DIR . 'TV/' . basename(__FILE__) . go_get(array('Rule' => $RuleId, 'Tour' => $TourCode, 'Order' => $quadro)); include 'Common/Templates/head-html-lightrot.php'; print $pagina; include 'Common/Templates/tail-html-rot.php'; function Genera_content_rot($Content, $Segment) { static $static = 0; global $CFG; $ret = array(); $ret['cols'] = ''; $ret['head'] = ''; $ret['fissi'] = ''; $ret['type'] = 'MM'; $ret['style'] = ''; $ret['js'] = 'timeStop[%1$s]=' . intval($Segment->TVSTime * 1000 / $Segment->TVSScroll) . ";\n"; $ret['js'] .= 'timeScroll[%1$s]=' . $Segment->TVSScroll . ";\n";
<td colspan="4" class="Center"><input type="submit" value="<?php echo get_text('MsgSyncronize', 'Tournament'); ?> "></td> </tr> <tr><th colspan="4"><?php echo '<input type="checkbox" name="PrevPhoto"' . (empty($_REQUEST['PrevPhoto']) ? '' : ' checked="checked"') . ' onclick="window.location.href=\'' . basename(__FILE__) . (empty($_REQUEST['PrevPhoto']) ? '?PrevPhoto=on' : '') . '\'">' . get_text('PreviousPhotos', 'Tournament'); ?> </th></tr> <?php // check if there are some photos in this tournament... if (!empty($_REQUEST['PrevPhoto'])) { $q = safe_r_SQL("select * from Entries\r\n\t\t\tinner join (select PhEnId OtPhEnId, EnCode OtEnCode, EnIocCode OtEnIocCode, EnTournament OtEnTournament, ToCode OtToCode, ToName OtToName\r\n\t\t\t\tfrom Entries\r\n\t\t\t\tinner join Photos on PhEnId=EnId\r\n\t\t\t\tinner join Tournament on EnTournament=ToId) Ot on EnCode=OtEnCode and EnIocCode=OtEnIocCode\r\n\t\t\twhere EnId not in (select PhEnId from Photos inner join Entries on PhEnId=EnId and EnTournament={$_SESSION['TourId']})\r\n\t\t and EnTournament={$_SESSION['TourId']}\r\n\t\t\torder by EnCode, OtPhEnId desc"); while ($r = safe_fetch($q)) { echo '<tr>'; echo '<td><a href="' . go_get(array('EnId' => $r->EnId, 'PhEnId' => $r->OtPhEnId)) . '">' . $r->EnFirstName . ' ' . $r->EnName . '</a></td>'; echo '<td><img src="../Partecipants-exp/common/photo.php?id=' . $r->OtPhEnId . '&mode=y&val=50"></td>'; echo '<td>' . $r->OtToCode . '</td>'; echo '<td>' . $r->OtToName . '</td>'; echo '</tr>'; } } ?> </table> </form> <?php } else { //ini_set('memory_limit', '512M'); set_time_limit(0); $CFG->TRACE_QUERRIES = false; require_once 'Common/Lib/Fun_DateTime.inc.php';
?> </td> </tr> <tr> <th class="TitleLeft" width="15%"><?php print get_text('TVPresetChains', 'Tournament'); ?> </th> <td><?php echo preset_chains(); ?> </td> </tr> <tr><td colspan="2"></td></tr> <tr><td class="Center" colspan="2"><a href="<?php echo go_get('NewDb', 1); ?> "><?php print get_text('NewTourContent', 'Tournament'); ?> </a> <a href="<?php echo go_get('NewMm', 1); ?> "><?php print get_text('NewMediaContent', 'Tournament'); ?> </a></td></tr>