File "statistiques_joueurs03_xxxxxxx.php"
Full Path: /home/analogde/www/CB/temp_work/statistiques_joueurs03_xxxxxxx.php
File size: 22.13 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'];
//$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']);
}
?>
<!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>
</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'";
}
}
?>
<?php
$sql = "SELECT * FROM " .$_SESSION['evolution'] ." WHERE playerid = '$playerID' ORDER by date asc ";
$retid = mysql_query($sql);
$row = mysql_fetch_array($retid);
$cpt = 1;
$date_partie = array();
while ($row = mysql_fetch_array($retid))
{
$store = array();
if($cpt >= 22 )
{
//$store = $row["rating"];
//$store[1] = date("d F Y",$row["date"]);
$donnee[] = $row["rating"];
//$date_partie[] = date("d F Y",$row["date"]); OK mais test
$tmp = $row["date"];
$date= date("d F Y",$tmp);
$date_partie[] = strftime('%d-%m-%Y',strtotime($date));
$cpt = $cpt + 1;
}
else
{
$cpt = $cpt + 1;
}
}
// echo ("<pre>");
// print_r($donnee);
$best_elo = max($donnee);
// clé correspondant au best_elo
$key = array_search($best_elo , $donnee);
//echo "+++++ " .$best_elo . " " .$key;
//echo $date_partie[$key];
?>
</td>
</tr>
<tr>
<td height="35.7px" bgcolor="#CCCCCC">Meilleur ELO:</td>
<td><?php echo $best_elo ." (le " .$date_partie[$key] .") : the first 22 parts are not taken into account (unstabilized level)"; //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 disabled>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;
/***************************** improve *************************************************************/
/*
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>";
}
if($diff_b < 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>";
$s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/down.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>";
$s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/up.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>";
*/
/***************************** OK *************************************************************/
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_b < 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');
echo '<pre>' . print_r($_SESSION, TRUE) . '</pre>';
?>
<!---------------------------------------------------------->
</div> <!-- contenu -->
<!---------------------------------------------------------->
</div> <!-- main -->
<!---------------------------------------------------------->
<script type="text/javascript">
call_update();
</script>
</body>
</html>