File "statistiques_joueurs.php"
Full Path: /home/analogde/www/copy/statistiques_joueurs.php
File size: 21.55 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start(); include('database.php'); DB_connexion(); //error_reporting(0);
/*if(!isset($_SESSION['logged']) ) { header ('Location: interdiction.php'); }
if($_SESSION['logged']== "no") { header ('Location: interdiction.php'); }*/
$playerID = $_GET['playerID']; echo "plouf";
//$sql = "SELECT * FROM classement WHERE id = '$playerID' "; $sql = "SELECT * FROM " .$_SESSION['classement'] ." WHERE id = '$playerID' ";
$retid = mysql_query($sql);
while ($row = mysql_fetch_array($retid)) { $joueur = $row["joueur"]; $rating = $row["elo"]; $games = $row["parties"]; $gcount=$row["gcount"]; $wins=$row["wins"]; $losses=$row["losses"]; $draws=$row["draws"]; $oldrating = $row["oldrating"]; $incr = $rating - $oldrating; }
if ($gcount !=0 ) { $winp=round(($wins/$gcount)*100,2); $lossp=round(($losses/$gcount)*100,2); $drawp=round(($draws/$gcount)*100,2); }
else { $winp=0; $lossp=0; $drawp=0; }
//$sql = "SELECT * FROM evolution WHERE playerid = '$playerID' ORDER by rating desc "; $sql = "SELECT * FROM " .$_SESSION['evolution'] ." WHERE playerid = '$playerID' ORDER by rating desc ";
$retid = mysql_query($sql); $row = mysql_fetch_array($retid); $max_rating = $row["rating"]; $max_date = $row["date"]; //$max_date = date("d j, Y",$max_date); // date("F j, Y",$max_date $max_date=date("d F Y",$max_date); $max_date = strftime('%d-%m-%Y',strtotime($max_date));
$graph_max=$max_rating+50; //$sql = "SELECT * FROM evolution WHERE playerid = '$playerID' ORDER by rating asc "; $sql = "SELECT * FROM " .$_SESSION['evolution'] ." WHERE playerid = '$playerID' ORDER by rating asc ";
$retid = mysql_query($sql); $row = mysql_fetch_array($retid); $min_rating = $row["rating"]; $graph_min=$min_rating-50;
//$query = "SELECT * FROM evolution WHERE playerID = '$playerID' ORDER by date asc"; $query = "SELECT * FROM " .$_SESSION['evolution'] ." WHERE playerID = '$playerID' ORDER by date asc";
$result = mysql_query($query); $num = mysql_num_rows($result);
if ($num != 0) {
$file= fopen("include/data.xml", "w"); $_xml="<chart caption='Evolution du classement' xAxisName='Parties' yAxisName='Niveau ELO' decimals='0' formatNumberScale='0' formatNumber='0' showValues='0' yAxisMinValue='".$graph_min."' yAxisMaxValue='".$graph_max."'>";
$label = "";
while ($row = mysql_fetch_array($result)) { if ($row["playerID"]) { $infos = $row["rating"] ."" .$row["date"]; $_xml .="\t<set label=\"" . $label . "\""; $_xml .=" value='" . $row["rating"] ."'/>\r\n"; //$_xml .=" value='" . $row["rating"] ."'/>\r\n"; }
else { $_xml .="\t<page title=\"Nothing Returned\">\r\n"; $_xml .="\t\t<file>none</file>\r\n"; $_xml .="\t</page>\r\n"; } }
$_xml .="</chart>"; fwrite($file, $_xml); fclose($file); }
/*********************************************************************************/
if(!empty($_POST) ) { $_SESSION['sauvegarde_formulaire'] = $_POST ;
$page_actuelle = $_SERVER['PHP_SELF'] ;
if(!empty($_SERVER['QUERY_STRING'])) { $page_actuelle .= '?' . $_SERVER['QUERY_STRING'] ; }
header('Location: ' . $page_actuelle); exit; }
if(isset($_SESSION['sauvegarde_formulaire'])) { $_POST = $_SESSION['sauvegarde_formulaire'] ; unset($_SESSION['sauvegarde_formulaire']); }
if( isset($_POST['valide_form']) && $_POST['valide_form'] == "ok" ) { //header ('Location: salut.php'); $_SESSION['message'] = "ok"; echo $_POST['selection_score'];
switch ($_POST['selection_score']) { case "J1 gagne": $elo_J1 = $_SESSION['$J1_gagne_score'] ; $elo_J2 = $_SESSION['$J2_perd_score'] ; break;
case "J1 perd": $elo_J1 = $_SESSION['$J1_perd_score'] ; $elo_J2 = $_SESSION['$J2_gagne_score'] ; break;
case "J2 gagne": $elo_J1 = $_SESSION['$J1_perd_score'] ; $elo_J2 = $_SESSION['$J2_gagne_score'] ; break;
case "J2 perd": $elo_J1 = $_SESSION['$J1_gagne_score'] ; $elo_J2 = $_SESSION['$J2_perd_score'] ; break;
case "Match nul": $elo_J1 = $_SESSION['$J1_match_nul'] ; $elo_J2 = $_SESSION['$J2_match_nul'] ; break;
default: echo "erreur dans le traitement"; }
echo '<br/>'; echo $elo_J1; echo '<br/>'; echo $elo_J2;
//$sql = "SELECT * FROM joueurs WHERE nom = '".$_SESSION['$J1_nom']."' "; $sql = "SELECT * FROM " .$_SESSION['joueurs'] ." WHERE nom = '".$_SESSION['$J1_nom']."' ";
echo $sql;
$result = mysql_query($sql);
$data = mysql_fetch_assoc($result);
$id = $data['id'];
echo $id;
//$sql = "UPDATE joueurs SET score = '".$elo_J1."' WHERE id = '$id' " ; $sql = "UPDATE " .$_SESSION['joueurs'] ." SET score = '".$elo_J1."' WHERE id = '$id' " ;
echo $sql;
//$requete = mysql_query($sql);
//$sql = "SELECT * FROM joueurs WHERE nom = '".$_SESSION['$J2_nom']."' "; $sql = "SELECT * FROM " .$_SESSION['joueurs'] ." WHERE nom = '".$_SESSION['$J2_nom']."' ";
echo $sql; $result = mysql_query($sql); $data = mysql_fetch_assoc($result); $id = $data['id']; echo $id;
//$sql = "UPDATE joueurs SET score = '".$elo_J2."' WHERE id = '$id' " ; $sql = "UPDATE " .$_SESSION['joueurs'] ." SET score = '".$elo_J2."' WHERE id = '$id' " ; echo $sql;
//$requete = mysql_query($sql);
$heure = date("H:i");
$J1_nom = $_SESSION['$J1_nom']; $J2_nom = $_SESSION['$J2_nom']; $resultat_partie = $_POST['selection_score'];
//$sql = "INSERT INTO partie( id, joueur1, joueur2, resultat_partie, score_joueur1, score_joueur2 ,date_partie, heure_partie) // VALUES('', '$J1_nom', '$J2_nom', '$resultat_partie' , '$elo_J1' , '$elo_J2' , NOW(), '$heure' )"; $sql = "INSERT INTO " .$_SESSION['parties'] ." ( id, joueur1, joueur2, resultat_partie, score_joueur1, score_joueur2 ,date_partie, heure_partie) VALUES('', '$J1_nom', '$J2_nom', '$resultat_partie' , '$elo_J1' , '$elo_J2' , NOW(), '$heure' )";
echo $sql;
$requete = mysql_query($sql);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><meta name="Description" content="Site perso,cours,ouvrages" /><meta name="Keywords" content="WEBSITE perso " /><meta name="Distribution" content="Global" /><meta name="Robots" content="" /><meta http-equiv="Content-Language" content="fr" /><meta name="rating" content="general" /><meta name="author" content="Patrice DELPY" /><meta name="copyright" content="Copyright 2013" /><meta name="generator" content="Patoche" /><title>Patoche WEBSITE - 2013 - Template du site - en cours de développemment ...</title><script language="JavaScript" src="include/chartembed.js"></script>
<!---------------------------------------------------------->
<?php include('include_css_template_commun.php'); include('include_css.php'); include('css_tools_skill.php'); include('include_javascript.php');?>
<style type="text/css">
#bloc_filtre { float: left; width: 831px; padding: 50px 50px 25px 50px; }
#bloc_stats { float: left; width: 850px; padding: 50px 10px 25px 10px; }
#navigation_tournoi { float: left; width: 885px; padding: 10px 0px 0px 10px; text-align: center; }
label { display: block; width: 150px; float: left; //padding: 28px; }
select { width: 100px; }#alignement { text-align: center; }
dddtd { text-align: left;}
</style>
<script type="text/javascript">function call_update(){ ajax_routine(); setTimeout("call_update()", 1000); //appelle la fonction 1 fois par seconde}
function getXhr(){ var xhr = null; if(window.XMLHttpRequest) // Firefox et autres xhr = new XMLHttpRequest(); else if(window.ActiveXObject) { // Internet Explorer try { xhr = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xhr = new ActiveXObject("Microsoft.XMLHTTP"); } } else { // XMLHttpRequest non supporté par le navigateur alert("Votre navigateur ne supporte pas les objets XMLHTTPRequest..."); xhr = false; }
return xhr;}
function mise_jour_joueur2(){ var xhr = getXhr(); document.getElementById("div_joueur2").style.visibility='visible'; document.getElementById('affiche_resultat').innerHTML = ""; document.getElementById('bloc_listing').style.display = "none";
//document.getElementById("div_filtre").display: none ='hidden'; //document.getElementById("div_filtre").style.display = "none";// document.getElementById("div_filtre").style.display = "block";// document.getElementById("div_filtre").innerHTML = "nada";
/* var div = document.getElementById('div_filtre'); while(div.firstChild) { div.removeChild(div.firstChild); }
*//*var element = document.getElementById("div_filtre");element.parentNode.removeChild(element);*/ /* var e = document.getElementById("div_filtre"); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block';*/
xhr.onreadystatechange = function() { // On ne fait quelque chose que si on a tout reçu et que le serveur est ok if(xhr.readyState == 4 && xhr.status == 200) { leselect = xhr.responseText; // On se sert de innerHTML pour rajouter les options a la liste document.getElementById('div_joueur2').innerHTML = leselect; } }
// Ici on va voir comment faire du post xhr.open("POST","ajax_mise_jour_joueur2.php",true); // ne pas oublier ça pour le post xhr.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); // ne pas oublier de poster les arguments sel = document.getElementById('J1'); joueur = sel.options[sel.selectedIndex].value; xhr.send("joueur="+joueur);}
function filtre(){ var J1 = document.getElementById("J1").value; var J2 = document.getElementById("J2").value; var xhr = getXhr();
xhr.onreadystatechange = function() { // On ne fait quelque chose que si on a tout reçu et que le serveur est ok if(xhr.readyState == 4 && xhr.status == 200) { retour = xhr.responseText; document.getElementById('affiche_resultat').innerHTML = retour; } }
// Ici on va voir comment faire du post xhr.open("POST","new_filtre.php",true); // ne pas oublier ça pour le post xhr.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); // ne pas oublier de poster les arguments //xhr.send("J1="+J1+"&J2="+J2+"&choix1="+choice1+"&choix2="+choice2+"&choix3="+choice3+"&resultat="+resultat); xhr.send("J1="+J1+"&J2="+J2);}</script>
<!----------------------------------------------------------> </head>
<body><!----------------------------------------------------------> <div class="main"> <!-- main --><!---------------------------------------------------------->
<div class="header"> <div class="balise_titre">Patoche</div> <div class="balise_citation"> "Etre conscient que l'on est ignorant est un grand pas vers le savoir" </div> </div>
<div class="banniere"></div> <!---------------------------------------------------------->
<?php/* include("include_barre_login.php"); echo '<div id="box_icon">'; include("debug_connexion_membre.php"); echo '</div>'; include("include_menu.php");*/
echo '<div id="box_infos">'; include("include_menu.php"); echo '<div id="box_icon2">'; include("connexion_membre.php"); echo '</div>'; echo '<div id="box_icon3">'; include("include_barre_login.php"); echo '</div>'; echo '</div>';
$_SESSION['page_active'] = basename (__FILE__ );?>
<!----------------------------------------------------------> <div class="contenu"> <!-- contenu --><!---------------------------------------------------------->
<div class="barre_vide"></div> <div id="navigation_tournoi"> <ul id="menu_horiz"> <li class="tournoi_back_tag_selected"><a href="classement02.php" title="Retour à la page classement">Retour</a></li> <!-- <li class="tournoi_back_tag_selected"><a href="compare_elo.php" title="Graphe compare 2 joueurs">Compare 2 joueurs</a></li> --> <!-- <li class="tournoi_partie_tag"><a href="partie.php" title="aller à la section">Partie</a></li> <li class="tournoi_classement_tag"><a href="classement.php" title="aller à la section">classement</a></li> <li class="tournoi_liste_joueurs_tag"><a href="liste_joueurs.php" title="aller à la section">Joueurs</a></li> <li class="tournoi_stats_tag_selected"><a href="selection_filtre.php" title="aller à la section">stats</a></li> <li class="tournoi_securite_tag"><a href="admin.php" title="aller à la section">Admin</a></li> !--> </ul> </div>
<div id="bloc_stats">
<table> <!--align="center" --> <tr> <td bgcolor="#CCCCCC">Joueur:</td> <td><?php echo $joueur; ?></td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">ELO:</td> <td>
<?php echo $rating." "; if ($oldrating !=0 || $incr!=0) { if ($incr>0 && $oldrating !=0) { echo "(+".$incr.") <img src='images/up.png'"; } elseif($incr<0 && $oldrating !=0) { echo "(".$incr.") <img src='images/down.png'"; } }?> </td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">Meilleur ELO:</td> <td><?php echo $max_rating; if($max_rating !=0) { echo (" (le ".$max_date.")");} ?> </td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">Parties:</td> <td><?php echo $gcount;?></td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">Victoires:</td> <td><?php echo ($wins." (".$winp." %)"); ?></td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">Défaites:</td> <td><?php echo ($losses." (".$lossp." %)"); ?></td> </tr>
<tr> <td height="35.7px" bgcolor="#CCCCCC">Match nul:</td> <td><?php echo ($draws." (".$drawp." %)"); ?></td> </tr>
<tr> <td colspan="2"><div id="chartdiv" align="center" ></div>
<?php if ($gcount !=0) { echo (" <script type=\"text/javascript\"> var myChart = new FusionCharts(\"include/Line.swf\", \"myChartId\", \"900\", \"350\", \"0\", \"0\"); myChart.setDataURL(escape(\"include/data.xml?currTime=\" + getTimeForURL())); myChart.render(\"chartdiv\"); function getTimeForURL(){ var dt = new Date(); var strOutput = \"\"; strOutput = dt.getHours() + \"_\" + dt.getMinutes() + \"_\" + dt.getSeconds() + \"_\" + dt.getMilliseconds(); return strOutput; } </script>" ); } elseif ($gcount == 0) { echo "<div align='center'>Pas de données pour ce joueur!</div>"; }?>
</td> </tr> </table>
<br> <br>
<!------------------------------------------------------------------------------>
<a href="compare_elo02.php"><button>Comparaison entre 2 joueurs</button></a>
<div id="bloc_filtre"> <input type="hidden" name="valide_form" id="valide_form" value="" /> <input type="hidden" name="filtrage" id="filtrage" value="" />
<fieldset style="width: 600px"> <legend>Paramétre du filtre </legend> <p> <label for="nom">Joueur1 :</label> <select name='J1' id='J1' onchange='mise_jour_joueur2()'>
<?php //$sql = "SELECT * FROM classement"; $sql = "SELECT * FROM " .$_SESSION['classement'];
$results = mysql_query($sql); while($val = mysql_fetch_array($results)) { echo "<option>".$val["joueur"]."</option>\n"; }?> </select> </p>
<div id="div_joueur2" style="visibility: hidden;" > </div>
<div id="affiche_resultat"></div>
</fieldset> </div>
<!------------------------------------------------------------------------------>
<div id="bloc_listing"> <div align='center'>Parties disputées:</div> <br>
<table width="750" align="center"> <tr> <div id = "alignement"> <td width="15" align='center' bgcolor="#CCCCCC">ID</td> <td width="15" align='center' bgcolor="#CCCCCC">Resultat</td> <td width="120" align='center' bgcolor="#CCCCCC">ELO</td> <td width="40" align='center' nowrap="nowrap" bgcolor="#CCCCCC">Couleur</td> <td width="200" align='center' bgcolor="#CCCCCC">Adversaire</td> <td width="120" align='center' bgcolor="#CCCCCC">Date</td> </div> </tr>
<?php if($gcount !=0) { //$sql = "SELECT * FROM parties WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc"; $sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc";
$retid = mysql_query($sql);
$id = 1;
while ($row = mysql_fetch_array($retid)) { $white = $row["w_playerID"]; $w_name=$row["w_name"]; $black = $row["b_playerID"]; $b_name=$row["b_name"]; $w_rating = $row["w_arating"]; $b_rating = $row["b_arating"]; $w_brating = $row["w_brating"]; $b_brating = $row["b_brating"]; $result=$row["result"]; $date =$row["date"]; $date=date("d F Y",$date); $date = strftime('%d-%m-%Y',strtotime($date));
$diff_w = $w_rating - $w_brating; $diff_b = $b_rating - $b_brating;
if($white==$playerID) { if ($result==1) { echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/win.png'></td> <td width='120' align='center' >".$w_rating. " (" .$w_brating ." " .$diff_w ." )<img src='images/up.png'></td> <td width='40' align='center'>White</td> <td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/down.png'></td> <td width='120' align='center'>".$date."</td> </tr>"; }
if($result==2) { echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/loss.png'></td> <td width='120' align='center' >".$w_rating. " (" .$w_brating ." " .$diff_w ." )<img src='images/down.png'></td> <td width='40' align='center'>White</td> <td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/up.png'></td> <td width='120' align='center'>".$date."</td> </tr>"; }
if ($result==3) { if($diff_w < 0) { $s1 = "<td width='120' align='center'>".$w_rating. " (" .$w_brating ." " .$diff_w .")<img src='images/down.png'></td>"; $s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/up.png'></td>"; } else { $s1 = "<td width='120' align='center'>".$w_rating. " (" .$w_brating ." " .$diff_w .")<img src='images/up.png'></td>"; $s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/down.png'></td>"; }
echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/draw.png'></td>"; echo $s1;
echo " <td width='40' align='center'>White</td>"; echo $s2; echo " <td width='120' align='center'>".$date."</td> </tr>"; } }
if ($black==$playerID) {
if($result==1) { echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/loss.png'></td> <td width='120' align='center' >".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/down.png'></td> <td width='40' align='center'>Black</td> <td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White <img src='images/up.png'></td> <td width='120' align='center'>".$date."</td> </tr>"; }
if ($result==2) { echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/win.png'></td> <td width='120' align='center'>".$b_rating. " (" .$b_brating ." " .$diff_b.")<img src='images/up.png'></td> <td width='40' align='center'>Black</td> <td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White <img src='images/down.png'></td> <td width='120' align='center'>".$date."</td> </tr>"; }
if ($result==3) { if($diff_w < 0) { $s1 = "<td width='120' align='center' >".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/down.png'></td>"; $s2 = "<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black <img src='images/up.png'></td>"; } else { $s1 = "<td width='120' align='center'>".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/up.png'></td>"; $s2 = "<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black <img src='images/down.png'></td>"; }
echo " <tr> <td width='15' align='center'>".$id."</td> <td width='15' align='center'><img src='images/draw.png'></td>"; echo $s1; echo " <td width='40' align='center'>Black</td>"; echo $s2; echo " <td width='120' align='center'>".$date."</td> </tr>"; } }
$id = $id + 1; } }
else { echo "<td colspan='5' align='center'>Aucunes parties disputées!</td>"; }?>
</table> <br/> <br/> </div>
<!-------------------------------------------------------------------------->
</div>
<br/> <br/> <br/> <br/> <br/>
<!----------------------------------------------------------> <?php include('include_pied_page.php'); include('include_publicite.php');?><!----------------------------------------------------------> </div> <!-- contenu --><!----------------------------------------------------------> </div> <!-- main --><!----------------------------------------------------------> <script type="text/javascript"> call_update(); </script>
</body></html>