<?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;
}
