#!/usr/local/bin/php
<?php
/********************************************/	
function remove_old_files($path, $time_ancien)
{
	chdir($path);	
	$current_time = time();
	
	//$cpt = 1;
	$files = glob('*.*');
	foreach($files as $file) 
	{
		$file_creation_time = filemtime($file);
		$difference = $current_time - $file_creation_time;
		
		if(is_file($file)) 
		{
			//echo " *** " .$cpt ."  " .$file ."  " .$file_creation_time ."  " .$time_ancien  ."  " .$difference;
			//echo "<br>";
			//$cpt++;
		
			if ($difference >= $time_ancien) // on prend les plus récent, 3 jours maxi
			{
				unlink($file);
			}	
		}
	}
}
/********************************************/	
function dump_table()
{
	$jour = date('d-m-Y');
	$heure = date("H_i_s");
	$infos = $jour.'-'.$heure;
	$fichier = '/homez.65/analogde/www/Massage/dump/dump_massage_db_auto-'.$infos.'.sql';
	//system("mysqldump --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 --default-character-set=utf8 analogdepat clone_chessmaster_new clone_classement_new clone_evolution_new clone_parties_new clone_elo_affectation > $fichier");


	$current_year = date('Y'); 
	$table = "reservation" .$current_year ."_v3";
		
	// on sauvegarde la table reservation de l'année en court car les année précédente ne sont plus modifiables
	// mains uniquement consultables
	$cmd = "mysqldump --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 --default-character-set=utf8 analogdepat configuration_v3 client gestion_v3 " .$table ." > $fichier";
		
	system($cmd);
	
	// 24 * 3 = 72 fichiers
	
	$time_ancien = 3 * 24 * 60 * 60;
	remove_old_files("dump", $time_ancien);
}	
/********************************************/	
	
	dump_table();
	
	echo "good";
	
?>