include_once("../../../mysql_connect.php");
$id_t = intval($_GET['id_t']);
$size = $_GET['size'];
$table_name = "dg_turnieje";
$parametry = array();
$sql = "SELECT * FROM $table_name WHERE `id` = \"$id_t\" ";
$result = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodło się.");
while ($wiersz = mysql_fetch_array($result)) {
$parametry['rok'][$id_t] = $wiersz['rok'];
$parametry['kraj'][$id_t] = $wiersz['kraj'];
$parametry['miasto'][$id_t] = $wiersz['miasto'];
$parametry['rodzaj'][$id_t] = $wiersz['rodzaj'];
$parametry['nazwa'][$id_t] = $wiersz['nazwa'];
$parametry['bo_Groups'][$id_t] = $wiersz['bo_7'];
$parametry['bo_Final'][$id_t] = $wiersz['bo_1'];
$parametry['bo_Semi_Final'][$id_t] = $wiersz['bo_2'];
$parametry['bo_Quarter_Final'][$id_t] = $wiersz['bo_3'];
$parametry['bo_Last_16'][$id_t] = $wiersz['bo_4'];
$parametry['bo_Last_24'][$id_t] = $wiersz['bo_5'];
$parametry['bo_Last_30'][$id_t] = $wiersz['bo_5'];
$parametry['bo_Last_32'][$id_t] = $wiersz['bo_5'];
$parametry['bo_Last_44'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_48'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_52'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_56'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_60'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_64'][$id_t] = $wiersz['bo_6'];
$parametry['bo_Last_72'][$id_t] = $wiersz['bo_8'];
$parametry['bo_Last_128'][$id_t] = $wiersz['bo_8'];
$parametry['bo_Last_256'][$id_t] = $wiersz['bo_9'];
$parametry['drabinka'][$id_t] = $wiersz['drabinka'];
$parametry['data_in'][$id_t] = $wiersz['data_in'];
$parametry['data_out'][$id_t] = $wiersz['data_out'];
$parametry['od_ilu'][$id_t] = $wiersz['od_ilu'];
$parametry['logo_1'][$id_t] = $wiersz['logo_1'];
$parametry['logo_2'][$id_t] = $wiersz['logo_2'];
$parametry['ile_s'][$id_t] = $wiersz['ile_s'];
}
include('vs.php');
?>
Knockout
$drabinka = array();
$table_name = "dg_wyniki";
$sql = "SELECT * FROM $table_name WHERE `id_t` = $id_t AND `faza` != \"Groups\" ORDER by `mecz_xxx` ";
$result = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodło się.");
while ($wiersz = mysql_fetch_array($result)) {
$mecz = $wiersz['mecz_xxx'];
$data = date('d.m.Y', strtotime($wiersz['data']));
$godzina = date('H:i', strtotime($wiersz['godzina']));
$sedzia1 = $wiersz['sedzia'];
$faza = $wiersz['faza'];
$drabinka['id_w'][$mecz] = $wiersz['id'];
if ($wiersz['id_z1']>0) {$drabinka['id_z1'][$mecz] = $wiersz['id_z1'];} else {$drabinka['id_z1'][$mecz] = 0;}
if ($wiersz['id_z2']>0) {$drabinka['id_z2'][$mecz] = $wiersz['id_z2'];} else {$drabinka['id_z2'][$mecz] = 0;}
$a = 'bo_'.$wiersz['faza'];
$drabinka['bo'][$mecz] = $parametry[$a][$id_t];
$drabinka['opis'][$mecz] = $data.' '.$godzina.' ('.$parametry[$a][$id_t].')';
$drabinka['w1'][$mecz] = $wiersz['w1'];
$drabinka['w2'][$mecz] = $wiersz['w2'];
for ($m = 1; $m <= 19; $m++) {
$a = $m.'_1';
$b = $m.'_2';
$c = 'F'.$a;
$d = 'F'.$b;
$drabinka[$c][$mecz] = $wiersz[$a];
$drabinka[$d][$mecz] = $wiersz[$b];
}
}
$krajm = $parametry['kraj'][$id_t];
$miasto = $parametry['miasto'][$id_t];
$turniej = $parametry['nazwa'][$id_t].' '.$parametry['rodzaj'][$id_t];
$rok = $parametry['rok'][$id_t];
$naglowek = $turniej.' - '.$miasto.' / '.$krajm.' '.$rok;
$table_name = "dg_zawodnicy";
$zawodnicy = array();
$sql = "SELECT * FROM $table_name WHERE `id_t` = \"$id_t\" and `nr_d` > 0 ORDER BY `id_z`";
$result = @mysql_query($sql,$dbc)or die("Wykonanie zapytania nie powiodło się.");
$ilu_z = mysql_numrows($result);
while ($wiersz = mysql_fetch_array($result)) {
$zawodnik['mwd'][$wiersz['id_z']] = $wiersz['nr_d'];
}
$lista = "";
//$lista .= "";
$lista .= "";
$lista .= "";
$lista .= "";
$lista .= "";
$lista .= "";
$lista .= "";
$lista .= "";
/*
echo '';
print_r($drabinka);
echo '
';
print_r($zawodnik);
echo '
';
print_r($players);
echo '
';
echo '
';
echo '
';
print_r($_POST);
echo '
';
print_r($_FILES);
exit;
*/
if ($size) {
switch($size) {
case 256:
case 128:
case 96:
case 64:
case 32:
case 16:
case 8:
case 4: $plik = 'd'.$size.'.php'; break;
default: $plik = 'd'.$parametry['drabinka'][$id_t].'.php'; break;
}
} else {
$plik = 'd'.$parametry['drabinka'][$id_t].'.php';
}
include($plik);
echo "$display_block"; ?>
Created by :