<?php
/***************************************************************************
- * Copyright (C) 2003-2009 Polytechnique.org *
+ * Copyright (C) 2003-2011 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
{
private $it;
private $user;
- public function __construct(PlIterator &$it, PlUser &$user)
+ public function __construct(PlIterator $it, PlUser $user)
{
$this->it =& $it;
$this->user =& $user;
'xnetgrp/announce-rss.tpl');
}
- protected function fetch(PlUser &$user)
+ protected function fetch(PlUser $user)
{
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'));
}
}