Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.
<?php
require_once '../../includes/connect_endpoint.php';
require_once '../../includes/validate_endpoint_admin.php';
function emptyRestoreFolder()
{
$files = new RecursiveIteratorIterator(
new RecursiveDirectoryIterator('../../.tmp', RecursiveDirectoryIterator::SKIP_DOTS),
RecursiveIteratorIterator::CHILD_FIRST
);
foreach ($files as $fileinfo) {
$removeFunction = ($fileinfo->isDir() ? 'rmdir' : 'unlink');
$removeFunction($fileinfo->getRealPath());
}
}
if (isset($_FILES['file'])) {
$file = $_FILES['file'];
$fileTmpName = $file['tmp_name'];
$fileError = $file['error'];
if ($fileError === 0) {
$fileDestination = '../../.tmp/restore.zip';
move_uploaded_file($fileTmpName, $fileDestination);
$zip = new ZipArchive();
if ($zip->open($fileDestination) === true) {
// Validate all entries before extracting — ZipArchive::extractTo() does not
// guarantee protection against path traversal (Zip Slip), and the extraction
// target sits under the web root, so a crafted archive could otherwise drop
// an executable script here (RCE).
// Extensions the web server may execute if extracted into a servable path.
// .tmp/ is denied at the nginx layer as the primary control; this is defense
// in depth for other deployments (Apache).
$blockedExtensions = [
'php', 'php3', 'php4', 'php5', 'php7', 'php8', 'phtml', 'pht',
'phps', 'phar', 'shtml', 'cgi', 'pl', 'py', 'sh',
'htaccess', 'htpasswd'
];
for ($i = 0; $i < $zip->numFiles; $i++) {
$entry = str_replace('\\', '/', $zip->getNameIndex($i));
if ($entry === '' || $entry[0] === '/' || in_array('..', explode('/', $entry), true)) {
$zip->close();
emptyRestoreFolder();
die(json_encode([
"success" => false,
"message" => "Invalid backup file: unsafe file path detected."
]));
}
if (in_array(strtolower(pathinfo($entry, PATHINFO_EXTENSION)), $blockedExtensions, true)) {
$zip->close();
emptyRestoreFolder();
die(json_encode([
"success" => false,
"message" => "Invalid backup file: disallowed file type detected."
]));
}
}
$zip->extractTo('../../.tmp/restore/');
$zip->close();
} else {
die(json_encode([
"success" => false,
"message" => "Failed to extract the uploaded file"
]));
}
if (file_exists('../../.tmp/restore/wallos.db')) {
$db->close();
if (file_exists('../../db/wallos.db')) {
unlink('../../db/wallos.db');
}
rename('../../.tmp/restore/wallos.db', '../../db/wallos.db');
$db = new SQLite3('../../db/wallos.db');
$db->busyTimeout(5000);
ob_start();
require_once __DIR__ . '/../../includes/run_migrations.php';
ob_end_clean();
if (file_exists('../../.tmp/restore/logos/')) {
$dir = '../../images/uploads/logos/';
$di = new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS);
$ri = new RecursiveIteratorIterator($di, RecursiveIteratorIterator::CHILD_FIRST);
foreach ($ri as $file) {
if ($file->isDir()) {
rmdir($file->getPathname());
} else {
unlink($file->getPathname());
}
}
$dir = new RecursiveDirectoryIterator('../../.tmp/restore/logos/');
$ite = new RecursiveIteratorIterator($dir);
$allowedExtensions = ['png', 'jpg', 'jpeg', 'gif', 'webp'];
foreach ($ite as $filePath) {
if (in_array(pathinfo($filePath, PATHINFO_EXTENSION), $allowedExtensions)) {
$destination = str_replace('../../.tmp/restore/', '../../images/uploads/', $filePath);
$destinationDir = pathinfo($destination, PATHINFO_DIRNAME);
if (!is_dir($destinationDir)) {
mkdir($destinationDir, 0755, true);
}
copy($filePath, $destination);
}
}
}
emptyRestoreFolder();
echo json_encode([
"success" => true,
"message" => translate("success", $i18n)
]);
} else {
emptyRestoreFolder();
die(json_encode([
"success" => false,
"message" => "wallos.db does not exist in the backup file"
]));
}
} else {
echo json_encode([
"success" => false,
"message" => "Failed to upload file"
]);
}
} else {
echo json_encode([
"success" => false,
"message" => "No file uploaded"
]);
}