Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20540
Modified Files:
serendipity_functions.inc.php
Log Message:
Removed an invalid SQL WHERE clause. The entry_id is NOT NULL, so checking against an empty string is a waste of time
Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.194
retrieving revision 1.195
diff -u -d -r1.194 -r1.195
--- serendipity_functions.inc.php 3 Feb 2004 16:24:02 -0000 1.194
+++ serendipity_functions.inc.php 3 Feb 2004 16:49:59 -0000 1.195
@@ -903,7 +903,7 @@
{$serendipity['dbPrefix']}comments co
LEFT JOIN {$serendipity['dbPrefix']}entries e ON (co.entry_id = e.id)
LEFT JOIN {$serendipity['dbPrefix']}category c ON (e.categoryid = c.categoryid)
- WHERE co.type LIKE 'NORMAL' AND co.entry_id != '' $and
+ WHERE co.type LIKE 'NORMAL' $and
ORDER BY
co.id " . ($order != '' ? $order : '') . "
$limit";
@@ -962,7 +962,7 @@
<?php echo nl2br(serendipity_markup_text(serendipity_emoticate($body))); ?><br />
<div class="serendipity_comment_source">
- <a href="#c<?php echo $comment['id']; ?>" title="<?php echo LINK_TO_COMMENT . $x; ?>">#<?php echo $x ; ?></a> - <?php echo $type . ' '; ?>
+ <a href="#c<?php echo $comment['id']; ?>" title="<?php echo LINK_TO_COMMENT . $x; ?>">#<?php echo $x ; ?></a> - <?php echo $comment['type'] . ' '; ?>
<?php
/* Link to the user's email */
if ( !empty($comment['email']) ) {
|