get_var("SELECT COUNT(*) AS `count` FROM `".$wpdb->prefix."product_list` WHERE `special` = '1'"); if($special_count > 0) { $title = empty($options['title']) ? __(TXT_WPSC_PRODUCT_SPECIALS) : $options['title']; echo $before_widget; $full_title = $before_title . $title . $after_title; echo $full_title; nzshpcrt_specials(); echo $after_widget; } } function widget_specials_control() { return null; } function widget_specials_init() { if(function_exists('register_sidebar_widget')) { register_sidebar_widget(TXT_WPSC_PRODUCT_SPECIALS, 'widget_specials'); } return; } function nzshpcrt_specials($input = null) { global $wpdb; $siteurl = get_option('siteurl'); $sql = "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `special` = '1' ORDER BY RAND() LIMIT 1"; $product = $wpdb->get_results($sql,ARRAY_A) ; if($product != null) { $output = "

"; foreach($product as $special) { $output .= "".$special['name']."
"; if($special['image'] != null) { $output .= "

".$special[

"; } $output .= $special['description']."
"; // $output .= $special['price']; $variations_processor = new nzshpcrt_variations; $variations_output = $variations_processor->display_product_variations($special['id'],true, false, true); $output .= $variations_output[0]; if($variations_output[1] !== null) { $special['price'] = $variations_output[1]; } if($variations_output[1] == null) { $output .= "".nzshpcrt_currency_display($special['price'], $special['notax'],false)."
"; } $output .= ""; $output .= nzshpcrt_currency_display(($special['price'] - $special['special_price']), $special['notax'],false,$product['id']); $output .= "
"; $output .= ""; } $output .= "

"; } else { $output = ''; } echo $input.$output; } add_action('plugins_loaded', 'widget_specials_init'); ?>