Changes in [137:ba3dc5540d8a:135:a62283a79a74]

File:

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

inc/core/class.dc.core.php

@@ -1424 +1424 @@
      public function countAllComments()
      {
-     
-          $updCommentReq = 'UPDATE '.$this->prefix.'post P '.
-               'SET nb_comment = ('.
-                    'SELECT COUNT(C.comment_id) from '.$this->prefix.'comment C '.
-                    'WHERE C.post_id = P.post_id AND C.comment_trackback <> 1 '.
-                    'AND C.comment_status = 1 '.
-               ')';
-          $updTrackbackReq = 'UPDATE '.$this->prefix.'post P '.
-               'SET nb_trackback = ('.
-                    'SELECT COUNT(C.comment_id) from '.$this->prefix.'comment C '.
-                    'WHERE C.post_id = P.post_id AND C.comment_trackback = 1 '.
-                    'AND C.comment_status = 1 '.
-               ')';
-          $this->con->execute($updCommentReq);
-          $this->con->execute($updTrackbackReq);
+          $strReq = 'SELECT COUNT(comment_id) AS nb, post_id '.
+                    'FROM '.$this->prefix.'comment '.
+                    'WHERE comment_trackback %s 1 '.
+                    'AND comment_status = 1 '.
+                    'GROUP BY post_id ';
+          
+          $rsC = $this->con->select(sprintf($strReq,'<>'));
+          $rsT = $this->con->select(sprintf($strReq,'='));
+          
+          $cur = $this->con->openCursor($this->prefix.'post');
+          while ($rsC->fetch()) {
+               $cur->nb_comment = (integer) $rsC->nb;
+               $cur->update('WHERE post_id = '.(integer) $rsC->post_id);
+               $cur->clean();
+          }
+          
+          while ($rsT->fetch()) {
+               $cur->nb_trackback = (integer) $rsT->nb;
+               $cur->update('WHERE post_id = '.(integer) $rsT->post_id);
+               $cur->clean();
+          }
      }