prefix."product_list` WHERE `display_frontpage` IN('1') AND `active` IN('1')"; $product_list = $wpdb->get_results($sql,ARRAY_A); $output = "
\n\r"; foreach((array)$product_list as $product) { $output .= "
\n\r"; $output .= ""; if($product['image'] != '') { $output .= "".$product[\n\r"; $output .= "

\n\r"; $output .= stripslashes($product['name']); $output .= "\n\r"; if($product['special']==1) { $output .= "".nzshpcrt_currency_display($product['price'], $product['notax'])."
\n\r"; $output .= nzshpcrt_currency_display(($product['price'] - $product['special_price']), $product['notax'],false,$product['id']); } else { $output .= "".nzshpcrt_currency_display($product['price'], $product['notax']); } $output .= "\n\r"; $output .= "

\n\r"; } $output .= ""; $output .= "
\n\r"; } $output .= "
\n\r"; $output .= "
\n\r"; return preg_replace("/\[homepage_products\]/", $output, $content); } function nszhpcrt_category_tag($content = '') { global $wpdb; if(preg_match_all("/\[wpsc_category_exclude=([\d]+),*(full)?\]/", $content, $matches)) { foreach($matches[1] as $key => $category_id) { $categories[$key]['id'] = $category_id; $categories[$key]['display'] = $matches[2][$key]; $categories[$key]['original_string'] = $matches[0][$key]; } foreach ($categories as $category) { $sql1 = "SELECT DISTINCT `".$wpdb->prefix."product_list`.*, `".$wpdb->prefix."item_category_associations`.`category_id`,`".$wpdb->prefix."product_order`.`order`, IF(ISNULL(`".$wpdb->prefix."product_order`.`order`), 0, 1) AS `order_state` FROM `".$wpdb->prefix."product_list` LEFT JOIN `".$wpdb->prefix."item_category_associations` ON `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."item_category_associations`.`product_id` LEFT JOIN `".$wpdb->prefix."product_order` ON ( ( `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."product_order`.`product_id` ) AND ( `".$wpdb->prefix."item_category_associations`.`category_id` = `".$wpdb->prefix."product_order`.`category_id` ) ) WHERE `".$wpdb->prefix."product_list`.`active` = '1' AND `".$wpdb->prefix."item_category_associations`.`category_id` NOT IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".$wpdb->prefix."product_order`.`order` ASC"; $product_list1 = $wpdb->get_results($sql1,ARRAY_A); if(function_exists('product_display_list') && (get_option('product_view') == 'list')) { $output1= product_display_list($product_list1, $group_type, $group_sql, $search_sql); } else if(function_exists('product_display_grid') && (get_option('product_view') == 'grid')) { $output1= product_display_grid($product_list1, $group_type, $group_sql, $search_sql); } else { $output1= product_display_default($product_list1,''); } } $content = str_replace($category['original_string'], $output1, $content); } if(preg_match_all("/\[wpsc_category=([\d]+),*(full)?\]/", $content, $matches)) { foreach($matches[1] as $key => $category_id) { $categories[$key]['id'] = $category_id; $categories[$key]['display'] = $matches[2][$key]; $categories[$key]['original_string'] = $matches[0][$key]; } //echo("
".print_r($categories,true)."
"); $siteurl = get_option('siteurl'); if(get_option('permalink_structure') != '') { $seperator ="?"; } else { $seperator ="&"; } foreach((array)$activated_widgets as $widget_container) { if(is_array($widget_container) && array_search(TXT_WPSC_DONATIONS, $widget_container)) { $no_donations_sql = "AND `".$wpdb->prefix."product_list`.`donation` != '1'"; break; } } foreach((array)$categories as $category) { $full_view = null; if($category['display'] == 'full') { $sql = "SELECT DISTINCT `".$wpdb->prefix."product_list`.*, `".$wpdb->prefix."item_category_associations`.`category_id`,`".$wpdb->prefix."product_order`.`order`, IF(ISNULL(`".$wpdb->prefix."product_order`.`order`), 0, 1) AS `order_state` FROM `".$wpdb->prefix."product_list` LEFT JOIN `".$wpdb->prefix."item_category_associations` ON `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."item_category_associations`.`product_id` LEFT JOIN `".$wpdb->prefix."product_order` ON ( ( `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."product_order`.`product_id` ) AND ( `".$wpdb->prefix."item_category_associations`.`category_id` = `".$wpdb->prefix."product_order`.`category_id` ) ) WHERE `".$wpdb->prefix."product_list`.`active` = '1' AND `".$wpdb->prefix."item_category_associations`.`category_id` IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".$wpdb->prefix."product_order`.`order` ASC"; $product_list = $wpdb->get_results($sql,ARRAY_A); // sorry about the global variable, but it was the best way I could think of to avoid people having to upgrade the gold cart $GLOBALS['wpsc_category_id'] = $category['id']; if(function_exists('product_display_list') && (get_option('product_view') == 'list')) { $output .= product_display_list($product_list, $group_type, $group_sql, $search_sql); } else if(function_exists('product_display_grid') && (get_option('product_view') == 'grid')) { $output .= product_display_grid($product_list, $group_type, $group_sql, $search_sql); } else { $output .= product_display_default($product_list, $group_type, $group_sql, $search_sql); } } else { $sql = "SELECT DISTINCT `".$wpdb->prefix."product_list`.*, `".$wpdb->prefix."item_category_associations`.`category_id`,`".$wpdb->prefix."product_order`.`order`, IF(ISNULL(`".$wpdb->prefix."product_order`.`order`), 0, 1) AS `order_state` FROM `".$wpdb->prefix."product_list` LEFT JOIN `".$wpdb->prefix."item_category_associations` ON `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."item_category_associations`.`product_id` LEFT JOIN `".$wpdb->prefix."product_order` ON ( ( `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."product_order`.`product_id` ) AND ( `".$wpdb->prefix."item_category_associations`.`category_id` = `".$wpdb->prefix."product_order`.`category_id` ) ) WHERE `".$wpdb->prefix."product_list`.`active` = '1' AND `".$wpdb->prefix."item_category_associations`.`category_id` IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".$wpdb->prefix."product_order`.`order` ASC"; $product_list = $wpdb->get_results($sql,ARRAY_A); $output = "
\n\r"; $output .= "
\n\r"; if ($full_view != null){ $output .= ""; } foreach((array)$product_list as $product) { if(function_exists('wpsc_theme_html')) { $wpsc_theme = wpsc_theme_html($product); } if ($full_view == null) { $output .= "
\n\r"; } else { /* product image is here */ $output .= "
"; $output .= ""; $output .=""; } else { $output .= "\n\r"; $output .= ""; } } if ($full_view != null) { $output .= "
"; } $output .=""; if($product['image'] != '') { $output .= "".$product[\n\r"; } $output .= ""; if ($full_view != null) { $output .= ""; } else { $output .= "
"; } if (get_option('hide_name_link')!=1) { if(($product['special']==1) && ($variations_output[1] === null)) { $output .= "$specialSpecial / Sale Price - " . stripslashes($product['name']) . ""; } else { $output .= "$special" . stripslashes($product['name']) . ""; } } else { if(($product['special']==1) && ($variations_output[1] === null)) { $output .= "$specialSpecial / Sale Price - " . stripslashes($product['name']) . ""; } else { $output .= "$special" . stripslashes($product['name']) . ""; } } if ($full_view !=null) { if($product['description'] != '') { $output .= "

".nl2br(stripslashes($product['description'])) . "

"; } if($product['additional_description'] != '') { $output .= ""; $output .= "".$product["; $output .= TXT_WPSC_MOREDETAILS.""; $output .= "
"; $output .= nl2br(stripslashes($product['additional_description'])) . ""; $output .= "
"; } } /* adding to cart stuff */ $output .= "
"; $output .= ""; $output .= ""; $variations_procesor = new nzshpcrt_variations; $variations_output = $variations_procesor->display_product_variations($product['id'],false, false, true); $output .= $variations_output[0]; if($variations_output[1] !== null) { $product['price'] = $variations_output[1]; } if(($product['special']==1) && ($variations_output[1] === null)) { $output .= "".nzshpcrt_currency_display($product['price'], $product['notax']) . "
"; $output .= nzshpcrt_currency_display(($product['price'] - $product['special_price']), $product['notax'],false,$product['id']) . "
"; } else { $output .= "" . nzshpcrt_currency_display($product['price'], $product['notax']) . "
"; } if(((get_option('hide_addtocart_button') !='1') || (get_option('payment_gateway') !='google'))) { if(isset($wpsc_theme) && is_array($wpsc_theme) && ($wpsc_theme['html'] !='')) { $output .= $wpsc_theme['html']; } else { $output .= ""; } } $output .= "
"; if (get_option('addtocart_or_buynow')=='1') { if (get_option('payment_gateway')=='google') { $output .= google_buynow($product['id']); } } if ($full_view != null) { if(get_option('product_ratings') == 1) { $output .= "
"; $output .= "
"; $output .= "".TXT_WPSC_AVGCUSTREVIEW.":"; $output .= nzshpcrt_product_rating($product['id']); $output .= "
"; $output .= "
"; $vote_output = nzshpcrt_product_vote($product['id'],"onmouseover='hide_save_indicator(\"saved_".$product['id']."_text\");'"); if($vote_output[1] == 'voted') { $output .= "".TXT_WPSC_YOURRATING.":"; $output .= " ".TXT_WPSC_RATING_SAVED.""; $output .= ""; } else if($vote_output[1] == 'voting') { $output .= "".TXT_WPSC_RATETHISITEM.":"; $output .= " ".TXT_WPSC_RATING_SAVED.""; $output .= ""; } $output .= $vote_output[0]; $output .= "
"; $output .= "
"; } $output .="
"; } $output .= "
\n\r"; $output .= "
\n\r"; $output .= "
\n\r"; } $content = str_replace($category['original_string'], $output, $content); } } return $content; } ?>