<?php


require_once "../../maincore.php";
require_once THEMES."templates/header.php";

$db_prefix = 'fusion7M485_';



if($_GET['date'] == '') {

if (isset($_POST['rodyti'])) {
header( 'Location: '.BASEDIR.'infusions/stats/matches.php?date='.$_POST['data'].'' ) ;
}

$matchu_sk = dbquery("SELECT COUNT(id) FROM ".$db_prefix."matches");
$numeris = dbresult($matchu_sk, 0);
opentable("Var&#382;yb&#371; rezultatai (I&#353;viso: $numeris)");
$query = dbquery("SELECT * FROM ".$db_prefix."matches GROUP BY date");
$quuu = dbarray($query);
echo "<form method='post' action='".INFUSIONS."stats/matches.php?date=".$quuu['date']."'><table width='60%' align='center' cellspacing='1' cellpadding='0' class='tbl-border'><tr><td class='tbl2' align='center'><b>Pasirinkite dat&#261;:</b></td></tr>";

echo "<tr><td class='tbl1' align='center'><select name='data' style='width:100px' class='textbox'>";
while($data = dbarray($query)) {

$kada = $data['date'];

echo "<option value='$kada'>$kada</option>";

}
echo "</select></td></tr>";

echo "<tr><td class='tbl2' align='center'><input type='submit' value='Rodyti' name='rodyti' class='button' /></td></tr></table></form>"; } else {

opentable("Var&#382;yb&#371; rezultatai");

echo "<table cellspacing='1' cellpadding='2' class='tbl-border' align='center' width='90%'><tr><td class='tbl2' colspan='4' align='center'><b style='font-size:13px'>";
echo $_GET['date']."</b></td></tr>";

$where = $_GET['date'];
$query = dbquery("SELECT * FROM ".$db_prefix."matches WHERE date = '$where'");
$i = 0;
while ($data = dbarray($query)) {
$i++;
$match_id = $data['id'];
$dataa = $data['date'];
$ho_team = $data['ho_team'];
$aw_team = $data['aw_team'];
$ho_score = $data['ho_score'];
$aw_score = $data['aw_score'];
$laikasss = $data['datea'];
$tipas = $data['type'];


$ho_te_id_gavimas = mysql_query("SELECT * FROM ".$db_prefix."teams WHERE name='$ho_team'");

while ($q = mysql_fetch_array($ho_te_id_gavimas))
{
$rezu_te_id_ho = $q['id'];
}

$aw_te_id_gavimas = mysql_query("SELECT * FROM ".$db_prefix."teams WHERE name='$aw_team'");

while ($q = mysql_fetch_array($aw_te_id_gavimas))
{
$rezu_te_id_aw = $q['id'];
}


echo "<tr class='tbl3'>";
echo "<td align='center' style='padding-top:5px;padding-bottom:5px;' width='10%'><b>$laikasss</b></td>";
echo "<td align='center' style='padding-top:5px;padding-bottom:5px;' width='30%'><a href='".BASEDIR."infusions/stats/teams_main.php?id=$rezu_te_id_ho'>$ho_team</a></td>";
if ($tipas == 'playoffs') {
echo "<td align='center' style='padding-top:5px;padding-bottom:5px;' width='10%'><a href='".BASEDIR."infusions/stats/match.php?id=$match_id'>$ho_score : $aw_score</a><sup><img src='http://pixel.ql.lt/images/236playoffs.png'></sup></td>";
} else if ($tipas == 'normal') {
echo "<td align='center' style='padding-top:5px;padding-bottom:5px;' width='10%'><a href='".BASEDIR."infusions/stats/match.php?id=$match_id'>$ho_score : $aw_score</a></td>";
}
echo "<td align='center' style='padding-top:5px;padding-bottom:5px;' width='30%'><a href='".BASEDIR."infusions/stats/teams_main.php?id=$rezu_te_id_aw'>$aw_team</a></td>";
echo "</tr>";


}
$gavimas = dbquery("SELECT COUNT(id) FROM ".$db_prefix."matches WHERE date = '$dataa'");
echo "<tr><td class='tbl2' align='center' colspan='4'>&#352;i&#261; dien&#261; &#303;vyko <b>".dbresult($gavimas, 0)."</b> var&#382;ybos(-&#371;)</td></tr>";
echo "</table>";
}

closetable();


require_once THEMES."templates/footer.php";

?>