source: trunk/feed.php @ 8350

Last change on this file since 8350 was 6662, checked in by nikrou, 14 years ago

Bug 1762 fixed : Compleet RSS Feed returns notice
Remove mysql specific function

  • Property svn:eol-style set to LF
File size: 6.6 KB
RevLine 
[801]1<?php
2// +-----------------------------------------------------------------------+
[2297]3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
[5196]5// | Copyright(C) 2008-2010 Piwigo Team                  http://piwigo.org |
[2297]6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
[801]23
24define('PHPWG_ROOT_PATH','./');
25include_once(PHPWG_ROOT_PATH.'include/common.inc.php');
[1018]26include_once(PHPWG_ROOT_PATH.'include/functions_notification.inc.php');
[801]27
28// +-----------------------------------------------------------------------+
29// |                               functions                               |
30// +-----------------------------------------------------------------------+
31
32/**
33 * creates a Unix timestamp (number of seconds since 1970-01-01 00:00:00
34 * GMT) from a MySQL datetime format (2005-07-14 23:01:37)
35 *
36 * @param string mysql datetime format
37 * @return int timestamp
38 */
[6662]39function datetime_to_ts($datetime)
[801]40{
[6662]41  $date = strptime($datetime, '%Y-%m-%d %H:%M:%S');
42  return mktime($date['tm_hour'], $date['tm_min'], $date['tm_sec'],
43                $date['tm_mon'], $date['tm_mday'], 1900+$date['tm_year']);
[801]44}
45
46/**
47 * creates an ISO 8601 format date (2003-01-20T18:05:41+04:00) from Unix
48 * timestamp (number of seconds since 1970-01-01 00:00:00 GMT)
49 *
50 * function copied from Dotclear project http://dotclear.net
51 *
52 * @param int timestamp
53 * @return string ISO 8601 date format
54 */
55function ts_to_iso8601($ts)
56{
57  $tz = date('O',$ts);
58  $tz = substr($tz, 0, -2).':'.substr($tz, -2);
59  return date('Y-m-d\\TH:i:s',$ts).$tz;
60}
61
62// +-----------------------------------------------------------------------+
63// |                            initialization                             |
64// +-----------------------------------------------------------------------+
65
[5195]66check_input_parameter('feed', $_GET, false, '/^[0-9a-z]{50}$/i');
[4743]67
[1750]68$feed_id= isset($_GET['feed']) ? $_GET['feed'] : '';
69$image_only=isset($_GET['image_only']);
[801]70
71// echo '<pre>'.generate_key(50).'</pre>';
[1750]72if ( !empty($feed_id) )
[801]73{
74  $query = '
[1750]75SELECT user_id,
76       last_check
77  FROM '.USER_FEED_TABLE.'
78  WHERE id = \''.$feed_id.'\'
[801]79;';
[4325]80  $feed_row = pwg_db_fetch_assoc(pwg_query($query));
[1750]81  if ( empty($feed_row) )
82  {
[5535]83    page_not_found(l10n('Unknown feed identifier'));
[1750]84  }
85  if ($feed_row['user_id']!=$user['id'])
86  { // new user
87    $user = build_user( $feed_row['user_id'], true );
88  }
[801]89}
[1750]90else
[801]91{
[1750]92  $image_only = true;
[2029]93  if (!is_a_guest())
[1750]94  {// auto session was created - so switch to guest
95    $user = build_user( $conf['guest_id'], true );
96  }
[801]97}
98
[1850]99// Check the status now after the user has been loaded
100check_status(ACCESS_GUEST);
101
[4325]102list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
[801]103
104include_once(PHPWG_ROOT_PATH.'include/feedcreator.class.php');
105
[1750]106set_make_full_url();
[1549]107
[801]108$rss = new UniversalFeedCreator();
[2132]109$rss->encoding=get_pwg_charset();
[1549]110$rss->title = $conf['gallery_title'];
[4304]111$rss->title.= ' (as '.stripslashes($user['username']).')';
[833]112
[6411]113$rss->link = get_gallery_home_url();
[833]114
[801]115// +-----------------------------------------------------------------------+
116// |                            Feed creation                              |
117// +-----------------------------------------------------------------------+
118
[2152]119$news = array();
[1750]120if (!$image_only)
[801]121{
[1750]122  $news = news($feed_row['last_check'], $dbnow, true, true);
[1549]123
[1636]124  if (count($news) > 0)
[801]125  {
[1636]126    $item = new FeedItem();
[3122]127    $item->title = sprintf(l10n('New on %s'), format_date($dbnow) );
[6411]128    $item->link = get_gallery_home_url();
[1549]129
[1636]130    // content creation
131    $item->description = '<ul>';
132    foreach ($news as $line)
133    {
134      $item->description.= '<li>'.$line.'</li>';
135    }
136    $item->description.= '</ul>';
137    $item->descriptionHtmlSyndicated = true;
[1549]138
[6662]139    $item->date = $dbnow;
[2595]140    $item->author = $conf['rss_feed_author'];
[1636]141    $item->guid= sprintf('%s', $dbnow);;
[801]142
[1636]143    $rss->addItem($item);
144
145    $query = '
146UPDATE '.USER_FEED_TABLE.'
147  SET last_check = \''.$dbnow.'\'
[1750]148  WHERE id = \''.$feed_id.'\'
[1636]149;';
150    pwg_query($query);
151  }
152}
[2152]153
154if ( !empty($feed_id) and empty($news) )
155{// update the last check from time to time to avoid deletion by maintenance tasks
156  if ( !isset($feed_row['last_check'])
[6662]157    or time()-datetime_to_ts($feed_row['last_check']) > 30*24*3600 )
[2152]158  {
[1750]159    $query = '
[2152]160UPDATE '.USER_FEED_TABLE.'
[4367]161  SET last_check = '.pwg_db_get_recent_period_expression(-15, $dbnow).'
[2152]162  WHERE id = \''.$feed_id.'\'
163;';
[1750]164    pwg_query($query);
165  }
[1549]166}
[801]167
[1871]168$dates = get_recent_post_dates_array($conf['recent_post_dates']['RSS']);
[1549]169
[1784]170foreach($dates as $date_detail)
[1549]171{ // for each recent post date we create a feed item
[1784]172  $item = new FeedItem();
[1549]173  $date = $date_detail['date_available'];
[1784]174  $item->title = get_title_recent_post_date($date_detail);
[1549]175  $item->link = make_index_url(
176        array(
177          'chronology_field' => 'posted',
178          'chronology_style'=> 'monthly',
179          'chronology_view' => 'calendar',
180          'chronology_date' => explode('-', substr($date,0,10) )
181        )
182      );
183
184  $item->description .=
[3185]185    '<a href="'.make_index_url().'">'.$conf['gallery_title'].'</a><br> ';
[1549]186
[1784]187  $item->description .= get_html_description_recent_post_date($date_detail);
[1549]188
189  $item->descriptionHtmlSyndicated = true;
190
[6662]191  $item->date = $date;
[2595]192  $item->author = $conf['rss_feed_author'];
[1549]193  $item->guid= sprintf('%s', 'pics-'.$date);;
194
195  $rss->addItem($item);
196}
197
[2296]198$fileName= $conf['local_data_dir'].'/tmp';
[2497]199mkgetdir($fileName); // just in case
[2296]200$fileName.='/feed.xml';
[801]201// send XML feed
[2296]202echo $rss->saveFeed('RSS2.0', $fileName, true);
[801]203?>
Note: See TracBrowser for help on using the repository browser.