<?php

require dirname(__FILE__) . '/_init.php';

if (isset($_GET['old']))
{
    $expire = time() - round((365.25/12) * 24 * 3600 * (int)$_GET['old']);
    $tpl->assign('old', (int)$_GET['old']);

    $membres = DB::aQuery('SELECT id, email, date
        FROM membres
        WHERE date < "'.$expire.'"
        ORDER BY date DESC;', false, DB::FETCH_ASSOC);
}
else
{
    $expire = time() - (7 * 24 * 3600);

    $membres = DB::aQuery('SELECT m.id, m.email, m.date
        FROM membres AS m LEFT JOIN journaux AS j ON j.auteur = m.id
        WHERE j.id IS NULL AND m.date_inscription < "'.$expire.'"
        GROUP BY m.id ORDER BY m.date_inscription DESC;', false, DB::FETCH_ASSOC);
}

$tpl->assign('membres', $membres);

$tpl->display('admin/m_menage.tpl');

?>