View file install/downloads_converter.php

<?php

declare(strict_types=1);

const DEBUG = true;
const _IN_JOHNCMS = true;

require '../system/bootstrap.php';

/** @var PDO $db */
$db = di(PDO::class);


$files = $db->query('SELECT * FROM download__files');

while ($file = $files->fetch()) {
    $new_path = str_replace('../files/', 'upload/', $file['dir']);
    $db->query("UPDATE download__files SET dir = '" . $new_path . "' WHERE id = " . $file['id']);
}

echo 'Update complete!';