<style type="text/css">
@media screen and (max-width: 30.0em) {
.table_horez tbody tr td:nth-child(1):before {
content: "Datum";
}
.table_horez tbody tr td:nth-child(2):before {
content: "Čas";
}
.table_horez tbody tr td:nth-child(3):before {
content: "Místo";
}
.table_horez tbody tr td:nth-child(4):before {
content: "Kolo";
}
.table_horez tbody tr td:nth-child(5):before {
content: "Domácí";
}
.table_horez tbody tr td:nth-child(6):before {
content: "Hosté";
}
.table_horez tbody tr td:nth-child(7):before {
content: "Výsledek";
}
}
</style>
<link rel="stylesheet" href="/wp-includes/css/table_horez.css">
<script src='/wp-includes/js/sorttable.js'></script>
<?php
$vse = $_GET["vse"];
$aktualni = $_GET["aktualni"];
$aktualnihorez = $_GET["aktualnihorez"];
$vyber = $_GET["vyber"];
$svaz = $_GET["svaz"];
$tym = $_GET["tym"];
$soutez = $_GET["soutez"];
$cast = $_GET["cast"];
if ($vyber == '') $vyber = 0;
if (($tym == '') && ($aktualni != 1)) $tym = '1,148';
if ($aktualni == 1) {
if (trim($tym) != '') {
$intervalod = '-7';
$intervaldo = '31';
} else {
$intervalod = '-1';
$intervaldo = '2';
}
}
if ($vse == '') $vse = 0;
if ($aktualni == '') $aktualni = 0;
if ($aktualnihorez == '') $aktualnihorez = 0;
$kategorie = $_GET["kategorie"];
if ($kategorie == "") $kategorie = 'KLM';
$kategorietext = $kategorie;
if ($kategorietext == "") $kategorietext = "";
if ($kategorietext == "LMŽD") $kategorietext = "MLADŠÍ ŽÁCI";
if ($kategorietext == "LSŽB") $kategorietext = "STARŠÍ ŽÁCI";
if ($kategorietext == "KLM") $kategorietext = "MUŽI";
if ($kategorietext == "RLJ") $kategorietext = "JUNIOŘI";
if ($kategorietext == "RLD") $kategorietext = "DOROST";
if ($kategorietext == "KLP") $kategorietext = "4.TŘÍDA";
if ($kategorietext == "MIN") {
if ($cast == 'tr3') {$kategorietext = "3.TŘÍDA";} else {$kategorietext = "2.TŘÍDA";}
}
$rok = $_GET["rok"];
if ($soutez != '') {
$rok = substr($soutez, 0, 4);
$soutez = trim(substr($soutez, 5, 50));
$svaz = trim(substr($soutez, 0, strpos($soutez, '.')));
$soutez = trim(substr($soutez, strpos($soutez, '.') + 1, 50));
$kategorie = trim(substr($soutez, 0, strpos($soutez, '.')));
$kategorietext = $kategorie;
$soutez = trim(substr($soutez, strpos($soutez, '.') + 1, 50));
$cast = $soutez;
}
if ($rok == '') $rok = 2022;
$rokdo = $rok + 1;
$mysqli = new mysqli('localhost', 'horez', 'Teo_14_Fleury', 'systemzapasu');
if ($mysqli->connect_error) {
die('Nepodařilo se připojit k MySQL serveru (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
}
!$mysqli->set_charset("utf8");
$result = $mysqli->query('SELECT *
FROM `bz__competitions`
WHERE Rok = '.$rok.'
ORDER BY Svaz, Kategorie');
echo"<CENTER>";
if ($vyber == 1) {
echo "<form action=\"\">
Soutěž
<select name=\"soutez\">";
while($vypis=$result->fetch_assoc()){
echo"<option value=".$vypis['Rok'].'.'.$vypis['Svaz'].'.'.$vypis['Kategorie'].'.'.$vypis['Cast'].">".$vypis['Nazev']." ".$vypis['NazevCasti']."</option>";
}
echo"</select>";
echo "<input type=\"hidden\" name=\"vyber\" value=\"1\"/>";
echo"<input type=\"submit\" value=\"Vybrat!\" /></form>";
}
if ($aktualni != 1) {
$result = $mysqli->query('SELECT * FROM bz__competitions WHERE Kategorie = \''.$kategorie.'\' AND Rok = '.$rok);
if (mysqli_num_rows($result) > 0) {$vypis=$result->fetch_assoc();}
$nazev = '';
if (($tym != '1,148') && ($tym != '')) {
$result_tym = $mysqli->query('SELECT * FROM bz__teams WHERE Id = '.$tym);
if (mysqli_num_rows($result_tym) > 0) {$vypis_tym=$result_tym->fetch_assoc();}
$nazev = $vypis_tym['Nazev'];
}
if ($svaz == '') {
if ($tym == '1,148') {echo "<p></p><br><H2><b>ZÁPASY ".$vypis['Nazev']." (".$rok." - ".$rokdo.")</b></H2><br>";}
else {echo "<p></p><br><H2><b><a href = \"http://hokejub.mzf.cz/prehled/?tym=".$tym."&kategorie=".$kategorie."\">".$vypis_tym['Nazev']."</a/> - ZÁPASY ".$vypis['Nazev']." (".$rok." - ".$rokdo.")</b></H2><br>";}
} else {
echo "<p></p><br><H2><b>".$vypis['Nazev']."</b></H2><br>";
}
}
if ($aktualnihorez == 1) {
$result = $mysqli->query('SELECT
bz__matches.Id, bz__matches.Datum, bz__matches.Cas, bz__matches.Id AS MatchId, TymA, TymB,
Mesto, domaci.Nazev AS Domaci, hoste.Nazev AS Hoste, Kategorie, bz__matches.Typ,
GolyA, GolyB, Goly1A, Goly1B, Goly2A, Goly2B, Goly3A, Goly3B, Goly4A, Goly4B, GolyPA, GolyPB, GolyNA, GolyNB, Prodlouzeni, Najezdy, bz__matches.Hosys
FROM bz__matches
INNER JOIN bz__venues ON bz__venues.Id = bz__matches.Id_Stadion
INNER JOIN bz__teams AS domaci ON domaci.Id = bz__matches.TymA
INNER JOIN bz__teams AS hoste ON hoste.Id = bz__matches.TymB
where bz__matches.Zverejneno = 1
AND bz__matches.Datum >= CURDATE()-7
AND (bz__matches.Typ = \'M\')
AND (TymA = 1 OR TymB = 1 OR TymA = 4 OR TymB = 4 OR TymA = 148 OR TymB = 148)
/*AND (bz__matches.Kategorie IN (\'2\',\'3\',\'KLP\',\'LMŽD\'))*/
AND Platne = 1
ORDER BY bz__matches.Datum, bz__matches.Cas
');
} else {
if ($aktualni == 1) {
$dotaz = 'SELECT
bz__matches.Id, bz__matches.Datum, bz__matches.Cas, bz__matches.Kolo, bz__matches.Id AS MatchId, bz__matches.Cast AS Cast, TymA, TymB, Mesto, domaci.Nazev AS Domaci, hoste.Nazev AS Hoste, Kategorie, bz__matches.Typ,
GolyA, GolyB, Goly1A, Goly1B, Goly2A, Goly2B, Goly3A, Goly3B, Goly4A, Goly4B, GolyPA, GolyPB, GolyNA, GolyNB, Prodlouzeni, Najezdy, bz__matches.Hosys
FROM bz__matches
INNER JOIN bz__venues ON bz__venues.Id = bz__matches.Id_Stadion
INNER JOIN bz__teams AS domaci ON domaci.Id = bz__matches.TymA
INNER JOIN bz__teams AS hoste ON hoste.Id = bz__matches.TymB
where bz__matches.Zverejneno = 1
AND bz__matches.Datum >= DATE_ADD(CURDATE(), INTERVAL '.$intervalod.' DAY)
AND bz__matches.Datum <= DATE_ADD(CURDATE(), INTERVAL '.$intervaldo.' DAY)';
if ($tym != '') {
$dotaz = $dotaz.' AND (TymA IN ('.$tym.') OR TymB IN ('.$tym.'))';
}
$dotaz = $dotaz.' AND (TymA <> TymB) AND Kategorie NOT IN (\'2TR\',\'3TR\',\'4TR\',\'5TR\') AND Platne = 1';
if ($tym != '') {
$dotaz = $dotaz.' ORDER BY bz__matches.Datum, bz__matches.Cas';
} else {
$dotaz = $dotaz.' ORDER BY bz__matches.Datum, bz__matches.Kategorie, bz__matches.Cas';
}
$result = $mysqli->query($dotaz);
} else {
if (($vse == 0) && ($svaz == '') && ($vyber == 0)) {
$resulttext = 'SELECT
bz__matches.Id, bz__matches.Datum, bz__matches.Cas, bz__matches.Kolo, bz__matches.Id AS MatchId, bz__matches.Cast AS Cast, TymA, TymB, bz__matches.Typ,
Mesto, domaci.Nazev AS Domaci, hoste.Nazev AS Hoste, Kategorie,
GolyA, GolyB, Goly1A, Goly1B, Goly2A, Goly2B, Goly3A, Goly3B, Goly4A, Goly4B, GolyPA, GolyPB, GolyNA, GolyNB, Prodlouzeni, Najezdy, bz__matches.Hosys
FROM bz__matches
INNER JOIN bz__venues ON bz__venues.Id = bz__matches.Id_Stadion
INNER JOIN bz__teams AS domaci ON domaci.Id = bz__matches.TymA
INNER JOIN bz__teams AS hoste ON hoste.Id = bz__matches.TymB
where bz__matches.Zverejneno = 1 AND bz__matches.Datum between \''.$rok.'-07-01\'
AND \''.$rokdo.'-06-30\'
AND Platne = 1
AND (TymA IN ('.$tym.') OR TymB IN ('.$tym.')) AND (TymA <> TymB) AND kategorie IN (\''.$kategorie.'\')';
if ($cast != '') {
$resulttext = $resulttext.' AND Cast = \''.$cast.'\' ';
}
$resulttext = $resulttext.'ORDER BY Datum, PoradiDne, Kategorie DESC';
$result = $mysqli->query($resulttext);
} else
{
$resulttext = 'SELECT
bz__matches.Id, bz__matches.Datum, bz__matches.Cas, bz__matches.Kolo, bz__matches.Id AS MatchId, bz__matches.Cast AS Cast, TymA, TymB, Mesto, domaci.Nazev AS Domaci, hoste.Nazev AS Hoste, Kategorie, bz__matches.Typ,
GolyA, GolyB, Goly1A, Goly1B, Goly2A, Goly2B, Goly3A, Goly3B, Goly4A, Goly4B, GolyPA, GolyPB, GolyNA, GolyNB, Prodlouzeni, Najezdy, bz__matches.Hosys
FROM bz__matches
INNER JOIN bz__venues ON bz__venues.Id = bz__matches.Id_Stadion
INNER JOIN bz__teams AS domaci ON domaci.Id = bz__matches.TymA
INNER JOIN bz__teams AS hoste ON hoste.Id = bz__matches.TymB
where bz__matches.Datum between \''.$rok.'-07-01\'
AND \''.$rokdo.'-06-30\'
AND Platne = 1 AND (TymA <> TymB)
AND (bz__matches.Typ = \'M\') AND kategorie IN (\''.$kategorie.'\') AND Svaz = \''.$svaz.'\' ';
if ($cast != '') {
$resulttext = $resulttext.'AND Cast = \''.$cast.'\' ';
}
$resulttext = $resulttext.'ORDER BY bz__matches.Datum, bz__matches.Hosys, bz__matches.Id';
$result = $mysqli->query($resulttext);
}
}
}
if(mysqli_num_rows($result)) {
//if (($aktualni != 1)or($aktualnihorez != 1)) { echo"<div class=\"tabulka\">";}
echo"
<table class=\"table_horez sortable\">
<thead>
<tr><td>Datum</td><td></td><td>Místo</td>";
if (($kategorietext == '4.TŘÍDA') || (($kategorietext == 'JUNIOŘI')&&($svaz != ''))) echo "<td>Část</td>";
if (($vyber == 0) && ($aktualnihorez != 1) && ($aktualni != 1)) {
echo "<td>Kolo</td>";
} else {
echo "<td>Kat.</td>";
}
echo "<td>Domácí</td><td>Hosté</td>";
if (($kategorietext != '4._TŘÍDA') && ($kategorietext != '3._TŘÍDA') && ($kategorietext != '2._TŘÍDA')) echo "<td>Výsledek</td>";
echo "</tr></thead><tbody>";
while($vypis=$result->fetch_assoc()){
if (((strlen($vypis['Domaci']) < 5) || (strlen($vypis['Hoste']) < 5)) && ($svaz != '')) continue;
if ((($vypis['Domaci'] == 'Volno') || ($vypis['Hoste'] == 'Volno')) && ($svaz != '')) continue;
if (($vypis['TymA'] == 1 or $vypis['TymB'] == 1) and (trim($vypis['Kategorie'])== "LMŽD") and ($aktualni == 1 or $aktualnihorez == 1))
{echo "<tr id=\"tr2\"";}
else {
if (
((
($vypis['TymA'] == 1 or $vypis['TymB'] == 1) and trim($vypis['Kategorie'])!= "2" and trim($vypis['Kategorie'])!= "3")
or (
($vypis['TymA'] == 4 or $vypis['TymB'] == 4) and trim($vypis['Kategorie'])== "KLP"
)
)
and ($aktualni == 1 or $aktualnihorez == 1)
)
{echo "<tr";}
else {echo "<tr";}
}
if (($vypis['Typ']== 'T'))
echo " onclick=\"location.href='/turnaj/?idt=".$vypis['Id']."';\">";
else
echo " onclick=\"location.href='http://hokejub.mzf.cz/zapas/?idm=".$vypis['MatchId']."';\">";
echo "<td>";
$datum = strtotime($vypis['Datum']);
$datum = cesky_den(date("w", $datum)).Date(" j.n.Y", $datum);
echo "<a href=\"https://zapasy.ceskyhokej.cz/pdf/print/cs-html/".$vypis['Hosys']."\">";
echo $datum;
echo "</a>";
echo "</td>
<td>";
if ($vypis['Cas'] != NULL) {
$casutkani = DateTime::createFromFormat('H:i:s', $vypis['Cas']);
//$casutkani = new DateTime($vypis['Cas']);
//$casutkani->setTime($vypis['Cas']);
//print date("G.i:s",$casutkani);
//echo $vypis['Cas'];
//echo date('H:i',$vypis['Cas']);
echo $casutkani->format('H:i');}
echo "</td>
<td>";
echo $vypis['Mesto'];
echo "</td>
<td>";
switch ($vypis['Kategorie']){
case "0" :
$kategorie = "1.tř.";
break;
case "1" :
$kategorie = "2.tř.";
break;
case "2" :
$kategorie = "3.tř.B";
break;
case "3" :
$kategorie = "3.tř.A";
break;
case "MLZ" :
$kategorie = "MLŽ";
break;
default :
$kategorie = $vypis['Kategorie'];
}
if (($kategorietext == '4.TŘÍDA') || (($kategorietext == 'JUNIOŘI')&&($svaz != ''))) {
switch ($vypis['Cast']){
case "m" :
echo "Malé hřiště";
break;
case "v" :
echo "Velké hřiště";
break;
case "skL" :
echo "Skupina L";
break;
case "skM" :
echo "Skupina M";
break;
case "skN" :
echo "Skupina N";
break;
case "naS" :
echo "Nadstavba S";
break;
case "naY" :
echo "Nadstavba Y";
break;
case "naZ" :
echo "Nadstavba Z";
break;
default :
echo $vypis['Cast'];
}
echo "</td>";
echo "<td>";
}
if (($vyber == 0) && ($aktualnihorez != 1) && ($aktualni != 1)) {
if ($vypis['Typ'] == 'M') {
echo $vypis['Kolo'];
} else
{
echo $vypis['Typ'];
}
}
else {
echo $kategorie;}
echo "</td>
<td>";
if ($aktualni == 1) {
echo "<a href=\"http://hokejub.mzf.cz/zapasy/?aktualni=1&tym=".$vypis['TymA']."\">".$vypis['Domaci']."</a>";
} else {
echo "<a href=\"http://hokejub.mzf.cz/zapasy/?kategorie=".$kategorie."&tym=".$vypis['TymA']."\">".$vypis['Domaci']."</a>";
}
echo "</td><td>";
if ($aktualni == 1) {
echo "<a href=\"http://hokejub.mzf.cz/zapasy/?aktualni=1&tym=".$vypis['TymB']."\">".$vypis['Hoste']."</a>";
} else {
echo "<a href=\"http://hokejub.mzf.cz/zapasy/?kategorie=".$kategorie."&tym=".$vypis['TymB']."\">".$vypis['Hoste']."</a>";
}
if ($vypis['GolyA'] == "") $vysledek = ""; else $vysledek = $vypis['GolyA'].":".$vypis['GolyB'];
if (($vypis['Prodlouzeni'] == "1") && ($vypis['Najezdy'] != "1")) $vysledek = $vysledek."p";
if ($vypis['Najezdy'] == "1") $vysledek = $vysledek."n";
if ($vypis['Goly1A'] != "") $vysledek = $vysledek." (".$vypis['Goly1A'].":".$vypis['Goly1B'].", ";
if ($vypis['Goly2A'] != "") $vysledek = $vysledek.$vypis['Goly2A'].":".$vypis['Goly2B'].", ";
if ($vypis['Goly3A'] != "") $vysledek = $vysledek.$vypis['Goly3A'].":".$vypis['Goly3B'].", ";
if ($vypis['Goly4A'] != "") $vysledek = $vysledek.$vypis['Goly4A'].":".$vypis['Goly4B'].", ";
if ($vypis['GolyPA'] != "") $vysledek = $vysledek.$vypis['GolyPA'].":".$vypis['GolyPB'].", ";
if ($vypis['GolyNA'] != "") $vysledek = $vysledek.$vypis['GolyNA'].":".$vypis['GolyNB'].", ";
if ($vypis['GolyA'] != "" || $vypis['Goly1A'] != "" || $vypis['Goly2A'] != "" || $vypis['Goly3A'] != "" || $vypis['Goly4A'] != "" || $vypis['GolyPA'] != "" || $vypis['GolyNA'] != "")
{
$vysledek = strrev($vysledek);
if ( $vypis['Goly1A'] != "") $vysledek = ")".substr($vysledek, 2, strlen($vysledek)-1);
$vysledek = strrev($vysledek);
}
echo "</td>";
if (($kategorietext != '4._TŘÍDA') && ($kategorietext != '3._TŘÍDA') && ($kategorietext != '2._TŘÍDA')) {
echo "<td>";
if (($kategorietext == '4.TŘÍDA') || ($kategorietext == '3.TŘÍDA') || ($kategorietext == '2.TŘÍDA')) {
if (date_format($datum,'Y-m-d') < date("Y-m-d")) echo "Odehráno";
} else
{
echo $vysledek;
}
echo "</td>";
}
echo "</tr>";
}
echo"</tbody></table>";
echo"</CENTER>";
if (($aktualni != 1)or($aktualnihorez != 1)) {echo"</div>";}
}
if ($rok == 2000) echo "Zápasy z loňské sezony průběžně přidáváme."
?>