/** * wpsc buy now button code products function * Sorry about the ugly code, this is just to get the functionality back, buy now will soon be overhauled, and this function will then be completely different * @return string - html displaying one or more products */ function wpsc_buy_now_button($product_id, $replaced_shortcode = false) { global $wpdb, $wpsc_query, $wpsc_cart; $temp_wpsc_query = new WPSC_query(array('product_id' => $product_id)); list($wpsc_query, $temp_wpsc_query) = array($temp_wpsc_query, $wpsc_query); // swap the wpsc_query objects // exit('<pre>'.print_r($temp_wpsc_query, true).'</pre>'); $selected_gateways = get_option('custom_gateway_options'); if (in_array('google', (array) $selected_gateways)) { $output .= google_buynow($product['id']); } else { if (in_array('paypal_multiple', (array) $selected_gateways)) { if ($product_id > 0) { //$output .= "<pre>".print_r($wpsc_query,true)."</pre>"; while (wpsc_have_products()) { wpsc_the_product(); $price = calculate_product_price($wpsc_query->product['id'], $wpsc_query->first_variations); $shipping = $wpsc_query->product['pnp']; $output .= "<form onsubmit='log_paypal_buynow(this)' target='paypal' action='" . get_option('paypal_multiple_url') . "' method='post' />\n\t\t\t\t\t<input type='hidden' name='business' value='" . get_option('paypal_multiple_business') . "' />\n\t\t\t\t\t<input type='hidden' name='cmd' value='_xclick' />\n\t\t\t\t\t<input type='hidden' name='item_name' value='" . wpsc_the_product_title() . "' />\n\t\t\t\t\t<input type='hidden' id='item_number' name='item_number' value='" . wpsc_the_product_id() . "' />\n\t\t\t\t\t<input type='hidden' id='amount' name='amount' value='" . ($price + $pnp) . "' />\n\t\t\t\t\t<input type='hidden' id='unit' name='unit' value='" . $price . "' />\n\t\t\t\t\t<input type='hidden' id='shipping' name='ship11' value='" . $shipping . "' />\n\t\t\t\t\t<input type='hidden' name='handling' value='" . get_option('base_local_shipping') . "' />\n\t\t\t\t\t<input type='hidden' name='currency_code' value='" . get_option('paypal_curcode') . "' />\n\t\t\t\t\t<input type='hidden' name='undefined_quantity' value='0' />\n\t\t\t\t\t<input type='image' name='submit' border='0' src='https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif' alt='PayPal - The safer, easier way to pay online' />\n\t\t\t\t\t<img alt='' border='0' width='1' height='1' src='https://www.paypal.com/en_US/i/scr/pixel.gif' />\n\t\t\t\t</form>\n\r"; } } } } list($temp_wpsc_query, $wpsc_query) = array($wpsc_query, $temp_wpsc_query); // swap the wpsc_query objects back if ($replaced_shortcode == true) { return $output; } else { echo $output; } }
function product_display_list($product_list, $group_type, $group_sql = '', $search_sql = '') { global $wpdb; $siteurl = get_option('siteurl'); if ((double) WPSC_VERSION < 3.8) { $images_dir = 'images'; } else { $images_dir = 'wpsc-core/images'; } if (get_option('permalink_structure') != '') { $seperator = "?"; } else { $seperator = "&"; } $product_listing_data = wpsc_get_product_listing($product_list, $group_type, $group_sql, $search_sql); $product_list = $product_listing_data['product_list']; $output .= $product_listing_data['page_listing']; if ($product_listing_data['category_id']) { $category_nice_name = $wpdb->get_var("SELECT `nice-name` FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `id` ='" . (int) $product_listing_data['category_id'] . "' LIMIT 1"); } else { $category_nice_name = ''; } if ($product_list != null) { $output .= "<table class='list_productdisplay {$category_nice_name}'>"; $i = 0; foreach ($product_list as $product) { $num++; if ($i % 2 == 1) { $output .= " <tr class='product_view_{$product['id']}'>"; } else { $output .= " <tr class='product_view_{$product['id']}' style='background-color:#EEEEEE'>"; } $i++; $output .= " <td style='width: 9px;'>"; if ($product['description'] != null) { $output .= "<a href='#' class='additional_description_link' onclick='return show_additional_description(\"list_description_" . $product['id'] . "\",\"link_icon" . $product['id'] . "\");'>"; $output .= "<img style='margin-top:3px;' id='link_icon" . $product['id'] . "' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/icon_window_expand.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' />"; $output .= "</a>"; } $output .= " </td>\n\r"; $output .= " <td width='55%'>"; if ($product['special'] == 1) { $special = "<strong class='special'>" . TXT_WPSC_SPECIAL . " - </strong>"; } else { $special = ""; } $output .= "<a href='" . wpsc_product_url($product['id']) . "' class='wpsc_product_title' ><strong>" . stripslashes($product['name']) . "</strong></a>"; $output .= " </td>"; $variations_procesor = new nzshpcrt_variations(); $variations_output = $variations_procesor->display_product_variations($product['id'], false, false, true); if ($variations_output[1] !== null) { $product['price'] = $variations_output[1]; } $output .= " <td width='10px' style='text-align: center;'>"; if ($product['quantity'] < 1 && $product['quantity_limited'] == 1) { $output .= "<img style='margin-top:5px;' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/no_stock.gif' title='No' alt='No' />"; } else { $output .= "<img style='margin-top:4px;' src='{$siteurl}/wp-content/plugins/" . WPSC_DIR_NAME . "/" . $images_dir . "/yes_stock.gif' title='Yes' alt='Yes' />"; } $output .= " </td>"; $output .= " <td width='10%'>"; if ($product['special'] == 1 && $variations_output[1] === null) { $output .= nzshpcrt_currency_display($product['price'] - $product['special_price'], $product['notax'], false, $product['id']) . "<br />"; } else { $output .= "<span id='product_price_" . $product['id'] . "'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span>"; } $output .= " </td>"; $output .= " <td width='20%'>"; if (get_option('addtocart_or_buynow') == '0') { $output .= "<form name='{$num}' id='product_" . $product['id'] . "' method='POST' action='" . get_option('product_list_url') . $seperator . "category=" . $_GET['category'] . "' onsubmit='submitform(this);return false;' >"; } if (get_option('list_view_quantity') == 1) { $output .= "<input type='text' name='quantity' value='1' size='3' maxlength='3'> "; } $output .= $variations_output[0]; $output .= "<input type='hidden' name='item' value='" . $product['id'] . "' />"; $output .= "<input type='hidden' name='prodid' value='" . $product['id'] . "'>"; if (get_option('wpsc_selected_theme') == 'iShop') { if (get_option('addtocart_or_buynow') == '0') { if ($product['quantity_limited'] == 1 && $product['quantity'] < 1) { $output .= "<input disabled='true' type='submit' value='' name='Buy' class='wpsc_buy_button'/>"; } else { $output .= "<input type='submit' name='Buy' value='' class='wpsc_buy_button'/>"; } } else { if (!($product['quantity_limited'] == 1 && $product['quantity'] < 1)) { $output .= google_buynow($product['id']); } } } else { if (get_option('addtocart_or_buynow') == '0') { if ($product['quantity_limited'] == 1 && $product['quantity'] < 1) { $output .= "<input disabled='true' type='submit' name='Buy' class='wpsc_buy_button' value='" . TXT_WPSC_ADDTOCART . "' />"; } else { $output .= "<input type='submit' name='Buy' class='wpsc_buy_button' value='" . TXT_WPSC_ADDTOCART . "' />"; } } else { if (!($product['quantity_limited'] == 1 && $product['quantity'] < 1)) { $output .= google_buynow($product['id']); } } } $output .= "</form>"; $output .= " </td>\n\r"; $output .= " </tr>\n\r"; $output .= " <tr class='list_view_description'>\n\r"; $output .= " <td colspan='5'>\n\r"; $output .= " <div id='list_description_" . $product['id'] . "'>\n\r"; $output .= $product['description']; $output .= " </div>\n\r"; $output .= " </td>\n\r"; $output .= " </tr>\n\r"; } $output .= "</table>"; } else { $output .= "<p>" . TXT_WPSC_NOITEMSINTHIS . " " . $group_type . ".</p>"; } return $output; }
function nszhpcrt_category_tag($content = '') { require_once 'themes/iShop/iShop.php'; 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("<pre>".print_r($categories,true)."</pre>"); $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 = "<div id='products_page_container' class='wrap wpsc_container'>\n\r"; $output .= "<div id='homepage_products'>\n\r"; if ($full_view != null) { $output .= "<table class='productdisplay'>"; } foreach ((array) $product_list as $product) { $wpsc_theme = wpsc_theme_html($product); if ($full_view == null) { $output .= "<div class='category_view_product'>\n\r"; } else { /* product image is here */ $output .= "<tr>"; $output .= "<td class='imagecol'>"; } $output .= "<a href='" . WPSC_IMAGE_URL . $product['image'] . "' class='thickbox preview_link' rel='" . str_replace(" ", "_", $product['name']) . "'>"; if ($product['image'] != '') { $output .= "<img class='product_image' src='" . WPSC_THUMBNAIL_URL . $product['image'] . "' title='" . $product['name'] . "' alt='" . $product['name'] . "' />\n\r"; } $output .= "</a>"; if ($full_view != null) { $output .= "</td><td class='textcol'>"; } else { $output .= "<div class='product_details'>"; } if (get_option('hide_name_link') != 1) { if ($product['special'] == 1 && $variations_output[1] === null) { $output .= "<a href='" . wpsc_product_url($product['id']) . "' class='wpsc_product_title' >{$special}<strong class='special'>Special / Sale Price - </strong><strong>" . stripslashes($product['name']) . "</strong></a>"; } else { $output .= "<a href='" . wpsc_product_url($product['id']) . "' class='wpsc_product_title' >{$special}<strong>" . stripslashes($product['name']) . "</strong></a>"; } } else { if ($product['special'] == 1 && $variations_output[1] === null) { $output .= "<a class='wpsc_product_title' >{$special}<strong class='special'>Special / Sale Price - </strong><strong>" . stripslashes($product['name']) . "</strong></a>"; } else { $output .= "<a class='wpsc_product_title' >{$special}<strong>" . stripslashes($product['name']) . "</strong></a>"; } } if ($full_view != null) { if ($product['description'] != '') { $output .= "<p class='wpsc_description'>" . nl2br(stripslashes($product['description'])) . "</p>"; } if ($product['additional_description'] != '') { $output .= "<a href='#' class='additional_description_link' onclick='return show_additional_description(\"additionaldescription" . $product['id'] . "\",\"link_icon" . $product['id'] . "\");'>"; $output .= "<img id='link_icon" . $product['id'] . "' class='additional_description_button' src='" . WPSC_URL . "/images/icon_window_expand.gif' title='" . $product['name'] . "' alt='" . $product['name'] . "' />"; $output .= TXT_WPSC_MOREDETAILS . "</a>"; $output .= "<span class='additional_description' id='additionaldescription" . $product['id'] . "'><br />"; $output .= nl2br(stripslashes($product['additional_description'])) . ""; $output .= "</span><br />"; } } /* adding to cart stuff */ $output .= "<form id='product_" . $product['id'] . "' name='product_" . $product['id'] . "' method='post' action='" . get_option('product_list_url') . $seperator . "category=" . $_GET['category'] . "' onsubmit='submitform(this);return false;' >"; $output .= "<input type='hidden' name='prodid' value='" . $product['id'] . "' />"; $output .= "<input type='hidden' name='item' value='" . $product['id'] . "' />"; $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 .= "<span class='oldprice'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />"; $output .= nzshpcrt_currency_display($product['price'] - $product['special_price'], $product['notax'], false, $product['id']) . "<br />"; } else { $output .= "<span id='product_price_" . $product['id'] . "'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />"; } 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 .= "<input type='submit' id='product_" . $product['id'] . "_submit_button' class='wpsc_buy_button' name='Buy' value='" . TXT_WPSC_ADDTOCART . "' />"; } } $output .= "</form>"; 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 .= "<div class='product_footer'>"; $output .= "<div class='product_average_vote'>"; $output .= "<strong>" . TXT_WPSC_AVGCUSTREVIEW . ":</strong>"; $output .= nzshpcrt_product_rating($product['id']); $output .= "</div>"; $output .= "<div class='product_user_vote'>"; $vote_output = nzshpcrt_product_vote($product['id'], "onmouseover='hide_save_indicator(\"saved_" . $product['id'] . "_text\");'"); if ($vote_output[1] == 'voted') { $output .= "<strong><span id='rating_" . $product['id'] . "_text'>" . TXT_WPSC_YOURRATING . ":</span>"; $output .= "<span class='rating_saved' id='saved_" . $product['id'] . "_text'> " . TXT_WPSC_RATING_SAVED . "</span>"; $output .= "</strong>"; } else { if ($vote_output[1] == 'voting') { $output .= "<strong><span id='rating_" . $product['id'] . "_text'>" . TXT_WPSC_RATETHISITEM . ":</span>"; $output .= "<span class='rating_saved' id='saved_" . $product['id'] . "_text'> " . TXT_WPSC_RATING_SAVED . "</span>"; $output .= "</strong>"; } } $output .= $vote_output[0]; $output .= "</div>"; $output .= "</div>"; } $output .= "</td>"; $output .= "</tr>"; } else { $output .= "</div>\n\r"; $output .= "</div>"; } } if ($full_view != null) { $output .= "</table>"; } $output .= "</div>\n\r"; $output .= "<br style='clear: left;'>\n\r"; $output .= "</div>\n\r"; } $content = str_replace($category['original_string'], $output, $content); } } return $content; }
function wpsc_buy_now_button($product_id, $replaced_shortcode = false) { global $wpdb; $selected_gateways = get_option('custom_gateway_options'); if (in_array('google', (array) $selected_gateways)) { $output .= google_buynow($product['id']); } else { if (in_array('paypal_multiple', (array) $selected_gateways)) { if ($product_id > 0) { $product_sql = "SELECT * FROM " . $wpdb->prefix . "product_list WHERE id = " . $product_id . " LIMIT 1"; $product = $wpdb->get_row($product_sql, ARRAY_A); $output .= "<form onsubmit='log_paypal_buynow(this)' target='paypal' action='" . get_option('paypal_multiple_url') . "' method='post'>\n\t\t\t\t<input type='hidden' name='business' value='" . get_option('paypal_multiple_business') . "'>\n\t\t\t\t<input type='hidden' name='cmd' value='_xclick'>\n\t\t\t\t<input type='hidden' name='item_name' value='" . $product['name'] . "'>\n\t\t\t\t<input type='hidden' id='item_number' name='item_number' value='" . $product['id'] . "'>\n\t\t\t\t<input type='hidden' id='amount' name='amount' value='" . $product['price'] . "'>\n\t\t\t\t<input type='hidden' id='unit' name='unit' value='" . $product['price'] . "'>\n\t\t\t\t<input type='hidden' id='shipping' name='ship11' value='" . $shipping . "'>\n\t\t\t\t<input type='hidden' name='handling' value='" . get_option('base_local_shipping') . "'>\n\t\t\t\t<input type='hidden' name='currency_code' value='" . get_option('paypal_curcode') . "'>\n\t\t\t\t<input type='hidden' name='undefined_quantity' value='0'>\n\t\t\t\t<input type='image' name='submit' border='0' src='https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif' alt='PayPal - The safer, easier way to pay online'>\n\t\t\t\t<img alt='' border='0' width='1' height='1' src='https://www.paypal.com/en_US/i/scr/pixel.gif' >\n\t\t\t</form>\n\t\t"; } } } if ($replaced_shortcode == true) { return $output; } else { echo $output; } }