function wpsc_buy_now_button($product_id, $replaced_shortcode = false) { global $wpdb; $selected_gateways = get_option('custom_gateway_options'); $output = ''; 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); $tax_percentage = 0; $country_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."currency_list` WHERE `isocode` IN('".get_option('base_country')."') LIMIT 1",ARRAY_A); if(($country_data['has_regions'] == 1)) { $region_data = $wpdb->get_row("SELECT `".$wpdb->prefix."region_tax`.* FROM `".$wpdb->prefix."region_tax` WHERE `".$wpdb->prefix."region_tax`.`country_id` IN('".$country_data['id']."') AND `".$wpdb->prefix."region_tax`.`id` IN('".get_option('base_region')."') ",ARRAY_A) ; $tax_percentage = $region_data['tax']; } if($product['special']==1) { $price = $product['price'] - $product['special_price']; } $price += $tax_percentage; $output .= "