Changeset 2318:0419bb8bae43 for inc

Timestamp:

10/09/13 07:54:35 (12 years ago)

Author:

Dsls

Branch:

default

Message:

one missing thing...

File:

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

inc/core/class.dc.blog.php

@@ -791 +791 @@
                }
                
-               if ($this->core->con->driver() == 'pgsql' && isset($params['media'])) {
-                    $strReq = 'SELECT DISTINCT ON (P.post_id) ';
-               } else {
-                    $strReq = 'SELECT ';
-               }
-               $strReq .=
-               'P.post_id, P.blog_id, P.user_id, P.cat_id, post_dt, '.
+
+               $strReq =
+               'SELECT P.post_id, P.blog_id, P.user_id, P.cat_id, post_dt, '.
                'post_tz, post_creadt, post_upddt, post_format, post_password, '.
                'post_url, post_lang, post_title, '.$content_req.
@@ -943 +939 @@
           
           if (isset($params['media'])) {
-               $strReq .= 'AND P.post_id ';
                if ($params['media'] == '0') {
-                    $strReq .= 'NOT ';
-               }
-               $strReq .= 'IN (SELECT M.post_id FROM '.$this->prefix.'post_media M ';
+                    $strReq .= 'AND NOT ';
+               } else {
+                    $strReq .= 'AND ';                 
+               }
+               $strReq .= 'EXISTS (SELECT M.post_id FROM '.$this->prefix.'post_media M '.
+                    'WHERE M.post_id = P.post_id ';
                if (isset($params['link_type'])) {
-                    $strReq .= " WHERE M.link_type ".$this->con->in($params['link_type'])." ";
+                    $strReq .= " AND M.link_type ".$this->con->in($params['link_type'])." ";
                }
                $strReq .= ")";