Changeset 30359

Timestamp:

Nov 3, 2014, 10:07:33 PM (9 years ago)

Author:

rvelices

Message:

bug 3163: pwg.tags.getImages mysql error if order parameter is provided

File:

• trunk/include/ws_functions/pwg.tags.php (modified) (2 diffs)

trunk/include/ws_functions/pwg.tags.php

@@ -111 +111 @@
   }
 
+  $order_by = ws_std_image_sql_order($params, 'i.');
+  if (!empty($order_by))
+  {
+    $order_by = 'ORDER BY '.$order_by;
+  }
   $image_ids = get_image_ids_for_tags(
     $tag_ids,
     $params['tag_mode_and'] ? 'AND' : 'OR',
     $where_clauses,
-    ws_std_image_sql_order($params)
+    $order_by
     );
 
@@ -137 +142 @@
     {
       $row['image_id'] = (int)$row['image_id'];
-      $image_ids[] = $row['image_id'];
       $image_tag_map[ $row['image_id'] ] = explode(',', $row['tag_ids']);
     }