* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
a.create_date AS publication,
FIND_IN_SET('photo', a.flags) AS photo,
CONCAT({?}, '/#art', a.id) AS link
a.create_date AS publication,
FIND_IN_SET('photo', a.flags) AS photo,
CONCAT({?}, '/#art', a.id) AS link
WHERE peremption >= NOW() AND a.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,
NULL AS photo, NULL AS contacts
WHERE peremption >= NOW() AND a.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,
NULL AS photo, NULL AS contacts
WHERE FIND_IN_SET('public', a.flags) AND peremption >= NOW() AND a.asso_id = {?}",
$this->link, $globals->asso('id'));
}
WHERE FIND_IN_SET('public', a.flags) AND peremption >= NOW() AND a.asso_id = {?}",
$this->link, $globals->asso('id'));
}