WHERE page_state=0 AND page_cat NOT LIKE 'system'
AND page_cat IN ('".implode("','", $catsub)."') ORDER BY page_".$sed_cat[$cfg['plugin']['news']['category']]['order']." ".$sed_cat[$cfg['plugin']['news']['category']]['way']." LIMIT ".$cfg['plugin']['news']['maxpages']);

if (!defined('SED_CODE')) { die('Wrong URL.'); }

if ($cfg['plugin']['news']['maxpages']>0 && !empty($cfg['plugin']['news']['category']) && !empty($sed_cat[$cfg['plugin']['news']['category']]['order']))
{
$jj = 0;
$mtch = $sed_cat[$cfg['plugin']['news']['category']]['path'].".";
$mtchlen = strlen($mtch);
$catsub = array();
$catsub[] = $cfg['plugin']['news']['category'];

foreach($sed_cat as $i => $x)
{
if (substr($x['path'], 0, $mtchlen)==$mtch && sed_auth('page', $i, 'R'))
{ $catsub[] = $i; }
}

$sql = sed_sql_query("SELECT p.*, u.user_name, user_avatar FROM $db_pages AS p
LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid
WHERE page_state=0 AND page_cat NOT LIKE 'system'
AND page_cat IN ('".implode("','", $catsub)."') ORDER BY page_".$sed_cat[$cfg['plugin']['news']['category']]['order']." ".$sed_cat[$cfg['plugin']['news']['category']]['way']." LIMIT ".$cfg['plugin']['news']['maxpages']);

$news = new XTemplate(sed_skinfile('news'));

while ($pag = sed_sql_fetcharray($sql))
{
$jj++;
$catpath = sed_build_catpath($pag['page_cat'], "<a href=\"list.php?c=%1\$s\">%2\$s</a>");
$pag['page_desc'] = sed_cc($pag['page_desc']);
$pag['page_pageurl'] = (empty($pag['page_alias'])) ? "page.php?id=".$pag['page_id'] : "page.php?al=".$pag['page_alias'];
$pag['page_fulltitle'] = $catpath." ".$cfg['separator']." <a href=\"".$pag['page_pageurl']."\">".$pag['page_title']."</a>";

$item_code = 'p'.$pag['page_id'];
list($pag['page_comments'], $pag['page_comments_display']) = sed_build_comments($item_code, $pag['page_pageurl'], FALSE);
list($pag['page_ratings'], $pag['page_ratings_display']) = sed_build_ratings($item_code, $pag['page_pageurl'], FALSE);