From 1e7c2797dcd2b96e1c0dd6f59aebf02fff7711f4 Mon Sep 17 00:00:00 2001
From: Arnaud Borde <arnaud.borde.2006@polytechnique.org>
Date: Sun, 6 Dec 2009 01:04:38 +0100
Subject: [PATCH] If several 'new' NLs exist, default is the latest

Signed-off-by: Arnaud Borde <arnaud.borde.2006@polytechnique.org>
---
 include/newsletter.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/newsletter.inc.php b/include/newsletter.inc.php
index e8cc260..c899e55 100644
--- a/include/newsletter.inc.php
+++ b/include/newsletter.inc.php
@@ -43,7 +43,7 @@ class NewsLetter extends MassMailer
             if (!$res->numRows()) {
                 Newsletter::create();
             }
-            $res = XDB::query("SELECT * FROM newsletter WHERE bits='new'");
+            $res = XDB::query("SELECT * FROM newsletter WHERE bits='new' ORDER BY id DESC LIMIT 1");
         }
         if ($res->numRows() != 1) {
             throw new MailNotFound();
-- 
2.1.4