File "ooo.php"
Full Path: /home/analogde/www/Freebox/CHESS_ON/ooo.php
File size: 7.77 KB
MIME-type: text/x-php
Charset: utf-8
<?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;
}
}
?>