updateHomeDirectories.php

<?php

define('BYPASS_TOKEN_CHECK', true);
require('system/initialize.php');

class UpdateHomeDirectories extends Frontend {

    public function __construct()
    {
        parent::__construct();
        $this->import('Database');
    }

    public function run() {

        echo "<pre>";

        $objMembers = $this->Database->prepare("
            SELECT id
            FROM tl_member
        ")->execute();

        // Update home directories
        while($objMembers->next() != null) {
            $homeDir = "tl_files/users/user_" . $objMembers->id;
            echo $homeDir."\n";
            mkdir($homeDir);
            $this->Database->prepare("
                UPDATE tl_member
                SET homeDir = ?
                WHERE id = ?
            ")->execute($homeDir, $objMembers->id);
        }

        echo "</pre>";

    }

}

$updater = new UpdateHomeDirectories();
$updater->run();