<?php
$dbHandler = new eZDFSFileHandlerMySQLiBackend();
$dbHandler->_connect();
/* @type $db mysqli */
$db = $dbHandler->db;
$limit = 100;
$offset = 0;
$count = 0;
do {
$query = "SELECT name FROM ezdfsfile
WHERE scope = 'template-block'
AND mtime > 0
AND mtime < (UNIX_TIMESTAMP(NOW()) - 3600 * 24 * 2)
LIMIT {$offset}, {$limit}";
$result = $db->query($query);
$count = $result->num_rows;
while ($row = $result->fetch_assoc()) {
$name = $row['name'];
$fileHandler = new eZDFSFileHandler($name);
$fileHandler->purge();
}
$offset += $limit;
} while($count > 0);
