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) //{ $arrData[$indice][1] = $joueur; $arrData[$indice][2] = $elo; $arrData[$indice][3] = $parties; $arrData[$indice][4] = $wins; $arrData[$indice][5] = $losses; $arrData[$indice][6] = $draws; $arrData[$indice][7] = $playerID; $arrData[$indice][8] = $oldrating; // pour le podium /*if($indice < 3) { $arrData[$indice][7] = $joueur; } else { $arrData[$indice][7] = "no_podium"; }*/ $indice = $indice + 1; //} } //echo "***** " . sizeof($arrData); //echo "
"; //echo "
";
			//print_r($arrData);
			//echo "
";

			/***************** Filtre 2 **************************/
			
			$date = date("d-m-Y");
			list($jour, $mois, $annee) = explode('-', $date);
			$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
			//echo "Timestamp du jour: " .$timestamp;
			//echo "
";
			
			$nb_joueur = sizeof($arrData);
						
            $inc = 0;       
            
            $liste_joueur_exclu = "";     
            $exclu_classement = array();
                        
			for ($i=0; $i < $nb_joueur ; $i++) 
			{
				//$joueur = $liste_joueur[$i];
				$joueur = $arrData[$i][1];
			
				//$sql = "SELECT * FROM parties WHERE w_name = '$joueur' OR b_name = '$joueur' ORDER by date"; //  desc LIMIT 20";
				$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_name = '$joueur' OR b_name = '$joueur' ORDER by date"; //  desc LIMIT 20";
				
				//echo $sql;
				//echo "
";

				$results = mysql_query($sql);
				//$nb_parties = mysql_num_rows($results);
				//echo $nb_parties;
				//echo "
";
					
				$tmp = array();
			
				while($row = mysql_fetch_assoc($results))
				{
					$tmp[] = $row['date'];
				}
			
				$store = array();
				
				$derniere_partie = max($tmp);
				$temps_ecouler = ceil( ( $timestamp - max($tmp) ) / 86400);
				
				// figure dans le classement
				if($temps_ecouler < 50) // 3 mois
				{
					$store[0] = $joueur;
					$store[1] = $arrData[$i][2];;
					$store[2] = max($tmp);
					$store[3]  = date('d/m/Y',  max($tmp));
					$store[4] =  ceil( ( $timestamp - max($tmp) ) / 86400);
					
					$store[5] = $arrData[$i][3]; 
					$store[6] = $arrData[$i][4]; 
					$store[7] = $arrData[$i][5]; 
					$store[8] = $arrData[$i][6];
					$store[9] = $arrData[$i][7];
					$store[10] = $arrData[$i][8];
					
					$tab_classement[] = $store;
				}
                else
                {
                    //$liste_joueur_exclu+= $liste_joueur_exclu . $joueur;
                    //echo $joueur;
                    $exclu_classement[$inc] = $joueur;
                    $inc = $inc + 1;
                }
			}
            
            //echo "
";
            //echo "
";
            //print_r($exclu_classement);
            
            
			
			//echo "
";
			//echo "
";
			//print_r($tab_classement);
			
			

//			$strXML = "";
		
			$nb_joueur = sizeof($tab_classement);
			
//			for ($i=0; $i < $nb_joueur ; $i++) 
//			{
//				$strXML .= "";
//			}
		
//			$strXML .= "";
//			echo renderChart("FCF_Column3D.swf", "", $strXML, "elo", 600, 300);	

			echo "

";
?>







"; 

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

				

				 ';
/*
				';
	*/			
	
		echo '
	
				';
	
	
		echo '  
				

					
				
				
				

					
					
					
				

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


				

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


				

				' .$tab_classement[2][0] .' 
				


				
	
				


				

 ';
	}
?>
" .$nb_joueur . " joueurs en lice.

";
			//echo "
Joueurs en lice.

";

			echo "";
			
			for ($i=0; $i < $nb_joueur ; $i++) 
			{
				$indice = $i + 1;
				
				$joueur = $tab_classement[$i][0]; 
				$elo = $tab_classement[$i][1]; ;
				$parties = $tab_classement[$i][5]; 
				$wins = $tab_classement[$i][6]; 
				$losses = $tab_classement[$i][7]; 
				$draws = $tab_classement[$i][8]; 
				$playerID = $tab_classement[$i][9]; 
				$oldrating = $tab_classement[$i][10]; 
				
				$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 $efficacite;
				//echo "
";	
				
				/*
				[0] => stephaneb
				[1] => 941
				[2] => 1506549600
				[3] => 28/09/2017
				[4] => 31
				[5] => 45
				[6] => 21
				[7] => 23
				[8] => 1
				[9] => playerID
				*/
				
				
				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 ."

";
            
            
?>