[Comoblog-commit] modules/mod_latest_comments/include mod_latest_comments.inc.php, 1.2, 1.3

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/modules/mod_latest_comments/include
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27709/modules/mod_latest_comments/include

Modified Files:
	mod_latest_comments.inc.php 
Log Message:
work in progress, ditching this server cos its borked ;(



Index: mod_latest_comments.inc.php
===================================================================
RCS file: /cvsroot/comoblog/modules/mod_latest_comments/include/mod_latest_comments.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- mod_latest_comments.inc.php	17 Feb 2006 15:18:49 -0000	1.2
+++ mod_latest_comments.inc.php	22 Oct 2006 11:44:17 -0000	1.3
@@ -4,13 +4,12 @@
    else
       $iisbug = '';
 
-   $query = "
-select c.*, p.*   from   easymoblog_posts p , easymoblog_comments c where p.post_id =c.post_id  order by comment_id desc limit 0,".$howmany.";";
+   $query = "select c.*, p.*   from   comoblog_posts p , comoblog_comments c where p.post_id =c.post_id and c.comment_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'];
@@ -22,8 +21,8 @@
       error_log($row['comment_added']);
       $posts[] = $row;
       }
-   
+
    return ($posts);
-}   
+}
 
 ?>
\ No newline at end of file