ZoneMinder - remove old events

zm-cleanup.php

<?php

function rrmdir($dir)
{
    if (is_dir($dir)) {
        $objects = scandir($dir);
        foreach ($objects as $object) {
            if ($object != "." && $object != "..") {
                if (is_dir($dir . "/" . $object))
                    rrmdir($dir . "/" . $object);
                else
                    unlink($dir . "/" . $object);
            }
        }
        rmdir($dir);
    }
}

$pdo = new \PDO('mysql:host=localhost;port=3306;dbname=zm', 'zmuser', 'zmpass');

$maxTime = (new \DateTime())->modify('-7 days');

$query = 'select Id,Cause,StartTime,MonitorId from Events where StartTime < \'' . ($maxTime->format('Y-m-d')) . '\' order by Id';

echo $query . "\n\n";

$rows = $pdo->query($query)->fetchAll(\PDO::FETCH_ASSOC);

echo count($rows) . " events to remove.\n\n";

foreach ($rows as $r) {
    $id = (int)$r['Id'];
    $mId = (int)$r['MonitorId'];
    $eDate = explode(' ', $r['StartTime'])[0];

//      var_dump($r);

    $path = "/var/cache/zoneminder/events/$mId/$eDate/$id";

    echo "Deleting $id ... $path \n";

    rrmdir($path);

    $pdo->query("DELETE FROM Events where Id=$id");
    $pdo->query("DELETE FROM Frames where EventId=$id");
    $pdo->query("DELETE FROM Stats where EventId=$id");
}


echo "\nDone.\n";