<?
  require_once(dirname(__FILE__) . "/../classes.php");
  $db = new DataAccess();
  $db->query("
   SELECT c.Auteur, c.Comment, p.Titre
   FROM Commentaires c
   LEFT JOIN Mess p on p.num_mess=c.MessId
   WHERE 
   	c.DateComment IS NOT NULL
	AND UNIX_TIMESTAMP(c.DateComment) > UNIX_TIMESTAMP(NOW()) - 24*3600
	AND c.Visible = 0
  ");
  $tmp = "
  Voici les commentaires qui se sont vu filtres ces
  dernieres 24h sur Dual Blog:
  ";
  $i = 0;
  while($row = $db->getRow()) {
    $i++;
    $debComment = substr($row['Comment'], 0, 200);
    $tmp .= "
$i. {$row['Auteur']}, sur le post {$row['Titre']}:
{$debComment}

********************************************************
";
  }

  $subject = gmdate("Y-m-d") . " : Commentaires filtrés";
  mail(ADMIN_MAIL, $subject, wordwrap($tmp, 70));