Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start();
	//include('database.php');
	//DB_connexion(); 
	
	include('correlation.php');
	include('chessmaster.php');
			
	$_SESSION['chessmaster'] = "clone_chessmaster_new";	
	$_SESSION['classement'] = "clone_classement_new";
	$_SESSION['parties'] = "clone_parties_new";
	$_SESSION['evolution'] = "clone_evolution_new";

/**************************************************************/
function check_date($data) 
{
			if (date('d-m-Y', strtotime($data)) == $data) 
			{
				return "OK";
			} 
			else 
			{
				return "Erreur";
			}
}
/**************************************************************/
function inserer_partie($donnees) 
{
			//$sql = "SELECT * FROM parties";
			$sql = "SELECT * FROM " .$_SESSION['parties'];
			
			$results = mysql_query($sql);
			while($row = mysql_fetch_assoc($results))
			{
				$list_timestamp[] = intval($row["date"]);
			}
			
			$timestamp_ajout = $donnees[0];
			$J1 = $donnees[1] ;
			$J2 = $donnees[2];
			$score_blanc = $donnees[3];
			$score_noir = $donnees[4];
			
			// retourne le dernier timestamp
			$last_timestamp = end($list_timestamp);
			
			// il s'agit de la suite de la table : un simple ajout sans un le recalcule
			if($timestamp_ajout >= $last_timestamp)
			{
						algo_elo($donnees, "nostatistique", "sql", 0);
					
						//$sql = "SELECT * FROM chessmaster";
						$sql = "SELECT * FROM " .$_SESSION['chessmaster'];
						$results = mysql_query($sql);
					
			
						if (mysql_num_rows($results) != 0) 
						{
						
								$sql = "SELECT * FROM " .$_SESSION['chessmaster'];
								$results = mysql_query($sql);

$n =  mysql_num_rows($results);
								//$sql = "SELECT * FROM chessmaster WHERE id = '$n' ";
								//$sql = "SELECT * FROM " .$_SESSION['chessmaster'] ." WHERE id = '$n' ";
								
								$sql = "SELECT * FROM " .$_SESSION['chessmaster'] ." ORDER BY id DESC LIMIT 1 ";
								
								
								$sql = "SELECT * FROM clone_chessmaster_new ORDER BY id DESC LIMIT 1 ";
								
								//SELECT champs FROM tatable ORDER BY id DESC LIMIT 0, 1

//SELECT fields FROM table ORDER BY id DESC LIMIT 1;
								
								$results = mysql_query($sql);
								$row = mysql_fetch_assoc($results);
								$master = $row['gagnant'];
						
								// NOTA: $J1, $J2, $gagnant, $timestamp)
						
								if($J1 == $master &&  $J2 != $master)
								{
									if($score_blanc == 1)
									{
										insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
									}
									if($score_blanc == 0 )
									{
										insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
									}
									if($score_blanc == 0.5 && $score_noir == 0.5)
									{
										//avant la modif:  insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
										insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);  // le noir gagne
									}
								}	
				
								if($J1 != $master &&  $J2 == $master)
								{
									if($score_noir == 1)
									{
										insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
									}
									if($score_noir == 0)
									{
										insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
									}
									if($score_blanc == 0.5 && $score_noir == 0.5)
									{
										insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
									}
								}	
						}		
						
						
						else
						{
								$score_blanc = $donnees[3];
								$score_noir = $donnees[4];

if( $score_blanc == 1 && $score_noir == 0)
								{
									insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
								}		
								if( $score_blanc == 0 && $score_noir == 1)
								{
									insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
								}	
								
								//$retour = "simple";
						}		
						
			}
/*	
			else
			{
				// recherche si la date existe ?
				// retourne la cle si elle existe
				$test =  array_search( $timestamp_ajout , $list_timestamp); 
			
				if($test != "")
				{
					// timestamp existe...
					$array = array_count_values($list_timestamp);
					$nb_partie = $array[$timestamp_ajout];
					$index_ajout =  $test + $nb_partie - 1;
				}
			
				else
				{
					// on fait un recherche pour trouver le timestamp le plus proche
					$num= $timestamp_ajout; 
					$diff = $num;
					$min = $num;

foreach($list_timestamp as $a)
					{
					  if( abs($a-$num)< $diff )
					  {
						  $diff=abs($a-$num);
						  $min=$a;
					  }
					}
				
					$test =  array_search( $min , $list_timestamp);
					$array = array_count_values($list_timestamp);
					$nb_partie = $array[$min];
					
					// avant 
					if($timestamp_ajout < $min)
					{
						$index_ajout =  $test - 1 ;
					}
					// apres
					if($timestamp_ajout > $min)
					{
						$index_ajout =  $test  ;
					}
				}

// un recalcule est obligatoire
				$tmp = transfert_DB();
				$donnees[0] = date('d/m/Y', $timestamp_ajout);
				$nb_parties = $tmp[0];
				$table_fichier = $tmp[1];
				$tab1 = array();
				$tab2 = array();

for ($i=0; $i <= $index_ajout ; $i++)
				{
					$tab1[] = $table_fichier[$i];
				}
									
				for ($i=$index_ajout + 1 ; $i < $nb_parties; $i++)
				{
					$tab2[] = $table_fichier[$i];
				}

$table[] = $donnees;
				$tab_global = array_merge($tab1,$table, $tab2);
				regenerer_DB($tab_global);
				$retour = "complexe";
			}
*/			
}
/**************************************************************/

$jour = 25;
				$mois = "Juillet";
				$annee = "2022";
				$J1 = "StephaneR";
				$J2 = "HenriqueF";
				$selection_score = "Blanc gagne";
			
				$jour = $_POST['jour'];
				$mois = $_POST['mois'];
				$annee = $_POST['annee'];
				$J1 = $_POST['J1'];
				$J2 = $_POST['J2'];
				$selection_score = $_POST['selection_score'];
			
			echo 
			
				echo "...." .$jour ."  " .$mois ."  "  .$annee ."  "  .$J1 . "  " .$J2 . "  " .$selection_score;
			
				switch ($selection_score)
				{
					case "Blanc gagne":
						$score_blanc = "1";
						$score_noir = "0";
						$flag_validation = true;
						break;
					case "Blanc perd":
						$score_blanc = "0";
						$score_noir = "1";
						$flag_validation = true;
						break;
					case "Match nul":
						$score_blanc = "0.5";
						$score_noir = "0.5";
						$flag_validation = true;
						break;
				}	
				
				if($flag_validation == true)
				{
						$tab_associatif = array(); 
						$tab_associatif ['Janvier']='1';
						$tab_associatif ['Février']='2';
						$tab_associatif ['Mars']='3';
						$tab_associatif ['Avril']='4';
						$tab_associatif ['Mai']='5';
						$tab_associatif ['Juin']='6';
						$tab_associatif ['Juillet']='7';
						$tab_associatif ['Aôut']='8';
						$tab_associatif ['Septembre']='9';
						$tab_associatif ['Octobre']='10';
						$tab_associatif ['Novembre']='11';
						$tab_associatif ['Décembre']='12';
						$mois = $tab_associatif[$mois];
						
						$num_jour = intval($jour);
						$num_mois = intval($mois);
						
						if($num_jour < 10)
						{
							$jour = '0' .$jour;
						}
						
						if($num_mois < 10)
						{
							$mois = '0' .$mois;
						}
						
						$date_format = $jour ."-" .$mois ."-" .$annee; 
						
						if(check_date($date_format) == "Erreur") 
						{
							echo 2;
						}
						
						else
						{
							$timestamp_ajout = mktime (0, 0, 0, $mois, $jour, $annee);
								
							$donnees = array();
							$donnees[0] = $timestamp_ajout;
							$donnees[1] = $J1;
							$donnees[2] = $J2;
							$donnees[3] = $score_blanc;
							$donnees[4] = $score_noir;
								
							//echo "<pre>";
							//var_dump($donnees);
							//echo "</pre>";
							
							inserer_partie($donnees); 
							echo 1;
						}
				}