PunNewz (Page 2 of 3)

<? include "http://localhost/forum/externnews.php?action=new&show=10&fid=7"; ?>

<?php
/***********************************************************************

  Copyright (C) 2002, 2003, 2004  Rickard Andersson (rickard@punbb.org)

  This file is part of PunBB.

  PunBB is free software; you can redistribute it and/or modify it
  under the terms of the GNU General Public License as published
  by the Free Software Foundation; either version 2 of the License,
  or (at your option) any later version.

  PunBB is distributed in the hope that it will be useful, but
  WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  MA  02111-1307  USA

/***********************************************************************/

// The maximum number of topics that will be displayed
$show_max_topics = 3;

// The length at which topic subjects will be truncated (for HTML output)
$max_subject_length = 30;


/***********************************************************************/

// DO NOT EDIT ANYTHING BELOW THIS LINE! (unless you know what you are doing)


$pun_root = './';
@include $pun_root.'config.php';

// If PUN isn't defined, config.php is missing or corrupt
if (!defined('PUN'))
    exit('The file \'config.php\' doesn\'t exist or is corrupt. Please run install.php to install PunBB first.');

// Disable error reporting for uninitialized variables
//error_reporting(E_ERROR | E_WARNING | E_PARSE);

// Turn off magic_quotes_runtime
set_magic_quotes_runtime(0);

// Attempt to load the common language file
@include $pun_root.'lang/'.$language.'/'.$language.'_common.php';
if (!isset($lang_common))
    exit('There is no valid language pack \''.$language.'\' installed. Plese check $language setting in config.php.');

// Load the functions script
require $pun_root.'include/functions.php';

// Load DB abstraction layer and try to connect
require $pun_root.'include/dblayer/common_db.php';

// Load parser
require $pun_root.'include/parser.php';

// Get the forum config
$result = $db->query('SELECT * FROM '.$db->prefix.'config') or error('Unable to fetch forum config', __FILE__, __LINE__, $db->error());
while ($cur_config_item = $db->fetch_row($result))
    $pun_config[$cur_config_item[0]] = $cur_config_item[1];


// Make sure we have permission to read the forums
if ($pun_config['p_guests_read'] == '0')
    exit('No permission');


//
// Converts the CDATA end sequence ]]> into ]]>
//
function escape_cdata($str)
{
    return str_replace(']]>', ']]>', $str);
}


//
// Show recent discussions
//
if ($_GET['action'] == 'new')
{
    $order_by = 't.posted';
    $forum_sql = '';

    // Was a forum ID supplied?
    if (isset($_GET['fid']))
    {
        $fid = intval($_GET['fid']);
        if (!empty($fid))
            $forum_sql = 'f.id='.$fid.' AND ';
    }


        $show = intval($_GET['show']);
        if ($show < 1 || $show > 50)
            $show = $show_max_topics;

        $saveddate="";

        // Fetch $show topics
        $result = $db->query('SELECT t.id, t.poster, t.subject, t.num_replies, t.posted, t.last_post, f.id AS fid, f.forum_name FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id=f.id WHERE t.moved_to IS NULL AND '.$forum_sql.'f.admmod_only=0 ORDER BY '.$order_by.' DESC LIMIT '.$show.'') or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());
        while ($cur_topic = $db->fetch_assoc($result))
        {
            if ($pun_config['o_censoring'] == '1')
                $cur_topic['subject'] = censor_words($cur_topic['subject']);

            if (pun_strlen($cur_topic['subject']) > $max_subject_length)
                $subject_truncated = trim(substr($cur_topic['subject'], 0, ($max_subject_length-5))).' ...';
            else
                $subject_truncated = $cur_topic['subject'];

            $id = $cur_topic['id'];
            $msg = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.status, u.registered, u.admin_note, p.id, p.poster, p.poster_id, p.poster_ip, p.poster_email, p.message, p.smilies, p.posted, p.edited, p.edited_by FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id WHERE p.topic_id='.$id.' ORDER BY posted LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
            $cur_post = $db->fetch_assoc($msg);

            //Display first paragraph only (comment out next four lines to turn off)
            /*
            $paragraph = preg_split("/\s*\n+/", $cur_post['message']);
            if ($paragraph[1]) {
                $cur_post['message'] = $paragraph[0] . "...";
            }*/

            $newsheading = '<a href="'.$pun_config['o_base_url'].'/viewtopic.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($subject_truncated).'</a>';
            echo "\t<div><b>".$newsheading."</b></div>\n";

            $cur_post['message'] = parse_message($cur_post['message'], $cur_post['smilies']);
            echo "\t<div>".$cur_post['message']."</div><br>\n";

            echo "\t<div><i>Posted by ".$cur_topic['poster']." at ".date('h:i A', $cur_topic['posted'])." on ".date('l, d F Y', $cur_topic['posted'])." [ <a href='".$pun_config['o_base_url']."/viewtopic.php?id=".$cur_topic['id']."&action=new'>comentarii ".$cur_topic['num_replies']."</a> ]"."</i></div>\n";
            echo "\t ###############################<br><br>\n";
        }
    

    exit;
}
else
    exit('Bad request');