@$databaza = mysql_connect($mysql_server, $mysql_username,$mysql_pass);
//@$databaza = odbc_connect(squashrebr,"","");
if(!$databaza):
echo "Chyba pri otváraní databázy!!!";
exit;
endif;
mysql_query("SET character_set_results=utf8");
@$hrac1 = mysql_db_query($mysql_db_name, "SELECT * FROM Hrac WHERE PK_KodHraca = $id_hraca1");
//@$hrac1 = mysql_db_query($mysql_db_name, "SELECT * FROM Hrac WHERE PK_KodHraca = $id_hraca1");
if(!$hrac1):
echo "Chyba pri výbere z databázy !!!";
exit;
endif;
@$hrac2 = mysql_db_query($mysql_db_name, "SELECT * FROM Hrac WHERE PK_KodHraca = $id_hraca2");
if(!$hrac2):
echo "Chyba pri výbere z databázy !!!";
exit;
endif;
@$klub1 = mysql_db_query($mysql_db_name, "SELECT NazovKlubu FROM Klub WHERE PK_KodKlubu = ".mysql_result($hrac1,0, "FK_KodKlubu"));
if(!$klub1):
echo "Chyba pri výbere z databázy !!!";
exit;
endif;
@$klub2 = mysql_db_query($mysql_db_name, "SELECT NazovKlubu FROM Klub WHERE PK_KodKlubu = ".mysql_result($hrac2,0, "FK_KodKlubu"));
if(!$klub2):
echo "Chyba pri výbere z databázy !!!";
exit;
endif;
$statStart = "2006-09-01";
$statEnd = "2007-09-01";
$liga1 = statistics_liga($statStart, $statEnd, $id_hraca1);
$turnaje1 = statistics_turnaje($statStart, $statEnd, $id_hraca1);
$liga2 = statistics_liga($statStart, $statEnd, $id_hraca2);
$turnaje2 = statistics_turnaje($statStart, $statEnd, $id_hraca2);
echo "".mysql_result($hrac1,0, "Meno")." | Meno | ".mysql_result($hrac2,0, "Meno")." | ";
echo "".mysql_result($hrac1,0, "Priezvisko")." | Priezvisko | ".mysql_result($hrac2,0, "Priezvisko")." | ";
echo "".mysql_result($klub1,0, "NazovKlubu")." | Klub | ".mysql_result($klub2,0, "NazovKlubu")." | ";
echo "".(mysql_result($hrac1,0, "Body")==0?"---":mysql_result($hrac1,0, "Poradie"))." | Postavenie v aktuálnom rebríčku | ".(mysql_result($hrac2,0, "Body")==0?"---":mysql_result($hrac2,0, "Poradie"))." | ";
echo " | Aktuálna sezóna | | ";
echo "".$liga1["all"]." [".$liga1["win"]."/".$liga1["lost"]."] | Liga (s [v/p]) | ".$liga2["all"]." [".$liga2["win"]."/".$liga2["lost"]."] | ";
echo "".$turnaje1["all"]." [".$turnaje1["win"]."/".$turnaje1["lost"]."] | Turnaje (s [v/p]) | ".$turnaje2["all"]." [".$turnaje2["win"]."/".$turnaje2["lost"]."] | ";
echo "".($liga1["all"]+$turnaje1["all"])." [".($liga1["win"]+$turnaje1["win"])."/".($liga1["lost"]+$turnaje1["lost"])."] | Celkom (s [v/p]) | ".($liga2["all"]+$turnaje2["all"])." [".($liga2["win"]+$turnaje2["win"])."/".($liga2["lost"]+$turnaje2["lost"])."] | ";
$betweenStats = h2h($id_hraca1, $id_hraca2);
$h2h1 = $betweenStats[$id_hraca1];
$h2h2 = $betweenStats[$id_hraca2];
$zapasy = $betweenStats["games"];
echo " | Vzájomné zápasy | | ";
echo "".($h2h1["liga"]["win"]+$h2h1["liga"]["lost"])." [".$h2h1["liga"]["win"]."/".$h2h1["liga"]["lost"]."] | Liga (s [v/p]) | ".($h2h2["liga"]["win"]+$h2h2["liga"]["lost"])." [".$h2h2["liga"]["win"]."/".$h2h2["liga"]["lost"]."] | ";
echo "".($h2h1["turn"]["win"]+$h2h1["turn"]["lost"])." [".$h2h1["turn"]["win"]."/".$h2h1["turn"]["lost"]."] | Turnaje (s [v/p]) | ".($h2h2["turn"]["win"]+$h2h2["turn"]["lost"])." [".$h2h2["turn"]["win"]."/".$h2h2["turn"]["lost"]."] | ";
echo "".($h2h1["liga"]["win"]+$h2h1["liga"]["lost"]+$h2h1["turn"]["win"]+$h2h1["turn"]["lost"])." [".($h2h1["liga"]["win"]+$h2h1["turn"]["win"])."/".($h2h1["liga"]["lost"]+$h2h1["turn"]["lost"])."] | ";
echo "Celkom (s [v/p]) | ";
echo "".($h2h2["liga"]["win"]+$h2h2["liga"]["lost"]+$h2h2["turn"]["win"]+$h2h2["turn"]["lost"])." [".($h2h2["liga"]["win"]+$h2h2["turn"]["win"])."/".($h2h2["liga"]["lost"]+$h2h2["turn"]["lost"])."] | ";
$winturn1 = turnWin($id_hraca1);
$winturn2 = turnWin($id_hraca2);
echo " | Vitazne turnaje | | ";
echo "".$winturn1["AT"]." | Kat. A | ".$winturn2["AT"]." | ";
echo "".$winturn1["BT"]." | Kat. B | ".$winturn2["BT"]." | ";
echo "".$winturn1["CT"]." | Kat. C | ".$winturn2["CT"]." | ";
echo "".($winturn1["AT"]+$winturn1["BT"]+$winturn1["CT"])." | ";
echo "Celkom | ";
echo "".($winturn2["AT"]+$winturn2["BT"]+$winturn2["CT"])." | ";
echo " ";
if(count($zapasy)>0){
echo "
";
echo "vitaz | vysledok | turnaj | datum | pozicia/kolo | ";
foreach($zapasy as $game){
$vitaz = ($game["winner"]==$id_hraca1?mysql_result($hrac1,0, "Meno")." ".mysql_result($hrac1,0, "Priezvisko"):mysql_result($hrac2,0, "Meno")." ".mysql_result($hrac2,0, "Priezvisko"));
echo "";
echo "".$vitaz." |
".$game["vysledok"]." |
".$game["turnaj"]["Nazov"]." |
".date("d.m.Y", strtotime($game["turnaj"]["Datum"]))." |
".($game["turnaj"]["Typ"]=="L"?$game["pozicia"]:UmiestnenieVTurnaji($game["pozicia"]))." | ";
echo " ";
}
echo " ";
}
$end_databaza = mysql_close($databaza);
?>
|