spacer

		$sql = "SELECT c.id as id,
                       c.target as target,
                       c.target_id as target_id,
                       c.target_link as target_link, 
					   c.target_title,
                       c.content as content,
                       c.guestname,
                       c.pubdate as fpubdate,
                       IFNULL(c.user_id, 0) as user_id,
                       IFNULL(u.nickname, '') as author,
                       IFNULL(u.login, '') as author_login,
                       IFNULL(v.total_rating, 0) as rating
				FROM cms_comments c
				INNER JOIN cms_users u ON u.id = c.user_id {$guest_sql}
                LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
				WHERE c.published=1 {$hidden_sql} {$target_where}
                GROUP BY c.id
                ORDER BY c.id DESC
                LIMIT 70";
 
        $result = $inDB->query($sql);
		$is_com = false;
        if ($inDB->num_rows($result)){
			$is_com = true;
            $count = 0;
			$comments = array();
            while($con = $inDB->fetch_assoc($result)){
 
                if ($count >= $cfg['shownum']) { break; }
 
                if ($con['rating'] >= $cfg['minrate']){
 
                    $con['link'] = $con['target_link'] . '#c'.$con['id'];
                    $con['text'] = strip_tags($con['content']);
 
                    $con['text'] =  preg_replace('/\[hide\](.*?)\[\/hide\]/i', '', $con['text']);
                    $con['text'] =  preg_replace('/\[hide\](.*?)$/i', '', $con['text']);
 
                    if (strlen($con['text'])>60) { $con['text'] = substr($con['text'], 0, 60). '...'; }
                    if (!$con['text']) { $con['text'] = '...'; }

{if $is_blog}
 
    {foreach key=tid item=post from=$posts}
        <div class="mod_latest_entry">
 
            <div class="mod_latest_image">
                {$post.image}
            </div>
 
            <a class="mod_latest_blog_title" href="{$post.href}">{$post.title}</a>
 
            <div class="mod_latest_date">
                {$post.fpubdate} - <a href="{$post.bloghref}">{$post.blog}</a>{if $cfg.showcom} - <a href="{$post.href}" title="{$post.comments|spellcount:$LANG.COMMENT1:$LANG.COMMENT2:$LANG.COMMENT10}" class="mod_latest_comments">{$post.comments}</a>{/if}
            </div>
 
        </div>
    {/foreach}
 
    {if $cfg.showrss}
        <div class="mod_latest_rss">
            <a href="/rss/blogs/all/feed.rss">{$LANG.LATESTBLOGS_RSS}</a>
        </div>
    {/if}
 
{else}            
    <p>{$LANG.LATESTBLOGS_NOT_POSTS}</p>
{/if}