Новости блогов
// how many nodes per page
$nodes_per_page = 30;
// query
$q="SELECT * FROM node INNER JOIN node_revisions ON node.nid=node_revisions.nid WHERE type='blog' ORDER by created DESC";
// count query
$cq="SELECT count( * ) FROM node WHERE type='blog'";
$rs = pager_query($q,$nodes_per_page,0,$cq);
while($rw = db_fetch_object($rs))
{
$quer="SELECT totalcount, comment_count FROM `node_counter` INNER JOIN node_comment_statistics ON node_counter.nid=node_comment_statistics.nid WHERE node_counter.nid='$rw->nid' LIMIT 1";
$res=db_query($quer);
$resf=db_fetch_object($res);
#############
#$quer="SELECT filepath FROM `files` INNER JOIN content_field_picture ON #files.fid=content_field_picture.field_picture_fid WHERE content_field_picture.nid='$rw->nid' LIMIT 1";
#$res2=db_query($quer);
#$resf2=db_fetch_object($res2);
$img='';
#if($resf2->filepath){$img='';}
#############
$o .= '
'.$rw->teaser.'
';
}
// print paging links
$o .= theme('pager', NULL, 10);
echo $o;
?>