";
if(get_option('wpsc_default_category') == $product_listing_data['category_id']) {
$output .= wpsc_odd_category_setup();
}
}
}
if((get_option('wpsc_page_number_position') == 2) || (get_option('wpsc_page_number_position') == 3)) {
$output .= $product_listing_data['page_listing'];
}
$output = str_replace('$', '$', $output);
if(WPSC_DEBUG === true) {wpsc_debug_start_subtimer('product_display_default','stop');}
return $output;
}
function single_product_display($product_id) {
global $wpdb;
$siteurl = get_option('siteurl');
if(get_option('permalink_structure') != '') {
$seperator ="?";
} else {
$seperator ="&";
}
// what is our product?
if(is_numeric($product_id)) {
$product_list = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`='".(int)$product_id."' LIMIT 1",ARRAY_A);
}
// if we have a product
if($product_list != null) {
// show the breadcrumbs
if (get_option("show_breadcrumbs") == '1') {
$output .= "
\n\r";
$output .= " ".get_option('blogname')." » ";
$category = $wpdb->get_var("SELECT category_id FROM {$wpdb->prefix}item_category_associations WHERE product_id='".$product_id."' ORDER BY id ASC LIMIT 1");
$category_info = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_categories WHERE id='".$category."'",ARRAY_A);
$category_name= $wpdb->get_var("SELECT name FROM {$wpdb->prefix}product_categories WHERE id='".$category."'");
while ($category_info[0]['category_parent']!=0) {
$category_info = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_categories WHERE id='".$category_info[0]['category_parent']."'",ARRAY_A);
$output .= "".$category_info[0]['name']." » ";
}
$output .= "".$category_name." » ";
$output .= $product_list[0]['name']."\n\r";
$output .= "
\n\r";
}
$output .= "
\n\r";
foreach((array)$product_list as $product) {
$num++;
$output .= "
";
} else { // otherwise, we have no product
$output .= "
".TXT_WPSC_NOITEMSINTHIS." ".$group_type.".
";
}
// replace dollar signs with the HTML code so that PHP doesn't try to interpret them as variables.
$output = str_replace('$', '$', $output);
return $output;
}
function wpsc_post_title_seo($title) {
global $wpdb, $page_id, $wp_query;
if($wp_query->query_vars['product_name'] != '') {
$product_id = $wpdb->get_var("SELECT `product_id` FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `meta_key` IN ( 'url_name' ) AND `meta_value` IN ( '".$wpdb->escape($wp_query->query_vars['product_name'])."' ) LIMIT 1");
$title = $wpdb->get_var("SELECT `name` FROM `".$wpdb->prefix."product_list` WHERE `id` IN('".(int)$product_id."') LIMIT 1");
} else if(is_numeric($_GET['product_id'])) {
$title=$wpdb->get_var("SELECT `name` FROM ".$wpdb->prefix."product_list WHERE id IN ('".(int)$_GET['product_id']."') LIMIT 1" );
}
return stripslashes($title);
}
function wpsc_also_bought($product_id) {
/*
* Displays products that were bought aling with the product defined by $product_id
* most of it scarcely needs describing
*/
global $wpdb;
$siteurl = get_option('siteurl');
if(get_option('wpsc_also_bought') == 0) {
//returns nothing if this is off
return '';
}
// to be made customiseable in a future release
$also_bought_limit = 3;
$element_widths = 96;
$image_display_height = 96;
$image_display_width = 96;
$also_bought = $wpdb->get_results("SELECT `".$wpdb->prefix."product_list`.* FROM `".$wpdb->prefix."also_bought_product`, `".$wpdb->prefix."product_list` WHERE `selected_product`='".$product_id."' AND `".$wpdb->prefix."also_bought_product`.`associated_product` = `".$wpdb->prefix."product_list`.`id` AND `".$wpdb->prefix."product_list`.`active` IN('1') ORDER BY `".$wpdb->prefix."also_bought_product`.`quantity` DESC LIMIT $also_bought_limit",ARRAY_A);
if(count($also_bought) > 0) {
$output = "
".TXT_WPSC_ALSO_BOUGHT."
";
$output .= "
";
foreach((array)$also_bought as $also_bought_data) {
$output .= "
![".htmlentities($product[](".wpsc_product_image_html($image_file_name, $product[ "\".htmlentities($product[")
";
$output .= "";
if(function_exists("gold_shpcrt_display_extra_images")) {
$output .= gold_shpcrt_display_extra_images($product['id'],$product['name']);
}
} else {
if(get_option('product_image_width') != '') {
$output .= "![".$product[](".WPSC_URL."/no-image-uploaded.gif "\".$product[")
";
} else {
$output .= "
'.TXT_WPSC_UPDATING."...\n\r";
$output .= "