Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start();
	include('correlation.php');
	include('chessmaster.php');
	include('generation_chessmaster.php');

https://fr.pornhub.com/channels/my-pervy-family/videos?page=3
	
	//include('correlation.php');
	//include('echec_fonctions_communes.php');
	//include('chessmaster.php');

function check_date($data) 
{
    if (date('d-m-Y', strtotime($data)) == $data) 
	{
        return "OK";
    } 
	else 
	{
        return "Erreur";
    }
}

echo " Debug insere partie ....";
			echo " ";

$flag_validation = false;

$jour = $_POST['jour'];
			$mois = $_POST['mois'];
			$annee = $_POST['annee'];
			$J1 = $_POST['J1'];
			$J2 = $_POST['J2'];
			$selection_score = $_POST['selection_score'];
			$date_reference = $_POST['date_reference'];
			$option_date = $_POST['option_date'];
			$id_partie = $_POST['id_partie'];

//inserer_partie.php?id=1&J1=%20AlvaroM&J2=%20StephaneR&score=%201%20-%200&date=%2015/06/2022
			//AlvaroM	1700	StephaneR	1300	1 - 0	15/06/2022
			//2 20 Juillet 2022 RemyS StephaneR Blanc gagne apres 1655244000

$jour = 20;
			$mois = "Juillet";
			$annee = 2022;
			$J1 = "RemyS";
			$J2 = "StephaneR";
			$selection_score = "Blanc gagne";
			$date_reference = 1655244000;
			$option_date = "apres";
			$id_partie = 2;
			
			
			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 "Noir gagne":
						$score_blanc = "0";
						$score_noir = "1";
						$flag_validation = true;
						break;

case "Noir perd":
						$score_blanc = "1";
						$score_noir = "0";
						$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") 
					{
						//$message = '<div id="message_traitement" style="display:block">Date non valide.</div>';
						header ('Location: interdiction.php');
					}
					else
					{
						echo "TRACE 1 ";
						echo " ";
					
						$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
						
						echo "time " .$timestamp;
						echo " ";
						echo "reference " .$date_reference;
						echo " ";
						//echo $_POST['date_reference'];
						//echo $_POST['option_date'];

if($option_date == "avant")
						{
							//echo $timestamp ." **** " .$_POST['date_reference'];
							if($timestamp <= $date_reference)
							{
								$plage_date = "Ok";
							}	
							else
							{
								$plage_date = "Erreur_avant";
							}
						}

if($option_date == "apres")
						{
							//echo $timestamp ." **** " .$_POST['date_reference'];
							if($timestamp >= $date_reference)
							{
								$plage_date = "Ok";
							}	
							else
							{
								$plage_date = "Erreur_apres";
							}
						}

if($plage_date == "Ok")
						{
							echo "VROOM...";
							//echo " ---> " .$timestamp + " " .$date_reference;
							echo " ";
						
							$donnees = array();
							$donnees[0] = $jour ."/" .$mois ."/" .$annee; 
							$donnees[1] = $J1;
							$donnees[2] = $J2;
							$donnees[3] = $score_blanc;
							$donnees[4] = $score_noir;

$sql = "SELECT * FROM " .$_SESSION['parties'] ." ORDER by date asc"; 
							$results = mysql_query($sql);
							$nb_parties = mysql_num_rows($results);

while($row = mysql_fetch_assoc($results))
							{
								$blanc = $row['w_name'];
								$noir = $row['b_name'];
								$date = $row['date'];
								$resultat = $row['result'];
								$date_partie = date('d/m/Y', $date);

if($resultat == 1)
								{
									$_score_blanc = 1;
									$_score_noir = 0;
								}
								if($resultat == 2)
								{
									$_score_blanc = 0;
									$_score_noir = 1;
								}

if($resultat == 3)
								{
									$_score_blanc = 0.5;
									$_score_noir = 0.5;
								}

$table_csv[0] = $date_partie;
								$table_csv[1] = $blanc;
								$table_csv[2] = $noir;
								$table_csv[3] = $_score_blanc;
								$table_csv[4] = $_score_noir;
								$table_fichier[] = $table_csv;
							}

echo " TRACE 2 ";
							echo " ";
							
							echo "<pre>";
							print_r($table_fichier);
							echo "</pre>";
							
							
							$nom_fichier = "sauvegarde_insertion.txt";

$fp = fopen($nom_fichier, 'w');

for ($i=0; $i < $nb_parties; $i++)
							{
								$str_comma_separated = implode(";", $table_fichier[$i]);
								fputs ($fp, $str_comma_separated);
								if($i != $nb_parties - 1)
								fputs($fp, "\n");
							}

fclose($fp);

// creation du fichier modifie

$nom_fichier = "new_insertion.txt";

if($option_date == "avant")
							{
								$id_position = $id_partie -1;
							}

if($option_date == "apres")
							{
								$id_position = $id_partie ;
							}

$tab1 = array();
							$tab2 = array();

$fp = fopen($nom_fichier, 'w'); 
							for ($i=0; $i <= $id_position - 1; $i++)
							{
								$tab1[] = $table_fichier[$i];
							}

$table[] = $donnees;

for ($i=$id_position ; $i < $nb_parties; $i++)
							{
								$tab2[] = $table_fichier[$i];
							}

$tab_global = array_merge($tab1,$table,$tab2);
							
							$fp = fopen($nom_fichier, 'w'); 
							
							for ($i=0; $i < count($tab_global); $i++)
							{
								$str_comma_separated = implode(";", $tab_global[$i]);
								fputs ($fp, $str_comma_separated);

if($i != count($tab_global) - 1)
								{
									fputs($fp, "\n");
								}
							}

fclose($fp);
							
							/***********************************/
							
							$str1 = "TRUNCATE TABLE " .$_SESSION['classement'];
							$str2 = "TRUNCATE TABLE " .$_SESSION['evolution'];
							$str3 = "TRUNCATE TABLE " .$_SESSION['parties'];
							$str4 = "TRUNCATE TABLE " .$_SESSION['chessmaster'];
				
							//mysql_query($str1);
							//mysql_query($str2);
							//mysql_query($str3);
							//mysql_query($str4);

echo "Initialisation de la table classement ....";
							echo " ";
	
							$sql = "INSERT INTO `clone_classement_new` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
							(1, 'AlvaroM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(2, 'DamienB', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(3, 'EmileM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(4, 'FranckV', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(5, 'HenriqueF', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(6, 'PatrickA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(7, 'PhilippeA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(8, 'RemyS', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
							(9, 'StephaneR', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1); ";
							//$result = mysql_query($sql);
	
							$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
							//$result = mysql_query($sql);
							
							/***********************************/
							
							$file = fopen ("new_insertion.txt","r");
		
							$indice = 1;	
							while(! feof($file))
							{
								$tmp = fgets($file);
								$tmp = strtolower($tmp);
								//echo $tmp ." ";
								//$tmp = str_to_noaccent($tmp);
								$pieces = explode(";", $tmp);
								$donnees[0] = $pieces[0];
								list($jour, $mois, $annee) = explode('/', $donnees[0]);
								$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
								$donnees[0] = $timestamp; 
								$donnees[1] = $pieces[1];
								$donnees[2] = $pieces[2];
								$donnees[3] = $pieces[3];
								$donnees[4] = $pieces[4];
								//algo_elo($donnees, "nostatistique", "sql", $indice );
								$indice = $indice + 1;
							}
				
							echo " ";
					
							//generer_chessmaster();

echo "Script executé avec succés";	
							echo " ";
				
							//partie insérée dans la database
							echo 1;
						}

else
						{
							//Date non valide dans la plage définie 
							echo 2 ." " .$timestamp ." " .$date_reference ." " .$option_date;
						}
					}	
			}

else
			{
				//Erreur dans le traitement
				echo 3;
			}