Forum

<?php
require_once('../kernel/begin.php'); 
define('TITLE', 'Script download');
require_once('../kernel/header.php'); 
 
$tpl = new StringTemplate('# INCLUDE MSG #');
$result = PersistenceContext::get_querier()->select('SELECT id, url
FROM ' . DownloadSetup::$download_table . '
WHERE size = 0
LIMIT 100 OFFSET 0');
 
$updated_files_number = 0;
while ($row = $result->fetch())
{
    $file_size = Url::get_url_file_size($row['url']);
 
    if (!empty($file_size))
    {
        $updated_files_number++;
        PersistenceContext::get_querier()->update(DownloadSetup::$download_table, array('size' => $file_size), 'WHERE id=:id', array('id' => $row['id']));
    }
}
$result->dispose();
 
$tpl->put('MSG', MessageHelper::display('Les tailles de ' . $updated_files_number . ' fichiers sont a jour.', MessageHelper::SUCCESS));
$tpl->display();
include('../kernel/footer.php');
?>