Вывод счетчика категорий (количество новостей в категории)

$tpl->set ( '{AJAX}', $ajax );

$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 = '/+'.$row['new_'].')';};
$t = '('.$row['allnews_'].$news_now;
$tpl->set('{count_categ_'.$row['id'].'}', $t);
$count_news_of_category .= $row['id'].'#'.$t.'|';
}

function countcatnews( $matches=array() ) {
        global $db, $is_logged, $member_id, $xf_inited, $cat_info, $config, $user_group, $category_id, $_TIME, $lang, $smartphone_detected, $dle_module, $allow_comments_ajax, $PHP_SELF, $news_date, $banners, $banner_in_news, $url_page, $user_query, $custom_news;
        $thisdate = date ( "Y-m-d H:i:s", (time () + ($config['date_adjust'] * 60)) );
        $where_date = " AND date < '" . $thisdate . "'";
        if ( !count($matches) ) return "";
        $param_str = trim($matches[1]);    
        $aviable = array();
        $count = 0;
        if( preg_match( "#catid=['\"](.+?)['\"]#i", $param_str, $match ) ) {
            $aviable = explode( ',', $match[1] );
            $SQL = $db->query ( "SELECT * FROM " . PREFIX . "_post  WHERE category regexp '[[:<:]](" . implode ( '|', $aviable ) . ")[[:>:]]'".$where_date." and approve=1");
            $count = $row = $db->num_rows();
        }
        return $count;
    }
    if (stripos ( $tpl->copy_template, "{catcount" ) !== false) {
        $tpl->copy_template = preg_replace_callback ( "#\\{catcount(.+?)\\}#i", "countcatnews", $tpl->copy_template );
    }

function countcatnews( $matches=array() ) {
        global $db, $is_logged, $member_id, $xf_inited, $cat_info, $config, $user_group, $category_id, $_TIME, $lang, $smartphone_detected, $dle_module, $allow_comments_ajax, $PHP_SELF, $news_date, $banners, $banner_in_news, $url_page, $user_query, $custom_news;
        $thisdate = date ( "Y-m-d H:i:s", (time () + ($config['date_adjust'] * 60)) );
 
// вот тут условие выбирает все до текущей даты, ну а если нужно за сегодня там просто ставим = вместо <
        $where_date = " AND date = '" . $thisdate . "'";
 
 
 
        if ( !count($matches) ) return "";
        $param_str = trim($matches[1]);    
        $aviable = array();
        $count = 0;
        if( preg_match( "#catid=['\"](.+?)['\"]#i", $param_str, $match ) ) {
            $aviable = explode( ',', $match[1] );
            $SQL = $db->query ( "SELECT * FROM " . PREFIX . "_post  WHERE category regexp '[[:<:]](" . implode ( '|', $aviable ) . ")[[:>:]]'".$where_date." and approve=1");
            $count = $row = $db->num_rows();
        }
        return $count;
    }
    if (stripos ( $tpl->copy_template, "{catcount" ) !== false) {
        $tpl->copy_template = preg_replace_callback ( "#\\{catcount(.+?)\\}#i", "countcatnews", $tpl->copy_template );
    }

    /*********Главное меню**********/
$count_news = dle_cache( "count_news_of_category", $config[’skin’] );
if( !$count_news )
{
  //кэш с количеством новостей пуст
  $all = '';
  $onlyday = '';
    $sql_result = $db->query("SELECT category,date FROM ".PREFIX."_post WHERE approve = '1'");
    while ($row = $db->get_row($sql_result)) {
        $all .= $row['category'].',';
        if ($row['date'] > date("Y-m-d H:i:s", strtotime("-1 DAY"))) {
            $onlyday .= $row['category'].',';
            }
        }
    /**В кэш **/
    create_cache( 'count_news_of_category', substr($all, 0, -1).'|||'.substr($onlyday, 0, -1));
    $db->free();
    $all = explode(",", substr($all, 0, -1));
    $allar = array_count_values($all);
    $onlyday = explode(",", substr($onlyday, 0, -1));
    $onlydayar = array_count_values($onlyday);
    //выводим по тегам кол-во новостей
foreach ($allar as $key => $value) {
    $tpl->set('{categnum-'.$key.'}', $value);
    ${'categnum-'.$key} = $value;
    }
foreach ($onlydayar as $key => $value) {
    $tpl->set('{categday-'.$key.'}', $value);
    ${'categday-'.$key} = $value;
    }
$catidall = "";
$catidday = "";
foreach ($cat_info as $cat) {
    $catidall .= $cat['id'].',';
    }
foreach ($cat_info as $cat) {
    $catidday .= $cat['id'].',';
    }
$catidall = array_diff(explode(",", substr($catidall, 0, -1)), $all);
$catidday = array_diff(explode(",", substr($catidday, 0, -1)), $onlyday);
foreach ($catidall as $catnull) {
    $tpl->set('{categnum-'.$catnull.'}', '0');
    }
foreach ($catidday as $catnull) {
    $tpl->set('{categday-'.$catnull.'}', '0');
    }
}
else
{
  //достанем количество новостей из кэша
    $count_news = explode("|||", $count_news);
    $all = explode(",", $count_news[0]);
    $allar = array_count_values($all);
    $onlyday = explode(",", $count_news[1]);
    $onlydayar = array_count_values($onlyday);
    //выводим по тегам кол-во новостей
foreach ($allar as $key => $value) {
    $tpl->set('{categnum-'.$key.'}', $value);
    ${'categnum-'.$key} = $value;
    }
foreach ($onlydayar as $key => $value) {
    $tpl->set('{categday-'.$key.'}', $value);
    ${'categday-'.$key} = $value;
    }
$catidall = "";
$catidday = "";
foreach ($cat_info as $cat) {
    $catidall .= $cat['id'].',';
    }
foreach ($cat_info as $cat) {
    $catidday .= $cat['id'].',';
    }
$catidall = array_diff(explode(",", substr($catidall, 0, -1)), $all);
$catidday = array_diff(explode(",", substr($catidday, 0, -1)), $onlyday);
foreach ($catidall as $catnull) {
    $tpl->set('{categnum-'.$catnull.'}', '0');
    }
foreach ($catidday as $catnull) {
    $tpl->set('{categday-'.$catnull.'}', '0');
    }
}
/************************************/

<?php
    if(!defined('DATALIFEENGINE'))die("Hacking attempt!");  
    //Подключаем API CMS DLE  
    include ('engine/api/api.class.php');
    
    //24 часа назад
    $thisdate = langdate( "Y-m-d", $_TIME-86400 )." 00:00:00";
    
    //условие отбора новостей
    $where_date = " AND date > '" . $thisdate . "'";
    
    //формируем список категорий которые мы ввели в параметр cat=
    $aviable = array();
    $aviable = explode( ',', $cat );
    
    //Выполняем запрос
    $SQL = $db->query ( "SELECT * FROM " . PREFIX . "_post  WHERE category regexp '[[:<:]](" . implode ( '|', $aviable ) . ")[[:>:]]'".$where_date." and approve=1");
    $count = $row = $db->num_rows();
    if($count != 0)
        echo '+'.$count;
?>