Changeset 357431

Timestamp:

03/08/2011 10:04:46 PM (13 years ago)

Author:

jghazally

Message:

I hope this does not blow up in my face

File:

• wp-e-commerce/branches/3.8-development/wpsc-admin/includes/updating-functions.php (modified) (5 diffs)

wp-e-commerce/branches/3.8-development/wpsc-admin/includes/updating-functions.php

@@ -372 +372 @@
         // select the variation set associations
         $variation_set_associations = $wpdb->get_col("SELECT `variation_id` FROM ".WPSC_TABLE_VARIATION_ASSOC." WHERE `associated_id` = '{$original_id}'");
-
+        //echo '$variation_set_associations<pre>'.print_r($variation_set_associations,1).'</pre>';
         // select the variation associations if the count of variation sets is greater than zero
         if(($original_id > 0) && (count($variation_set_associations) > 0)) {
@@ -380 +380 @@
             continue;
         }
-        
+    
         foreach($variation_set_associations as $variation_set_id) {
             $base_product_terms[] = wpsc_get_meta($variation_set_id, 'variation_set_id', 'wpsc_variation_set');
@@ -415 +415 @@
             
             // select all values this "product" is associated with, then loop through them, getting the term id of the variation using the value ID
-            $variation_associations = $wpdb->get_results("SELECT * FROM ".WPSC_TABLE_VARIATION_COMBINATIONS." WHERE `priceandstock_id` = '{$variation_item->id}'");
-            foreach((array)$variation_associations as $association) {
+            $variation_associations = $wpdb->get_results("SELECT * FROM ".WPSC_TABLE_VARIATION_COMBINATIONS." WHERE `priceandstock_id` = '{$variation_item->id}'");
+            foreach((array)$variation_associations as $association) {
                 $variation_id = (int)wpsc_get_meta($association->value_id, 'variation_id', 'wpsc_variation');
                 // discard any values that are null, as they break the selecting of the terms
-                if($variation_id > 0) {
+                if($variation_id > 0) {
                     $variation_ids[] = $variation_id;
                 }
@@ -425 +425 @@
             
             // if we have more than zero remaining terms, get the term data, then loop through it to convert it to a more useful set of arrays.
-            if(count($variation_ids) > 0) {
+            if(count($variation_ids) > 0) {
                 $combination_terms = get_terms('wpsc-variation', array(
                     'hide_empty' => 0,
@@ -431 +431 @@
                     'orderby' => 'parent',
                 ));
+
                 foreach($combination_terms as $term) {
                     $term_data['ids'][] = $term->term_id;