function widget_specials($args) { global $wpdb, $table_prefix; extract($args); $special_count = $wpdb->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($args) { global $wpdb, $table_prefix; extract($args); $options = get_option('wpsc-widget_specials'); $special_count = $wpdb->get_var("SELECT COUNT(*) AS `count` FROM `" . WPSC_TABLE_PRODUCT_LIST . "` WHERE `special_price` != '0.00' AND `active` IN ('1')"); //exit('COUNT'.$special_count); 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; } }