X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fxnetgrp%2Ffeed.inc.php;h=95b421cec58c0af61996623d72eb885fc6acd521;hb=ba39c6d2636c971e5e4fe9d99eb5ed1fdc57d72d;hp=d3f72b8174c474eb2de6a9411cb70dad21599cff;hpb=483da16573717c21c7e6da3eacc094048ab7d72f;p=platal.git

diff --git a/modules/xnetgrp/feed.inc.php b/modules/xnetgrp/feed.inc.php
index d3f72b8..95b421c 100644
--- a/modules/xnetgrp/feed.inc.php
+++ b/modules/xnetgrp/feed.inc.php
@@ -1,6 +1,6 @@
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2009 Polytechnique.org                              *
+ *  Copyright (C) 2003-2010 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -75,19 +75,19 @@ class XnetGrpEventFeed extends PlFeed
         global $globals;
         if (!is_null($user)) {
             return new UserFilterIterator(
-                   XDB::iterator("SELECT  a.id, a.titre AS title, a.texte, a.contacts,
-                                          a.create_date AS publication,
-                                          FIND_IN_SET('photo', a.flags) AS photo,
-                                          CONCAT({?}, '/#art', a.id) AS link
-                                    FROM  groupex.announces AS a
-                                   WHERE  peremption >= NOW() AND a.asso_id = {?}",
+                   XDB::iterator("SELECT  id, titre AS title, texte, contacts,
+                                          create_date AS publication,
+                                          FIND_IN_SET('photo', flags) AS photo,
+                                          CONCAT({?}, '/#art', id) AS link
+                                    FROM  group_announces
+                                   WHERE  expiration >= NOW() AND asso_id = {?}",
                                    $this->link, $globals->asso('id'), $user));
         } else {
-            return  XDB::iterator("SELECT  a.id, a.titre AS title, a.texte, a.create_date AS publication,
-                                           CONCAT({?}, '/#art', a.id) AS link,
+            return  XDB::iterator("SELECT  id, titre AS title, texte, create_date AS publication,
+                                           CONCAT({?}, '/#art', id) AS link,
                                            NULL AS photo, NULL AS contacts
-                                     FROM  groupex.announces AS a
-                                    WHERE  FIND_IN_SET('public', a.flags) AND peremption >= NOW() AND a.asso_id = {?}",
+                                     FROM  group_announces
+                                    WHERE  FIND_IN_SET('public', flags) AND expiration >= NOW() AND asso_id = {?}",
                                   $this->link, $globals->asso('id'));
         }
     }