Changeset 2999:7a766509c5aa for inc/core/class.dc.core.php

Timestamp:

04/22/15 11:57:45 (10 years ago)

Author:

Nicolas <nikrou77@…>

Branch:

default

committer:

Nicolas <nikrou77@gmail.com> 1429696695 -7200

Message:

Fix #2087 - Ambiguous column name for SQLite

File:

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

inc/core/class.dc.core.php

@@ -573 +573 @@
 
                if (!empty($params['order']) && !$count_only) {
-                    $strReq .= 'ORDER BY '.$this->con->escape($params['order']).' ';
+                    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';
+                         } else {
+                              $table_prefix = 'P'; // order = nb_post (asc|desc)
+                         }
+                         $strReq .= 'ORDER BY '.$table_prefix.'.'.$this->con->escape($params['order']).' ';
+                    } else {
+                         $strReq .= 'ORDER BY '.$this->con->escape($params['order']).' ';
+                    }
                } else {
                     $strReq .= 'ORDER BY U.user_id ASC ';