"; //print_r($arrData); //echo "
"; /*if(!isset($_SESSION['logged']) ) { header ('Location: interdiction.php'); } if($_SESSION['logged']== "no") { header ('Location: interdiction.php'); }*/ ?> Patoche WEBSITE - 2013 - Template du site - en cours de développemment ...Classement ELO
Patoche
"Etre conscient que l'on est ignorant est un grand pas vers le savoir"
'; include("debug_connexion_membre.php"); echo '
'; include("include_menu.php");*/ echo '
'; include("include_menu.php"); echo '
'; include("connexion_membre.php"); echo '
'; echo '
'; include("include_barre_login.php"); echo '
'; echo '
'; $_SESSION['page_active'] = basename (__FILE__ ); ?>
900 && $parties >= 20) //{ $tab_classement[$indice][0] = $indice; $tab_classement[$indice][1] = $joueur; $tab_classement[$indice][2] = $elo; $tab_classement[$indice][3] = $parties; $tab_classement[$indice][4] = $wins; $tab_classement[$indice][5] = $losses; $tab_classement[$indice][6] = $draws; $tab_classement[$indice][7] = $playerID; $tab_classement[$indice][8] = $oldrating; $indice = $indice + 1; //} } //echo "
";
			//print_r($tab_classement);
			//echo "
";

			
			
			echo "

";
?>

 " .$J1 ."  " .$J2  ."  " .$J3;

	$J1_image = "Chess joueurs/".$J1 .".jpg";
	$J2_image = "Chess joueurs/".$J2 .".jpg";
	$J3_image = "Chess joueurs/".$J3 .".jpg";

	if(!file_exists($J1_image)) 
	{
		$J1 = "nophoto";
	} 
	
	if(!file_exists($J2_image)) 
	{
		$J2 = "nophoto";
	} 

	if(!file_exists($J3_image)) 
	{
		$J3 = "nophoto";
	} 

	

?>





";
		//print_r($arrData);
		//echo "
";
		echo "riri";
	
	//echo '';
	
	
	
?>


FusionCharts XT will load here!



"; 

	// affichage du podium
	if( $number != 0)
	{	
		echo '
				

				 ';
		echo '
	
				';
		echo '  
				

					
					
					
				

				 
				'  .$tab_classement[0][1] .' 
				 
				


				

				' .$tab_classement[1][1] .' 
				 
				


				

				' .$tab_classement[2][1] .' 
				


				
	
				


				

 ';
	}
?>
 plot_chart(); "; 	
	
			$nb_joueur = sizeof($tab_classement);
	
			echo "
" .$nb_joueur . " joueurs en lice.

";
			//echo "
Joueurs en lice.

";

			echo "";
			
			for ($i=0; $i < $nb_joueur ; $i++) 
			{
				$indice = $i + 1;
				
				$joueur = $tab_classement[$i][1]; 
				$elo = $tab_classement[$i][2]; ;
				$parties = $tab_classement[$i][3]; 
				$wins = $tab_classement[$i][4]; 
				$losses = $tab_classement[$i][5]; 
				$draws = $tab_classement[$i][6]; 
				$playerID = $tab_classement[$i][7]; 
				$oldrating = $tab_classement[$i][8]; 
				
				$difference_elo = $elo - $oldrating;
				//$plage = $parties - 20;
				$plage = 20;
				
				//$sql = "SELECT * FROM parties WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc LIMIT " .$plage;
				$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc LIMIT " .$plage;
				
				//echo $sql;
				//echo "
";

				$partie_win = 0;
				$partie_losses = 0;
				$partie_nulle = 0;
				
				$results = mysql_query($sql);
				$nb_parties = mysql_num_rows($results);
				//echo $nb_parties;
				//echo "
";
				
				while ($row = mysql_fetch_array($results)) 
				{	 
						$white = $row["w_playerID"]; 
						$black = $row["b_playerID"];
						$result=$row["result"];

						if($white==$playerID)
						{
							if ($result==1) 
							{
								$partie_win = $partie_win + 1;		
							}

							if($result==2)
							{
								$partie_losses = $partie_losses + 1;		
							}

							if ($result==3)
							{
								$partie_nulle = $partie_nulle + 1;		
							}
						}

						if ($black==$playerID)
						{
							if($result==1)
							{
								$partie_losses = $partie_losses + 1;		
							}

							if ($result==2)
							{
								$partie_win = $partie_win + 1;		
							}

							if ($result==3)
							{
								$partie_nulle = $partie_nulle + 1;		
							}
						} 
				} 
	
				//echo $partie_win ."  " .$partie_losses ."  " . $partie_nulle;
				//echo "
";	
				
				$efficacite = ($partie_win + 0.5 * $partie_nulle) / $plage;
				$efficacite = $efficacite * 100;
				$efficacite = round($efficacite, 2);
				
				echo "";

				echo "";
				
				if($elo > $oldrating)
				{
					echo "";
				}
				if($difference_elo < 0)
				{
					echo "";
				}
				
				if($difference_elo == 0)
				{
					echo "";
				}
				//echo "";  // temporaire
				
				if($parties > 20)
				{
					echo "";
				}	  
				else
				{
					echo "";
				}
					
			}			
			
			/*
			for ($i=0; $i < $nb_joueur ; $i++) 
			{
				$playerID = $tab_classement[$i][9]; 
				$parties = $tab_classement[$i][5]; 
				$plage = $parties - 20;
				
				$sql = "SELECT * FROM parties WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc LIMIT " .$plage;
				echo $sql;
				echo "
";
					
				$retid = mysql_query($sql);

				$partie_win = 0;
				$partie_losses = 0;
				$partie_nulle = 0;
				
				$results = mysql_query($sql);
				$nb_parties = mysql_num_rows($results);
				echo $nb_parties;
				echo "
";
				
				while ($row = mysql_fetch_array($retid)) 
				{	 
						$white = $row["w_playerID"]; 
						$black = $row["b_playerID"];
						$result=$row["result"];

						if($white==$playerID)
						{
							if ($result==1) 
							{
								$partie_win = $partie_win + 1;		
							}

							if($result==2)
							{
								$partie_losses = $partie_losses + 1;		
							}

							if ($result==3)
							{
								$partie_nulle = $partie_nulle + 1;		
							}
						}

						if ($black==$playerID)
						{
							if($result==1)
							{
								$partie_losses = $partie_losses + 1;		
							}

							if ($result==2)
							{
								$partie_win = $partie_win + 1;		
							}

							if ($result==3)
							{
								$partie_nulle = $partie_nulle + 1;		
							}
						} 
				} 
	
				echo $partie_win ."  " .$partie_losses ."  " . $partie_nulle;
				echo "
";	
				
				$efficacite = ($partie_win + 0.5 * $partie_nulle) / $plage;
				$efficacite = $efficacite * 100;
				$efficacite = round($efficacite, 2);

				echo $efficacite;
				echo "
";	
				
			}
			*/
			
			
	/*****/
/*	
			$sql = "select * from classement where active=1 ORDER by elo desc ";
			$results = mysql_query($sql);
			$number = mysql_num_rows($results);

			//echo "
$number joueurs en lice.

";
			echo "
Joueurs en lice.

";

			echo "

			ID
			Joueur
			ELO
			Parties	
			Victoires	
			Défaites	
			Match nul
			Efficacité (20 parties)

					  ".$indice."".$joueur."".$elo." (+".$difference_elo.") ".$elo." (".$difference_elo.") ".$elo." (".$difference_elo.") ".$elo."".$parties."
						  ".$wins."
						  ".$losses."
						  ".$draws."
						  ".$efficacite."
						  
".$parties."
						  ".$wins."
						  ".$losses."
						  ".$draws."
						   > 20 parties 
						  
";

			$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 texte en italique

					if ($oldrating !=0)
					{
						if ($rat_increase>0)
						{
							if($elo > 900 && $parties >= 20)
							{
							    $toto = elo_glissant($playerID);
								echo "	";
								/*if($parties >= 20) 		
								{	
									echo "";
								}		
								else
								{
									echo "";
								}*/
/*
								echo "";		
								echo "
										";
							}									
						}	 

						else
						{
							if($elo > 900 && $parties >= 20)
							{
							    $toto = elo_glissant($playerID);
								echo "	";
								/*if($parties >= 20) 		
								{		
										echo "";
								}
								else
								{
										echo "";
								}*/
/*
								echo "";
								echo "	";
							}			
						}
					}

					else
					{
						echo "	";

						if($parties >= 20) 		
						{		
							echo "";
						}
						else
						{
							echo "";
						}

					    $toto = elo_glissant($playerID);

						echo "	";
					}

					$indice = $indice + 1;

			} 	
*/
			echo "

			ID
			Joueur
			ELO
			Parties	
			Victoires	
			Défaites	
			Match nul
			Efficacité (20 parties)

									".$indice."".$joueur."".$joueur."".$joueur."".$elo." (+".$rat_increase.") 
										".$parties."
										".$wins."
										".$losses."
										".$draws."
										".$toto."
										

										".$indice."".$joueur."".$joueur."".$joueur."".$elo." (".$rat_increase.") 
										".$parties."
										".$wins."
										".$losses."
										".$draws."
										".$toto."
										

								".$indice."".$joueur."".$joueur."".$elo."
								".$parties."
								".$wins."
								".$losses."
								".$draws."
								".$toto."
								
";
			mysql_close();
?>
			
			
			
            
" .$msg ."

";
            
            
?>