Tiny File Manager

Back Back Up Advanced Editor

<?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)
		
?>

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();

});
	
		//  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>