[go: up one dir, main page]
Menu ▾ ▴

[r21]: / backupsTable.php  Maximize  Restore  History

Download this file

75 lines (66 with data), 2.2 kB 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php 

include('includes/databaseLogin.php'); 

include('includes/installedLanguage.php'); 

echo "<!DOCTYPE html>";

?>



<html>

<head>

    <link rel="stylesheet" href="css/style.css" />

</head>



<body>

<?php 

	mysql_query("BEGIN");

	$dir = "../../backups";

	$bkNumber = 0;



	if(isset($_POST[sCode])){

		//Search for db version 	

		$tableQuery = mysql_query("SELECT * FROM system WHERE sysId='1'");

		if(mysql_num_rows ($tableQuery)){

			while ($row = mysql_fetch_array($tableQuery)){

				$versionString = $row[sysVersion];

			}

		}



		$versionParts	= explode(".", $versionString);

		$dbVersion	= $versionParts[0];



		// Open a known directory, and proceed to read its contents

		if (is_dir($dir)) {

			if ($dh = opendir($dir)) {

				while (($file[] = readdir($dh)) !== false) {

					$bkNumber++;

				}

				closedir($dh);



				rsort($file);



				echo "<table>";

				for($i; $i<$bkNumber; $i++){

					$nameLenght=strlen($file[$i]);

					$filenameParts=explode(".",$file[$i]);

					if($filenameParts[1] == 'sql'){

						list($year, $month, $day, $hour, $minute, $second, $tName) = explode('#',$filenameParts[0]);

						echo "<tr>";

						echo "<td>Backup on " . $day . "/" . $month . "/" . $year . " @ " . $hour . ":" . $minute . "." . $second . "</td>";

						$fh = fopen($dir."/".$file[$i],'r');

						$bkVersionLine=fgets($fh);

						fclose($fh);

						$bkVersionLineParts = explode(".", $bkVersionLine);

						$bkVersion = $bkVersionLineParts[1];

						echo "<td>[DB v." . $dbVersion . " BK v." . $bkVersion . "]</td>";

						if($dbVersion == $bkVersion){

							echo "<td><a class=\"aBkRestore\" name=\"" . $filenameParts[0] . "\" href=\"#\">[" . _T("Restore") . "]</a></td>";

						}else{

							echo "<td>(" . _T("Corrupt") . ")</td>";

						}

						//echo "<td><a href=\"javascript:deleteBackup('" . $backupVet[$index] . "')\"><img src=\"images/cancella.png\"></a></td>";

						echo "<td><a class=\"aBkDelete\" name=\"" . $filenameParts[0] . "\" href=\"#\"><img src=\"images/cancella.png\"></a></td>";

						echo "</tr>";

					}

				}

				echo "</table>";

			}

		}

	}else{

		//Error

	}

	mysql_query("COMMIT");

?>

</body>

</html>