Changeset 3077:cf08ef81780e

Timestamp:

08/17/15 15:47:11 (10 years ago)

Author:

Dsls

Branch:

2.8

Children:

3078:2980b7408547, 3079:7701177797c7

Message:

nb_post has no table prefix when querying users, fixes #2127

File:

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

inc/core/class.dc.core.php

@@ -574 +574 @@
                     if (preg_match('`^([^. ]+) (?:asc|desc)`i',$params['order'],$matches)) {
                          if (in_array($matches[1],array('user_id','user_name','user_firstname','user_displayname'))) {
-                              $table_prefix = 'U';
+                              $table_prefix = 'U.';
                          } else {
-                              $table_prefix = 'P'; // order = nb_post (asc|desc)
+                              $table_prefix = ''; // order = nb_post (asc|desc)
                          }
-                         $strReq .= 'ORDER BY '.$table_prefix.'.'.$this->con->escape($params['order']).' ';
+                         $strReq .= 'ORDER BY '.$table_prefix.$this->con->escape($params['order']).' ';
                     } else {
                          $strReq .= 'ORDER BY '.$this->con->escape($params['order']).' ';
@@ -590 +590 @@
                $strReq .= $this->con->limit($params['limit']);
           }
-
           $rs = $this->con->select($strReq);
           $rs->extend('rsExtUser');