Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

7.0 KB
Raw Blame
<?php
require_once '../../includes/connect_endpoint.php';

$result = $db->query("SELECT COUNT(*) as count FROM user");
$row = $result->fetchArray(SQLITE3_NUM);
if ($row[0] > 0) {
    die(json_encode([
        "success" => false,
        "message" => "Denied"
    ]));
}

$setupTokenFile = '../../db/setup_token.db';
$storedToken = file_exists($setupTokenFile) ? trim(file_get_contents($setupTokenFile)) : '';
$submittedToken = $_POST['setup_token'] ?? '';
if ($storedToken === '' || !hash_equals($storedToken, $submittedToken)) {
    die(json_encode([
        "success" => false,
        "message" => "Invalid setup token"
    ]));
}

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 ($_SERVER['REQUEST_METHOD'] === 'POST') {
    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 every entry before extracting. ZipArchive::extractTo()
                // offers no 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')) {
                    emptyRestoreFolder();
                    die(json_encode([
                        "success" => false,
                        "message" => "Failed to remove existing database"
                    ]));
                }

                if (!rename('../../.tmp/restore/wallos.db', '../../db/wallos.db')) {
                    emptyRestoreFolder();
                    die(json_encode([
                        "success" => false,
                        "message" => "Failed to replace database"
                    ]));
                }

                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();

                if (file_exists($setupTokenFile)) {
                    unlink($setupTokenFile);
                }

                $db = new SQLite3('../../db/wallos.db');
                $db->busyTimeout(5000);
                ob_start();
                require_once __DIR__ . '/../../includes/run_migrations.php';
                ob_end_clean();

                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"
        ]);
    }
} else {
    echo json_encode([
        "success" => false,
        "message" => "Invalid request method"
    ]);
}
?>