Update of /cvsroot/comoblog/modules/mod_rss2/include
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27709/modules/mod_rss2/include
Modified Files:
mod_rss2.inc.php
Log Message:
work in progress, ditching this server cos its borked ;(
Index: mod_rss2.inc.php
===================================================================
RCS file: /cvsroot/comoblog/modules/mod_rss2/include/mod_rss2.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- mod_rss2.inc.php 17 Feb 2006 15:18:50 -0000 1.4
+++ mod_rss2.inc.php 22 Oct 2006 11:44:05 -0000 1.5
@@ -5,27 +5,27 @@
$iisbug = '';
$query = "
-select c.*, p.post_mail_subject, c.comment_text as post_mail_body,c.comment_added as post_mail_date, c.comment_author_email as post_mail_from from easymoblog_posts p , easymoblog_comments c where p.post_id =c.post_id order by comment_id desc limit 0,".$howmany.";";
+select c.*, p.post_mail_subject, c.comment_text as post_mail_body,c.comment_added as post_mail_date, c.comment_author_email as post_mail_from from comoblog_posts p , comoblog_comments c where p.post_id =c.post_id and c.commnet_live='Y' order by comment_id desc limit 0,".$howmany.";";
$res = mysql_query($query);
if (!$res || !mysql_num_rows($res))
return (false);
-
+
$posts = array();
while ($row = mysql_fetch_array($res)) {
$row['post_permalink'] = CFG_SITE_URL.'post.php'.$iisbug.'/'.$row['post_id'];
if (CFG_USE_FRIENDLY_URLS =="yes"){
$row['postlink'] = CFG_SITE_URL.$row['post_id'] ."/". $row['post_mail_subject'];
- }
+ }
$row['post_trackback_ping_url'] = CFG_SITE_URL.'trackback.php'.$iisbug.'/'.$row['post_id'];
$row['post_trackback_list'] = CFG_SITE_URL.'trackback.php'.$iisbug.'/'.$row['post_id'].'?__mode=list';
$row['post_trackback_list_rss'] = CFG_SITE_URL.'trackback.php'.$iisbug.'/'.$row['post_id'].'?__mode=rss';
- $row['post_mail_from'] = "hidden";
+ $row['post_mail_from'] = "hidden";
$row['post_mail_date_rss'] = gmstrftime("%a, %d %b %Y %T %Z",$row['post_mail_date']);
$posts[] = $row;
}
-
+
return ($posts);
-}
+}
-?>
\ No newline at end of file
+?>
|
