get_row("SELECT * FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `sessionid`= ".$sessionid." LIMIT 1",ARRAY_A) ;
if ($purchase_log['totalprice']==0) {
header("Location: ".get_option('transact_url').$seperator."sessionid=".$sessionid);
exit();
}
$cart_sql = "SELECT * FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `purchaseid`='".$purchase_log['id']."'";
$cart = $wpdb->get_results($cart_sql,ARRAY_A) ;
//written by allen
//exit("
".print_r($cart,true)."
");
$member_subtype = get_product_meta($cart[0]['prodid'],'is_permenant',true);
$status = get_product_meta($cart[0]['prodid'],'is_membership',true);
$is_member = $status;
$is_perm = $member_subtype;
//end of written by allen
$transact_url = get_option('transact_url');
// paypal connection variables
$data['business'] = get_option('paypal_multiple_business');
$data['return'] = urlencode($transact_url.$seperator."sessionid=".$sessionid."&gateway=paypal");
$data['cancel_return'] = urlencode($transact_url);
$data['notify_url'] =urlencode(get_option('siteurl')."/?ipn_request=true");
$data['rm'] = '2';
//data['bn'] = 'Instinct-WP-e-commerce_ShoppingCart_EC';
// look up the currency codes and local price
$currency_code = $wpdb->get_results("SELECT `code` FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `id`='".(int)get_option('currency_type')."' LIMIT 1",ARRAY_A);
$local_currency_code = $currency_code[0]['code'];
$paypal_currency_code = get_option('paypal_curcode');
if($paypal_currency_code == '') {
$paypal_currency_code = 'US';
}
//exit(get_option('currency_type'). " ".$paypal_currency_code);
// Stupid paypal only accepts payments in one of 5 currencies. Convert from the currency of the users shopping cart to the curency which the user has specified in their paypal preferences.
$curr=new CURRENCYCONVERTER();
$data['currency_code'] = $paypal_currency_code;
// $data['lc'] = 'US';
$data['lc'] = $paypal_currency_code;
$data['bn'] = 'wp-e-commerce';
$data['no_shipping'] = (int)(bool)get_option('paypal_ship');
if(get_option('address_override') == 1) {
$data['address_override'] = '1';
}
$data['no_note'] = '1';
switch($paypal_currency_code) {
case "JPY":
$decimal_places = 0;
break;
case "HUF":
$decimal_places = 0;
default:
$decimal_places = 2;
break;
}
$i = 1;
$all_donations = true;
$all_no_shipping = true;
$total = $wpsc_cart->calculate_total_price();
$discount = $wpsc_cart->coupons_amount;
//exit($discount);
if(($discount > 0)) {
if($paypal_currency_code != $local_currency_code) {
$paypal_currency_productprice = $curr->convert( $wpsc_cart->calculate_total_price(),$paypal_currency_code,$local_currency_code);
$paypal_currency_shipping = $curr->convert($local_currency_shipping,$paypal_currency_code,$local_currency_code);
$base_shipping = $curr->convert($wpsc_cart->calculate_total_shipping(),$paypal_currency_code, $local_currency_code);
$tax_price = $curr->convert($item['tax_charged'],$paypal_currency_code, $local_currency_code);
} else {
$paypal_currency_productprice = $wpsc_cart->calculate_total_price();
$paypal_currency_shipping = $local_currency_shipping;
$base_shipping = $wpsc_cart->calculate_total_shipping();
$tax_price = $item['tax_charged'];
}
$data['item_name_'.$i] = "Your Shopping Cart";
$data['amount_'.$i] = number_format(sprintf("%01.2f",$paypal_currency_productprice),$decimal_places,'.','');
$data['quantity_'.$i] = 1;
// $data['item_number_'.$i] = 0;
$data['shipping_'.$i] = 0;
$data['shipping2_'.$i] = 0;
$data['handling_'.$i] = 0;
$i++;
} else {
foreach((array)$cart as $item) {
$product_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='".$item['prodid']."' LIMIT 1",ARRAY_A);
$product_data = $product_data[0];
if ((float)$item['price'] == 0 ) {
continue;
}
$variation_count = count($product_variations);
$local_currency_productprice = $item['price'];
$local_currency_shipping = $item['pnp'];
if($paypal_currency_code != $local_currency_code) {
$paypal_currency_productprice = $curr->convert($local_currency_productprice,$paypal_currency_code,$local_currency_code);
$paypal_currency_shipping = $curr->convert($local_currency_shipping,$paypal_currency_code,$local_currency_code);
// exit($paypal_currency_productprice . " " . $paypal_currency_shipping.' '.$local_currency_productprice . " " . $local_currency_code);
$base_shipping = $curr->convert($purchase_log['base_shipping'],$paypal_currency_code, $local_currency_code);
//exit($paypal_currency_productprice.' Local>'.$local_currency_productprice.' Base shp'.$base_shipping);
$tax_price = $curr->convert($item['tax_charged'],$paypal_currency_code, $local_currency_code);
} else {
$paypal_currency_productprice = $local_currency_productprice;
$paypal_currency_shipping = $local_currency_shipping;
$base_shipping = $purchase_log['base_shipping'];
$tax_price = $item['tax_charged'];
}
//exit("
Note: If your checkout page does not have a shipping details section, or if you don't want to send Paypal shipping information. You should change Send shipping details option to No.
Address Override:
This setting affects your PayPal purchase log. If your customers already have a PayPal account PayPal will try to populate your PayPal Purchase Log with their PayPal address. This setting tries to replace the address in the PayPal purchase log with the Address customers enter on your Checkout page.
".sprintf(__('Your website uses %s. This currency is not supported by PayPal, please select a currency using the drop down menu below. Buyers on your site will still pay in your local currency however we will send the order through to Paypal using the currency you choose below.', 'wpsc'), $store_currency_data['currency'])."