get( 'count', 10 ) ); $moduleclass_sfx = $params->get( 'moduleclass_sfx' ); $now = date( 'Y-m-d H:i:s', time() + $mosConfig_offset * 60 * 60 ); $query = "SELECT MONTH(created) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year" . "\n FROM #__content" . "\n WHERE ( state='-1' AND checked_out='0' AND sectionid > '0' )" . "\n GROUP BY created_year DESC, created_month DESC LIMIT $count"; $database->setQuery( $query ); $rows = $database->loadObjectList(); if (is_array($rows)) { ?>

created, "%m" ); $month_name = mosFormatDate ( $row->created, "%B" ); $created_year = mosFormatDate ( $row->created, "%Y" ); $link = sefRelToAbs( 'index.php?option=com_content&task=archivecategory&year='. $created_year .'&month='. $created_month .'&module=1' ); $text = $month_name .', '. $created_year; ?>