e107inc/e107

<?php
/*
 * e107 website system
 *
 * Copyright (C) 2008-2013 e107 Inc (e107.org)
 * Released under the terms and conditions of the
 * GNU General Public License (http://www.gnu.org/licenses/gpl.txt)
 *
 *    RSS news feed addon
 */
 
if (!defined('e107_INIT')) { exit; }

// v2.x Standard 
class news_rss // plugin-folder + '_rss'
{

    private $showImages         = false;
    private $summaryDescription = false;

    /**
     * Admin RSS Configuration
     *
     */        
    function config() 
    {
        $config = array();

        $config[] = array(
            'name'            => ADLAN_0,
            'url'            => 'news',               // The identifier and plugin-path location for the rss feed url
            'topic_id'        => '',                  // The topic_id, empty on default (to select a certain category)
            'description'    => RSS_PLUGIN_LAN_7,     // that's 'description' not 'text'
            'class'            => '0',
            'limit'            => '9'
        );

        // News categories
        $sqli = e107::getDb();
        if($sqli ->select("news_category", "*","category_id!='' ORDER BY category_name "))
        {
            while($rowi = $sqli ->fetch())
            {

                $config[] = array(
                    'name'            => ADLAN_0.' > '.$rowi['category_name'],
                    'url'            => 'news',
                    'topic_id'        => $rowi['category_id'],
                    'description'    => RSS_PLUGIN_LAN_10.' '.$rowi['category_name'], // that's 'description' not 'text'
                    'class'            => '0',
                    'limit'            => '9'
                );

            }
        }
        
        return $config;
    }


    /**
     * Generate the Feed Data
     * @param string $parms
     * @return array
     */
    function data($parms=null)
    {
        $pref                       = e107::getConfig()->getPref();
        $tp                         = e107::getParser();

        $this->showImages           = vartrue($pref['rss_shownewsimage'],false);
        $this->summaryDescription   =  vartrue($pref['rss_summarydiz'],false);

        $render         = ($pref['rss_othernews'] != 1) ? "AND (FIND_IN_SET('0', n.news_render_type) OR FIND_IN_SET(1, n.news_render_type))" : "";
        $nobody_regexp  = "'(^|,)(".str_replace(",", "|", e_UC_NOBODY).")(,|$)'";
        $topic          = (!empty($parms['id']) && is_numeric($parms['id'])) ?  " AND news_category = ".intval($parms['id']) : '';
        $limit          = vartrue($parms['limit'],10);

        $rssQuery = "SELECT n.*, u.user_id, u.user_name, u.user_email, u.user_customtitle, nc.category_name, nc.category_sef, nc.category_icon FROM #news AS n
                LEFT JOIN #user AS u ON n.news_author = u.user_id
                LEFT JOIN #news_category AS nc ON n.news_category = nc.category_id
                WHERE n.news_class IN (".USERCLASS_LIST.") AND NOT (n.news_class REGEXP ".$nobody_regexp.") AND n.news_start < ".time()." AND (n.news_end=0 || n.news_end>".time().") {$render} {$topic} ORDER BY n.news_datestamp DESC LIMIT 0,".$limit;
        
        $sql = e107::getDb();
        
        
        $sql->gen($rssQuery);
        $tmp = $sql->db_getList();

        $rss = array();
        $i=0;
        
        foreach($tmp as $value)
        {
            $rss[$i]['title']           = $value['news_title'];
            $rss[$i]['link']            = e107::getUrl()->create('news/view/item', $value, 'full=1');
            $rss[$i]['author']          = $value['user_name'];
            $rss[$i]['author_email']    = $value['user_email'];
            $rss[$i]['category_name']   = $tp->toHTML($value['category_name'],TRUE,'defs');
            //category sef
            if (empty($value['category_sef']))
            {
                $url = SITEURL . "news.php?cat." . $value['news_category']; 
            }
            else
            {
                $category = array('id' => $value['news_category'], 'name' => $value['category_sef']);
                $opts = array('full' => 1);
                $url = e107::getUrl()->create('news/list/category', $category, $opts);
            }
            $rss[$i]['datestamp']         = $value['news_datestamp'];
            $rss[$i]['description']     = $this->getDescription($value);

            if($value['news_allow_comments'] && $pref['comments_disabled'] != 1)
            {
                $rss[$i]['comment']     = "http://".$_SERVER['HTTP_HOST'].e_HTTP."comment.php?comment.news.".$value['news_id'];
            }

            $rss[$i]['media']            = $this->getMedia($value);

            $i++;
        }
    
        return $rss;
    
    }

    function getDescription($row)
    {

        $tp = e107::getParser();

        if($row['news_summary'] && $this->summaryDescription == true)
        {
            $text = $tp->toHTML($row['news_summary'],true);
        }
        else
        {

            $text= $tp->toHTML($row['news_body'],true). "<br />".$tp->toHTML($row['news_extended'], true);
        }

        if($this->showImages == true && !empty($row['news_thumbnail']))
        {
            $tmp = explode(",", $row['news_thumbnail']);

            foreach($tmp as $img)
            {

                $text .= "<br />\n";
                $text .= $tp->toImage($img, array('w'=>800,'h'=>600, 'legacy'=> "{e_IMAGE}newspost_images/"));
            }

        }

        return $text;

    }

    function getMedia($row)
    {
        $tp = e107::getParser();

        if(empty($this->showImages) ||  empty($row['news_thumbnail']))
        {
            return '';
        }

        $tmp = explode(",", $row['news_thumbnail']);

        $ret = array();

        foreach($tmp as $v)
        {

            if($tp->isImage($v))
            {
                $ret[] =  array(
                    'media:content'   => array(
                        'url'=>$tp->thumbUrl($v,array('w'=>800), true, true),
                        'medium'=>'image',
                        'value' => array('media:title'=> array('type'=>'html', 'value'=>basename($v)))

                    )
                );
            }
            elseif($tp->isVideo($v))
            {
                list($code,$type) = explode(".",$v);

                if($type == 'youtube')
                {

                    //TODO Needs to be verified as working.
                    $ret[] = array(
                        'media:player'  => array('url'=>"http://www.youtube.com/embed/".$code, 'height'=>"560", 'width'=>"315" )
                    );

                }
            }
        }

        return $ret;

    }    
}