/wp-content/plugins/wp-e-commerce/wpsc-includes/wpsc_query.php

<?php
/**
 * WP eCommerce query class and product display functions
 *
 * This is the wpsc equivalent of the wp query class, needed for the wpsc templates to work
 * The Cart class handles adding, removing and adjusting items in the cart, and totaling up the cost of the items in the cart.
 * The Cart Items class handles the same, but for cart items themselves.
 *
 * This code contains modified methods from the wp_query object of WordPress, located in wp-includes/query.php, these parts are to do with the loops we use that mirror the functionality of the wordpress loop
 * As such, they can be used in the same way, if needed.
 * 
 * @package wp-e-commerce
 * @since 3.7
 * @subpackage wpsc-cart-classes
*/



/**
* wpsc display categories function
* Used to determine whether to display products on the page
* @return boolean - true for yes, false for no
*/
function wpsc_display_categories() {
  global $wp_query;
  $output = false;
	if(!is_numeric(get_option('wpsc_default_category'))) {
		if(is_numeric($wp_query->query_vars['category_id'])) {
			$category_id = $wp_query->query_vars['category_id'];
		} else if(is_numeric($_GET['category'])) {
			$category_id = $_GET['category'];
		}
		
		// if we have no categories, and no search, show the group list
		//exit('product id '.$product_id.' catid '.$category_id );
		if(is_numeric(get_option('wpsc_default_category')) || (is_numeric($product_id)) || ($_GET['product_search'] != '')) {
		  $output = true;
		}
		if((get_option('wpsc_default_category') == 'all+list')|| (get_option('wpsc_default_category') == 'list')){
		  $output = true;
		}
	}
	
	if($category_id > 0) {
		$output = false;
	}
  return $output;
}

/**
* wpsc display products function
* Used to determine whether to display products on the page
* @return boolean - true for yes, false for no
*/
function wpsc_display_products() {
	global $wpsc_query;
	//we have to display something, if we are not displaying categories, then we must display products
	$output = true;
	
	if(wpsc_display_categories() && ($wpsc_query->query_vars['custom_query'] == false)) {
		if(get_option('wpsc_default_category') == 'list') {
			$output = false;
		}
		if(isset($_GET['range']) || isset($_GET['category'])){
			$output = true;
		}
	}
  return $output;
}

/**
*	this page url function, returns the URL of this page
* @return string - the URL of the current page
*/
function wpsc_this_page_url() {
	global $wpsc_query;
	//echo "<pr".print_r($wpsc_query->category,true)."</pre>";
	if($wpsc_query->is_single === true) {
		return wpsc_product_url($wpsc_query->product['id']);
	} else {
		$output = wpsc_category_url($wpsc_query->category);
		if($wpsc_query->query_vars['page'] > 1) {
			//
			if(get_option('permalink_structure')) {
				$output .= "page/{$wpsc_query->query_vars['page']}/";
			} else {
				$output = add_query_arg('page_number', $wpsc_query->query_vars['page'], $output);
			}
			
		}
		return $output;
	}
}

/**
*	is single product function, determines if we are viewing a single product
* @return boolean - true, or false...
*/
function wpsc_is_single_product() {
	global $wpsc_query;
	if($wpsc_query->is_single === true) {
		$state = true;
	} else {
		$state = false;
	}
	return $state;
}

/**
* category class function, categories can have a specific class, this gets that
* @return string - the class of the selected category
*/
function wpsc_category_class() {
	global $wpdb, $wp_query; 
	
	$category_nice_name = '';
	if($wp_query->query_vars['product_category'] != null) {
		$catid = $wp_query->query_vars['product_category'];
	} else if(is_numeric($_GET['category'])) {
		$catid = $_GET['category'];
	} else if(is_numeric($GLOBALS['wpsc_category_id'])) {
		$catid = $GLOBALS['wpsc_category_id'];
	} else {
		$catid = get_option('wpsc_default_category');
		if($catid == 'all+list') {
			$catid = 'all';
		}
	}
	
	if((int)$catid > 0) {
		$category_nice_name = $wpdb->get_var("SELECT `nice-name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `id` ='".(int)$catid."' LIMIT 1");
	} else if($catid == 'all') {
		$category_nice_name = 'all-categories';
	}
	//exit("<pre>".print_r(get_option('wpsc_default_category'),true)."</pre>");
	return $category_nice_name;
}


/**
* category transition function, finds the transition between categories
* @return string - the class of the selected category
*/
function wpsc_current_category_name() {
	global $wpsc_query;
	return $wpsc_query->product['category'];
}

/**
* category transition function, finds the transition between categories
* @return string - the class of the selected category
*/
function wpsc_category_transition() {
	global $wpdb, $wp_query, $wpsc_query;
	$current_product_index = (int)$wpsc_query->current_product;
	$previous_product_index = ((int)$wpsc_query->current_product - 1);

	if($previous_product_index >= 0) {
		$previous_category_id = $wpsc_query->products[$previous_product_index]['category_id'];
	} else {
		$previous_category_id = 0;
	}

	$current_category_id =	$wpsc_query->product['category_id'];
	if($current_category_id != $previous_category_id) {
		return true;
	} else {
		return false;
	}
}



/**
* wpsc have products function, the product loop
* @return boolean true while we have products, otherwise, false
*/
function wpsc_have_products() {
	global $wpsc_query;
	return $wpsc_query->have_products();
}

/**
* wpsc the product function, gets the next product, 
* @return nothing
*/
function wpsc_the_product() {
	global $wpsc_query;
	$wpsc_query->the_product();
}

/**
* wpsc in the loop function, 
* @return boolean - true if we are in the loop
*/
function wpsc_in_the_loop() {
	global $wpsc_query;
	return $wpsc_query->in_the_loop;
}

/**
* wpsc rewind products function, rewinds back to the first product
* @return nothing
*/
function wpsc_rewind_products() {
	global $wpsc_query;
	return $wpsc_query->rewind_products();
}

/**
* wpsc the product id function, 
* @return integer - the product ID
*/
function wpsc_the_product_id() {
	global $wpsc_query;
	return $wpsc_query->product['id'];
}

/**
* wpsc edit the product link function
* @return string - a link to edit this product
*/
function wpsc_edit_the_product_link( $link = null, $before = '', $after = '', $id = 0 ) {
	global $wpsc_query, $current_user, $table_prefix;
	if ( $link == null ) {
		$link = __('Edit');
	}
	$product_id = $wpsc_query->product['id'];
	if ( $id > 0 ) {
		$product_id = $id;
	}
	$siteurl = get_option('siteurl');
	get_currentuserinfo();
	$output = '';
	if($current_user->{$table_prefix . 'capabilities'}['administrator'] == 1) {
		$output = $before . "<a class='wpsc_edit_product' href='{$siteurl}/wp-admin/admin.php?page=wpsc-edit-products&amp;product_id={$product_id}'>" . $link . "</a>" . $after;
	}
	return $output;
}

/**
* wpsc the product title function
* @return string - the product title
*/
function wpsc_the_product_title() {
	global $wpsc_query;
	//return stripslashes($wpsc_query->the_product_title());
	return htmlentities(stripslashes($wpsc_query->the_product_title()), ENT_QUOTES, "UTF-8");
}

/**
* wpsc product description function
* @return string - the product description
*/
function wpsc_the_product_description() {
	global $wpsc_query, $allowedtags;
	$description_allowed_tags = $allowedtags + array(
		'img' => array(
			'src' => array(),'width' => array(),'height' => array(),
		),
		'span' => array(
			'style' => array()
		),
		'ul' => array(),
		'li' => array(),
		'table' => array(),
		'tr'=>array(
			'class'=>array(),
		),
		'th' => array(
			'class'=>array(),
		),
		'td' => array(
			'class'=>array(),		
		),

	);
	return wpautop(wptexturize( wp_kses(stripslashes($wpsc_query->product['description']), $description_allowed_tags )));
}

/**
* wpsc additional product description function
* TODO make this work with the tabbed multiple product descriptions, may require another loop
* @return string - the additional description
*/
function wpsc_the_product_additional_description() {
	global $wpsc_query;
	return $wpsc_query->product['additional_description'];
}


/**
* wpsc product permalink function
* @return string - the URL to the single product page for this product
*/
function wpsc_the_product_permalink( $category_id = null ) {
	global $wpsc_query;
	if ( !isset( $category_id ) || !absint( $category_id ) ) {
		$category_id = $wpsc_query->category;
	} else {
		$category_id = absint( $category_id );
	}
	return wpsc_product_url( $wpsc_query->product['id'], $category_id );
}


/**
* wpsc product price function
* @return string - the product price
*/
function wpsc_the_product_price($no_decimals = false) {
	global $wpsc_query;	
	$price = calculate_product_price($wpsc_query->product['id'], $wpsc_query->first_variations);	
	if(($wpsc_query->product['special_price'] > 0) && (($wpsc_query->product['price'] - $wpsc_query->product['special_price'] ) >= 0) && ($variations_output[1] === null)) {
		$output = nzshpcrt_currency_display($price, $wpsc_query->product['notax'],true, $wpsc_query->product['id']);
	} else {
		$output = nzshpcrt_currency_display($price, $wpsc_query->product['notax'], true);
	}
	if($no_decimals == true) {
		$output = array_shift(explode(".", $output));
	}
//	echo 'NO DECIMALS VALUE:'.$no_decimals;
	//echo "<pre>".print_r($wpsc_query->product,true)."</pre>";
	return $output;
}

/**
* wpsc external link function
* @return string - the product price
*/
function wpsc_product_external_link($id){
	global $wpdb, $wpsc_query;
	$id = absint($id);
	$externalLink = $wpdb->get_var("SELECT `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id`='{$id}' AND `meta_key`='external_link' LIMIT 1");
	return $externalLink;
}

/**
* wpsc product sku function
* @return string - the product price
*/
function wpsc_product_sku($id){
	global $wpdb;
	$id = absint($id);
	$sku = $wpdb->get_var("SELECT `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id`='{$id}' AND `meta_key`='sku' LIMIT 1");
	return $sku;
}



/**
* wpsc product creation time function
* @return string - the product price
*/
function wpsc_product_creation_time($format = null) {
	global $wpsc_query;
	if($format == null) {
		$format = "Y-m-d H:i:s";
	}
	return mysql2date($format, $wpsc_query->product['date_added']);
}


/**
* wpsc product has stock function
* TODO this may need modifying to work with variations, test this
* @return boolean - true if the product has stock or does not use stock, false if it does not
*/
function wpsc_product_has_stock() {
 // Is the product in stock?
	global $wpsc_query;
	if((count($wpsc_query->first_variations) == 0) && ($wpsc_query->product['quantity_limited'] == 1) && ($wpsc_query->product['quantity'] < 1)) {
		return false;
	} else {
		return true;
	}
}




/**
* wpsc product remaining stock function
* @return integer - the amount of remaining stock, or null if product is stockless
*/
function wpsc_product_remaining_stock() {
	// how much stock is left?
	global $wpsc_query;
	if((count($wpsc_query->first_variations) == 0) && ($wpsc_query->product['quantity_limited'] == 1) && ($wpsc_query->product['quantity'] > 0)) {
		return $wpsc_query->product['quantity'];
	} else {
		return null;
	}
}

/**
* wpsc is donation function
* @return boolean - true if it is a donation, otherwise false
*/
function wpsc_product_is_donation() {
 // Is the product a donation?
	global $wpsc_query;
	if($wpsc_query->product['donation'] == 1) {
		return true;
	} else {
		return false;
	}
}

/**
* wpsc product on special function
* @return boolean - true if the product is on special, otherwise false
*/
function wpsc_product_on_special() {
	// function to determine if the product is on special
	global $wpsc_query;
	//echo "<pre>".print_r($wpsc_query,true)."</pre>";
	if(($wpsc_query->product['special_price'] > 0) && (($wpsc_query->product['price'] - $wpsc_query->product['special_price']) >= 0) && (count($wpsc_query->first_variations) < 1)) {
		return true;
	} else {
		return false;
	}
}

/**
* wpsc product has file function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_file() {
	global $wpsc_query, $wpdb;
	if(is_numeric($wpsc_query->product['file']) && ($wpsc_query->product['file'] > 0)) {
		return true;
	}
	return false;
}

/**
* wpsc product is modifiable function
* @return boolean - true if the product has a file
*/
function wpsc_product_is_customisable() {
	global $wpsc_query, $wpdb;
	
	$engraved_text = get_product_meta($wpsc_query->product['id'], 'engraved');
	$can_have_uploaded_image = get_product_meta($wpsc_query->product['id'], 'can_have_uploaded_image');
	if(($engraved_text == 'on') || ($can_have_uploaded_image == 'on')) {
		return true;
	}
	return false;
}


/**
* wpsc product has personal text function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_personal_text() {
	global $wpsc_query, $wpdb;
	$engraved_text = get_product_meta($wpsc_query->product['id'], 'engraved');
	if($engraved_text == 'on') {
		return true;
	}
	return false;
}

/**
* wpsc product has personal file function
* @return boolean - true if the product has a file
*/
function wpsc_product_has_supplied_file() {
	global $wpsc_query, $wpdb;
	$can_have_uploaded_image = get_product_meta($wpsc_query->product['id'], 'can_have_uploaded_image');
	if($can_have_uploaded_image == 'on') {
		return true;
	}
	return false;
}

/**
* wpsc product postage and packaging function
* @return string - currently only valid for flat rate
*/
function wpsc_product_postage_and_packaging() {
	global $wpsc_query;
	return nzshpcrt_currency_display($wpsc_query->product['pnp'], 1, true);
}

/**
* wpsc normal product price function
* TODO determine why this function is here
* @return string - returns some form of product price
*/
function wpsc_product_normal_price() {
	global $wpsc_query;
	$price = calculate_product_price($wpsc_query->product['id'], $wpsc_query->first_variations, true);
	if(($wpsc_query->product['special_price'] > 0) && (($wpsc_query->product['price'] - $wpsc_query->product['special_price']) >= 0) && ($variations_output[1] === null)) {
		$output = nzshpcrt_currency_display($price, $wpsc_query->product['notax'],true,$wpsc_query->product['id']);
	} else {
		$output = nzshpcrt_currency_display($price, $wpsc_query->product['notax'], true);
	}
   	 $output = apply_filters('wpsc_price_display_changer', $output);
	return $output;
}

/**
* wpsc product image function
* if no parameters are passed, the image is not resized, otherwise it is resized to the specified dimensions
* @param integer width
* @param integer height
* @return string - the product image URL, or the URL of the resized version
*/
function wpsc_the_product_image($width = null, $height = null) {
	// show the full sized image for the product, if supplied with dimensions, will resize image to those.
	global $wpsc_query, $wpdb;
	$image_file_name = null;
	if($wpsc_query->product['image_file'] != null) {
		$image_file_name = $wpsc_query->product['image_file'];
	} else if ($wpsc_query->product['image'] != null) {
		if(is_numeric($wpsc_query->product['image'])){
			$image_file_name = $wpdb->get_var("SELECT `image` FROM `".WPSC_TABLE_PRODUCT_IMAGES."` WHERE `id`= '".$wpsc_query->product['image']."' LIMIT 1");
		}else{

			$image_file_name = $wpsc_query->product['image'];
		}
		$wpsc_query->product['image_file'] = $wpsc_query->product['image'];
	}
	
	if ($wpsc_query->product['thumbnail_state'] == 3) {
		$image_path = WPSC_THUMBNAIL_DIR . $image_file_name;
	} else {
		$image_path = WPSC_IMAGE_DIR . $image_file_name;
	}

	$image_file_name_parts = explode(".",$image_file_name);
	$extension = array_pop($image_file_name_parts);

	if($image_file_name != null) {
		if(($width > 0) && ($height > 0) && ($width <= 1024) && ($height <= 1024)) {
			$cache_filename = basename("product_img_{$wpsc_query->product['image']}_{$height}x{$width}");
			if(file_exists(WPSC_CACHE_DIR.$cache_filename.'.'.$extension)) {
				$original_modification_time = filemtime($image_path);
				$cache_modification_time = filemtime(WPSC_CACHE_DIR.$cache_filename.'.'.$extension);
				if($original_modification_time < $cache_modification_time) {
					$use_cache = true;
				}
			}
			if($use_cache == true) {
				$cache_url = WPSC_CACHE_URL;
				if(is_ssl()) {
					$cache_url = str_replace("http://", "https://", $cache_url);
				}
				$image_url = $cache_url.$cache_filename.'.'.$extension;
			} else {
				$image_url = "index.php?image_id=".$wpsc_query->product['image']."&amp;width=".$width."&amp;height=".$height;
			}
			return $image_url;
		} else {
			if ($wpsc_query->product['thumbnail_state'] == 3) {
				$image_url = WPSC_THUMBNAIL_URL.$image_file_name;
			} else {
				$image_url = WPSC_IMAGE_URL.$image_file_name;
			}
			if(is_ssl()) {
				$image_url = str_replace("http://", "https://", $image_url);
			}
			return $image_url;
		}
	} else {
		return false;
	}
}

/**
* wpsc product thumbnail function
* @return string - the URL to the thumbnail image
*/
function wpsc_the_product_thumbnail() {
	// show the thumbnail image for the product
	global $wpsc_query;
	return $wpsc_query->the_product_thumbnail();
}

/**
* wpsc product comment link function
* @return string - javascript required to make the intense debate link work
*/
function wpsc_product_comment_link() {
 // add the product comment link
	global $wpsc_query;
	
	if (get_option('wpsc_enable_comments') == 1) {
		$enable_for_product = get_product_meta($wpsc_query->product['id'], 'enable_comments');
	
		if ((get_option('wpsc_comments_which_products') == 1 && $enable_for_product == '') || $enable_for_product == 'yes') {
			$original = array("&","'",":","/","@","?","=");
			$entities = array("%26","%27","%3A","%2F","%40","%3F","%3D");
	
			$output = "<div class=\"clear comments\">
						<script src='http://www.intensedebate.com/js/getCommentLink.php?acct=".get_option("wpsc_intense_debate_account_id")."&postid=product_".$wpsc_query->product['id']."&posttitle=".urlencode($wpsc_query->product['name'])."&posturl=".str_replace($original, $entities, wpsc_product_url($wpsc_query->product['id'], null, false))."&posttime=".urlencode(date('Y-m-d h:i:s', time()))."&postauthor=author_".$wpsc_query->product['id']."' type='text/javascript' defer='defer'></script>
					</div>";
		}
	}
	return $output;
}

/**
* wpsc product comments function
* @return string - javascript for the intensedebate comments
*/
function wpsc_product_comments() {
	global $wpsc_query;
	// add the product comments
	if (get_option('wpsc_enable_comments') == 1) {
		$enable_for_product = get_product_meta($wpsc_query->product['id'], 'enable_comments');

		if ((get_option('wpsc_comments_which_products') == 1 && $enable_for_product == '') || $enable_for_product == 'yes') {
			$output = "<script>
				var idcomments_acct = '".get_option('wpsc_intense_debate_account_id')."';
				var idcomments_post_id = 'product_".$wpsc_query->product['id']."';
				var idcomments_post_url = encodeURIComponent('".wpsc_product_url($wpsc_query->product['id'], null, false)."');
				</script>
				<span id=\"IDCommentsPostTitle\" style=\"display:none\"></span>
				<script type='text/javascript' src='http://www.intensedebate.com/js/genericCommentWrapperV2.js'></script>
				";
				
		}
	}
	return $output;
}

/**
* wpsc have custom meta function
* @return boolean - true while we have custom meta to display
*/
function wpsc_have_custom_meta() {
	global $wpsc_query;
	return $wpsc_query->have_custom_meta();
}

/**
* wpsc the custom meta function
* @return nothing - iterate through the custom meta vallues
*/
function wpsc_the_custom_meta() {
	global $wpsc_query;
	$wpsc_query->the_custom_meta();
}

/**
* wpsc have variation groups function
* @return boolean - true while we have variation groups
*/
function wpsc_have_variation_groups() {
	global $wpsc_query;
	return $wpsc_query->have_variation_groups();
}

/**
* wpsc the variation group function
* @return nothing - iterate through the variation groups
*/
function wpsc_the_variation_group() {
	global $wpsc_query;
	$wpsc_query->the_variation_group();
}

/**
* wpsc have variations function
* @return boolean - true while we have variations
*/
function wpsc_have_variations() {
	global $wpsc_query;
	return $wpsc_query->have_variations();
}

/**
* wpsc the variation function
* @return nothing - iterate through the variations
*/
function wpsc_the_variation() {
	global $wpsc_query;
	$wpsc_query->the_variation();
}


function wpsc_product_has_multicurrency(){
	global $wpdb, $wpsc_query;
	$sql = "SELECT `meta_key`, `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id`=".$wpsc_query->product['id']." AND `meta_key` LIKE 'currency%'";
	$results = $wpdb->get_results($sql, ARRAY_A);
	if(count($results) > 0){
		return true;
	}else{
		return false;
	}
//	exit('<pre>'.print_r($results, true).'</pre>');

}

function wpsc_display_product_multicurrency(){
	global $wpdb, $wpsc_query;
	
	$output = '';
	$sql = "SELECT `meta_key`, `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id`=".$wpsc_query->product['id']." AND `meta_key` LIKE 'currency%'";
	$results = $wpdb->get_results($sql, ARRAY_A);
	if(count($results) > 0){
		foreach((array)$results as $curr){
			$isocode = str_ireplace("currency[", "", $curr['meta_key']);
			$isocode = str_ireplace("]", "", $isocode);			
			$currency_data = $wpdb->get_row("SELECT `symbol`,`symbol_html`,`code` FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `isocode`='".$isocode."' LIMIT 1",ARRAY_A) ;
			if($currency_data['symbol'] != '') {
				$currency_sign = $currency_data['symbol_html'];
			} else {
				$currency_sign = $currency_data['code'];
			}

			$output .='<span class="wpscsmall pricefloatright pricedisplay">'.$currency_sign.' '.nzshpcrt_currency_display($curr["meta_value"],false,false,false,true).'</span><br />';
			//exit('<pre>'.print_r($currency_sign, true).'</pre>');
		}
	
	}
	return $output;
}

/**
* wpsc variation group name function
* @return string - the variaton group name
*/
function wpsc_the_vargrp_name() {
 // get the variation group name;
	global $wpsc_query;
	return $wpsc_query->variation_group['name'];
}

/**
* wpsc variation group form ID function
* @return string - the variation group form id, for labels and the like
*/
function wpsc_vargrp_form_id() {
 // generate the variation group form ID;
	global $wpsc_query;
	$form_id = "variation_select_{$wpsc_query->product['id']}_{$wpsc_query->variation_group['variation_id']}";
	return $form_id;
}

/**
* wpsc variation group ID function
* @return integer - the variation group ID
*/
function wpsc_vargrp_id() {
	global $wpsc_query;
	return $wpsc_query->variation_group['variation_id'];
}

/**
* wpsc the variation name function
* @return string - the variation name
*/
function wpsc_the_variation_name() {
	global $wpsc_query;
	return stripslashes($wpsc_query->variation['name']);
}

/**
* wpsc the variation stock function
* @return string - HTML attribute to disable select options and radio buttons
*/
function wpsc_the_variation_stock() {
	global $wpsc_query, $wpdb;
	$out_of_stock = false;
	if(($wpsc_query->variation_group_count == 1) && ($wpsc_query->product['quantity_limited'] == 1)) {
		$product_id = $wpsc_query->product['id'];
		$variation_group_id = $wpsc_query->variation_group['variation_id'];
		$variation_id = $wpsc_query->variation['id'];
		

		$priceandstock_id = $wpdb->get_var("SELECT `priceandstock_id` FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `product_id` = '{$product_id}' AND `value_id` IN ( '$variation_id' ) AND `all_variation_ids` IN('$variation_group_id') LIMIT 1");
		
		$variation_stock_data = $wpdb->get_var("SELECT `stock` FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `id` = '{$priceandstock_id}' LIMIT 1");
		
	}
	return $variation_stock_data;
}


/**
* wpsc the variation price function
* @return string - the variation price
*/
function wpsc_the_variation_price() {
	global $wpdb, $wpsc_query;
	
    if(count($wpsc_query->variation_groups) == 1) {
		//echo "<pre>".print_r($wpsc_query->variation, true)."</pre>";
		$product_id = $wpsc_query->product['id'];
		$variation_group_id = $wpsc_query->variation_group['variation_id'];
		$variation_id = $wpsc_query->variation['id'];
		
		$priceandstock_id = $wpdb->get_var("SELECT `priceandstock_id` FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `product_id` = '{$product_id}' AND `value_id` IN ( '$variation_id' ) AND `all_variation_ids` IN('$variation_group_id') LIMIT 1");
		
		$variation_price = $wpdb->get_var("SELECT `price` FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `id` = '{$priceandstock_id}' LIMIT 1");

		$output = nzshpcrt_currency_display($variation_price, $wpsc_query->product['notax'], true);    		
    } else {
    	$output = false;
    }

	return $output;
}
/**
* wpsc the variation ID function
* @return integer - the variation ID
*/
function wpsc_the_variation_id() {
	global $wpsc_query;
	return $wpsc_query->variation['id'];
}


/**
* wpsc the variation out_of_stock function
* @return string - HTML attribute to disable select options and radio buttons
*/
function wpsc_the_variation_out_of_stock() {
	global $wpsc_query, $wpdb;
	$out_of_stock = false;
	//$wpsc_query->the_variation();
	if(($wpsc_query->variation_group_count == 1) && ($wpsc_query->product['quantity_limited'] == 1)) {
		$product_id = $wpsc_query->product['id'];
		$variation_group_id = $wpsc_query->variation_group['variation_id'];
		$variation_id = $wpsc_query->variation['id'];
		

		$priceandstock_id = $wpdb->get_var("SELECT `priceandstock_id` FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `product_id` = '{$product_id}' AND `value_id` IN ( '$variation_id' ) AND `all_variation_ids` IN('$variation_group_id') LIMIT 1");
		
		$variation_stock_data = $wpdb->get_var("SELECT `stock` FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `id` = '{$priceandstock_id}' LIMIT 1");
		if($variation_stock_data < 1) {
			$out_of_stock = true;
		}
	}
  if($out_of_stock == true) {
		return "disabled='disabled'";
  } else {
		return '';
  }
}

/**
* wpsc custom meta name function
* @return string - the custom metal name
*/
function wpsc_custom_meta_name() {
	global $wpsc_query;
	return	$wpsc_query->custom_meta_values['meta_key'];
}

/**
* wpsc custom meta value function
* @return string - the custom meta value
*/
function wpsc_custom_meta_value() {
	global $wpsc_query;
	return	$wpsc_query->custom_meta_values['meta_value'];
}

/**
* wpsc product rater function
* @return string - HTML to display the product rater
*/
function wpsc_product_rater() {
	global $wpsc_query;
	if(get_option('product_ratings') == 1) {
		$output .= "<div class='product_footer'>";

		$output .= "<div class='product_average_vote'>";
		$output .= "<strong>".__('Avg. Customer Rating', 'wpsc').":</strong>";
		$output .= wpsc_product_existing_rating($wpsc_query->product['id']);
		$output .= "</div>";
		
		$output .= "<div class='product_user_vote'>";

		//$vote_output = nzshpcrt_product_vote($wpsc_query->product['id'],"onmouseover='hide_save_indicator(\"saved_".$wpsc_query->product['id']."_text\");'");
		$output .= "<strong><span id='rating_".$wpsc_query->product['id']."_text'>".__('Your Rating', 'wpsc').":</span>";
		$output .= "<span class='rating_saved' id='saved_".$wpsc_query->product['id']."_text'> ".__('Saved', 'wpsc')."</span>";
		$output .= "</strong>";
		
		$output .= wpsc_product_new_rating($wpsc_query->product['id']);
		$output .= "</div>";
		$output .= "</div>";
	}
	return	$output;
}


function wpsc_product_existing_rating($product_id) {
	global $wpdb;
	$get_average = $wpdb->get_results("SELECT AVG(`rated`) AS `average`, COUNT(*) AS `count` FROM `".WPSC_TABLE_PRODUCT_RATING."` WHERE `productid`='".$product_id."'",ARRAY_A);
	$average = floor($get_average[0]['average']);
	$count = $get_average[0]['count'];
	$output .= "  <span class='votetext'>";
	for($l=1; $l<=$average; ++$l) {
		$output .= "<img class='goldstar' src='". WPSC_URL."/images/gold-star.gif' alt='$l' title='$l' />";
	}
	$remainder = 5 - $average;
	for($l=1; $l<=$remainder; ++$l) {
		$output .= "<img class='goldstar' src='". WPSC_URL."/images/grey-star.gif' alt='$l' title='$l' />";
	}
	$output .=  "<span class='vote_total'>&nbsp;(<span id='vote_total_$prodid'>".$count."</span>)</span> \r\n";
	$output .=  "</span> \r\n";
	return $output;
}


function wpsc_product_new_rating($product_id) {
	global $wpdb;
	$cookie_data = explode(",",$_COOKIE['voting_cookie'][$product_id]);
	$vote_id = 0;
	if(is_numeric($cookie_data[0])){
			$vote_id = absint($cookie_data[0]);
	}
	$previous_vote = 1;
	if($vote_id > 0) {
		$previous_vote = $wpdb->get_var("SELECT `rated` FROM `".WPSC_TABLE_PRODUCT_RATING."` WHERE `id`='".$vote_id."' LIMIT 1");
	}
	
	
	//print("<pre>".print_r($previous_vote, true)."</pre>");
	//print("<pre>".print_r(func_get_args(), true)."</pre>");
	$output = "<form class='wpsc_product_rating' method='post'>\n";
	//$output .= "			<input type='hidden' name='product_id' value='{$product_id}' />\n";
	$output .= "			<input type='hidden' name='wpsc_ajax_action' value='rate_product' />\n";
	$output .= "			<input type='hidden' class='wpsc_rating_product_id' name='product_id' value='{$product_id}' />\n";
	$output .= "			<select class='wpsc_select_product_rating' name='product_rating'>\n";
	$output .= "					<option ". (($previous_vote == '1') ? "selected='selected'" : '')." value='1'>1</option>\n";
	$output .= "					<option ". (($previous_vote == '2') ? "selected='selected'" : '')." value='2'>2</option>\n";
	$output .= "					<option ". (($previous_vote == '3') ? "selected='selected'" : '')." value='3'>3</option>\n";
	$output .= "					<option ". (($previous_vote == '4') ? "selected='selected'" : '')." value='4'>4</option>\n";
	$output .= "					<option ". (($previous_vote == '5') ? "selected='selected'" : '')." value='5'>5</option>\n";
	$output .= "			</select>\n";
	$output .= "			<input type='submit' value='".__('Save','wpsc')."'>";
	$output .= "	</form>";
	return $output;
}

/**
* wpsc has breadcrumbs function
* @return boolean - true if we have and use them, false otherwise
*/
function wpsc_has_breadcrumbs() {
	global $wpsc_query;	
	if(($wpsc_query->breadcrumb_count > 0) && (get_option("show_breadcrumbs") == 1)){
		return true;
	} else {
		return false;
	}
}

/**
* wpsc have breadcrumbs function
* @return boolean - true if we have breadcrimbs to loop through
*/
function wpsc_have_breadcrumbs() {
	global $wpsc_query;
	return $wpsc_query->have_breadcrumbs();
}

/**
* wpsc the breadcrumbs function
* @return nothing - iterate through the breadcrumbs
*/
function wpsc_the_breadcrumb() {
	global $wpsc_query;
	$wpsc_query->the_breadcrumb();
}

/**
* wpsc breadcrumb name function
* @return string - the breadcrumb name 
*/
function wpsc_breadcrumb_name() {
	global $wpsc_query;
	return $wpsc_query->breadcrumb['name'];
}

/**
* wpsc breadcrumb URL function
* @return string - the breadcrumb URL
*/
function wpsc_breadcrumb_url() {
	global $wpsc_query;
	if($wpsc_query->breadcrumb['url'] == '') {
		return false;
	} else {
		return $wpsc_query->breadcrumb['url'];
	}
}

/**
* wpsc currency sign function
* @return string - the selected currency sign for the store
*/
function wpsc_currency_sign() {
	global $wpdb;
	$currency_sign_location = get_option('currency_sign_location');
	$currency_type = get_option('currency_type');
	$currency_symbol = $wpdb->get_var("SELECT `symbol_html` FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `id`='".$currency_type."' LIMIT 1") ;
	return $currency_symbol;
}

/**
* wpsc has pages function
* @return boolean - true if we have pages
*/
function wpsc_has_pages() {
	global $wpsc_query;
	if($wpsc_query->page_count > 0) {
		return true;
	} else {
		return false;
	}
}

/**
* wpsc have pages function
* @return boolean - true while we have pages to loop through
*/
function wpsc_have_pages() {
	global $wpsc_query;
	return $wpsc_query->have_pages();
}

/**
* wpsc the page function
* @return nothing - iterate through the pages
*/
function wpsc_the_page() {
	global $wpsc_query;
	$wpsc_query->the_page();
}
	
/**
* wpsc page number function
* @return integer - the page number
*/
function wpsc_page_number() {
	global $wpsc_query;
	return $wpsc_query->page['number'];
}

/**
 * this is for the multi adding property, it checks to see whether multi adding is enabled;
 * 
 */
function wpsc_has_multi_adding(){
	if(get_option('multi_add') == 1 && (get_option('addtocart_or_buynow') != 1)){
		return true;
	}else{
		return false;
	}
}
/**
* wpsc page is selected function
* @return boolean - true if the page is selected
*/
function wpsc_page_is_selected() {
 // determine if we are on this page
	global $wpsc_query;
	return $wpsc_query->page['selected'];
}

/**
* wpsc page URL function
* @return string - the page URL
*/
function wpsc_page_url() {
 // generate the page URL
	global $wpsc_query;
	return $wpsc_query->page['url'];
}

/**
* wpsc product count function
* @return string - the page URL
*/
function wpsc_product_count() {
	global $wpsc_query;
	return $wpsc_query->product_count;
}

/**
* wpsc total product count function
* @return int - total number of products
*/
function wpsc_total_product_count() {
	global $wpsc_query;
	return $wpsc_query->total_product_count;
}

/**
 * The WPSC Query class.
 *
 * @since 3.7
 */
class WPSC_Query {

	var $query;
	var $query_vars = array();
	var $queried_object;
	var $queried_object_id;
	var $request;

	// This selected category, for the breadcrumbs
	var $category;
	var $category_id_list = array();
	var $category_product = array();
	
	
	// product loop variables.
	var $products;
	var $product_count = 0;
	var $total_product_count = 0;
	var $current_product = -1;
	var $in_the_loop = false;
	var $product;
	
	// variation groups: i.e. colour, size
	var $variation_groups;
	var $variation_group_count = 0;
	var $current_variation_group = -1;
	var $variation_group;
	
	// for getting the product price
	var $first_variations;
	
	//variations inside variation groups: i.e. (red, green, blue) or (S, M, L, XL)
	var $variations;
	var $variations_count = 0;
	var $current_variation = -1;
	var $variation;
	
	
	// Custom meta values
	var $custom_meta;
	var $custom_meta_count = 0;
	var $current_custom_meta = -1;
	var $custom_meta_values;
	
	
	// Breadcrumbs
	var $breadcrumbs;
	var $breadcrumb_count = 0;
	var $current_breadcrumb = -1;
	var $breadcrumb;
	
	// Pages
	var $pages;
	var $page_count = 0;
	var $current_page = -1;
	var $page;
	
	var $found_products = 0;
	var $max_num_pages = 0;
	
	var $is_single = false;
	var $is_search = false;

	/**
	 * The WPSC query constructor, if no query is passed to it, it makes one from the WP_Query data
	 *
	 * @since 3.7
	 *
	 * @param string $query URL query string.
	 * @return WPSC_Query
	 */
	function WPSC_Query ($query = '') {
		if (empty($query)) {
			$query = $this->create_default_query();
		}
		$this->parse_query($query);
		
		$this->get_products();
		//echo("<pre>".print_r($this,true)."</pre>");
	}


	function create_default_query() {
		global $wp_query;
		
		// get the product_url_name or ID
		if(isset($wp_query->query_vars['product_url_name']) && ($wp_query->query_vars['product_url_name'] != '')) {
			$query['product_url_name'] = $wp_query->query_vars['product_url_name'];
		} else if(is_numeric($_GET['category'])) {
			$query['product_id'] = $_GET['product_id'];
		}
		
		
		// get the category ID
		if($wp_query->query_vars['category_id'] > 0) {
			$query['category_id'] = $wp_query->query_vars['category_id'];
		} else if(is_numeric($_GET['category'])) {
			$query['category_id'] = $_GET['category'];
		}
		
		// get the category ID
		if($wp_query->query_vars['category_id'] > 0) {
			$query['category_id'] = $wp_query->query_vars['category_id'];
		}				
		
		// get the page number
		if($wp_query->query_vars['wpsc_page'] > 0) {
			$query['page'] = $wp_query->query_vars['wpsc_page'];
		} else if(is_numeric($_GET['page_number'])) {
			$query['page'] = $_GET['page_number'];
		}
		
		if(isset($_GET['order'])) {
			$query['sort_order'] = $_GET['order'];
			$_SESSION['wpsc_product_order'] = $_GET['order'];
		} else if(isset($_GET['product_order'])) {
			$query['sort_order'] = $_GET['product_order'];
			$_SESSION['wpsc_product_order'] = $_GET['order'];
		} else if(isset($_SESSION['wpsc_product_order'])) {
			$query['sort_order'] = $_SESSION['wpsc_product_order'];
		}
		
		
		if(isset($_GET['items_per_page'])) {
			$query['number_per_page'] = $_GET['items_per_page'];
			$_SESSION['wpsc_number_per_page'] = $_GET['items_per_page'];
		} else if(isset($_SESSION['wpsc_product_order'])) {
			$query['number_per_page'] = $_SESSION['wpsc_number_per_page'];
		}
		
		//$query['sort_order']
		//$query['number_per_page']
		
		return $query;
	}

	/**
	* Resets query flags to false.
	*
	* The query flags are what page info wp-eCommerce was able to figure out, same as the equivalent method on WordPress
	**/
	function init_query_flags() {
		$this->is_search = false;
		$this->is_feed = false;
		$this->is_404 = false;
	}
	
	
	/**
	 * Initiates object properties and sets default values, same as the equivalent method on WordPress
	 *
	 * @since 3.7
	 * @access public
	**/
	function init () {
		$this->category = null;
		unset($this->products);
		unset($this->query);
		$this->query_vars = array();
		unset($this->queried_object);
		unset($this->queried_object_id);
		$this->product_count = 0;
		$this->current_product = -1;
		$this->in_the_loop = false;

			$this->variation_groups = null;
			$this->variation_group = null;
			
			$this->variations = null;
			$this->variation = null;
			
		$this->custom_meta = null;
		$this->custom_meta_values = null;
		
		$this->breadcrumbs = null;
		$this->breadcrumb = null;
		
		$this->pages = null;
		$this->page = null;
		
		$this->init_query_flags();
	}	
	
	/**
	 * Fills in the query variables, which do not exist within the parameter.
	 *
	 * @since 3.7
	 * @access public
	 *
	 * @param array $array Defined query variables.
	 * @return array Complete query variables with undefined ones filled in empty.
	 */
	function fill_query_vars($array) {
	
		/// remove the comments at the ends of lines in this array once all of these work, until then, only the ones with "// works" work
		$keys = array(
			'product_id'	// works
			, 'product_url_name'	// works
			, 'product_name'	
			, 'category_id'	// works
			, 'category_url_name'	// works
			, 'tag'
			, 'price'
			, 'limit_of_items'
			, 'sort_order'
			, 'number_per_page'	// works
			, 'page'
			, 'custom_query'
			//, 'sku'
		);
		
		foreach ($keys as $key) {
			if ( !isset($array[$key]))
				$array[$key] = '';
		}
		
		return $array;
	}
	
	/**
	 * Parse a query string and set query type booleans.
	 *
	 * @since 3.7
	 * @access public
	 *
	 * @param string|array $query
	 */
	function parse_query ($query) {
		if ( !empty($query) || !isset($this->query) ) {
			$this->init();
			if ( is_array($query) )
				$this->query_vars = $query;
			else
				parse_str($query, $this->query_vars);
			$this->query = $query;
		}

		$this->query_vars = $this->fill_query_vars($this->query_vars);
		$qv = &$this->query_vars;
		
		
		// we need a category ID
		if(!($qv['category_id'] > 0) && ($qv['category_url_name'] == '')) {
			$qv['category_id'] = get_option('wpsc_default_category');
		}
		
		// we need a number of items per page
		if(!($qv['number_per_page'] > 0) && ($qv['number_per_page'] != 'all')) {
			$qv['number_per_page'] = get_option('wpsc_products_per_page');
		}
		
		
		
		
		
		
		$qv['product_id'] = absint($qv['product_id']);
		$qv['product_url_name'] = trim($qv['product_url_name']);
		$qv['product_name'] = trim($qv['product_name']);
		$qv['category_id'] = absint($qv['category_id']);
		$qv['category_url_name'] = trim($qv['category_url_name']);
		$qv['tag'] = trim($qv['tag']);
		$qv['price'] = absint($qv['price']);
		$qv['limit_of_items'] = absint($qv['limit_of_items']);
		$qv['sort_order'] = trim($qv['sort_order']);
		$qv['number_per_page'] = absint($qv['number_per_page']);
		$qv['page'] = absint($qv['page']);
		$qv['custom_query'] = (bool)$qv['custom_query'];

		
}
	
	
	function &get_products() {
		global $wpdb, $wp_query;
		do_action_ref_array('pre_get_products', array(&$this));
		
		if(($this->query_vars['category_url_name'] != '')) {
			$category_data = $wpdb->get_row("SELECT `id`, `image_height`, `image_width` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active`='1' AND `nice-name` = '{$this->query_vars['category_url_name']}' LIMIT 1", ARRAY_A);	
			$this->query_vars['category_id'] = $category_data['id'];
			$this->category = $this->query_vars['category_id'];
		} else if($this->query_vars['category_id'] > 0) {
			$category_data = $wpdb->get_row("SELECT `image_height`, `image_width` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active`='1' AND `id` = '{$this->query_vars['category_id']}' LIMIT 1", ARRAY_A);
		}
		
		// Show subcategory products on parent category page?
		$show_subcatsprods_in_cat = get_option( 'show_subcatsprods_in_cat' );
		$this->category_id_list = array( $this->query_vars['category_id'] );
		if ( $show_subcatsprods_in_cat && $this->query_vars['category_id'] > 0 ) {
			$this->category_id_list = array_merge( (array)$this->category_id_list, (array)wpsc_list_subcategories( $this->query_vars['category_id'] ) );
		}
		
		//exit('Here:<pre>'.print_r($category_id_list, true).'</pre>');
		if(is_array($category_data)) {
			$this->category_product['image_height'] = $category_data['image_height'];
			$this->category_product['image_width'] = $category_data['image_width'];
		}
		
		if($this->query_vars['product_url_name'] != null) {
			$product_id = $wpdb->get_var("SELECT `product_id` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `meta_key` IN ( 'url_name' ) AND `meta_value` IN ( '".stripslashes($this->query_vars['product_url_name'])."' ) ORDER BY `product_id` DESC LIMIT 1");
		} else {
			$product_id = absint($this->query_vars['product_id']);
		}
		

		if(($product_id > 0)) {
			$product_list = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='".(int)$product_id."' AND `active` IN('1') AND `publish` IN('1') LIMIT 1",ARRAY_A);
		}
		
		if(isset($_SESSION['price_range']) && isset($_GET['range'])){
			if (is_numeric($_GET['range']) || isset($_SESSION['price_range'])) {
					$price_ranges = $_SESSION['price_range'];

					$selected_price_point = absint($_GET['range']);
					$next_price_point = $selected_price_point + 1;
					//echo "<pre>".print_r($ranges,true)."</pre>";
					$product_range_sql_parts = array();
					$variation_sql_parts = array();
					$product_sql_parts = array();
					
					if(isset($price_ranges[$selected_price_point])) {
						$product_range_sql_parts[] = "(`price` - `special_price`) >= '".absint($price_ranges[$selected_price_point])."'";
						$variation_sql_parts[] = "`price` >= '".absint($price_ranges[$selected_price_point])."'";
						
						if(isset($price_ranges[$next_price_point])) {
							$product_range_sql_parts[] = "(`price` - `special_price`) < '".absint($price_ranges[$next_price_point])."'";
							$variation_sql_parts[] = "`price` < '".absint($price_ranges[$next_price_point])."'";
						}
						$variation_product_ids = (array)$wpdb->get_col("SELECT DISTINCT `product_id` FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE ".implode(" AND ", $variation_sql_parts)."");
						if(count($variation_product_ids) > 0 ) {
							$product_sql_parts[] = "( (".implode(" AND ", $product_range_sql_parts).") OR `id` IN('".implode("', '", $variation_product_ids)."') )";
						} else {
							$product_sql_parts += $product_range_sql_parts;
						}
					}

				$product_sql_parts[] = "`active` IN ('1')";
				$product_sql_parts[] = "`publish` IN('1')";
										
					
				$range_sql="SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE ".implode(" AND ", $product_sql_parts)."";

				$product_list = $wpdb->get_results($range_sql,ARRAY_A);
			}
		}
		//exit('Here:<pre>'.print_r($this->query_vars, true).'</pre>');
		if(count($product_list) > 0 && !isset($_GET['range'])) {
			// if is a single product
			$this->is_single = true;
			$this->products = $product_list;
			
			$this->category = $this->query_vars['category_id'];
			
		} elseif(count($product_list) > 0 && isset($_GET['range'])) {
		
			$this->is_single = false;
			$this->products = $product_list;
			
			$this->category = $this->query_vars['category_id'];
			
		}else{
			// Otherwise
			
			
		//if we are using pages, how many items per page and what page?
		if((get_option('use_pagination') == 1)) {
			$products_per_page = $this->query_vars['number_per_page'];
			if($this->query_vars['page'] > 0) {
				$startnum = ($this->query_vars['page']-1)*$products_per_page;
			} else {
				$startnum = 0;
			}
		} else {
			$startnum = 0;
		}
			
			
			
			
		// search section is done here
		if(function_exists('gold_shpcrt_search_sql') && ($_GET['product_search'] != '')) {
			$search_sql = gold_shpcrt_search_sql();
			if($search_sql != '') {
				// this cannot currently list products that are associated with no categories
				$rowcount = $wpdb->get_var("SELECT COUNT( DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.`id`) AS `count` FROM `".WPSC_TABLE_PRODUCT_LIST."`,`".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`publish`='1' AND `".WPSC_TABLE_PRODUCT_LIST."`.`active`='1' AND `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` AND `".WPSC_TABLE_PRODUCT_LIST."`.donation = '0' $search_sql");
				if (isset($_SESSION['item_per_page']))
				$products_per_page = $_SESSION['item_per_page'];
				//exit($products_per_page);
			if(!is_numeric($products_per_page) || ($products_per_page < 1)) { $products_per_page = $rowcount; }
			
			if($startnum >= $rowcount) {
				$startnum = 0;			
			}
				
				$sql = "SELECT DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.* FROM `".WPSC_TABLE_PRODUCT_LIST."`,`".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`publish`='1' AND `".WPSC_TABLE_PRODUCT_LIST."`.`active`='1' AND `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` $no_donations_sql $search_sql ORDER BY `".WPSC_TABLE_PRODUCT_LIST."`.`special` DESC LIMIT $startnum, $products_per_page";
			}
		} else if (($wp_query->query_vars['ptag'] != null) || ( $_GET['ptag']!=null)) {
			// search by tags is done here
			if($wp_query->query_vars['ptag'] != null) {
				$tag = $wp_query->query_vars['ptag'];
			} else {
				$tag = $_GET['ptag'];
			}
		
		
			$results = $wpdb->get_results("SELECT * FROM `{$wpdb->terms}` WHERE slug='$tag'");
			
			$term_id = $results[0]->term_id;
			
			$results = $wpdb->get_results("SELECT * FROM `{$wpdb->term_taxonomy}` WHERE term_id = '".$term_id."' AND taxonomy='product_tag'");
			
			$taxonomy_id = $results[0]->term_taxonomy_id;
			
			$results = $wpdb->get_results("SELECT * FROM `{$wpdb->term_relationships}` WHERE term_taxonomy_id = '".$taxonomy_id."'");
			
			foreach ($results as $result) {
				$product_ids[] = $result->object_id; 
			}
			$product_id = implode(",",$product_ids);
		
			$sql = "SELECT * FROM ".WPSC_TABLE_PRODUCT_LIST." WHERE id IN (".$product_id.") AND `publish` IN('1') AND `active` IN('1')"; //Transom - added publish & active
		} else {
			// select by category is done here
		 
			
			
		 
			if(is_numeric($this->query_vars['category_id']) && ($this->query_vars['category_id'] > 0)) {
					
				/*
					* The reason this is so complicated is because of the product ordering, it is done by category/product association
					* If you can see a way of simplifying it and speeding it up, then go for it.
					*/
					
					
				$rowcount = $wpdb->get_var("SELECT COUNT( DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.`id`) AS `count` FROM `".WPSC_TABLE_PRODUCT_LIST."` LEFT JOIN `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` ON `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`publish`='1' AND `".WPSC_TABLE_PRODUCT_LIST."`.`active` = '1' AND `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` IN ('".implode("','", $this->category_id_list)."') $no_donations_sql");
				
				if(!is_numeric($products_per_page) || ($products_per_page < 1)) { $products_per_page = $rowcount; }
				if($startnum >= $rowcount) {
					$startnum = 0;			
				}
				
				if($this->query_vars['sort_order']=='DESC') {
					$order = 'DESC';
				} else {
					$order = 'ASC';
				}
				
				
				// Invert this for alphabetical ordering.
				if (get_option('wpsc_sort_by')=='name') {
					$order_by = "`products`.`name` $order";
				} else if (get_option('wpsc_sort_by') == 'price') {
					$order_by = "`products`.`price` $order";
				} else {
				
					//$order = 'ASC';
					if(	$order == 'ASC'){
						$product_id_order = 'DESC';
					}else{
						$product_id_order = 'ASC';
					}				
					$order_by = " `category`.`name`, `order_state` DESC,`order`.`order` $order, `products`.`id` $product_id_order";
					//$order_by = " `order_state` DESC, `products`.`id` $product_id_order,`order`.`order` $order";
				}
					
				$sql = "SELECT DISTINCT `products`. * , `category`.`name` AS `category` , `cat_assoc`.`category_id` , `order`.`order` , IF( ISNULL( `order`.`order` ) , 0, 1 ) AS `order_state`
				FROM `".WPSC_TABLE_PRODUCT_LIST."` AS `products`
				LEFT JOIN `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` AS `cat_assoc`
					ON `products`.`id` = `cat_assoc`.`product_id`
				LEFT JOIN `".WPSC_TABLE_PRODUCT_CATEGORIES."` AS `category`
					ON `cat_assoc`.`category_id` = `category`.`id`
				LEFT JOIN `".WPSC_TABLE_PRODUCT_ORDER."` AS `order`
					ON (
						(`products`.`id` = `order`.`product_id`)
						AND
						(`cat_assoc`.`category_id` = `order`.`category_id`)
					)
				WHERE `products`.`publish` = '1'
				AND `products`.`active` = '1'
				AND `cat_assoc`.`category_id` IN ( '".implode("','", $this->category_id_list)."' ) $no_donations_sql
				GROUP BY `products`.`id`
				ORDER BY $order_by LIMIT $startnum, $products_per_page";
				
			} else {
				if ($this->query_vars['sort_order']=='DESC') {
					$order = 'DESC';
				} else {
					$order = 'ASC';
				}
				
				
				
				
				

				if (get_option('wpsc_sort_by')=='name') {
					$order_by = "`".WPSC_TABLE_PRODUCT_LIST."`.`name` $order";
				} else if (get_option('wpsc_sort_by') == 'pric