<?php
/**
 * Helper class for Hello World! module
 * 
 * @package    Joomla.Tutorials
 * @subpackage Modules
 * @link http://docs.joomla.org/J3.x:Creating_a_simple_module/Developing_a_Basic_Module
 * @license        GNU/GPL, see LICENSE.php
 * mod_helloworld is free software. This version may have been modified pursuant
 * to the GNU General Public License, and as distributed it includes or
 * is derivative of works licensed under the GNU General Public License or
 * other free or open source software licenses.
 */
class ModMCDiscussionsHelper
{
    /**
     * Retrieves the hello message
     *
     * @param   array  $params An object containing the module parameters
     *
     * @access public
     */    
	public static function getContent($params)
	{
		// Obtain a database connection
		$db = JFactory::getDbo();
		$query = $db->getQuery(true);
		$query->select($db->quoteName(array('id', 'discussion_type', 'title', 'resource', 'engdate', 'nepdate', 'discussion_time')));
		$query->from($db->quoteName('#__mcdiscussions'));
		$max=$params['max'];
		$latestfirst=$params['latestfirst'];
		if($latestfirst=="1")
			$query->order('dateinsert DESC');
		elseif($latestfirst=="0")
		$query->order('dateinsert ASC');
		$query->setLimit($max);
		$db->setQuery($query);
		$results = $db->loadObjectList();
		return $results;
	}
	
}