Changeset 355095

Timestamp:

03/04/2011 02:35:29 AM (13 years ago)

Author:

jghazally

Message:

Fix the sorting by price bug in category

File:

• wp-e-commerce/branches/3.8-development/wpsc-core/wpsc-functions.php (modified) (2 diffs)

wp-e-commerce/branches/3.8-development/wpsc-core/wpsc-functions.php

@@ -527 +527 @@
         }
     }
-
     if ( isset( $wp_query->post->ID ) )
         $post_id = $wp_query->post->ID;
@@ -846 +845 @@
             }
             $whichcat .= " AND $wpdb->posts.post_status IN ('publish', 'locked', 'private') ";
+
             $groupby = "{$wpdb->posts}.ID";
 
             $this->sql_components['join']     = $join;
-            $this->sql_components['where']    = $whichcat;
             $this->sql_components['fields']   = "{$wpdb->posts}.*, {$wpdb->term_taxonomy}.term_id";
-            $this->sql_components['order_by'] = "{$wpdb->term_taxonomy}.term_id";
             $this->sql_components['group_by'] = $groupby;
+
+
+
+
+
+
+
+
+
             add_filter( 'posts_join', array( &$this, 'join_sql' ) );
             add_filter( 'posts_where', array( &$this, 'where_sql' ) );