<?php

     //require("support/funformat.php");
       include_once('mysql-fix.php');
      require_once("sta_tennis1.php");

     $tennista = $_GET['tennista'];
     //$tennista = str_replace("_", " ", $tennista);
if ($tennista!=''){    // il resto solo se selezionato un tennista

    $dbhost1 = "edizionitonym4sk.mysql.db"; $dbname1 = "edizionitonym4sk"; $dbuser1 = "edizionitonym4sk";    $dbpass1 = "Didier0533";

                        $conn1 = mysql_connect($dbhost1,$dbuser1,$dbpass1) or die("Impossibile collegarsi al server MySQL.");

                        mysql_select_db($dbname1,$conn1) or die("Impossibile selezionare il database $dbname");

        $sql3 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='V' AND avversario='$tennista'";  // TOTALE VINTE

        $result3 = mysql_query($sql3,$conn1);

        $riga3=mysql_fetch_array($result3);

        $record3[0]=$riga3; $totalevinte = $record3[0]['conta'];

        $sql4 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='N' AND avversario='$tennista'";  // TOTALE NULLE

        $result4 = mysql_query($sql4,$conn1);

        $riga4=mysql_fetch_array($result4);

        $record4[0]=$riga4; $totalenulle = $record4[0]['conta'];

        $sql5 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='P' AND avversario='$tennista'";  // TOTALE PERSE

        $result5 = mysql_query($sql5,$conn1);

        $riga5=mysql_fetch_array($result5);

        $record5[0]=$riga5; $totaleperse = $record5[0]['conta'];

        $totalepartite=$totalevinte+$totaleperse+$totalenulle;

            $pervinte = $totalevinte * 100 / $totalepartite;

            $perperse = $totaleperse * 100 / $totalepartite;

            $pernulle = $totalenulle * 100 / $totalepartite;

?>

<h3 style="padding-left:20px; color: #990092">Statistiche contro <?php echo $tennista;?></h3>
<table style="padding-left:10px; color: #000000; font-size:16px;">

<!-- PARTITE -->

<tr><th width="150" style="text-align:center;">Totale</th><th width="150" style="text-align:center;">Vinte</th><th width="150" style="text-align:center;">Nulle</th><th width="150" style="text-align:center;">Perse</th></tr>

<tr><td style="color: #000000; font-size:20px; text-align:center;"><?php echo $totalepartite;?>&nbsp;<span style="font-size:14px;">Partite</span></td>
<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $totalevinte;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pervinte,2);?>%)</span></td>

<td style="color: #333366; font-size:20px; text-align:center;"><?php echo $totalenulle;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pernulle,2);?>%)</span></td>

 <td style="color: #ff0000; font-size:20px; text-align:center;"><?php echo $totaleperse;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($perperse,2);?>%)</span></td></tr>

<!-- SETS -->

<?php

    $setvinti = setvintix($tennista); $setpersi = setpersix($tennista);  $settotali = $setvinti + $setpersi;

    $persetvinti = $setvinti*100/$settotali; $persetpersi = $setpersi*100/$settotali;

?>

<tr><td style="color: #000000; font-size:20px; text-align:center;"><?php echo $settotali;?>&nbsp;<span style="font-size:14px;">Sets</span></td>

<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $setvinti;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($persetvinti,2);?>%)</span></td>

<td style="color: #333366; font-size:20px; text-align:center;">--</td>

 <td style="color: #ff0000; font-size:20px; text-align:center;"><?php echo $setpersi;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($persetpersi,2);?>%)</span></td></tr>

 <!-- GAMES -->

 <?php

    $gamevinti = gamesx("V",$tennista); $gamepersi = gamesx("P",$tennista);  $gametotali = $gamevinti + $gamepersi;

    $pergamevinti = $gamevinti*100/$gametotali; $pergamepersi = $gamepersi*100/$gametotali;

?>

<tr><td style="color: #000000; font-size:20px; text-align:center;"><?php echo $gametotali;?>&nbsp;<span style="font-size:14px;">Games</span></td>

<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $gamevinti;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pergamevinti,2);?>%)</span></td>

<td style="color: #333366; font-size:20px; text-align:center;">--</td>

 <td style="color: #ff0000; font-size:20px; text-align:center;"><?php echo $gamepersi;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pergamepersi,2);?>%)</span></td></tr>

<!-- TIE-BREAK -->

 <?php

    $tievinti = gamesx("TV",$tennista); $tiepersi = gamesx("TP",$tennista);  $tietotali = $tievinti + $tiepersi;

    if ($tietotali>0){

        $pertievinti = $tievinti*100/$tietotali; $pertiepersi = $tiepersi*100/$tietotali;

    }

?>

<tr><td style="color: #000000; font-size:20px; text-align:center;"><?php echo $tietotali;?>&nbsp;<span style="font-size:14px;">Tie-Break</span></td>

<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $tievinti;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pertievinti,2);?>%)</span></td>

<td style="color: #333366; font-size:20px; text-align:center;">--</td>

 <td style="color: #ff0000; font-size:20px; text-align:center;"><?php echo $tiepersi;?>&nbsp;<span style="font-size:12px;"> (<?php echo number_format($pertiepersi,2);?>%)</span></td></tr>

</table>

<br><h4>Tutti gli incontri disputati con <?php echo $tennista;?></h4>

<table border="1">

 <th width="100" style="text-align:center">Data</th>

 <th width="150" style="text-align:center">Luogo</th>

 <th width="150" style="text-align:center">Risultato</th>

 <th width="200" style="text-align:center">Note</th>

<?php    // TUTTI GLI INCONTRI CON IL TENNISTA SELEZIONATO

    $sql1 = "SELECT * FROM new_tennis WHERE avversario='$tennista' ORDER BY dapa DESC";

    $result1 = mysql_query($sql1,$conn1);



    if($result1){

                    $i=0;

                    do{

                        $riga1=mysql_fetch_array($result1);

                        $recordsetx[$i]=$riga1;

                        $dd= $recordsetx[$i]['dapa'] ;

                        $luogo = $recordsetx[$i]['luogo'];

                        $note = $recordsetx[$i]['note'];

                        $set1 = $recordsetx[$i]['set1'];

                        $set2 = $recordsetx[$i]['set2'];

                        $set3 = $recordsetx[$i]['set3'];

                        $set4 = $recordsetx[$i]['set4'];

                        $set5 = $recordsetx[$i]['set5'];

                        $note = $recordsetx[$i]['note'];

                        $gg = substr($dd,8,2);    // Individua il Mese

                        $mm = substr($dd,5,2);    // Individua il Mese

                        //$mm = nomimesi($mm);
                        //$mm = $mm;

                        $aa = substr($dd,2,2);    // Individua l'Anno

                        $risultato = "$set1";

                        if ($recordsetx[$i]['esito']=="V"){

                            $colore = "#00CC33";

                        }elseif ($recordsetx[$i]['esito']=="N"){

                             $colore = "#333366";

                        }else{

                             $colore = "#FF0000";

                        }

                        if ($set2!=''){ $risultato .="/$set2";}

                        if ($set3!=''){ $risultato .="/$set3";}

                        if ($set4!=''){ $risultato .="/$set4";}

                        if ($set5!=''){ $risultato .="/$set5";}

                           if ($luogo!=''){

                                echo "<tr>";

                                    echo "<td style=\"font-size:12px;\">$gg $mm $aa</td>";

                                    echo "<td style=\"font-size:14px;\">$luogo</td>";

                                    echo "<td style=\"font-size:18px; color:$colore\">$risultato</td>";

                                    echo "<td>$note</td>";

                                echo "</tr>";

                           }

                    }while($riga1);

                        $i++;

                 //        unset ($recordsetx[$i-1]);

        }else{

                    return FALSE;

                    mysql_close($conn1);

        }

?>

</table>

 <?php } ?>