Новый материал на сайта +1

$template = ($cfg['tpl'] ? $cfg['tpl'] : 'mod_menu.tpl');

    function newContent($table, $where=''){
    	if ($where) { $where = ' AND '.$where; }
		$new = dbGetField($table, "DATE_FORMAT(pubdate, '%d-%m-%Y') = DATE_FORMAT(NOW(), '%d-%m-%Y'){$where}", 'COUNT(id)');
		return $new;
		}
			$count_sql_board = "SELECT id FROM cms_board_items WHERE published = 1";
			$count_board = $inDB->query($count_sql_board) ;
			$total_board = $inDB->num_rows($count_board);
			$new['board'] 	= (int)newContent('cms_board_items');
		if($new['board']) { $new_board = ' (<span style="color: green;" title="Сегодня +'.$new['board'].'">+'.$new['board'].'</span>)'; }

$smarty->assign('cfg', $cfg);

		$smarty->assign('new_board', $new_board); 
		$smarty->assign('total_board', $total_board);

$count_sql_board = "SELECT id FROM cms_board_items WHERE published = 1";

$count_sql_board = "SELECT id FROM cms_board_items WHERE category_id = 12 and published = 1";

$count_sql_board = "SELECT i.id
FROM cms_board_items i
INNER JOIN cms_board_cats cat ON i.category_id = 12 WHERE i.published = 1";

    function newContent($table, $where=''){
    	if ($where) { $where = ' AND '.$where; }
		$new = dbGetField($table, "DATE_FORMAT(pubdate, '%d-%m-%Y') = DATE_FORMAT(NOW(), '%d-%m-%Y'){$where}", 'COUNT(id)');
		return $new;
		}
			//$count_sql_board = "SELECT id FROM cms_board_items on category_id = 12 where published = 1";
			$count_sql_board = "SELECT COUNT(*) FROM `cms_board_cats` WHERE category_id = 12 AND published = 1";
			$count_board = $inDB->query($count_sql_board) ;
			$total_board = $count_board;//$inDB->num_rows($count_board);
			$new['board'] 	= (int)newContent('cms_board_items', 'category_id = 12 ');
		if($new['board']) { $new_board = ' <span style="vertical-align:top;font-size:14px;color: white;background-image:url(/images/1.png)" title="Сегодня +'.$new['board'].'">+'.$new['board'].'</span>'; }