Popular Products Module

gistfile1.aw

<?php
//Popular products function
function popular_products ($atts) {

	//Expose the Db to the function
	global $wpdb;

	//Get the results
	$pp = $wpdb->get_results("SELECT `prodid`, SUM(quantity)
								FROM `{$wpdb->prefix}wpsc_cart_contents`
								GROUP BY `prodid`
								ORDER BY `quantity`
								DESC LIMIT {$atts['limit']}", ARRAY_A);

	//Keep a counter
	$i = 1;

	//Loop through the results
	foreach ($pp as $item) {
		$product = get_post($item['prodid']);
		the_post();
		var_dump(get_post_meta($item['prodid']));
?>
		<div class="product-grid popular-<?php echo $i?>">
			<p class="popular-name">
				<?php
					$string = $product->post_title;
					if (strlen($string) > 17) {
						$string = substr($string, 0, 17);
						print "{$string}..";
					}
					else print $string;
				?>
			</p>
			
			<a href="<?php echo get_permalink($item['prodid'])?>">
				<span class="img">
					<?php echo get_the_post_thumbnail($item['prodid'])?>
				</span>
				<span class="price">
					<span>From only </span><?php echo the_product_price($item['prodid'])?>
				</span>
			</a>
		</div>
	<?php
	$i++;
	}

	//reset everything
	$pp = $i = $item = null;
}

add_shortcode('popular_products', popular_products);

function the_product_price($id, $special_price = false) {
	if ($special_price) {
		return wpsc_currency_display(get_post_meta($id, '_wpsc_special_price', true));
	} else {
		return wpsc_currency_display(get_post_meta($id, '_wpsc_price', true));
	}
}