";
$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']."' ";
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' " ;
echo $sql;
//$requete = mysql_query($sql);
$sql = "SELECT * FROM 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' " ;
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' )";
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! | "; } ?>