Правка модуля "Популярное в блогах", топ записей за 10 дней

<?php
function mod_bestblogs($module_id){
        $inCore = cmsCore::getInstance();
        $inDB = cmsDatabase::getInstance();
        global $_LANG;
		if (!function_exists('cmsKarmaFormat')){ //if not included earlier
			include($_SERVER['DOCUMENT_ROOT'].'/core/lib_karma.php');
		}		
 
		$cfg = $inCore->loadModuleConfig($module_id);
 
        if (!isset($cfg['namemode'])) { $cfg['namemode'] = 'blog';}
        if (!isset($cfg['shownum'])) { $cfg['shownum'] = 10; }
        if (!isset($cfg['menuid'])) { $cfg['menuid'] = 0; }
 
		if (!isset($cfg['shownum'])){
			echo '<p>'.$_LANG['BESTBLOGS_CONFIG_TEXT'].'</p>';
			return;
		}
 
        $inCore->loadModel('blogs');
        $model = new cms_model_blogs();
 
        $sql = "
            SELECT *
            FROM cms_ratings
            WHERE target = 'blogpost'
            AND pubdate >= CURRENT_DATE - INTERVAL 10  DAY
            GROUP BY item_id
        ";
        $result = $inDB->query($sql);
    $posts = array();
        $qqq = '';
        while($con = $inDB->fetch_assoc($result)){
            $qqq.= $con['item_id'].",";
        }
        $qqq.="0";
            $sql = "
                SELECT * , SUM(points) as sumpoint
                FROM cms_ratings
                WHERE target = 'blogpost'
                AND pubdate >= CURRENT_DATE - INTERVAL 10 DAY
                AND item_id IN (".$qqq.") GROUP by item_id ORDER BY sumpoint desc
            ";
            $res = $inDB->query($sql);
            $nums_b = 1;
//            $cfg['shownum'] = 1;
            while ($item = $inDB->fetch_assoc($res))
            {
                if ($nums_b<=$cfg['shownum']) {
                $nums_b++;
                $sql = "SELECT  p.id,
                                p.title,
                                p.seolink,
                                p.pubdate,
                                b.title as blog,
                                b.id as blog_id,
                                b.seolink as bloglink,
                                b.owner as owner,
                                b.user_id as uid,
                                b.owner as owner,
                                b.ownertype as ownertype,
                                u.nickname as author
                        FROM cms_blog_posts p
                        LEFT JOIN cms_blogs b ON b.id = p.blog_id
                        LEFT JOIN cms_users u ON u.id=b.user_id
                        WHERE p.published = 1 AND b.allow_who = 'all' AND p.id = '{$item['item_id']}'";
 
                $ress = $inDB->query($sql);
                $con = $inDB->fetch_assoc($ress);
//
  				$next = sizeof($posts);
 
                if ($con['owner']=='club'){
                    $con['blog'] = dbGetField('cms_clubs', 'id='.$con['uid'], 'title');
                }
 
				$text = strip_tags($con['title']);
				if (strlen($text)>70) { $text = substr($text, 0, 70). '...'; }
 
				$posts[$next]['title'] = $text;
                $posts[$next]['href'] = $model->getPostURL(null, $con['bloglink'], $con['seolink']);
 
                if ($con['owner']=='user' && $con['ownertype']=='single' && $cfg['namemode']=='user'){
                    $con['blog'] = $con['author'];
                }
 
				$posts[$next]['blog'] = $con['blog'];
                $posts[$next]['bloghref'] = $model->getBlogURL(null, $con['bloglink']);
 
//				$posts[$next]['karma'] = cmsKarmaFormat($con['points']);
				$posts[$next]['karma'] = $item['sumpoint'];
 
				$posts[$next]['date'] = $inCore->dateFormat($con['pubdate']);
            }
            }
 
			$smarty = $inCore->initSmarty('modules', 'mod_bestblogs.tpl');
			$smarty->assign('posts', $posts);
			$smarty->display('mod_bestblogs.tpl');
 
		return true;
}
?>