<?php

	session_start();

	include('database.php');

	include('elo_glissant02.php');

	DB_connexion(); 

	error_reporting( 0 );



	include("FusionCharts.php");

	include("FC_Colors.php");

	

	/*if(!isset($_SESSION['logged']) )

	{		header ('Location: interdiction.php');

	}

	

	if($_SESSION['logged']== "no")

	{

		header ('Location: interdiction.php');

	}*/

	

?>



<!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 ...Classement ELO</title>



<!---------------------------------------------------------->	

<?php

		include('include_css_template_commun.php');

		include('include_css.php');

		include('css_tools_skill.php');

		include('include_javascript.php');

?> 



<link href="http://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet">

<script src="http://code.jquery.com/jquery-1.10.2.js"></script>

<script src="http://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>



<script language="javascript" src="FusionCharts.js"></script>



<style type="text/css">

#bloc_classement_joueur { float: left;

					width: 831px; 

					padding: 50px 50px 25px 50px;

					}	

					

#navigation_tournoi{

					float: left;

					width: 910px; // 870

					padding: 10px 0px 0px 10px;

					text-align: center;

		}

					

</style>



<script type="text/javascript">



function call_update()

{

			scruter(); 

			setTimeout("call_update()", 1000); 

}



function scruter()

{

			var xhr = getXhr()

			// On défini ce qu'on va faire quand on aura la réponse

			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)

					{

						//alert(xhr.responseText);

						retour = xhr.responseText;

						

						if(retour == 0)

						{  	

		

							$(function()

							{

									$( "#message_expiration" ).dialog({

									modal: true,

									title: "Infos",

									buttons: {

												Ok: function()

												{

													$( this ).dialog( "close" );

													 document.location.href = "logout_expire.php";

												}

											 }

										});

							});

						}

					}

			}

					

			xhr.open("GET","session_timeout.php",true);

			xhr.send(null);

}

</script>



<!---------------------------------------------------------->	

</head>



<body>

<!---------------------------------------------------------->	

	<div class="main"> <!-- main -->

<!---------------------------------------------------------->	



			<div class="header">

                <div class="balise_titre">Patoche</div>

                <div class="balise_citation">

                &quot;Etre conscient que l'on est ignorant est un grand pas vers le savoir&quot;

                </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_partie_tag"><a href="partie.php" title="aller à la section">Duel</a></li>

				<li class="tournoi_simulation_tag"><a href="simulation.php" title="aller à la section">Sim</a></li>

				<li class="tournoi_classement_tag_selected"><a href="classement.php" title="aller à la section">ELO</a></li>

				<li class="tournoi_master_tag"><a href="on_chess_master.php" title="aller à la section">Master</a></li>

				<li class="tournoi_liste_joueurs_tag"><a href="joueurs_echec.php" title="aller à la section">Players</a></li>

				<li class="tournoi_stats_tag"><a href="historique.php" title="aller à la section">Games</a></li>

				<li class="tournoi_securite_tag"><a href="admin.php" title="aller à la section">Admin</a></li>

				</ul>

				

			</div>

			

			<div id="bloc_classement_joueur">

	

<?php			



			$sql = "select * from classement where active=1 ORDER by elo desc ";

			$results = mysql_query($sql);

			$number = mysql_num_rows($results);



			$indice = 0;

	

			while($row = mysql_fetch_assoc($results))

			{

							$joueur = $row["joueur"]; 

							$elo = $row["elo"];

							$parties = $row["parties"];



							if($elo > 900 && $parties >= 20)

							{

									$arrData[$indice][1] = $joueur;

									$arrData[$indice][2] = $elo;

									

									if($indice < 3)

									{

										$arrData[$indice][3] = $joueur;

									}

									$indice = $indice + 1;

							}



			}	



			//Init  <graph> element

	//$strXML = "<graph caption='Classement score ELO' numberPrefix='' formatNumberScale='0' decimalPrecision='0'>";

	$strXML = "<graph caption='Classement score ELO' yAxisMinValue='900' formatNumber='0' formatNumberScale='0' decimalPrecision='0'>";

	

	//Convertir les datas en XML puis append

	foreach ($arrData as $arSubData)

		$strXML .= "<set name='" . $arSubData[1] . "' value='" . $arSubData[2] ."' color='". getFCColor() ."' />";

	

	$strXML .= "</graph>";

	

	//Creation du chart - Column 3D Chart avec les datas contenues dans strXML

	echo renderChart("FCF_Column3D.swf", "", $strXML, "elo", 600, 300);	



	echo "<br><br>";

?>



<?php



	$J1 = $arrData[0][3]; 

	$J2 = $arrData[1][3]; 

	$J3 = $arrData[2][3]; 



	$J1 = "Chess joueurs/".$J1 .".jpg";

	$J2 = "Chess joueurs/".$J2 .".jpg";

	$J3 = "Chess joueurs/".$J3 .".jpg";

	

?>



<!-- Podium --->

<center>

<table width="500" border="0">

  <tr>

    <th scope="col"><img src="<?php echo $J2; ?>" width="128" height="128" title = "Le Challenger Italien !"/></th>

    <th scope="col"><img src="<?php echo $J1; ?>" alt="" width="128" height="128"  title="L'indétronable  le retour!" /></th>

    <th scope="col"><img src="<?php echo $J3; ?>" alt="" width="128" height="128" title = "Le troublion en embuscade !" /></th>

  </tr>

  <tr>

    <td>&nbsp;</td>

    <td rowspan="3" align="center" bgcolor="#F5BF0C"><?php echo $arrData[0][3]; ?> </td>

    <td>&nbsp;</td>

  </tr>

  <tr>

    <td rowspan="2" align="center" bgcolor="#B0D7F8"><?php echo $arrData[1][3]; ?> </td>

    <td>&nbsp;</td>

  </tr>

  <tr>

    <td align="center" bgcolor="#8CBA02"><?php echo $arrData[2][3]; ?></td>

  </tr>

</table>	

</center>



<br><br>



<?php



	/*****/



			$sql = "select * from classement where active=1 ORDER by elo desc ";

			$results = mysql_query($sql);

			$number = mysql_num_rows($results);

				

			//echo "<p align=center>$number joueurs en lice.</p><br>";

			echo "<p align=center>Joueurs en lice.</p><br>";

				

			echo "<table border=1 align=center width='80%'><tr>

			<th>ID</th>

			<th>Joueur</th>

			<th>ELO</th>

			<th>Parties</th>	

			<th>Victoires</th>	

			<th>Défaites</th>	

			<th>Match nul</th>

			<th>Efficacité (20 parties)</th>";

				

			$indice = 1;

				

			while($row = mysql_fetch_assoc($results))

			{

					$joueur = $row["joueur"]; 

					$elo = $row["elo"];

					$parties = $row["parties"];

					$prior = $row["prior"];

					$bonus = $row["bonus"];

					

					$wins = $row["wins"];

					$losses = $row["losses"];

					$draws = $row["draws"];

					

					$toto = ($wins + 0.5 * $draws) / $parties;

					$toto = $toto * 100;

					$toto = round($toto, 2);

					$toto = $toto ." %";

					

					$oldrating=$row["oldrating"];

					$playerID=$row["id"];

					$rat_increase = $elo - $oldrating;

					

					// si partie < 20 -> italique <EM>texte en italique</EM>

					

					if ($oldrating !=0)

					{

						if ($rat_increase>0)

						{

									

							if($elo > 900 && $parties >= 20)

							{

							    $toto = elo_glissant($playerID);

								echo "	<tr>

									<td align=center>".$indice."</td>";

									

								/*if($parties >= 20) 		

								{	

									echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'>".$joueur."</a></td>";

								}		

								else

								{

									echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'><em>".$joueur."</em></a></td>";

								}*/

										

								echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'>".$joueur."</a></td>";		

								echo "

										<td align=center>".$elo." (+".$rat_increase.")&nbsp;<img src='images/up.png' title='Derniére partie'></td>

										<td align=center>".$parties."</td>

										<td align=center>".$wins."</td>

										<td align=center>".$losses."</td>

										<td align=center>".$draws."</td>

										<td align=center>".$toto."</td>

										</tr>";

							}									

						}	 

			

						else

						{

							

							if($elo > 900 && $parties >= 20)

							{

							    $toto = elo_glissant($playerID);

								echo "	<tr>

										<td align=center>".$indice."</td>";

							

								/*if($parties >= 20) 		

								{		

										echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'>".$joueur."</a></td>";

								}

								else

								{

										echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'><em>".$joueur."</em></a></td>";

								}*/

								

								echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'>".$joueur."</a></td>";

								echo "	<td align=center>".$elo." (".$rat_increase.")&nbsp;<img src='images/down.png' title='Derniére partie'></td>

										<td align=center>".$parties."</td>

										<td align=center>".$wins."</td>

										<td align=center>".$losses."</td>

										<td align=center>".$draws."</td>

										<td align=center>".$toto."</td>

										</tr>";

							}			

						}

					}



					else

					{

		

						echo "	<tr>

								<td align=center>".$indice."</td>";

						if($parties >= 20) 		

						{		

							echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'>".$joueur."</a></td>";

						}

						else

						{

							echo "<td align=center><a href=\"statistiques_joueurs.php?playerID=$playerID\" title='Statistiques'><em>".$joueur."</em></a></td>";

						}

					    $toto = elo_glissant($playerID);

						echo "	<td align=center>".$elo."</td>

								<td align=center>".$parties."</td>

								<td align=center>".$wins."</td>

								<td align=center>".$losses."</td>

								<td align=center>".$draws."</td>

								<td align=center>".$toto."</td>

								</tr>";

					}

					

					$indice = $indice + 1;

					

			} 	



			echo "</table>";

			

			mysql_close();

?>



			</td>

			</tr>

			</table>

				

			<div id="message_expiration" style="display: none">

			<p>

			<span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>

			La session a expiré. veuillez vous reconnecter.

			</p>

			</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>

