Вывод количества новостей в меню

$staticcountcnews = (file_exists(ENGINE_DIR . "/cache/staticcountcnews.tmp" )) ? @file_get_contents( ENGINE_DIR . "/cache/staticcountcnews.tmp" ) : '';
if( ! $staticcountcnews ) {
$sql_result = $db->query("select ct.id,
(select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND (DATE_FORMAT(date, '%Y%m%d')=CURDATE()) AND approve = '1') as new_,
(select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND approve = '1') as allnews_
from ". PREFIX ."_category ct"
);
if(count($db->get_row($sql_result))>0){
$staticcountcnews = array();
while($row = $db->get_row($sql_result)){$staticcountcnews[$row['id']] = array('new'=>intval($row['new_']),'all'=>intval($row['allnews_']));}

$staticcountcnews = serialize($staticcountcnews);

file_put_contents (ENGINE_DIR . "/cache/staticcountcnews.tmp",$staticcountcnews, LOCK_EX);
@chmod( ENGINE_DIR . "/cache/staticcountcnews.tmp", 0666 );}
$db->free();}
if ($staticcountcnews !== false ) {
$countCatNews = unserialize($staticcountcnews);
if ( is_array($countCatNews) OR is_int($countCatNews) ){
foreach($countCatNews as $key => $val){
$show = '';
$show .= intval($countCatNews[$key]['all']) ? $countCatNews[$key]['all'] : '';
$show .= intval($countCatNews[$key]['new']) ? ' /+'.$countCatNews[$key]['new'] : '';
$tpl->set('{count-categ-'.$key.'}',$show);
}}}

//echo'<pre>';print_r($countCatNews);echo'</pre>';

$sql_result = $db->query("select ct.id,
(select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND (DATE_FORMAT(date, '%Y%m%d')=CURDATE()) AND approve = '1') as new_,
(select count(*) from ". PREFIX ."_post ps where (ps.category REGEXP concat( '^(' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ',)' ) or ps.category REGEXP concat( '(,' ,ct.id, ')$' ) or ps.category=ct.id) AND approve = '1') as allnews_
from ". PREFIX ."_category ct"
);
$count_news_of_category = '';
while($row = $db->get_row($sql_result))
{
if( $row['new_'] == '0') {$news_now = '';} else {$news_now = '<font color="#CC0000">+'.$row['new_'].'</font>&nbsp;|&nbsp;';};
$t = '[&nbsp;'.$news_now.$row['allnews_'].'&nbsp;]';
$tpl->set('{count_categ_'.$row['id'].'}', $t);
$count_news_of_category .= $row['id'].'#'.$t.'|';
}