File "dump.php"

Full Path: /home/analogde/www/DCIM/Auto/CHESS_2022/dump.php
File size: 7.96 KB
MIME-type: text/x-php
Charset: utf-8

<?php

	$message = "";

	if (isset($_GET['riri'])) 
	{

		echo $_GET['riri'];
		
		//echo "<script> document.getElementById('id_div').style.visibility='visible'; </script>";
		
		 // echo "<script>document.getElementById('id_div').display='block' </script>";
		  
		//$message = "Bingo.....";
		
		//echo "<script> document.getElementById('id_div').value=dgdgdgqgdggdfgdf; </script>";
		
		//echo "<script> document.getElementById('id_div').innerHTML = errMsg;</script>";
		  
		//document.getElementById("image").style.display='none';  
		  
		?>
		<script language="javascript">
		
		//var div = document.getElementById("tel2")
		//div.style.visibility = 'visible';

		//document.getElementById("tel2").style.display = "block";
		//alert("TRACE");
		//toto();
		
		var div = document.getElementById('id_div');
		div.innerHTML += "Here is some more data appended";
		
		</script>
		<?php
		echo "Action ....";
	}
	
	
?>


<link rel="stylesheet" href="//code.jquery.com/ui/1.13.1/themes/base/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script src="https://code.jquery.com/jquery-3.6.0.js"></script>
<script src="https://code.jquery.com/ui/1.13.1/jquery-ui.js"></script>

<script type="text/javascript">


function getXhr()
{
			var xhr = null; 
			if(window.XMLHttpRequest) // Firefox et autres
			   xhr = new XMLHttpRequest(); 
			else if(window.ActiveXObject)
			{ // Internet Explorer 
			   try 
			   {
					xhr = new ActiveXObject("Msxml2.XMLHTTP");
			   } 
			   catch (e) 
			   {
					xhr = new ActiveXObject("Microsoft.XMLHTTP");
			   }
			}
			else 
			{ 
				// XMLHttpRequest non supporté par le navigateur 
				alert("Votre navigateur ne supporte pas les objets XMLHTTPRequest..."); 
				xhr = false; 
			} 

			return xhr;
}

function myFunction(filename)
{
		
		$(function () 
		{
			$( "#dialog" ).dialog({
								modal: true,
								title: "Confirmation",
								closeOnEscape: false,
								buttons: {
											Oui: function()
											{
												$( this ).dialog( "close" );
												fct_restaurer(filename);
											},
											Non: function()
											{
												$( this ).dialog( "close" );
													
											}
										 }
			});
		
			$("#action").click(function () 
			{
				$('#dialog').dialog('open');
			});
		});
	
}

function fct_restaurer(filename)
{
	//alert(filename);
	
	//document.location.href="http://manouvellepage.com"; 
	
	//var div = document.getElementById('id_div');
	
	// show
	//div.style.visibility = 'visible';
	// OR
	//div.style.display = 'block';
	
			var xhr = getXhr();
								
			xhr.onreadystatechange = function()
			{
						// On ne fait quelque chose que si on a tout reçu et que le serveur est ok
						if(xhr.readyState == 4 && xhr.status == 200)
						{
								retour = xhr.responseText;
								
								alert(retour);
								
								if(retour == 1)
								{
									document.getElementById("id_div").innerHTML="L'import du dump a réussi, vous allez être rédirigé dans quelques instants. <br/><br/>";
									//document.ready(window.setTimeout(location.href = "admin.php",2500));
									setTimeout(function(){ window.location="admin.php"; },5000);
								}
								else
								{
									document.getElementById("id_div").innerHTML="Echec de la restauration ?. <br/><br/>";
								}
								
						}
			}

			xhr.open("POST","traitement_dump.php",true);
			xhr.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
	
			//var dump = "Student.sql";
			//alert(dump);
			//xhr.send("filename="+dump);
	
			xhr.send("filename="+filename);

	
	//window.location.href = "dump.php?riri="+filename;
	
	
	
	
}

function toto()
{
	var div = document.getElementById('id_div');
	div.style.visibility = 'visible';
}


/*
			document.getElementById("save").onclick = function() {
            // when clicked the button
			alert("fgfd");
			
            var content = document.getElementById('source').value;
            // a [save as] dialog will be shown
            window.open("data:application/txt," + encodeURIComponent(content), "_self");
        }
*/
</script>

<!-- dialog -->
	<div id="dialog" style="display: none" align = "center">Restaurer la sauvegarde ?.</div>

<?php
	
	header( 'content-type: text/html; charset=utf-8' );
	
	error_reporting(0);
	date_default_timezone_set('Europe/Paris');
	
	$path = "dump";
	$results = array();
	$cpt = 0;
	
	chdir($path);
	array_multisort(array_map('filemtime', ($files = glob("*.*"))), SORT_DESC, $files);
	foreach($files as $filename)
	{
		//echo "<li>".substr($filename, 0, -4)."</li>";
		//echo "<li>" .$filename    ."</li>";
		
		if(is_file($filename))
		{
			$results[$cpt][0] = $filename;
			$results[$cpt][1]= filesize($filename);
			$results[$cpt][2]= filemtime($filename);
			$results[$cpt][3]= date("F d Y H:i:s", filemtime($filename));
			$cpt = $cpt + 1;
		}
	}
	
	echo '<a href="admin.php">Retour...</a>';
	echo '<br><br>';


	if (!isset($_GET['riri'])) 
	{	
	   //echo "<div id='id_div' style='visibility: hidden'>texte affichage</div>";
	    echo "<div id='id_div'></div>";
	}
	/*else
	{
		 echo "<div id='id_div'>patopouf</div>";
	}	*/	


	echo "Liste des points de restaurations dump SQL de la database (toute les heures):";
	echo '<br><br>';
	
	
	echo "<table border=1 cellpadding=5 cellspacing=0>";
	echo "	<tr>
			<th>Id</th>
			<th>Fichier backup</th>
			<th>Date</th>
			<th>Taille en octets</th>
			<th>Restaurer</th>
			<th>Download</th>
			</tr>";
			
	//for($i=0; $i < count($tab_affiche); $i++)
	for($i=0; $i < $cpt; $i++)
		
	{
			$j = $i + 1;
			echo "<tr>
				  <td>" .$j ."</td>";	
			//echo '<td>';
			//echo '<a href="restauration.php?fichier=" .$tab_affiche[$i][0].</a>' .$tab_affiche[$i][0] .'</td>';
			echo '<td>'; 
				  //<a href="restauration.php?fichier='.$tab_affiche[$i][0].'" title = "Restauration">';
			//echo  $tab_affiche[$i][0];
			echo $results[$i][0];
			
			//echo '</a>
			echo	'</td>';
			
			$b = '<input type="button" value="Voir">';
			
			echo "<td align = 'center'>" .$results[$i][3] ."</td>";
			
			echo "<td align = 'center'>" .$results[$i][1] ."</td>";
			
			//$blabla = $tab_affiche[$i][0];
			$blabla = $results[$i][0];
			
			echo "<td align = 'center'>"; 
			//echo "<button type=\"button\" title=\"Lancer la restauration\" id=\"button_restaurer\" onclick=\"window.location.href='https://analog-design.net/CHESS_2022/importer.php?filename=$blabla'\"> Go </>";
			echo '<input type="button" value="Go" onclick="myFunction(\'' . $blabla . '\')">';
			echo "</td>";

			echo "<td align = 'center'>"; 
			//echo "<button type='button' id='save' title='Save as text file'>Save</button>";
			
			//echo "<button type='submit' onclick='window.open(tournoi.php)'>Download!</button>";
			
			//echo "<a href='lulu'  download=" .$blabla .">Download</a>";
			
			
			$path = "/home/analogde/www/CHESS_2022/dump/" .$blabla;
			
			
			
			//echo "<a href=" .$path ." download>" .$path ."</a>";
			
			//echo "<a href=" .$path ." download=" .$path ."><button type=\"button\">Download</button>
			//</a>";
			
			////////echo "<a href='partie.php' download='xyz'> <button type='button'>Download</button></a>";



			//echo "<a href=" .$path ." download=" .$blabla ."> <button type='button'>Download</button></a>";

			echo "<a href=/CHESS_2022/dump/" .$blabla ." download=" .$blabla ."> <button type='button'>Download</button></a>";
			
			echo "</td>";
			
			echo '</td>   </tr>';
	}
	echo "</table>";

	
	//https://www.daniweb.com/programming/web-development/threads/315627/show-and-hide-a-div-in-php
	
	// https://www.sitepoint.com/community/t/solved-hide-div-based-on-database-value/114705/5
?>

<?php

	
?>

<div id="tel2" style="display:none">Viewing all who have been confirmed.</div>

	<div id="message_import" style="display: none">
	<p>
	dfqffggggd
	</p>
	</div>