".nl2br(get_option('payment_instructions'))."
"; /*if($purchase_log['gateway'] != 'testmode') { if((get_option('purch_log_email') != null) && ($purchase_log['email_sent'] != 1)) { mail(get_option('purch_log_email'), TXT_WPSC_NEW_ORDER_PENDING_SUBJECT, TXT_WPSC_NEW_ORDER_PENDING_BODY.$order_url, "From: ".get_option('return_email').""); } return false; }*/ } } $cart = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`='{$purchase_log['id']}'",ARRAY_A); if($purchase_log['shipping_country'] != '') { $billing_country = $purchase_log['billing_country']; $shipping_country = $purchase_log['shipping_country']; } else { $country = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id`=".$purchase_log['id']." AND `form_id` = '".get_option('country_form_field')."' LIMIT 1",ARRAY_A); $billing_country = $country[0]['value']; $shipping_country = $country[0]['value']; } $email_form_field = $wpdb->get_results("SELECT `id`,`type` FROM `".$wpdb->prefix."collect_data_forms` WHERE `type` IN ('email') AND `active` = '1' ORDER BY `order` ASC LIMIT 1",ARRAY_A); $email_address = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id`=".$purchase_log['id']." AND `form_id` = '".$email_form_field[0]['id']."' LIMIT 1",ARRAY_A); $email = $email_address[0]['value']; $stock_adjusted = false; $previous_download_ids = array(0); $product_list=''; if(($cart != null) && ($errorcode == 0)) { foreach($cart as $row) { $link = ""; $product_data = $wpdb->get_row("SELECT * FROM `{$wpdb->prefix}product_list` WHERE `id`='{$row['prodid']}' LIMIT 1", ARRAY_A) ; if($product_data['file'] > 0) { if($purchase_log['email_sent'] != 1) { $wpdb->query("UPDATE `{$wpdb->prefix}download_status` SET `active`='1' WHERE (`fileid` = '{$product_data['file']}' OR `cartid` = '{$row['id']}' ) AND `purchid` = '{$purchase_log['id']}'"); } if (($purchase_log['processed'] >= 2)) { //echo "SELECT * FROM `".$wpdb->prefix."download_status` WHERE `active`='1' AND `purchid`='".$purchase_log['id']."' AND (`cartid` = '".$row['id']."' OR (`cartid` IS NULL AND `fileid` = '{$product_data['file']}') ) AND `id` NOT IN ('".implode("','",$previous_download_ids)."') LIMIT 1"; $download_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."download_status` WHERE `active`='1' AND `purchid`='".$purchase_log['id']."' AND (`cartid` = '".$row['id']."' OR (`cartid` IS NULL AND `fileid` = '{$product_data['file']}') ) AND `id` NOT IN ('".implode("','",$previous_download_ids)."') LIMIT 1",ARRAY_A); if($download_data != null) { if($download_data['uniqueid'] == null) { // if the uniqueid is not equal to null, its "valid", regardless of what it is $link = $siteurl."?downloadid=".$download_data['id']; } else { $link = $siteurl."?downloadid=".$download_data['uniqueid']; } } $previous_download_ids[] = $download_data['id']; $order_status= 4; } } do_action('wpsc_confirm_checkout', $purchase_log['id']); $shipping = nzshpcrt_determine_item_shipping($row['prodid'], $row['quantity'], $shipping_country); if (isset($_SESSION['quote_shipping'])){ $shipping = $_SESSION['quote_shipping']; } $total_shipping += $shipping; if($product_data['special']==1) { $price_modifier = $product_data['special_price']; } else { $price_modifier = 0; } $total+=($row['price']*$row['quantity']); $message_price = nzshpcrt_currency_display(($row['price']*$row['quantity']), $product_data['notax'], true); $shipping_price = nzshpcrt_currency_display($shipping, 1, true); $variation_values = $wpdb->get_col("SELECT `value_id` FROM `{$wpdb->prefix}cart_item_variations` WHERE `cart_id`='{$row['id']}'"); //echo "".print_r($product_data,true).""; $variation_count = count($variation_data); if(($purchase_log['processed'] >= 2) && ($sessionid != '') && ($purchase_log['stock_adjusted'] != 1)) { if($product_data['quantity_limited'] == 1) { if(count($variation_values) > 0) { $variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `{$wpdb->prefix}variation_values` WHERE `id` IN ('".implode("','",$variation_values)."')"); asort($variation_ids); $all_variation_ids = implode(",", $variation_ids); $priceandstock_id = $wpdb->get_var("SELECT `priceandstock_id` FROM `{$wpdb->prefix}wpsc_variation_combinations` WHERE `product_id` = '".(int)$product_data['id']."' AND `value_id` IN ( '".implode("', '",$variation_values )."' ) AND `all_variation_ids` IN('{$all_variation_ids}') GROUP BY `priceandstock_id` HAVING COUNT( `priceandstock_id` ) = '".count($variation_values)."' LIMIT 1"); $variation_stock_data = $wpdb->get_row("SELECT * FROM `{$wpdb->prefix}variation_priceandstock` WHERE `id` = '{$priceandstock_id}' LIMIT 1", ARRAY_A); $wpdb->query("UPDATE `{$wpdb->prefix}variation_priceandstock` SET `stock` = '".($variation_stock_data['stock']-$row['quantity'])."' WHERE `id` = '{$variation_stock_data['id']}' LIMIT 1",ARRAY_A); } else { $wpdb->query("UPDATE `{$wpdb->prefix}product_list` SET `quantity`='".($product_data['quantity']-$row['quantity'])."' WHERE `id`='{$product_data['id']}' LIMIT 1"); } } $stock_adjusted = true; } if($variation_count > 1) { $variation_list = " ("; if($purchase['gateway'] != 'testmode') { if($gateway['internalname'] == $purch_data[0]['gateway'] ) { $gateway_name = $gateway['name']; } } else { $gateway_name = "Manual Payment"; } $i = 0; foreach($variation_data as $variation) { if($i > 0) { $variation_list.= ", "; } $value_id = $variation['value_id']; $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A); $variation_list.= $value_data[0]['name']; $i++; } $variation_list .= ")"; } else { if($variation_count == 1) { $value_id = $variation_data[0]['value_id']; $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A); $variation_list = " (".$value_data[0]['name'].")"; } else { $variation_list = ''; } } if($link != '') { $product_list.= " - ". $product_data['name'] . $variation_list ." ".$message_price ." ".TXT_WPSC_CLICKTODOWNLOAD.": $link\n"; $product_list_html.= " - ". $product_data['name'] . $variation_list ." ".$message_price ." ".TXT_WPSC_DOWNLOAD."\n"; } else { $plural = ''; if($row['quantity'] > 1) { $plural = "s"; } $product_list.= " - ".$row['quantity']." ". $product_data['name'].$variation_list ." ". $message_price ."\n - ". TXT_WPSC_SHIPPING.":".$shipping_price ."\n\r"; $product_list_html.= " - ".$row['quantity']." ". $product_data['name'].$variation_list ." ". $message_price ."\n ". TXT_WPSC_SHIPPING.":".$shipping_price ."\n\r"; } $report = get_option('wpsc_email_admin'); $report_product_list.= " - ". $product_data['name'] .$variation_list." ".$message_price ."\n"; } if($purchase_log['discount_data'] != '') { $coupon_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."wpsc_coupon_codes` WHERE coupon_code='".$wpdb->escape($purchase_log['discount_data'])."' LIMIT 1",ARRAY_A); if($coupon_data['use-once'] == 1) { $wpdb->query("UPDATE `".$wpdb->prefix."wpsc_coupon_codes` SET `active`='0', `is-used`='1' WHERE `id`='".$coupon_data['id']."' LIMIT 1"); } } //$wpdb->query("UPDATE `".$wpdb->prefix."download_status` SET `active`='1' WHERE `fileid`='".$product_data['file']."' AND `purchid` = '".$purchase_log['id']."' LIMIT 1"); //if (!isset($_SESSION['quote_shipping'])) //$total_shipping = nzshpcrt_determine_base_shipping($total_shipping, $shipping_country); $total_shipping += $purchase_log['base_shipping']; $total = (($total+$total_shipping) - $purchase_log['discount_value']); // $message.= "\n\r"; $product_list.= "Your Purchase No.: ".$purchase_log['id']."\n\r"; if($purchase_log['discount_value'] > 0) { $discount_email.= TXT_WPSC_DISCOUNT.": ".nzshpcrt_currency_display($purchase_log['discount_value'], 1, true)."\n\r"; } $total_shipping_email.= TXT_WPSC_TOTALSHIPPING.": ".nzshpcrt_currency_display($total_shipping,1,true)."\n\r"; $total_price_email.= TXT_WPSC_TOTAL.": ".nzshpcrt_currency_display($total,1,true)."\n\r"; $product_list_html.= "Your Purchase No.: ".$purchase_log['id']."\n\n\r"; if($purchase_log['discount_value'] > 0) { $discount_html.= TXT_WPSC_DISCOUNT.": ".nzshpcrt_currency_display($purchase_log['discount_value'], 1, true)."\n\r"; } $total_shipping_html.= TXT_WPSC_TOTALSHIPPING.": ".nzshpcrt_currency_display($total_shipping,1,true)."\n\r"; $total_price_html.= TXT_WPSC_TOTAL.": ".nzshpcrt_currency_display($total, 1,true)."\n\r"; if(isset($_GET['ti'])) { $message.= "\n\r".TXT_WPSC_YOURTRANSACTIONID.": " . $_GET['ti']; $message_html.= "\n\r".TXT_WPSC_YOURTRANSACTIONID.": " . $_GET['ti']; $report.= "\n\r".TXT_WPSC_TRANSACTIONID.": " . $_GET['ti']; } else { $report_id = "Purchase No.: ".$purchase_log['id']."\n\r"; } $message = str_replace('%product_list%',$product_list,$message); $message = str_replace('%total_shipping%',$total_shipping_email,$message); $message = str_replace('%total_price%',$total_price_email,$message); //$message = str_replace('%order_status%',get_option('blogname'),$message); $message = str_replace('%shop_name%',get_option('blogname'),$message); $report = str_replace('%product_list%',$report_product_list,$report); $report = str_replace('%total_shipping%',$total_shipping_email,$report); $report = str_replace('%total_price%',$total_price_email,$report); $report = str_replace('%shop_name%',get_option('blogname'),$report); $message_html = str_replace('%product_list%',$product_list_html,$message_html); $message_html = str_replace('%total_shipping%',$total_shipping_html,$message_html); $message_html = str_replace('%total_price%',$total_price_email,$message_html); $message_html = str_replace('%shop_name%',get_option('blogname'),$message_html); //$message_html = str_replace('%order_status%',get_option('blogname'),$message_html); if(($email != '') && ($purchase_log['email_sent'] != 1)) { if($purchase_log['processed'] < 2) { $payment_instructions = strip_tags(get_option('payment_instructions')); $message = TXT_WPSC_ORDER_PENDING . "\n\r" . $payment_instructions ."\n\r". $message; mail($email, TXT_WPSC_ORDER_PENDING_PAYMENT_REQUIRED, $message, "From: ".get_option('return_email').""); } else { mail($email, TXT_WPSC_PURCHASERECEIPT, $message, "From: ".get_option('return_email').""); } } $report_user = TXT_WPSC_CUSTOMERDETAILS."\n\r"; $form_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase_log['id']."'"; $form_data = $wpdb->get_results($form_sql,ARRAY_A); if($form_data != null) { foreach($form_data as $form_field) { $form_sql = "SELECT * FROM `".$wpdb->prefix."collect_data_forms` WHERE `id` = '".$form_field['form_id']."' LIMIT 1"; $form_data = $wpdb->get_results($form_sql,ARRAY_A); $form_data = $form_data[0]; if($form_data['type'] == 'country' ) { $report_user .= $form_data['name'].": ".get_country($form_field['value'])."\n"; } else { $report_user .= $form_data['name'].": ".$form_field['value']."\n"; } } } $report_user .= "\n\r"; $report = $report_user. $report_id . $report; if($stock_adjusted == true) { $wpdb->query("UPDATE `{$wpdb->prefix}purchase_logs` SET `stock_adjusted` = '1' WHERE `sessionid` = ".$sessionid." LIMIT 1") ; } if((get_option('purch_log_email') != null) && ($purchase_log['email_sent'] != 1)) { mail(get_option('purch_log_email'), TXT_WPSC_PURCHASEREPORT, $report, "From: ".get_option('return_email').""); } if($purchase_log['processed'] < 2) { echo "