def( 'count', 10 ) ); $now = _CURRENT_SERVER_TIME; $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" ; $database->setQuery( $query, 0, $count ); $rows = $database->loadObjectList(); if( count( $rows ) ) { echo '

'; foreach ( $rows as $row ) { $created_month = mosFormatDate ( $row->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; ?>
'; } ?>