| Server IP : 79.170.40.229 / Your IP : 3.144.12.19 Web Server : Apache System : Linux web232.extendcp.co.uk 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : 1stforcarhirealicante.com ( 296923) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/thread-self/cwd/modules/mod_archive/ |
Upload File : |
<?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;
}
}