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