CoreFiles by mySites.guru
helper.php53 lines, 1,688 bytes, from Joomla_1.5.13-Stable-Full_Package.zip
Raw History Compare with 1.5.12
md5
b949e7f2a8e0fab4af5b26e746001040
sha1
38466578c2833a6efca1e02f4a07a588ead4e05d
sha256
085fd7d4caed8e95daf43c26c66fe7dc5668298ac988656a8998ed77ef662697
<?php
/**
* @version		$Id: helper.php 11646 2009-03-01 19:34:56Z ian $
* @package		Joomla
* @copyright	Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved.
* @license		GNU/GPL, see LICENSE.php
* Joomla! 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.
* See COPYRIGHT.php for copyright notices and details.
*/

// no direct access
defined('_JEXEC') or die('Restricted access');



class modArchiveHelper
{
	function getList(&$params)
	{
		//get database
		$db =& JFactory::getDBO();

		$query = 'SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year' .
			' FROM #__content' .
			' WHERE ( state = -1 AND checked_out = 0 AND sectionid != 0)' .
			' GROUP BY created_year DESC, created_month DESC';
		$db->setQuery($query, 0, intval($params->get('count')));
		$rows = $db->loadObjectList();

		$menu = &JSite::getMenu();
		$item = $menu->getItems('link', 'index.php?option=com_content&view=archive', true);
		$itemid = isset($item) ? '&Itemid='.$item->id : '';

		$i		= 0;
		$lists	= array();
		foreach ( $rows as $row )
		{
			$date =& JFactory::getDate($row->created);

			$created_month	= $date->toFormat("%m");
			$month_name		= $date->toFormat("%B");
			$created_year	= $date->toFormat("%Y");

			$lists[$i]->link	= JRoute::_('index.php?option=com_content&view=archive&year='.$created_year.'&month='.$created_month.$itemid);
			$lists[$i]->text	= $month_name.', '.$created_year;
			$i++;
		}
		return $lists;
	}
}

The same content is in 6 releases, Joomla 1.5.10 to 1.5.15. See them all, or every version of this file.