get( 'count', 20 ) ); $access = !$mainframe->getCfg( 'shownoauth' ); $now = date( 'Y-m-d H:i:s', time() + $mosConfig_offset * 60 * 60 ); $database->setQuery( "SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt" . "\n FROM #__sections as a" . "\n LEFT JOIN #__content as b" . "\n ON a.id=b.sectionid" . ($access ? "\n AND b.access<='$my->gid'" : "" ) . "\n AND (b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '". $now ."' )" . "\n AND (b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '". $now ."' )" . "\n WHERE a.scope='content'" . "\n AND a.published='1'" . ($access ? "\n AND a.access<='$my->gid'" : "" ) . "\n GROUP BY a.id" . "\n HAVING COUNT(b.id)>0" . "\n ORDER BY a.ordering" . "\n LIMIT $count" ); $rows = $database->loadObjectList(); $menuhandler =& mosMenuHandler::getInstance(); echo "

\n"; if ($rows) { foreach ($rows as $row) { $sectionItemid = $menuhandler->getSectionItemId($row->id,1); $url = "index.php?option=com_content&task=blogsection&id=".$row->id."&Itemid=$sectionItemid"; echo "
• " . $row->title . "
\n"; } echo "

\n"; } ?>