From 518569483b2f814c6915e4f13aa5bb32a67df872 Mon Sep 17 00:00:00 2001 From: plegall Date: Sat, 17 Sep 2005 21:14:28 +0000 Subject: - new: the number of elements waiting for validation is notified in RSS feed. git-svn-id: http://piwigo.org/svn/trunk@864 68402e56-0260-453c-a942-63ccdbb3a9ee --- feed.php | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'feed.php') diff --git a/feed.php b/feed.php index 49b52c103..9f26000f7 100644 --- a/feed.php +++ b/feed.php @@ -138,6 +138,22 @@ SELECT user_id return array_from_query($query, 'user_id'); } +/** + * currently waiting pictures + * + * @return array waiting ids + */ +function waiting_elements() +{ + $query = ' +SELECT id + FROM '.WAITING_TABLE.' + WHERE validated = \'false\' +;'; + + return array_from_query($query, 'id'); +} + /** * What's new between two dates ? * @@ -188,6 +204,18 @@ function news($start, $end) { array_push($news, sprintf(l10n('%d new users'), $nb_new_users)); } + + $nb_waiting_elements = count(waiting_elements()); + if ($nb_waiting_elements > 0) + { + array_push( + $news, + sprintf( + l10n('%d waiting elements'), + $nb_waiting_elements + ) + ); + } } return $news; -- cgit v1.2.3