<?php require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Common/Fun_FormatText.inc.php'; $CFG->TRACE_QUERRIES = false; if (!empty($_SESSION['TourId'])) { $TourId = $_SESSION['TourId']; } if (isset($_REQUEST['TourCode'])) { $TourId = getIdFromCode($_REQUEST['TourCode']); } if (empty($TourId)) { print get_text('CrackError'); exit; } include 'Common/Fun_Export.php'; $Gara = export_tournament($TourId, !empty($_REQUEST['Complete'])); // We'll be outputting a gzipped TExt File in UTF-8 pretending it's binary header('Content-type: application/octet-stream'); // It will be called ToCode.ianseo header("Content-Disposition: attachment; filename=\"{$Gara['Tournament']['ToCode']}.ianseo\""); ini_set('memory_limit', sprintf('%sM', 512)); //debug_svela($Gara, true); // The PDF source is in original.pdf echo gzcompress(serialize($Gara), 9); exit;
$ElimEvent = array(1 => 0, 2 => 0); for ($i = 1; $i <= 2; ++$i) { $Select = "SELECT EvCode FROM Events " . "WHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvElim" . $i . ">0 AND EvE" . $i . "ShootOff=1 "; $Rs = safe_r_sql($Select); if ($Rs && safe_num_rows($Rs) > 0) { $ElimEvent[$i] = safe_num_rows($Rs); } } list($asc, ) = ExportASC(); /* * preparo il vettore con i file che non sono pdf * Mentre lo faccio inizializzo il vettore per ciclare tra i pdf */ $pdfFiles = array($ToCode . '_report.pdf' => dirname(__FILE__) . '/FinalReport/PDFReport.php', $ToCode . '.pdf' => dirname(dirname(__FILE__)) . '/Qualification/PrnIndividual.php', $ToCode . '_team.pdf' => dirname(dirname(__FILE__)) . '/Qualification/PrnTeam.php'); $Tour = array(); $Tour[$ToCode . '.ianseo'] = gzcompress(serialize(export_tournament($_SESSION['TourId'], false))); $Tour[$ToCode . '.asc'] = $asc; $Tour[$ToCode . '.lst'] = ExportLSTInd(); $Tour[$ToCode . '_team.lst'] = ExportLSTTeam(); if ($ElimEvent[1] > 0 || $ElimEvent[2] > 0) { //$Tour[$ToCode . '_elim.pdf'] = URLWrapper($CFG->ROOT_DIR .'Elimination/PrnIndividual.php?Lang=' . SelectLanguage(). '&TourId=' . $_SESSION['TourId'] . '&ToFitarco=ignored&Dest=S'); $pdfFiles[$ToCode . '_elim.pdf'] = dirname(dirname(__FILE__)) . '/Elimination/PrnIndividual.php'; } if ($FinEventInd > 0) { $Tour[$ToCode . '_rank.lst'] = ExportLSTFinInd(); //$Tour[$ToCode . '_rank.pdf'] = URLWrapper( $CFG->ROOT_DIR . 'Final/Individual/PrnRanking.php?Lang=' . SelectLanguage(). '&TourId=' . $_SESSION['TourId'] . '&ToFitarco=ignored&Dest=S'); //$Tour[$ToCode . '_grid.pdf'] = URLWrapper( $CFG->ROOT_DIR . 'Final/Individual/PrnBracket.php?Lang=' . SelectLanguage(). '&TourId=' . $_SESSION['TourId'] . '&ToFitarco=ignored&Dest=S'); $pdfFiles[$ToCode . '_abs.pdf'] = dirname(dirname(__FILE__)) . '/Qualification/PrnIndividualAbs.php'; $pdfFiles[$ToCode . '_rank.pdf'] = dirname(dirname(__FILE__)) . '/Final/Individual/PrnRanking.php'; $pdfFiles[$ToCode . '_grid.pdf'] = dirname(dirname(__FILE__)) . '/Final/Individual/PrnBracket.php'; }
// per ora faremo solo un dump completo del DB // che verrà salvato come data-ora/ianseodump.sql $working_dir = dirname($_SERVER['SCRIPT_FILENAME']) . "/dbdumps/" . date('Ymd-His'); mkdir($working_dir, 0777); $SQLfilename = $working_dir . "/ianseodump.sql"; exec("mysqldump -Q -h'{$W_HOST}' -u'" . str_replace("'", "\\'", $W_USER) . "' -p'" . str_replace("'", "\\'", $W_PASS) . "' --opt {$DB_NAME} > {$SQLfilename}", $error_lines); // per ogni gara fanne l'esportazione nei dump e la cancella dal DB include 'Common/Fun_Export.php'; include 'Common/Fun_TourDelete.php'; $CompToReload = array(); //controlla che ci sia la tabella Tournament $q = safe_r_sql("show tables like 'Tournament'"); if (safe_num_rows($q)) { $q = safe_w_sql("select * from Tournament"); while ($r = safe_fetch($q)) { $Gara = export_tournament($r->ToId); $filename = $working_dir . "/{$Gara['Tournament']['ToCode']}.ianseo"; $f = fopen($filename, 'w'); fwrite($f, gzcompress(serialize($Gara), 9)); fclose($f); tour_delete($r->ToId); } // per sicurezza fai un secondo dump del DB svuotato... $SQLfilename = $working_dir . "/ianseodump-vuoto.sql"; exec("mysqldump -Q -h'{$W_HOST}' -u'" . str_replace("'", "\\'", $W_USER) . "' -p'" . str_replace("'", "\\'", $W_PASS) . "' --opt {$DB_NAME} > {$SQLfilename}", $error_lines); // zappo la tabella LookUpEntries safe_w_sql("truncate table LookUpEntries"); $SQLfilename = $working_dir . "/ianseodump-base.sql"; exec("mysqldump -Q -h'{$W_HOST}' -u'" . str_replace("'", "\\'", $W_USER) . "' -p'" . str_replace("'", "\\'", $W_PASS) . "' --opt {$DB_NAME} > {$SQLfilename}", $error_lines); $CompToReload[] = $filename; }