3.0.x Последние альбомы музыки на главной

1. Шагаем в Админку -> CMS -> Block -> Add New Block ( новый блог )

2. Вписываем далее:

*Product: phpfox
*Module: group
*Title: Featured Music Albums
*Type: PHP Code
*Controller: core.index-member
*Placement: Block 3.
*Active: Yes
*PHP/HTML Code (Optional):

Code:

<?php 
 
$sSelect = 'ma.*, mat.text_parsed,' . Phpfox::getUserField(); 
$sJoinCondAlbum = 'ma.album_id = mat.album_id'; 
$sJoinCondUser = 'ma.user_id = u.user_id'; 
$sCond = 'ma.view_id = 0 AND ma.is_featured = 1'; 
$sOrder = 'RAND()'; 
$db = Phpfox::getLib('database'); 
 
$aRows = $db->select($sSelect) 
                        ->from(Phpfox::getT('music_album'), 'ma') 
                        ->join(Phpfox::getT('music_album_text'), 'mat', $sJoinCondAlbum) 
                        ->join(Phpfox::getT('user'), 'u', $sJoinCondUser) 
                        ->where($sCond) 
                        ->limit('3') // Limit to only 3 albums 
                        ->order($sOrder) 
                        ->execute('getSlaveRows'); 
 
foreach ($aRows as $iKey => $aRow) 
{
        $aRows[$iKey]['album_url'] = Phpfox::getLib('url')->makeUrl($aRow['user_name'], array('music', $aRow['name_url'])); 
        $aRows[$iKey]['creator_url'] = Phpfox::getLib('url')->makeUrl('profile', array($aRow['user_name'])); 
        $aRows[$iKey]['image_path_parsed'] = Phpfox::getLib('phpfox.image.helper')->display( 
                array(
                        'title' => $aRow['name'], 
                        'path' => 'music.url_image', 
                        'file' => $aRow['image_path'], 
                        'suffix' => '_120', 
                        'max_width' => '120', 
                        'max_height' => '120', 
                )
        );
}
 
$sAddAlbum = Phpfox::getLib('url')->makeUrl('music', array('album')); 
$sViewAll = Phpfox::getLib('url')->makeUrl('music', array('browse', 'album')); 
?> 
 
<div class="block js_sortable" id="js_block_border_featured_music_album">
        <div class="title js_sortable_header" style="cursor: move; ">
                <?php echo Phpfox::getPhrase('music.featured'); ?> 
        </div>
        <div class="content" id="js_block_content_featured_music_album">
                <?php 
                if (!count($aRows)) 
                {
                        ?> 
                        <div class="extra_info">
                                <?php echo Phpfox::getPhrase('music.there_are_no_featured_albums'); ?> 
                                <ul class="action">
                                        <li><a href="<?php echo $sAddAlbum; ?>"><?php echo Phpfox::getPhrase('music.add_album'); ?></a></li>
                                </ul>
                        </div>
                        <?php 
                } 
                else
                {
                        $i = 1; 
                        foreach($aRows as $aAlbum) 
                        {
                        ?> 
                                <div class="<?php if (is_int($i/2)) { ?> row1 <?php } else { ?> row2 <?php } if ($i == 1) { ?> row_first <?php } ?>">
                                        <div style="width:55px; position:absolute; text-align:center; left:20px;">
                                                <a href="<?php echo $aAlbum['album_url']; ?>" title="<?php echo $aAlbum['name']; ?>">
                                                        <?php echo $aAlbum['image_path_parsed']; ?> 
                                                </a>
                                        </div>
                                        <div style="margin-left:130px; min-height:55px; height:auto !important; height:55px;">
                                                <a href="<?php echo $aAlbum['album_url']; ?>" title="<?php echo $aAlbum['name']; ?>">
                                                        <?php echo $aAlbum['name']; ?> 
                                                </a>
                                                                                                <?php echo Phpfox::getPhrase('music.by'); ?> 
                                                <a href="<?php echo $aAlbum['creator_url']; ?>" title="<?php echo $aAlbum['user_name']; ?>">
                                                        <?php echo $aAlbum['full_name']; ?> 
                                                </a>
                                                <div class="extra_info">
                                                        <?php echo Phpfox::getLib('parse.output')->shorten($aAlbum['text_parsed'], 200); ?> 
                                                </div>
                                                                                                <div class="extra_info">
                                                                                                        <?php 
                                                                                                                echo Phpfox::getPhrase('music.total_play_plays',
                                                                                                                                array(
                                                                                                                                        'total_play' => $aAlbum['total_play'],
                                                                                                                                )
                                                                                                                );
                                                                                                        ?> 
                                                                                                        <?php echo Phpfox::getPhrase('music.released'),': ',$aAlbum['year']; ?> 
                                                                                                        <?php 
                                                                                                                echo Phpfox::getPhrase('music.total_track_tracks',
                                                                                                                                array(
                                                                                                                                        'total_track' => $aAlbum['total_track'],
                                                                                                                                )
                                                                                                                );
                                                                                                        ?> 
                                                                                                </div>
                                        </div>
                                </div>
                        <?php 
                        $i++; 
                        }
                }
                ?> 
                <div class="clear"></div>
        </div>
        <div class="bottom">
                <ul>
                        <li id="js_block_bottom_1" class="first">
                                <a href="<?php echo $sViewAll; ?>" id="js_block_bottom_link_1">
                                        <?php echo Phpfox::getPhrase('music.view_more'); ?> 
                                </a>
                        </li>
                </ul>
        </div>
</div>

Пользуемся, говорим Спасибо.

Ваня, следи за тем что пишешь, не *Module: group, а *Module: music, и не последние, а популярные!!!