Changeset 3761:849987324197 for inc/core/class.dc.rs.extensions.php

Timestamp:

06/15/18 18:31:29 (7 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

sql-statement

Message:

Apply SQL Statement in DC code, work in progress

File:

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

inc/core/class.dc.rs.extensions.php

@@ -444 +444 @@
             return $rs->_nb_media[$rs->index()];
         } else {
-            $strReq =
-            'SELECT count(media_id) ' .
-            'FROM ' . $rs->core->prefix . 'post_media ' .
-            'WHERE post_id = ' . (integer) $rs->post_id . ' ';
+            $sql = new dcSelectStatement($rs->core, 'coreRsExtCountMedia');
+            $sql
+                ->columns(array('count(media_id)'))
+                ->from($rs->core->prefix . 'post_media')
+                ->where('post_id = ' . $sql->quote((integer) $rs->post_id));
             if ($link_type != null) {
-                $strReq .= "AND link_type = '" . $rs->core->con->escape($link_type) . "'";
+                $sql->where('link_type = ' . $sql->quote($link_type));
             }
-
-            $res                         = (integer) $rs->core->con->select($strReq)->f(0);
+            $res                         = (integer) $rs->core->con->select($sql->statement())->f(0);
             $rs->_nb_media[$rs->index()] = $res;
             return $res;