Changeset 774:d1875bf1202f for inc/core/class.dc.blog.php

Timestamp:

11/29/11 08:47:14 (14 years ago)

Author:

Dsls <dsls@…>

Branch:

default

Message:

Tuned sql_only parameters in core->blog->getPosts and core->blog->getComments, closes #1028

File:

• inc/core/class.dc.blog.php (modified) (7 diffs)

inc/core/class.dc.blog.php

@@ -658 +658 @@
      - order: Order of results (default "ORDER BY post_dt DES")
      - limit: Limit parameter
+     - sql_only : return the sql request instead of results. Only ids are selected
      
      Please note that on every cat_id or cat_url, you can add ?not to exclude
@@ -664 +665 @@
      @param    params         <b>array</b>        Parameters
      @param    count_only     <b>boolean</b>      Only counts results
-     @param    sql_only  <b>boolean</b>      Only return SQL request
      @return   <b>record</b>  A record with some more capabilities or the SQL request
      */
-     public function getPosts($params=array(),$count_only=false,$sql_only=false)
+     public function getPosts($params=array(),$count_only=false)
      {
           # --BEHAVIOR-- coreBlogBeforeGetPosts
@@ -675 +675 @@
           {
                $strReq = 'SELECT count(P.post_id) ';
+          }
+          elseif (!empty($params['sql_only'])) 
+          {
+               $strReq = 'SELECT P.post_id ';
           }
           else
@@ -844 +848 @@
           }
           
-          if ($sql_only) {
+          if (!empty($params['sql_only'])) {
                return $strReq;
           }
@@ -1725 +1729 @@
      - order: Order of results (default "ORDER BY comment_dt DES")
      - limit: Limit parameter
+     - sql_only : return the sql request instead of results. Only ids are selected
      
      @param    params         <b>array</b>        Parameters
@@ -1735 +1740 @@
           {
                $strReq = 'SELECT count(comment_id) ';
+          }
+          elseif (!empty($params['sql_only'])) 
+          {
+               $strReq = 'SELECT P.post_id ';
           }
           else
@@ -1860 +1869 @@
                $strReq .= $this->con->limit($params['limit']);
           }
+
+          if (!empty($params['sql_only'])) {
+               return $strReq;
+          }
           
           $rs = $this->con->select($strReq);