=1)
{
echo "Ce joueur existe deja :" .$prenom;
echo "
";
}
else
{
$sql = "SELECT elo FROM elo_affectation WHERE joueur ='".$prenom."'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$elo = $row['elo'];
$sql = " INSERT INTO classement ";
$sql = $sql . " (joueur, elo, parties, prior, initial) VALUES ";
$sql = $sql . " ('$prenom', '$elo','$partie','$prior', '$elo') ";
//echo $sql;
//echo "
";
$result = mysql_query($sql);
if (!$result)
{
echo("ERROR: " . mysql_error() . "\n$SQL\n");
}
}
}
}
/******************************************************************************************/
function inserer_partie($donnees)
{
$sql = "SELECT * FROM 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);
if($timestamp_ajout > $last_timestamp)
{
algo_elo($donnees, "nostatistique", "sql", 0);
$sql = "SELECT * FROM chessmaster";
$results = mysql_query($sql);
$n = mysql_num_rows($results);
$sql = "SELECT * FROM chessmaster WHERE id = '$n' ";
$results = mysql_query($sql);
$row = mysql_fetch_assoc($results);
$master = $row['gagnant'];
if($J1 == $master && $J2 != $master)
{
if($score_blanc == 1)
{
insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
//echo 1;
}
if($score_blanc == 0 )
{
insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
//echo 2;
}
if($score_blanc == 0.5 && $score_noir == 0.5)
{
insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
//echo 3;
}
}
if($J1 != $master && $J2 == $master)
{
if($score_noir == 1)
{
//echo 4;
insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
}
if($score_noir == 0)
{
//echo 5;
insert_chessmaster_DB($J1, $J2, $J1, $timestamp_ajout);
}
if($score_blanc == 0.5 && $score_noir == 0.5)
{
//echo 6;
insert_chessmaster_DB($J1, $J2, $J2, $timestamp_ajout);
}
}
$retour = "simple";
}
else
{
// recherche si la date existe ?
$test = array_search( $timestamp_ajout , $list_timestamp); // retourne la cle si elle existe
if($test != "")
{
//echo "Timestamp existe...";
//echo "Ce que je recherche -> " .$mois ." " .$jour ." " .$annee ." " .$timestamp_ajout;
//echo "
";
//echo "Position " .$test;
//echo "
";
//echo $list_timestamp[$test];
$array = array_count_values($list_timestamp);
$nb_partie = $array[$timestamp_ajout];
//echo "
";
//echo $nb_partie;
//echo "
";
$index_ajout = $test + $nb_partie - 1;
//echo $index_ajout;
}
else
{
echo "Timestamp au plus proche...";
// 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;
}
}
//echo "Ce que je recherche -> " .$mois ." " .$jour ." " .$annee ." " .$timestamp_ajout;
//echo "
";
//echo "Ce que je trouve ->" .$min;
//echo "
";
//echo "La date :" .date('d/m/Y', $min);
$test = array_search( $min , $list_timestamp);
//echo "
";
//echo "Position " .$test;
$array = array_count_values($list_timestamp);
$nb_partie = $array[$min];
//echo "
";
//echo $nb_partie;
//echo "
";
//$diff = $timestamp_ajout-$min;
//echo $diff;
// avant
if($timestamp_ajout < $min)
{
$index_ajout = $test - 1 ;
//echo $index_ajout;
}
// apres
if($timestamp_ajout > $min)
{
$index_ajout = $test ;
//echo $index_ajout;
}
}
$tmp = transfert_DB();
//echo "";
//print_r($tmp);
$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];
}
/*echo "------------------TABLE------------------------
";
print_r($table_fichier);
echo "-----------------------------------------------
";
echo "------------------TAB 1------------------------
";
print_r($tab1);
echo "-----------------------------------------------
";
print_r($donnees);
echo "------------------TAB 2------------------------
";
print_r($tab2);
echo "-----------------------------------------------
";*/
$table[] = $donnees;
$tab_global = array_merge($tab1,$table, $tab2);
echo "";
print_r($tab_global);
regenerer_DB($tab_global);
$retour = "complexe";
}
return($retour);
}
?>