900 && $parties >= 20) //{ $arrData[$indice]["label"] = $joueur; $arrData[$indice]["value"] = $elo; $indice = $indice + 1; //} } //echo "
";
	//print_r($arrData);
	//echo "
"; /*if(!isset($_SESSION['logged']) ) { header ('Location: interdiction.php'); } if($_SESSION['logged']== "no") { header ('Location: interdiction.php'); }*/ $playerID = 12; //$_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=""; $label = ""; while ($row = mysql_fetch_array($result)) { if ($row["playerID"]) { $infos = $row["rating"] ."" .$row["date"]; $_xml .="\t\r\n"; //$_xml .=" value='" . $row["rating"] ."'/>\r\n"; } else { $_xml .="\t\r\n"; $_xml .="\t\tnone\r\n"; $_xml .="\t\r\n"; } } $_xml .=""; 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']); } ?> Patoche WEBSITE - 2013 - Template du site - en cours de développemment ...
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; //} } $J1 = $tab_classement[0][1]; $J2 = $tab_classement[1][1]; $J3 = $tab_classement[2][1]; //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"; } $sql = "SELECT * FROM " .$_SESSION['parties']; $results = mysql_query($sql); $number = mysql_num_rows($results); echo "Nombre de parties : " .$number; echo "

"; // affichage du podium /* if( $number != 0) { echo '
'; echo ' '; echo '
  ' .$tab_classement[0][1] .'  
' .$tab_classement[1][1] .'  
' .$tab_classement[2][1] .'


'; } */ echo '
FusionCharts XT will load here!
'; 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( $parties == 0) { //$sql = "SELECT * FROM " .$_SESSION['elo_affectation '] . "where id = " .$playerID ; //$results = mysql_query($sql); //while($row = mysql_fetch_assoc($results)) //{ //echo ""; //echo ""; //} echo ""; } else { if($elo > $oldrating) { echo ""; } if($difference_elo < 0) { echo ""; } if($difference_elo == 0) { echo ""; } } //echo ""; // temporaire /*if($parties == 0) { echo ""; }*/ if($parties > 20) { echo ""; } else { echo ""; } } echo "
ID Joueur ELO Parties Victoires Défaites Match nul Efficacité (20 parties)
".$indice."".$joueur."ELO initial" .$row["elo"] ."ELO initial".$elo." (+".$difference_elo.") ".$elo." (".$difference_elo.") ".$elo." (".$difference_elo.") ".$elo."nada".$parties." ".$wins." ".$losses." ".$draws." ".$efficacite."
".$parties." ".$wins." ".$losses." ".$draws." > Calculer sur 20 parties
"; mysql_close(); ?>





' . print_r($_SESSION, TRUE) . ''; ?>