Changeset 1110:44e8d66c9012 for inc

Timestamp:

03/08/13 11:32:08 (13 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

2.5

Message:

Avoid unnecessary statement in SQL query (see  http://forum.dotclear.org/viewtopic.php?pid=320290)

File:

• inc/core/class.dc.blog.php (modified) (1 diff)

inc/core/class.dc.blog.php

@@ -228 +228 @@
                'SELECT post_id, COUNT(post_id) AS nb_comment,comment_trackback '.
                'FROM '.$this->prefix.'comment '.
-               'WHERE post_id'.$this->con->in($a_ids).
-               'AND comment_status = 1 ';
+               'WHERE comment_status = 1 '.
+               (count($a_ids) > 0 ? 'AND post_id'.$this->con->in($a_ids) : '');
           
           if ($del) {