<h3 style="padding-left:20px;">Ultimi incontri</h3> <?php include_once('mysql-fix.php'); require_once("support/funformat.php"); require_once("sta_tennis.php"); $oldmm=-1; $flag =0; $conta = 0; $cm=0; // CONTATORE dei Menù $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"); $sql1 = "SELECT * FROM new_tennis WHERE YEAR(dapa)>2007 ORDER BY dapa DESC LIMIT 20"; $result1 = mysql_query($sql1,$conn1); $sql2 = "SELECT COUNT(rkid) conta FROM new_tennis"; // TOTALE PARTITE $result2 = mysql_query($sql2,$conn1); $riga2=mysql_fetch_array($result2); $record2[0]=$riga2; $totalepartite = $record2[0]['conta']; $sql3 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='V'"; // TOTALE VINTE $result3 = mysql_query($sql3,$conn1); $riga3=mysql_fetch_array($result3); $record3[0]=$riga3; $totalevinte = $record3[0]['conta']; $pervinte = $totalevinte * 100 / $totalepartite; $sql4 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='N'"; // TOTALE NULLE $result4 = mysql_query($sql4,$conn1); $riga4=mysql_fetch_array($result4); $record4[0]=$riga4; $totalenulle = $record4[0]['conta']; $pernulle = $totalenulle * 100 / $totalepartite; $sql5 = "SELECT COUNT(rkid) conta FROM new_tennis WHERE esito='P'"; // TOTALE PERSE $result5 = mysql_query($sql5,$conn1); $riga5=mysql_fetch_array($result5); $record5[0]=$riga5; $totaleperse = $record5[0]['conta']; $perperse = $totaleperse * 100 / $totalepartite; // AVVERSARI PIU' FREQUENTI $sql6 = " SELECT Count(rkid) AS conta, avversario FROM new_tennis "; $sql6.= "GROUP BY avversario ORDER BY Count(rkid) DESC"; $result6 = mysql_query($sql6,$conn1); for ($p=0; $p<10; $p++){ $riga6=mysql_fetch_array($result6); $record6[$p]=$riga6; $avve[$p] = $record6[$p]['avversario']; $avveconta[$p] = $record6[$p]['conta']; } ?> <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;">Avversario</th> <th width="150" style="text-align:center;">Risultato</th> <th width="100" style="text-align:center;">Note</th> <?php if($result1){ $i=0; do{ $riga1=mysql_fetch_array($result1); $recordsetx[$i]=$riga1; $dd= $recordsetx[$i]['dapa'] ; $avversario = $recordsetx[$i]['avversario']; $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 $aa = substr($dd,2,2); // Individua l'Anno $m = MeDes($mm); $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 ($avversario!=''){ echo "<tr>"; echo "<td style=\"font-size:10px;\">$gg.$m.$aa</td>"; echo "<td style=\"font-size:12px;\">$luogo</td>"; echo "<td style=\"font-size:14px;\">$avversario</td>"; echo "<td style=\"font-size:16px;\"><span style=\"color:$colore;\">$risultato</span></td>"; echo "<td>$note</td>"; echo "</tr>"; } }while($riga1); $i++; // unset ($recordsetx[$i-1]); }else{ return FALSE; mysql_close($conn1); } ?> </table> * <span style="font-size:9px;color:#00cc33">Vinte</span> <span style="font-size:9px;color:#333366">Nulle</span> <span style="font-size:9px;color:#ff0000">Perse</span> <h3 style="padding-left:20px;">Statistiche Generali - Partite, Sets, Games e Tie-Break</h3> <table style="padding-left:10px; color: #000000; font-size:16px;" border="1"> <!-- 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 = setvinti(); $setpersi = setpersi(); $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 = games("V"); $gamepersi = games("P"); $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 = games("TV"); $tiepersi = games("TP"); $tietotali = $tievinti + $tiepersi; $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> <h3 style="padding-left:20px;">Statistiche Varie - Avversari Frequenti</h3> <table border="1"><tr><th width="100" style="text-align:center;">Posizione</th><th width="300" style="text-align:center;">Avversario</th><th width="200" style="text-align:center;">Incontri</th></tr> <?php for ($px=1; $px<10; $px++){ ?> <tr><td style="font-size:16px; text-align:center;"><?php echo $px;?></td><td style="font-size:16px; padding-left:5px;"><?php echo $avve[$px];?></td><td style="font-size:16px;text-align:center;"><?php echo $avveconta[$px];?></td> </tr> <?php } ?> </table></html>