File "blabla02.php"
Full Path: /home/analogde/www/Bookmarks/CHESS_ON/blabla02.php
File size: 8.96 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('database.php');
DB_connexion();
header('Content-Type: text/html; charset=utf-8');
$playerID = "12";
$sql = "SELECT * FROM parties_new WHERE w_playerID = '$playerID' OR b_playerID = '$playerID' ";
echo $sql;
echo "<br><br>";
$result = mysql_query($sql);
// $num = mysql_num_rows($result);
//echo "<br><br>";
//echo "Nb de parties jouées " .$num;
/*$cpt = 1;
while($data = mysql_fetch_assoc($result))
{
$date = $data["date"];
$date= date("d F Y",$date);
$date = strftime('%d-%h-%Y',strtotime($date));
echo $cpt ." " .$date;
$cpt++;
echo "<br>";
}*/
//$sql = "SELECT * FROM parties WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc";
// $sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_playerid = '$playerID' OR b_playerid = '$playerID' ORDER by date desc";
?>
<table width="750" align="center">
<tr>
<div id = "alignement">
<td width="50" align='center' bgcolor="#CCCCCC">ID</td>
<td width="15" align='center' bgcolor="#CCCCCC">Resultat</td>
<td width="120" align='center' bgcolor="#CCCCCC">ELO</td>
<td width="40" align='center' nowrap="nowrap" bgcolor="#CCCCCC">Couleur</td>
<td width="200" align='center' bgcolor="#CCCCCC">Adversaire</td>
<td width="120" align='center' bgcolor="#CCCCCC">Date</td>
</div>
</tr>
<?php
$sql = "SELECT * FROM parties_new WHERE w_playerID = '$playerID' OR b_playerID = '$playerID' ORDER by date asc ";
echo $sql;
echo "<br><br>";
$graph_data = array();
$result = mysql_query($sql);
$retid = mysql_query($sql);
$id = 1;
while ($row = mysql_fetch_array($retid))
{
$white = $row["w_playerID"];
$w_name=$row["w_name"];
$black = $row["b_playerID"];
$b_name=$row["b_name"];
$w_rating = $row["w_arating"];
$b_rating = $row["b_arating"];
$w_brating = $row["w_brating"];
$b_brating = $row["b_brating"];
$result=$row["result"];
//$date =$row["date"];
//$date=date("d F Y",$date);
//$date_convert = strftime('%d-%m-%Y',strtotime($date));
$date = $row["date"];
$date= date("d F Y",$date);
$date_convert = strftime('%d-%h-%Y',strtotime($date));
$diff_w = $w_rating - $w_brating;
$diff_b = $b_rating - $b_brating;
if($white==$playerID)
{
if ($result==1)
{
echo "
<tr>
<td width='50' align='center'>".$id." " ."W1" ."</td>
<td width='15' align='center'><img src='images/win.png'></td>
<td width='120' align='center' >".$w_rating. " (" .$w_brating ." " .$diff_w ." )<img src='images/up.png'></td>
<td width='40' align='center'>White</td>
<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/down.png'></td>
<td width='120' align='center'>".$date_convert."</td>
</tr>";
$pipo =array( $date_convert , $w_rating);
}
if($result==2)
{
echo "
<tr>
<td width='50' align='center'>".$id." " ."W2" ."</td>
<td width='15' align='center'><img src='images/loss.png'></td>
<td width='120' align='center' >".$w_rating. " (" .$w_brating ." " .$diff_w ." )<img src='images/down.png'></td>
<td width='40' align='center'>White</td>
<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/up.png'></td>
<td width='120' align='center'>".$date_convert."</td>
</tr>";
$pipo =array( $date_convert , $w_rating);
}
if ($result==3)
{
if($diff_w < 0)
{
$s1 = "<td width='120' align='center'>".$w_rating. " (" .$w_brating ." " .$diff_w .")<img src='images/down.png'></td>";
$s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/up.png'></td>";
}
else
{
$s1 = "<td width='120' align='center'>".$w_rating. " (" .$w_brating ." " .$diff_w .")<img src='images/up.png'></td>";
$s2 = "<td width='200' align='center'>".$b_name." ".$b_rating ." (" .$b_brating ." " .$diff_b .") Black <img src='images/down.png'></td>";
}
$pipo =array( $date_convert , $w_rating);
echo "
<tr>
<td width='50' align='center'>".$id."</td>
<td width='15' align='center'><img src='images/draw.png'></td>";
echo $s1;
echo " <td width='40' align='center'>White</td>";
echo $s2;
echo " <td width='120' align='center'>".$date."</td>
</tr>";
}
}
if ($black==$playerID)
{
if($result==1)
{
echo "
<tr>
<td width='50' align='center'>".$id ." " ."B1" ."</td>
<td width='15' align='center'><img src='images/loss.png'></td>
<td width='120' align='center' >".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/down.png'></td>
<td width='40' align='center'>Black</td>
<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White <img src='images/up.png'></td>
<td width='120' align='center'>".$date_convert."</td>
</tr>";
$pipo =array( $date_convert , $b_rating);
}
if ($result==2)
{
echo "
<tr>
<td width='50' align='center'>".$id ." " ."B2" ."</td>
<td width='15' align='center'><img src='images/win.png'></td>
<td width='120' align='center'>".$b_rating. " (" .$b_brating ." " .$diff_b.")<img src='images/up.png'></td>
<td width='40' align='center'>Black</td>
<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") White <img src='images/down.png'></td>
<td width='120' align='center'>".$date_convert."</td>
</tr>";
$pipo =array( $date_convert , $b_rating);
}
if ($result==3)
{
if($diff_b < 0)
{
$s1 = "<td width='120' align='center' >".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/down.png'></td>";
$s2 = "<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black <img src='images/up.png'></td>";
}
else
{
$s1 = "<td width='120' align='center'>".$b_rating. " (" .$b_brating ." " .$diff_b .")<img src='images/up.png'></td>";
$s2 = "<td width='200' align='center'>".$w_name." ".$w_rating ." (" .$w_brating ." " .$diff_w .") Black <img src='images/down.png'></td>";
}
$pipo =array( $date_convert , $b_rating);
echo "
<tr>
<td width='50' align='center'>".$id."</td>
<td width='15' align='center'><img src='images/draw.png'></td>";
echo $s1;
echo " <td width='40' align='center'>Black</td>";
echo $s2;
echo " <td width='120' align='center'>".$date."</td>
</tr>";
}
}
$graph_data[] = $pipo;
$id = $id + 1;
}
?>
</table>
<?php
echo "<pre>";
print_r($graph_data);
echo "</pre>";
echo json_encode($graph_data);
$json = json_encode($graph_data);
file_put_contents("test_data.json", $json)
?>
<script src="Charts_2022/js/fusioncharts.js"></script>
<div id="container"></div>
<script>
const URL_DATA = 'test_data.json';
const URL_SCHEMA = 'infos_elo.json';
const jsonify = res => res.json();
const dataFetch = fetch(URL_DATA).then(jsonify);
const schemaFetch = fetch(URL_SCHEMA).then(jsonify);
Promise.all([dataFetch, schemaFetch]).then(([data, schema]) => {
var fusionTable = new FusionCharts.DataStore().createDataTable(data, schema);
new FusionCharts({
type: 'timeseries',
renderAt: 'container',
width: "90%",
height: 490,
dataSource: {
data: fusionTable,
chart: {
exportEnabled: 0,
//yAxisMaxValue: 2000,
//yAxisMinValue: 1000,
//formatNumberScale: 0,
// numberSuffix: "zz"
},
caption: {
text: 'Evolution de votre score ELO'
},
yAxis: {
"plot": {
"value": "ELO",
"connectNullData": true,
"type": "line"
},
}
}
}).render();
});
<!--
"formatNumberScale": "0",
"formatNumber": "0",
"min": "1000",
"max": "2000",
"formatNumberScale": "0",
-->
// https://www.fusioncharts.com/fusiontime/examples/join-missing-data?framework=javascript
// https://www.fusioncharts.com/fusiontime/examples/plotting-two-variables-measures?framework=javascript
//https://www.fusioncharts.com/fusiontime/examples/plotting-multiple-series-on-time-axis?framework=javascript
</script>