Nejbližší akce


Žádné události

Náhodné foto

Facebook


<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."

?>