Beispiel #1
0
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;
    }
}
Beispiel #2
0
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;
    }
}