phpBB/feed.php

   1 <?php
   2 /**
   3 * @package phpBB3
   4 * @version $Id$
   5 * @copyright (c) 2009 phpBB Group
   6 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   7 *
   8 * Idea and original RSS Feed 2.0 MOD (Version 1.0.8/9) by leviatan21
   9 * Original MOD: http://www.phpbb.com/community/viewtopic.php?f=69&t=1214645
  10 * MOD Author Profile: http://www.phpbb.com/community/memberlist.php?mode=viewprofile&u=345763
  11 * MOD Author Homepage: http://www.mssti.com/phpbb3/
  12 *
  13 **/
  14
  15 /**
  16 * @ignore
  17 **/
  18 define('IN_PHPBB', true);
  19 $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
  20 $phpEx = substr(strrchr(__FILE__, '.'), 1);
  21 include($phpbb_root_path . 'common.' . $phpEx);
  22
  23 if (!$config['feed_enable'])
  24 {
  25         trigger_error('NO_FEED_ENABLED');
  26 }
  27
  28 // Start session
  29 $user->session_begin();
  30 $auth->acl($user->data);
  31 $user->setup();
  32
  33 // Initial var setup
  34 $forum_id       = request_var('f', 0);
  35 $topic_id       = request_var('t', 0);
  36 $mode           = request_var('mode', '');
  37
  38 // Feed date format for PHP > 5 and PHP4
  39 $feed_date_format = (PHP_VERSION >= 5) ? 'c' : "Y-m-d\TH:i:sO";
  40 $params = false;
  41
  42 // We do not use a template, therefore we simply define the global template variables here
  43 $global_vars = $item_vars = array();
  44
  45 // Generate params array for use in append_sid() to correctly link back to this page
  46 if ($forum_id || $topic_id || $mode)
  47 {
  48         $params = array(
  49                 'f'             => ($forum_id) ? $forum_id : NULL,
  50                 't'             => ($topic_id) ? $topic_id : NULL,
  51                 'mode'  => ($mode) ? $mode : NULL,
  52         );
  53 }
  54
  55 // This boards URL
  56 $board_url = generate_board_url();
  57
  58 // Get correct feed object
  59 $feed = phpbb_feed_factory::init($mode, $forum_id, $topic_id);
  60
  61 // No feed found
  62 if ($feed === false)
  63 {
  64         trigger_error('NO_FEED');
  65 }
  66
  67 // Open Feed
  68 $feed->open();
  69
  70 // Some default assignments
  71 // FEED_IMAGE is not used (atom)
  72 $global_vars = array(
  73         'FEED_IMAGE'                    => ($user->img('site_logo', '', false, '', 'src')) ? $board_url . '/' . substr($user->img('site_logo', '', false, '', 'src'), strlen($phpbb_root_path)) : '',
  74         'SELF_LINK'                             => feed_append_sid('/feed.' . $phpEx, $params),
  75         'FEED_LINK'                             => $board_url . '/index.' . $phpEx,
  76         'FEED_TITLE'                    => $config['sitename'],
  77         'FEED_SUBTITLE'                 => $config['site_desc'],
  78         'FEED_UPDATED'                  => $user->format_date(time(), $feed_date_format, true),
  79         'FEED_LANG'                             => $user->lang['USER_LANG'],
  80         'FEED_AUTHOR'                   => $config['sitename'],
  81 );
  82
  83 // Iterate through items
  84 while ($row = $feed->get_item())
  85 {
  86         // BBCode options to correctly disable urls, smilies, bbcode...
  87         if ($feed->get('options') === NULL)
  88         {
  89                 // Allow all combinations
  90                 $options = 7;
  91
  92                 if ($feed->get('enable_bbcode') !== NULL && $feed->get('enable_smilies') !== NULL && $feed->get('enable_magic_url') !== NULL)
  93                 {
  94                         $options = (($row[$feed->get('enable_bbcode')]) ? OPTION_FLAG_BBCODE : 0) + (($row[$feed->get('enable_smilies')]) ? OPTION_FLAG_SMILIES : 0) + (($row[$feed->get('enable_magic_url')]) ? OPTION_FLAG_LINKS : 0);
  95                 }
  96         }
  97         else
  98         {
  99                 $options = $row[$feed->get('options')];
 100         }
 101
 102         $title = ($row[$feed->get('title')]) ? $row[$feed->get('title')] : ((isset($row[$feed->get('title2')])) ? $row[$feed->get('title2')] : '');
 103         $title = censor_text($title);
 104
 105         $item_row = array(
 106                 'author'                => ($feed->get('creator') !== NULL) ? $row[$feed->get('creator')] : '',
 107                 'pubdate'               => $user->format_date($row[$feed->get('date')], $feed_date_format, true),
 108                 'link'                  => '',
 109                 'title'                 => censor_text($title),
 110                 'category'              => ($config['feed_item_statistics']) ? $board_url . '/viewforum.' . $phpEx . '?f=' . $row['forum_id'] : '',
 111                 'category_name' => ($config['feed_item_statistics']) ? utf8_htmlspecialchars($row['forum_name']) : '',
 112                 'description'   => censor_text(feed_generate_content($row[$feed->get('text')], $row[$feed->get('bbcode_uid')], $row[$feed->get('bitfield')], $options)),
 113                 'statistics'    => '',
 114         );
 115
 116         // Adjust items, fill link, etc.
 117         $feed->adjust_item($item_row, $row);
 118
 119         $item_vars[] = $item_row;
 120 }
 121
 122 $feed->close();
 123
 124 // Output page
 125
 126 // gzip_compression
 127 if ($config['gzip_compress'])
 128 {
 129         if (@extension_loaded('zlib') && !headers_sent())
 130         {
 131                 ob_start('ob_gzhandler');
 132         }
 133 }
 134
 135 // IF debug extra is enabled and admin want to "explain" the page we need to set other headers...
 136 if (!defined('DEBUG_EXTRA') || !request_var('explain', 0) || !$auth->acl_get('a_'))
 137 {
 138         header("Content-Type: application/atom+xml; charset=UTF-8");
 139         header("Last-Modified: " . gmdate('D, d M Y H:i:s', time()) . ' GMT');
 140 }
 141 else
 142 {
 143         header('Content-type: text/html; charset=UTF-8');
 144         header('Cache-Control: private, no-cache="set-cookie"');
 145         header('Expires: 0');
 146         header('Pragma: no-cache');
 147
 148         $mtime = explode(' ', microtime());
 149         $totaltime = $mtime[0] + $mtime[1] - $starttime;
 150
 151         if (method_exists($db, 'sql_report'))
 152         {
 153                 $db->sql_report('display');
 154         }
 155
 156         garbage_collection();
 157         exit_handler();
 158 }
 159
 160 echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
 161 echo '<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="' . $global_vars['FEED_LANG'] . '">' . "\n";
 162 echo '<link rel="self" type="application/atom+xml" href="' . $global_vars['SELF_LINK'] . '" />' . "\n\n";
 163
 164 echo (!empty($global_vars['FEED_TITLE'])) ? '<title>' . $global_vars['FEED_TITLE'] . '</title>' . "\n" : '';
 165 echo (!empty($global_vars['FEED_SUBTITLE'])) ? '<subtitle>' . $global_vars['FEED_SUBTITLE'] . '</subtitle>' . "\n" : '';
 166 echo (!empty($global_vars['FEED_LINK'])) ? '<link href="' . $global_vars['FEED_LINK'] .'" />' . "\n" : '';
 167 echo '<updated>' . $global_vars['FEED_UPDATED'] . '</updated>' . "\n\n";
 168
 169 echo '<author><name><![CDATA[' . $global_vars['FEED_AUTHOR'] . ']]></name></author>' . "\n";
 170 echo '<id>' . $global_vars['SELF_LINK'] . '</id>' . "\n";
 171
 172 foreach ($item_vars as $row)
 173 {
 174         echo '<entry>' . "\n";
 175
 176         if (!empty($row['author']))
 177         {
 178                 echo '<author><name><![CDATA[' . $row['author'] . ']]></name></author>' . "\n";
 179         }
 180
 181         echo '<updated>' . $row['pubdate'] . '</updated>' . "\n";
 182         echo '<id>' . $row['link'] . '</id>' . "\n";
 183         echo '<link href="' . $row['link'] . '"/>' . "\n";
 184         echo '<title type="html"><![CDATA[' . $row['title'] . ']]></title>' . "\n\n";
 185
 186         if (!empty($row['category']))
 187         {
 188                 echo '<category term="' . $row['category_name'] . '" scheme="' . $row['category'] . '" label="' . $row['category_name'] . '"/>' . "\n";
 189         }
 190
 191         echo '<content type="html" xml:base="' . $row['link'] . '"><![CDATA[' . "\n";
 192         echo $row['description'];
 193
 194         if (!empty($row['statistics']))
 195         {
 196                 echo '<p>' . $user->lang['STATISTICS'] . ': ' . $row['statistics'] . '</p>';
 197         }
 198
 199         echo '<hr /></div>' . "\n" . ']]></content>' . "\n";
 200         echo '</entry>' . "\n";
 201 }
 202
 203 echo '</feed>';
 204
 205 garbage_collection();
 206 exit_handler();
 207
 208 /**
 209 * Run links through append_sid(), prepend generate_board_url() and remove session id
 210 **/
 211 function feed_append_sid($url, $params)
 212 {
 213         global $board_url;
 214
 215         $link = append_sid($board_url . $url, $params);
 216
 217         // Remove added sid - not as easy as it sounds. ;)
 218         $link = (strpos($link, 'sid=') !== false) ? trim(preg_replace('/(&amp;|&|\?)sid=[a-z0-9]+(&amp;|&)?/', '\1', $link), '?& ') : $link;
 219
 220         // Now the only thing remaining could be an empty &amp;
 221         $link = (substr($link, -5) === '&amp;') ? substr($link, 0, -5) : $link;
 222         // And &amp;#xxx
 223         $link = str_replace('&amp;#', '#', $link);
 224
 225         return $link;
 226 }
 227
 228 /**
 229 * Generate text content
 230 **/
 231 function feed_generate_content($content, $uid, $bitfield, $options)
 232 {
 233         global $user, $config, $phpbb_root_path, $phpEx, $board_url;
 234
 235         if (empty($content))
 236         {
 237                 return '';
 238         }
 239
 240         // Prepare some bbcodes for better parsing
 241         $content        = preg_replace("#\[quote(=&quot;.*?&quot;)?:$uid\]\s*(.*?)\s*\[/quote:$uid\]#si", "[quote$1:$uid]<br />$2<br />[/quote:$uid]", $content);
 242
 243         $content = generate_text_for_display($content, $uid, $bitfield, $options);
 244
 245         // Add newlines
 246         $content = str_replace('<br />', '<br />' . "\n", $content);
 247
 248         // Relative Path to Absolute path, Windows style
 249         $content = str_replace('./', $board_url . '/', $content);
 250
 251         // Remove "Select all" link and mouse events
 252         $content = str_replace('<a href="#" onclick="selectCode(this); return false;">' . $user->lang['SELECT_ALL_CODE'] . '</a>', '', $content);
 253         $content = preg_replace('#(onkeypress|onclick)="(.*?)"#si', '', $content);
 254
 255         // Firefox does not support CSS for feeds, though
 256
 257         // Remove font sizes
 258 //      $content = preg_replace('#<span style="font-size: [0-9]+%; line-height: [0-9]+%;">([^>]+)</span>#iU', '\1', $content);
 259
 260         // Make text strong :P
 261 //      $content = preg_replace('#<span style="font-weight: bold?">(.*?)</span>#iU', '<strong>\1</strong>', $content);
 262
 263         // Italic
 264 //      $content = preg_replace('#<span style="font-style: italic?">([^<]+)</span>#iU', '<em>\1</em>', $content);
 265
 266         // Underline
 267 //      $content = preg_replace('#<span style="text-decoration: underline?">([^<]+)</span>#iU', '<u>\1</u>', $content);
 268
 269         // Remove embed Windows Media Streams
 270         $content        = preg_replace( '#<\!--\[if \!IE\]>-->([^[]+)<\!--<!\[endif\]-->#si', '', $content);
 271
 272         // Do not use &lt; and &gt;, because we want to retain code contained in [code][/code]
 273
 274         // Remove embed and objects
 275         $content        = preg_replace( '#<(object|embed)(.*?) (value|src)=(.*?) ([^[]+)(object|embed)>#si',' <a href=$4 target="_blank"><strong>$1</strong></a> ',$content);
 276
 277         // Remove some specials html tag, because somewhere there are a mod to allow html tags ;)
 278         $content        = preg_replace( '#<(script|iframe)([^[]+)\1>#siU', ' <strong>$1</strong> ', $content);
 279
 280         // Remove Comments from inline attachments [ia]
 281         $content        = preg_replace('#<div class="(inline-attachment|attachtitle)">(.*?)<!-- ia(.*?) -->(.*?)<!-- ia(.*?) -->(.*?)</div>#si','$4',$content);
 282
 283         // Replace some entities with their unicode counterpart
 284         $entities = array(
 285                 '&nbsp;'        => "\xC2\xA0",
 286                 '&bull;'        => "\xE2\x80\xA2",
 287                 '&middot;'      => "\xC2\xB7",
 288                 '&copy;'        => "\xC2\xA9",
 289         );
 290
 291         $content = str_replace(array_keys($entities), array_values($entities), $content);
 292
 293         // Remove CDATA blocks. ;)
 294         $content = preg_replace('#\<\!\[CDATA\[(.*?)\]\]\>#s', '', $content);
 295
 296         // Other control characters
 297         // $content = preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $content);
 298
 299         return $content;
 300 }
 301
 302 /**
 303 * Factory class to return correct object
 304 * @package phpBB3
 305 */
 306 class phpbb_feed_factory
 307 {
 308         /**
 309         * Return correct object for specified mode
 310         *
 311         * @param string $mode           The feeds mode.
 312         * @param int    $forum_id       Forum id specified by the script if forum feed provided.
 313         * @param int    $topic_id       Topic id specified by the script if topic feed provided.
 314         *
 315         * @return object        Returns correct feeds object for specified mode.
 316         */
 317         function init($mode, $forum_id, $topic_id)
 318         {
 319                 global $config;
 320
 321                 switch ($mode)
 322                 {
 323                         case 'forums':
 324                                 if (!$config['feed_overall_forums'])
 325                                 {
 326                                         return false;
 327                                 }
 328
 329                                 return new phpbb_feed_forums();
 330                         break;
 331
 332                         case 'topics':
 333                                 if (!$config['feed_overall_topics'])
 334                                 {
 335                                         return false;
 336                                 }
 337
 338                                 return new phpbb_feed_topics();
 339                         break;
 340
 341                         case 'news':
 342                                 global $db;
 343
 344                                 // Get at least one news forum
 345                                 $sql = 'SELECT forum_id
 346                                         FROM ' . FORUMS_TABLE . '
 347                                         WHERE ' . $db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');
 348                                 $result = $db->sql_query_limit($sql, 1, 0, 600);
 349                                 $s_feed_news = (int) $db->sql_fetchfield('forum_id');
 350                                 $db->sql_freeresult($result);
 351
 352                                 if (!$s_feed_news)
 353                                 {
 354                                         return false;
 355                                 }
 356
 357                                 return new phpbb_feed_news();
 358                         break;
 359
 360                         default:
 361                                 // Forum and/or topic specified?
 362                                 if ($topic_id && !$config['feed_topic'])
 363                                 {
 364                                         return false;
 365                                 }
 366
 367                                 if ($forum_id && !$topic_id && !$config['feed_forum'])
 368                                 {
 369                                         return false;
 370                                 }
 371
 372                                 return new phpbb_feed($forum_id, $topic_id);
 373                         break;
 374                 }
 375         }
 376 }
 377
 378 /**
 379 * Base/default Feed class if no mode is specified.
 380 * This can be the overall site feed or a forum/topic feed.
 381 * @package phpBB3
 382 */
 383 class phpbb_feed
 384 {
 385         /**
 386         * Forum id specified for forum feed.
 387         */
 388         var $forum_id = 0;
 389
 390         /**
 391         * Topic id specified for topic feed.
 392         */
 393         var $topic_id = 0;
 394
 395         /**
 396         * SQL Query to be executed to get feed items
 397         */
 398         var $sql;
 399
 400         /**
 401         * Keys specified for retrieval of title, content, etc.
 402         */
 403         var $keys = array();
 404
 405         /**
 406         * An array of excluded forum ids.
 407         */
 408         var $excluded_forums_ary = NULL;
 409
 410         /**
 411         * Number of items to fetch
 412         */
 413         var $num_items;
 414
 415         /**
 416         * boolean to determine if items array is filled or not
 417         */
 418         var $items_filled = false;
 419
 420         /**
 421         * array holding items
 422         */
 423         var $items = array();
 424
 425         /**
 426         * Default setting for last x days
 427         */
 428         var $sort_days = 30;
 429
 430         /**
 431         * Default cache time of entries in seconds
 432         */
 433         var $cache_time = 300;
 434
 435         /**
 436         * Separator for title elements to separate items (for example forum / topic)
 437         */
 438         var $separator = "\xE2\x80\xA2"; // &bull;
 439
 440         /**
 441         * Constructor. Set standard keys.
 442         */
 443         function phpbb_feed($forum_id = 0, $topic_id = 0)
 444         {
 445                 global $config;
 446
 447                 $this->forum_id = $forum_id;
 448                 $this->topic_id = $topic_id;
 449
 450                 $this->sql = array();
 451
 452                 // Set some values for pagination
 453                 $this->num_items = (int) $config['feed_limit'];
 454                 $this->set_keys();
 455         }
 456
 457         function set_keys()
 458         {
 459                 // Set keys for items...
 460                 $this->set('title',             'post_subject');
 461                 $this->set('title2',    'topic_title');
 462                 $this->set('author_id', 'user_id');
 463                 $this->set('creator',   'username');
 464                 $this->set('text',              'post_text');
 465                 $this->set('bitfield',  'bbcode_bitfield');
 466                 $this->set('bbcode_uid','bbcode_uid');
 467                 $this->set('date',              'post_time');
 468
 469                 $this->set('enable_bbcode',             'enable_bbcode');
 470                 $this->set('enable_smilies',    'enable_smilies');
 471                 $this->set('enable_magic_url',  'enable_magic_url');
 472         }
 473
 474         function open()
 475         {
 476                 if (!$this->forum_id && !$this->topic_id)
 477                 {
 478                         return;
 479                 }
 480                 else if ($this->forum_id && !$this->topic_id)
 481                 {
 482                         global $db, $user, $global_vars;
 483
 484                         $sql = 'SELECT forum_name
 485                                 FROM ' . FORUMS_TABLE . '
 486                                 WHERE forum_id = ' . $this->forum_id;
 487                         $result = $db->sql_query($sql);
 488
 489                         $global_vars['FEED_MODE'] = $user->lang['FORUM'] . ': ' . $db->sql_fetchfield('forum_name');
 490
 491                         $db->sql_freeresult($result);
 492                 }
 493                 else if ($this->topic_id)
 494                 {
 495                         global $db, $user, $global_vars;
 496
 497                         $sql = 'SELECT topic_title
 498                                 FROM ' . TOPICS_TABLE . '
 499                                 WHERE topic_id = ' . $this->topic_id;
 500                         $result = $db->sql_query($sql);
 501
 502                         $global_vars['FEED_MODE'] = $user->lang['TOPIC'] . ': ' . $db->sql_fetchfield('topic_title');
 503
 504                         $db->sql_freeresult($result);
 505                 }
 506         }
 507
 508         function close()
 509         {
 510                 if (!empty($this->result))
 511                 {
 512                         global $db;
 513
 514                         $db->sql_freeresult($this->result);
 515                 }
 516         }
 517
 518         /**
 519         * Set key
 520         */
 521         function set($key, $value)
 522         {
 523                 $this->keys[$key] = $value;
 524         }
 525
 526         /**
 527         * Get key
 528         */
 529         function get($key)
 530         {
 531                 return (isset($this->keys[$key])) ? $this->keys[$key] : NULL;
 532         }
 533
 534         /**
 535         * Return array of excluded forums
 536         */
 537         function excluded_forums()
 538         {
 539                 if ($this->excluded_forums_ary !== NULL)
 540                 {
 541                         return $this->excluded_forums_ary;
 542                 }
 543
 544                 global $auth, $db, $config, $phpbb_root_path, $phpEx, $user;
 545
 546                 // Which forums should not be searched ?
 547                 $exclude_forums = array();
 548
 549                 $sql = 'SELECT forum_id
 550                         FROM ' . FORUMS_TABLE . '
 551                         WHERE ' . $db->sql_bit_and('forum_options', FORUM_OPTION_FEED_EXCLUDE, '<> 0');
 552                 $result = $db->sql_query($sql);
 553
 554                 while ($row = $db->sql_fetchrow($result))
 555                 {
 556                         $exclude_forums[] = (int) $row['forum_id'];
 557                 }
 558                 $db->sql_freeresult($result);
 559
 560                 // Exclude forums the user is not able to read
 561                 $this->excluded_forums_ary = array_keys($auth->acl_getf('!f_read', true));
 562                 $this->excluded_forums_ary = (sizeof($exclude_forums)) ? array_merge($exclude_forums, $this->excluded_forums_ary) : $this->excluded_forums_ary;
 563
 564                 $not_in_fid = (sizeof($this->excluded_forums_ary)) ? 'WHERE (' . $db->sql_in_set('f.forum_id', $this->excluded_forums_ary, true) . ' AND ' . $db->sql_in_set('f.parent_id', $this->excluded_forums_ary, true) . ") OR (f.forum_password <> '' AND fa.user_id <> " . (int) $user->data['user_id'] . ')' : '';
 565
 566                 $sql = 'SELECT f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.right_id, f.forum_password, fa.user_id
 567                         FROM ' . FORUMS_TABLE . ' f
 568                         LEFT JOIN ' . FORUMS_ACCESS_TABLE . " fa ON (fa.forum_id = f.forum_id
 569                                 AND fa.session_id = '" . $db->sql_escape($user->session_id) . "')
 570                         $not_in_fid
 571                         ORDER BY f.left_id";
 572                 $result = $db->sql_query($sql);
 573
 574                 $right_id = 0;
 575                 while ($row = $db->sql_fetchrow($result))
 576                 {
 577                         // Exclude passworded forum completely
 578                         if ($row['forum_password'] && $row['user_id'] != $user->data['user_id'])
 579                         {
 580                                 $this->excluded_forums_ary[] = (int) $row['forum_id'];
 581                                 continue;
 582                         }
 583
 584                         if ($row['right_id'] > $right_id)
 585                         {
 586                                 $right_id = (int) $row['right_id'];
 587                         }
 588                         else if ($row['right_id'] < $right_id)
 589                         {
 590                                 continue;
 591                         }
 592                 }
 593                 $db->sql_freeresult($result);
 594
 595                 return $this->excluded_forums_ary;
 596         }
 597
 598         /**
 599         * Get SQL query for fetching items
 600         */
 601         function get_sql()
 602         {
 603                 global $db;
 604
 605                 $post_ids = array();
 606
 607                 // Search for topics in last X days
 608                 $last_post_time_sql = ($this->sort_days) ? ' AND t.topic_last_post_time > ' . (time() - ($this->sort_days * 24 * 3600)) : '';
 609
 610                 // Fetch latest post, grouped by topic...
 611                 if (!$this->forum_id && !$this->topic_id)
 612                 {
 613                         // First of all, the post ids...
 614                         $not_in_fid = (sizeof($this->excluded_forums())) ? ' AND ' . $db->sql_in_set('t.forum_id', $this->excluded_forums(), true) : '';
 615
 616                         $sql = 'SELECT t.topic_last_post_id
 617                                 FROM ' . TOPICS_TABLE . ' t
 618                                 WHERE t.topic_approved = 1
 619                                         AND t.topic_moved_id = 0' .
 620                                         $not_in_fid .
 621                                         $last_post_time_sql . '
 622                                 ORDER BY t.topic_last_post_time DESC';
 623                         $result = $db->sql_query_limit($sql, $this->num_items);
 624
 625                         while ($row = $db->sql_fetchrow($result))
 626                         {
 627                                 $post_ids[] = (int) $row['topic_last_post_id'];
 628                         }
 629                         $db->sql_freeresult($result);
 630                 }
 631                 // Fetch latest posts from forum
 632                 else if (!$this->topic_id && $this->forum_id)
 633                 {
 634                         // Make sure the forum is not listed within the forbidden ones. ;)
 635                         if (in_array($this->forum_id, $this->excluded_forums()))
 636                         {
 637                                 return false;
 638                         }
 639
 640                         // Determine which forums to fetch
 641                         $not_in_fid = (sizeof($this->excluded_forums())) ? ' AND ' . $db->sql_in_set('f1.forum_id', $this->excluded_forums(), true) : '';
 642
 643                         // Determine forum childs...
 644                         $sql = 'SELECT f2.forum_id
 645                                 FROM ' . FORUMS_TABLE . ' f1, ' . FORUMS_TABLE . ' f2
 646                                 WHERE f1.forum_id = ' . $this->forum_id . '
 647                                         AND (f2.left_id BETWEEN f1.left_id AND f1.right_id' . $not_in_fid . ')';
 648                         $result = $db->sql_query($sql);
 649
 650                         $forum_ids = array();
 651                         while ($row = $db->sql_fetchrow($result))
 652                         {
 653                                 $forum_ids[] = (int) $row['forum_id'];
 654                         }
 655                         $db->sql_freeresult($result);
 656
 657                         // Now select from forums...
 658                         $sql = 'SELECT t.topic_last_post_id
 659                                 FROM ' . TOPICS_TABLE . ' t
 660                                 WHERE ' . $db->sql_in_set('t.forum_id', $forum_ids) . '
 661                                         AND t.topic_approved = 1
 662                                         AND t.topic_moved_id = 0' .
 663                                         $last_post_time_sql . '
 664                                 ORDER BY t.topic_last_post_time DESC';
 665                         $result = $db->sql_query_limit($sql, $this->num_items);
 666
 667                         while ($row = $db->sql_fetchrow($result))
 668                         {
 669                                 $post_ids[] = (int) $row['topic_last_post_id'];
 670                         }
 671                         $db->sql_freeresult($result);
 672                 }
 673                 // Fetch last posts from specified topic...
 674                 else if ($this->topic_id)
 675                 {
 676                         // First of all, determine the forum...
 677                         $sql = 'SELECT forum_id
 678                                 FROM ' . TOPICS_TABLE . '
 679                                 WHERE topic_id = ' . $this->topic_id;
 680                         $result = $db->sql_query_limit($sql, 1);
 681                         $this->forum_id = (int) $db->sql_fetchfield('forum_id');
 682                         $db->sql_freeresult($result);
 683
 684                         // non-global announcement
 685                         if ($this->forum_id && in_array($this->forum_id, $this->excluded_forums()))
 686                         {
 687                                 return false;
 688                         }
 689
 690                         $sql = 'SELECT post_id
 691                                 FROM ' . POSTS_TABLE . '
 692                                 WHERE topic_id = ' . $this->topic_id . '
 693                                         AND post_approved = 1
 694                                 ORDER BY post_time DESC';
 695                         $result = $db->sql_query_limit($sql, $this->num_items);
 696
 697                         while ($row = $db->sql_fetchrow($result))
 698                         {
 699                                 $post_ids[] = (int) $row['post_id'];
 700                         }
 701                         $db->sql_freeresult($result);
 702                 }
 703
 704                 if (!sizeof($post_ids))
 705                 {
 706                         return false;
 707                 }
 708
 709                 // Now build sql query for obtaining items
 710                 $this->sql = array(
 711                         'SELECT'        =>      'f.forum_id, f.forum_name, f.forum_desc_options, ' .
 712                                                         't.topic_last_post_time, t.topic_id, t.topic_title, t.topic_time, t.topic_replies, t.topic_views, ' .
 713                                                         'p.post_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .
 714                                                         'u.username, u.user_id, u.user_email, u.user_colour',
 715                         'FROM'          => array(
 716                                 POSTS_TABLE             => 'p',
 717                                 TOPICS_TABLE    => 't',
 718                                 FORUMS_TABLE    => 'f',
 719                                 USERS_TABLE             => 'u',
 720                         ),
 721                         'WHERE'         => $db->sql_in_set('p.post_id', $post_ids) . '
 722                                                                 AND f.forum_id = p.forum_id
 723                                                                 AND t.topic_id = p.topic_id
 724                                                                 AND u.user_id = p.poster_id',
 725                         'ORDER_BY'      => 'p.post_time DESC',
 726                 );
 727
 728                 return true;
 729         }
 730
 731         function get_item()
 732         {
 733                 global $db, $cache;
 734
 735                 // Disable cache if it is not a guest or a bot but a registered user
 736                 if ($this->cache_time)
 737                 {
 738                         global $user;
 739
 740                         // We check this here because we call get_item() quite often
 741                         if (!empty($user) && $user->data['is_registered'])
 742                         {
 743                                 $this->cache_time = 0;
 744                         }
 745                 }
 746
 747                 if (!$this->cache_time)
 748                 {
 749                         if (empty($this->result))
 750                         {
 751                                 if (!$this->get_sql())
 752                                 {
 753                                         return false;
 754                                 }
 755
 756                                 // Query database
 757                                 $sql = $db->sql_build_query('SELECT', $this->sql);
 758                                 $this->result = $db->sql_query_limit($sql, $this->num_items);
 759                         }
 760
 761                         return $db->sql_fetchrow($this->result);
 762                 }
 763                 else
 764                 {
 765                         if (empty($this->items_filled))
 766                         {
 767                                 // Try to load result set...
 768                                 $cache_filename = substr(get_class($this), strlen('phpbb_'));
 769
 770                                 if (($this->items = $cache->get('_' . $cache_filename)) === false)
 771                                 {
 772                                         $this->items = array();
 773
 774                                         if ($this->get_sql())
 775                                         {
 776                                                 // Query database
 777                                                 $sql = $db->sql_build_query('SELECT', $this->sql);
 778                                                 $result = $db->sql_query_limit($sql, $this->num_items);
 779
 780                                                 while ($row = $db->sql_fetchrow($result))
 781                                                 {
 782                                                         $this->items[] = $row;
 783                                                 }
 784                                                 $db->sql_freeresult($result);
 785                                         }
 786
 787                                         $cache->put('_' . $cache_filename, $this->items, $this->cache_time);
 788                                 }
 789
 790                                 $this->items_filled = true;
 791                         }
 792
 793                         $row = array_shift($this->items);
 794                         return (!$row) ? false : $row;
 795                 }
 796         }
 797
 798         function adjust_item(&$item_row, &$row)
 799         {
 800                 global $phpEx, $config;
 801
 802                 $item_row['title'] = (!$this->topic_id) ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];
 803                 $item_row['link'] = feed_append_sid('/viewtopic.' . $phpEx, "t={$row['topic_id']}&amp;p={$row['post_id']}#p{$row['post_id']}");
 804
 805                 if ($config['feed_item_statistics'])
 806                 {
 807                         global $user;
 808
 809                         $user_link = '<a href="' . feed_append_sid('/memberlist.' . $phpEx, 'mode=viewprofile&amp;u=' . $row['user_id']) . '">' . $row['username'] . '</a>';
 810
 811                         $time = ($this->topic_id) ? $row['post_time'] : $row['topic_time'];
 812
 813                         $item_row['statistics'] = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $user_link . ' - ' . $user->format_date($time). ' - ' . $user->lang['REPLIES'] . ' ' . $row['topic_replies'] . ' - ' . $user->lang['VIEWS'] . ' ' . $row['topic_views'];
 814                 }
 815         }
 816 }
 817
 818 class phpbb_feed_forums extends phpbb_feed
 819 {
 820         function set_keys()
 821         {
 822                 global $config;
 823
 824                 $this->set('title',             'forum_name');
 825                 $this->set('text',              'forum_desc');
 826                 $this->set('bitfield',  'forum_desc_bitfield');
 827                 $this->set('bbcode_uid','forum_desc_uid');
 828                 $this->set('date',              'forum_last_post_time');
 829                 $this->set('options',   'forum_desc_options');
 830
 831                 $this->num_items = (int) $config['feed_overall_forums_limit'];
 832         }
 833
 834         function open()
 835         {
 836                 global $user, $global_vars;
 837
 838                 $global_vars['FEED_MODE'] = $user->lang['FORUMS'];
 839         }
 840
 841         function get_sql()
 842         {
 843                 global $db;
 844
 845                 $not_in_fid = (sizeof($this->excluded_forums())) ? ' AND ' . $db->sql_in_set('f.forum_id', $this->excluded_forums(), true) : '';
 846
 847                 // Build SQL Query
 848                 $this->sql = array(
 849                         'SELECT'        => 'f.*',
 850                         'FROM'          => array(FORUMS_TABLE => 'f'),
 851                         'WHERE'         => 'f.forum_type = ' . FORUM_POST . '
 852                                                                 AND (f.forum_last_post_id > 0' . $not_in_fid . ')',
 853                         'ORDER_BY'      => 'f.left_id',
 854                 );
 855
 856                 return true;
 857         }
 858
 859         function adjust_item(&$item_row, &$row)
 860         {
 861                 global $phpEx, $config;
 862
 863                 $item_row['link'] = feed_append_sid('/viewforum.' . $phpEx, 'f=' . $row['forum_id']);
 864
 865                 if ($config['feed_item_statistics'])
 866                 {
 867                         global $user;
 868
 869                         $item_row['statistics'] = sprintf($user->lang['TOTAL_TOPICS_OTHER'], $row['forum_topics']) . ' - ' . sprintf($user->lang['TOTAL_POSTS_OTHER'], $row['forum_posts']);
 870                 }
 871         }
 872 }
 873
 874 class phpbb_feed_news extends phpbb_feed
 875 {
 876         function set_keys()
 877         {
 878                 global $config;
 879
 880                 $this->set('title',             'topic_title');
 881                 $this->set('title2',    'forum_name');
 882                 $this->set('author_id', 'topic_poster');
 883                 $this->set('creator',   'topic_first_poster_name');
 884                 $this->set('text',              'post_text');
 885                 $this->set('bitfield',  'bbcode_bitfield');
 886                 $this->set('bbcode_uid','bbcode_uid');
 887                 $this->set('date',              'topic_time');
 888
 889                 $this->set('enable_bbcode',             'enable_bbcode');
 890                 $this->set('enable_smilies',    'enable_smilies');
 891                 $this->set('enable_magic_url',  'enable_magic_url');
 892
 893                 $this->num_items = (int) $config['feed_overall_forums_limit'];
 894         }
 895
 896         function open()
 897         {
 898                 global $user, $global_vars;
 899
 900                 $global_vars['FEED_MODE'] = $user->lang['FEED_NEWS'];
 901         }
 902
 903         function get_sql()
 904         {
 905                 global $db, $config;
 906
 907                 // Get news forums...
 908                 $sql = 'SELECT forum_id
 909                         FROM ' . FORUMS_TABLE . '
 910                         WHERE ' . $db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');
 911                 $result = $db->sql_query($sql);
 912
 913                 $in_fid_ary = array();
 914                 while ($row = $db->sql_fetchrow($result))
 915                 {
 916                         $in_fid_ary[] = (int) $row['forum_id'];
 917                 }
 918                 $db->sql_freeresult($result);
 919
 920                 if (!sizeof($in_fid_ary))
 921                 {
 922                         return false;
 923                 }
 924
 925                 // Build SQL Query
 926                 $this->sql = array(
 927                         'SELECT'        => 'f.forum_id, f.forum_password, f.forum_name, f.forum_topics, f.forum_posts, f.parent_id, f.left_id, f.right_id,
 928                                                         t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_views, t.topic_time,
 929                                                         p.post_id, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url,
 930                                                         u.username, u.user_id, u.user_email, u.user_colour',
 931                         'FROM'          => array(
 932                                 TOPICS_TABLE    => 't',
 933                                 FORUMS_TABLE    => 'f',
 934                                 POSTS_TABLE             => 'p',
 935                                 USERS_TABLE             => 'u',
 936                         ),
 937                         'WHERE'         => $db->sql_in_set('t.forum_id', $in_fid_ary) . '
 938                                                         AND f.forum_id = t.forum_id
 939                                                         AND p.post_id = t.topic_first_post_id
 940                                                         AND t.topic_poster = u.user_id
 941                                                         AND t.topic_moved_id = 0',
 942                         'ORDER_BY'      => 't.topic_time DESC',
 943                 );
 944
 945                 return true;
 946         }
 947
 948         function adjust_item(&$item_row, &$row)
 949         {
 950                 global $phpEx, $config;
 951
 952                 $item_row['link'] = feed_append_sid('/viewtopic.' . $phpEx, 't=' . $row['topic_id'] . '&amp;p=' . $row['post_id'] . '#p' . $row['post_id']);
 953
 954                 if ($config['feed_item_statistics'])
 955                 {
 956                         global $user;
 957
 958                         $user_link = '<a href="' . feed_append_sid('/memberlist.' . $phpEx, 'mode=viewprofile&amp;u=' . $row[$this->get('author_id')]) . '">' . $row[$this->get('creator')] . '</a>';
 959
 960                         $item_row['statistics'] = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $user_link . ' - ' . $user->format_date($row['topic_time']). ' - ' . $user->lang['REPLIES'] . ' ' . $row['topic_replies'] . ' - ' . $user->lang['VIEWS'] . ' ' . $row['topic_views'];
 961                 }
 962         }
 963 }
 964
 965 class phpbb_feed_topics extends phpbb_feed
 966 {
 967         function set_keys()
 968         {
 969                 global $config;
 970
 971                 $this->set('title',             'topic_title');
 972                 $this->set('title2',    'forum_name');
 973                 $this->set('author_id', 'topic_poster');
 974                 $this->set('creator',   'topic_first_poster_name');
 975                 $this->set('text',              'post_text');
 976                 $this->set('bitfield',  'bbcode_bitfield');
 977                 $this->set('bbcode_uid','bbcode_uid');
 978                 $this->set('date',              'topic_time');
 979
 980                 $this->set('enable_bbcode',             'enable_bbcode');
 981                 $this->set('enable_smilies',    'enable_smilies');
 982                 $this->set('enable_magic_url',  'enable_magic_url');
 983
 984                 $this->num_items = (int) $config['feed_overall_topics_limit'];
 985         }
 986
 987         function open()
 988         {
 989                 global $user, $global_vars;
 990
 991                 $global_vars['FEED_MODE'] = $user->lang['TOPICS'];
 992         }
 993
 994         function get_sql()
 995         {
 996                 global $db, $config;
 997
 998                 $post_ids = array();
 999                 $not_in_fid = (sizeof($this->excluded_forums())) ? ' AND ' . $db->sql_in_set('t.forum_id', $this->excluded_forums(), true) : '';
1000
1001                 // Search for topics in last x days
1002                 $last_post_time_sql = ($this->sort_days) ? ' AND t.topic_last_post_time > ' . (time() - ($this->sort_days * 24 * 3600)) : '';
1003
1004                 // Last x topics from all forums, with first post from topic...
1005                 $sql = 'SELECT t.topic_first_post_id
1006                         FROM ' . TOPICS_TABLE . ' t
1007                         WHERE t.topic_approved = 1
1008                                 AND t.topic_moved_id = 0' .
1009                                 $not_in_fid .
1010                                 $last_post_time_sql . '
1011                         ORDER BY t.topic_last_post_time DESC';
1012                 $result = $db->sql_query_limit($sql, $this->num_items);
1013
1014                 while ($row = $db->sql_fetchrow($result))
1015                 {
1016                         $post_ids[] = (int) $row['topic_first_post_id'];
1017                 }
1018                 $db->sql_freeresult($result);
1019
1020                 if (!sizeof($post_ids))
1021                 {
1022                         return false;
1023                 }
1024
1025                 $this->sql = array(
1026                         'SELECT'        => 'f.forum_id, f.forum_password, f.forum_name, f.forum_topics, f.forum_posts, f.parent_id, f.left_id, f.right_id,
1027                                                         t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_views, t.topic_time,
1028                                                         p.post_id, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url,
1029                                                         u.username, u.user_id, u.user_email, u.user_colour',
1030                         'FROM'          => array(
1031                                 TOPICS_TABLE    => 't',
1032                                 FORUMS_TABLE    => 'f',
1033                                 POSTS_TABLE             => 'p',
1034                                 USERS_TABLE             => 'u',
1035                         ),
1036                         'WHERE'         => $db->sql_in_set('p.post_id', $post_ids) . '
1037                                                                 AND f.forum_id = p.forum_id
1038                                                                 AND t.topic_id = p.topic_id
1039                                                                 AND u.user_id = p.poster_id',
1040                         'ORDER_BY'      => 't.topic_last_post_time DESC',
1041                 );
1042
1043                 return true;
1044         }
1045
1046         function adjust_item(&$item_row, &$row)
1047         {
1048                 global $phpEx, $config;
1049
1050                 $item_row['link'] = feed_append_sid('/viewtopic.' . $phpEx, 't=' . $row['topic_id'] . '&amp;p=' . $row['post_id'] . '#p' . $row['post_id']);
1051
1052                 if ($config['feed_item_statistics'])
1053                 {
1054                         global $user;
1055
1056                         $user_link = '<a href="' . feed_append_sid('/memberlist.' . $phpEx, 'mode=viewprofile&amp;u=' . $row[$this->get('author_id')]) . '">' . $row[$this->get('creator')] . '</a>';
1057
1058                         $item_row['statistics'] = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $user_link . ' - ' . $user->format_date($row['topic_time']). ' - ' . $user->lang['REPLIES'] . ' ' . $row['topic_replies'] . ' - ' . $user->lang['VIEWS'] . ' ' . $row['topic_views'];
1059                 }
1060         }
1061 }
1062
1063
1064 ?>