<?php
/**
* @version      $Id: helper.php 0003 2010-03-03 10:30:00Z pe7er $
* @copyright    Copyright 2010 by Peter Martin / db8.nl. All rights reserved.
* @license	http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/
defined( '_JEXEC' ) or die( 'Restricted access' );

/**
* db8 Latest Weblinks Module Helper
*
* @static
*/
class modDB8LatestWeblinksHelper
{
    /**
    * Gets a list of latest added Weblinks
    *
    * @param JParameter Module parameters
    * @return mixed Array of items, false on failure
    */
    function &getItems(&$params)
    {
        $count = intval( $params->def( 'count', 5 ) );
        $catid = trim( $params->get( 'catid' ) );
        $show_unpublished = abs($params->def('show_unpublished', 0));

        if ($show_unpublished) {
            $user = &JFactory::getUser();
            if ( $user->get('gid') < 20 ){ return array(); }
            $querypublished = ' AND ( a.published = 0 OR a.approved = 0 )';  // if unpublished, return
        }else{
            $querypublished = ' AND ( a.published = 1 AND a.approved = 1 )';
        }

        $db =& JFactory::getDBO();
        $query = 'SELECT a.id, a.title, a.url, a.description, a.catid' .
                ' FROM #__weblinks AS a' .
                ' LEFT JOIN #__categories AS cc ON cc.id = a.catid' .
                ' WHERE cc.published = 1' .
                $querypublished .
                ( $catid ? "\n AND ( a.catid IN ( $catid ) )" : '' ).
                ' ORDER BY a.date DESC'
                ;
        $db->setQuery($query,0,$count);
        $list = $db->loadObjectList();

        return $list;
    }
}