1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
<?php
/**
* @version $Id: mod_sections.php 305 2005-10-02 09:36:51Z stingrey $
* @package Joomla
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html 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.
*/
global $mosConfig_offset;
/// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );
$count = intval( $params->get( 'count', 20 ) );
$access = !$mainframe->getCfg( 'shownoauth' );
$now = date( 'Y-m-d H:i:s', time() + $mosConfig_offset * 60 * 60 );
$nullDate = $database->getNullDate();
$query = "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 ON a.id = b.sectionid"
. ( $access ? "\n AND b.access <= $my->gid" : '' )
. "\n AND ( b.publish_up = '$nullDate' OR b.publish_up <= '$now' )"
. "\n AND ( b.publish_down = '$nullDate' 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"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
$bs = $mainframe->getBlogSectionCount();
$bc = $mainframe->getBlogCategoryCount();
$gbs = $mainframe->getGlobalBlogSectionCount();
if ( $rows ) {
?>
<ul>
<?php
foreach ($rows as $row) {
$_Itemid = $mainframe->getItemid( $row->id, 0, 0, $bs, $bc, $gbs );
if ( $Itemid == $_Itemid ) {
$link = sefRelToAbs( "index.php?option=com_content&task=blogsection&id=". $row->id );
} else {
$link = sefRelToAbs( "index.php?option=com_content&task=blogsection&id=". $row->id ."&Itemid=". $_Itemid );
}
?>
<li>
<a href="<?php echo $link;?>">
<?php echo $row->title;?></a>
</li>
<?php
}
?>
</ul>
<?php
}
?>
|