Вход Регистрация
Файл: InstantSocial/uploud/modules/mod_latestblogs/module.php
Строк: 110
<?php
/******************************************************************************/
//                                                                            //
//                             InstantCMS v1.9                                //
//                        http://www.instantcms.ru/                           //
//                                                                            //
//                   written by InstantCMS Team, 2007-2011                    //
//                produced by InstantSoft, (www.instantsoft.ru)               //
//                                                                            //
//                        LICENSED BY GNU/GPL v2                              //
//                                                                            //
/******************************************************************************/

function mod_latestblogs($module_id){    
        
$inCore cmsCore::getInstance();
        
$inDB cmsDatabase::getInstance();
        
$cfg $inCore->loadModuleConfig($module_id);
        global 
$_LANG;
        
$inCore->loadModel('blogs');
        
$model = new cms_model_blogs();

        if (!isset(
$cfg['showrss'])) { $cfg['showrss'] = 1;}
        if (!isset(
$cfg['minrate'])) { $cfg['minrate'] = 0;}
        if (!isset(
$cfg['namemode'])) { $cfg['namemode'] = 'blog';}
        if (!isset(
$cfg['showcom'])) { $cfg['showcom'] = 1;}

        if (!isset(
$cfg['shownum'])){
            echo 
'<p>'.$_LANG['LATESTBLOGS_CONFIG_TEXT'].'</p>';
            return;
        }

        
$sql "SELECT  p.title as title,
                        p.id as id,
                        p.seolink as seolink, 
                        b.title as blog,
                        b.owner as owner,
                        b.id as blog_id,
                        b.seolink as bloglink,
                        p.pubdate as fpubdate,
                        b.user_id as uid,
                        IFNULL(r.total_rating, 0) as rating,
                        b.ownertype as ownertype,
                        u.id as author_id,
                        u.nickname as author,
                        up.imageurl as author_image,
                        u.is_deleted as author_deleted
                FROM cms_blog_posts p
                LEFT JOIN cms_blogs b ON b.id = p.blog_id
                LEFT JOIN cms_users u ON u.id = p.user_id                
                LEFT JOIN cms_user_profiles up ON up.user_id = p.user_id
                LEFT JOIN cms_ratings_total r ON r.item_id=p.id AND r.target='blogpost'
                WHERE p.published = 1 AND b.allow_who = 'all'
                ORDER BY p.id DESC
                LIMIT 30"
;
        
        
$result $inDB->query($sql);

        
$is_blog false;

        if (!
$inDB->num_rows($result)){    return false; }

            
$is_blog true;
            
$count 1;
            
$posts = array();

        include_once(
PATH.'/components/users/includes/usercore.php');

        while(
$con $inDB->fetch_assoc($result)){

                if (
$count $cfg['shownum']) { break; }

                if (
$con['rating'] >= $cfg['minrate']){

                    if (
$con['owner']=='user' && $con['ownertype']=='single' && $cfg['namemode']=='user'){
                        
$con['blog'] = $con['author'];
                    }

                    if (
$con['owner']=='club'){
                        
$con['blog'] = $inDB->get_field('cms_clubs''id='.$con['uid'], 'title');
                    }

                    
$con['href']      = $model->getPostURL(null$con['bloglink'], $con['seolink']);
                    
$con['title']      = strip_tags($con['title']);
                    if (
strlen($con['title'])>70) { $con['title'] = substr($con['title'], 070). '...'; }
                    
$con['fpubdate'] = $inCore->dateFormat($con['fpubdate']);
                    
$con['comments'] = $cfg['showcom'] ? $inCore->getCommentsCount('blog'$con['id']) : false;
                    
$con['bloghref'] = $model->getBlogURL(null$con['bloglink']);

                    
$con['image'] = usrImageNOdb($con['author_id'], 'small'$con['author_image'], $con['author_deleted']);

                    
$count++;

                
$posts[] = $con;

            }

            }                
        
        
$smarty $inCore->initSmarty('modules''mod_latestblogs.tpl');            
        
$smarty->assign('posts'$posts);
        
$smarty->assign('cfg'$cfg);
        
$smarty->assign('is_blog'$is_blog);
        
$smarty->display('mod_latestblogs.tpl');    
        
        return 
true;
}
?>
Онлайн: 0
Реклама