";
$label = "";
while ($row = mysql_fetch_array($result)) { if ($row["playerID"]) { $infos = $row["rating"] ."" .$row["date"]; $_xml .="\t
'; echo $elo_J1; echo '
'; echo $elo_J2;
//$sql = "SELECT * FROM joueurs WHERE nom = '".$_SESSION['$J1_nom']."' "; $sql = "SELECT * FROM " .$_SESSION['joueurs'] ." WHERE nom = '".$_SESSION['$J1_nom']."' ";
echo $sql;
$result = mysql_query($sql);
$data = mysql_fetch_assoc($result);
$id = $data['id'];
echo $id;
//$sql = "UPDATE joueurs SET score = '".$elo_J1."' WHERE id = '$id' " ; $sql = "UPDATE " .$_SESSION['joueurs'] ." SET score = '".$elo_J1."' WHERE id = '$id' " ;
echo $sql;
//$requete = mysql_query($sql);
//$sql = "SELECT * FROM joueurs WHERE nom = '".$_SESSION['$J2_nom']."' "; $sql = "SELECT * FROM " .$_SESSION['joueurs'] ." WHERE nom = '".$_SESSION['$J2_nom']."' ";
echo $sql; $result = mysql_query($sql); $data = mysql_fetch_assoc($result); $id = $data['id']; echo $id;
//$sql = "UPDATE joueurs SET score = '".$elo_J2."' WHERE id = '$id' " ; $sql = "UPDATE " .$_SESSION['joueurs'] ." SET score = '".$elo_J2."' WHERE id = '$id' " ; echo $sql;
//$requete = mysql_query($sql);
$heure = date("H:i");
$J1_nom = $_SESSION['$J1_nom']; $J2_nom = $_SESSION['$J2_nom']; $resultat_partie = $_POST['selection_score'];
//$sql = "INSERT INTO partie( id, joueur1, joueur2, resultat_partie, score_joueur1, score_joueur2 ,date_partie, heure_partie) // VALUES('', '$J1_nom', '$J2_nom', '$resultat_partie' , '$elo_J1' , '$elo_J2' , NOW(), '$heure' )"; $sql = "INSERT INTO " .$_SESSION['parties'] ." ( id, joueur1, joueur2, resultat_partie, score_joueur1, score_joueur2 ,date_partie, heure_partie) VALUES('', '$J1_nom', '$J2_nom', '$resultat_partie' , '$elo_J1' , '$elo_J2' , NOW(), '$heure' )";
echo $sql;
$requete = mysql_query($sql);
}*/
?>
| Joueur: | |
| ELO: |
0 && $oldrating !=0) { echo "(+".$incr.") |
| Meilleur ELO: | |
| Parties: | |
| Victoires: | |
| Défaites: | |
| Match nul: | |
|
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; } " ); } elseif ($gcount == 0) { echo " Pas de données pour ce joueur! "; }?>
| |
| ID | Resultat | ELO | Couleur | Adversaire | Date | ".$id." | ![]() | ".$w_rating. " (" .$w_brating ." " .$diff_w ." )![]() | White | ".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black ![]() | ".$date." | "; } if($result==2) { echo "
| ".$id." | ![]() | ".$w_rating. " (" .$w_brating ." " .$diff_w ." )![]() | White | ".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black ![]() | ".$date." | ".$w_rating. " (" .$w_brating ." " .$diff_w .")![]() | "; $s2 = "".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black ![]() | "; } else { $s1 = "".$w_rating. " (" .$w_brating ." " .$diff_w .")![]() | "; $s2 = "".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black ![]() | "; }
echo "
| ".$id." | ![]() | "; echo $s1;
echo " White | "; echo $s2; echo "".$date." | ||
| ".$id." | ![]() | ".$b_rating. " (" .$b_brating ." " .$diff_b .")![]() | Black | ".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White ![]() | ".$date." |
| ".$id." | ![]() | ".$b_rating. " (" .$b_brating ." " .$diff_b.")![]() | Black | ".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White ![]() | ".$date." | ".$b_rating. " (" .$b_brating ." " .$diff_b .")![]() | "; $s2 = "".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black ![]() | "; } else { $s1 = "".$b_rating. " (" .$b_brating ." " .$diff_b .")![]() | "; $s2 = "".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black ![]() | "; }
echo "
| ".$id." | ![]() | "; echo $s1; echo " Black | "; echo $s2; echo "".$date." | Aucunes parties disputées! | "; }?>