Index: trunk/core/units/categories/categories_tag_processor.php =================================================================== diff -u -N -r8385 -r8402 --- trunk/core/units/categories/categories_tag_processor.php (.../categories_tag_processor.php) (revision 8385) +++ trunk/core/units/categories/categories_tag_processor.php (.../categories_tag_processor.php) (revision 8402) @@ -6,18 +6,15 @@ { $object =& $this->getObject($params); - $sql = 'SELECT COUNT(*) - FROM '.$object->TableName.' - WHERE ParentPath LIKE "'.$object->GetDBField('ParentPath').'%"'; - if (isset($params['today']) && $params['today']) { - $sql .= ' AND CreatedOn > '.(adodb_mktime() - 86400); + $sql = 'SELECT COUNT(*) + FROM '.$object->TableName.' + WHERE (ParentPath LIKE "'.$object->GetDBField('ParentPath').'%") AND (CreatedOn > '.(adodb_mktime() - 86400).')'; + return $this->Conn->GetOne($sql) - 1; } - if (!$this->Application->IsAdmin()) { - $sql .= ' AND Status = '.STATUS_ACTIVE; - } - return $this->Conn->GetOne($sql) - 1; + return $object->GetDBField('CachedDescendantCatsQty'); + } function IsNew($params)