".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 `".WPSC_TABLE_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_var("SELECT `value` FROM `".WPSC_TABLE_SUBMITED_FORM_DATA."` WHERE `log_id`=".$purchase_log['id']." AND `form_id` = '".get_option('country_form_field')."' LIMIT 1"); $billing_country = $country; $shipping_country = $country; } $email_form_field = $wpdb->get_results("SELECT `id`,`type` FROM `".WPSC_TABLE_CHECKOUT_FORMS."` WHERE `type` IN ('email') AND `active` = '1' ORDER BY `order` ASC LIMIT 1",ARRAY_A); $email = $wpdb->get_var("SELECT `value` FROM `".WPSC_TABLE_SUBMITED_FORM_DATA."` WHERE `log_id`=".$purchase_log['id']." AND `form_id` = '".$email_form_field[0]['id']."' LIMIT 1"); $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 `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='{$row['prodid']}' LIMIT 1", ARRAY_A) ; if($purchase_log['email_sent'] != 1) { $wpdb->query("UPDATE `".WPSC_TABLE_DOWNLOAD_STATUS."` SET `active`='1' WHERE (`fileid` = '{$product_data['file']}' OR `cartid` = '{$row['id']}' ) AND `purchid` = '{$purchase_log['id']}'"); } do_action('wpsc_transaction_result_cart_item', array("purchase_id" =>$purchase_log['id'], "cart_item"=>$row, "purchase_log"=>$purchase_log)); if (($purchase_log['processed'] >= 2)) { //echo "SELECT * FROM `".WPSC_TABLE_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 `".WPSC_TABLE_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); //exit('IM HERE'.$errorcode.''.print_r($download_data).''); 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']; } //$order_status= 4; }else{ $order_status= $purchase_log['processed']; } $previous_download_ids[] = $download_data['id']; } do_action('wpsc_confirm_checkout', $purchase_log['id']); $shipping = $row['pnp']*$row['quantity']; $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 `".WPSC_TABLE_CART_ITEM_VARIATIONS."` WHERE `cart_id`='{$row['id']}'"); //echo "
".print_r($product_data,true).""; $variation_count = count($variation_values); if($purchase['gateway'] != 'testmode') { if($gateway['internalname'] == $purch_data[0]['gateway'] ) { $gateway_name = $gateway['name']; } } else { $gateway_name = "Manual Payment"; } //echo "
".print_r($variation_values,true).""; $variation_list = ''; if($variation_count > 0) { $value_names = $wpdb->get_col("SELECT `name` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$variation_values)."')"); $variation_list = " (".stripslashes(implode(", ",$value_names)).")"; } if($link != '') { $additional_content = apply_filters('wpsc_transaction_result_content', array("purchase_id" =>$purchase_log['id'], "cart_item"=>$row, "purchase_log"=>$purchase_log)); if(!is_string($additional_content)) { $additional_content = ''; } $product_list .= " - ". $product_data['name'] . stripslashes($variation_list) ." ".$message_price ." ".TXT_WPSC_CLICKTODOWNLOAD.":\n\r $link\n\r".$additional_content; $product_list_html .= " - ". $product_data['name'] . stripslashes($variation_list) ." ".$message_price ." ".TXT_WPSC_CLICKTODOWNLOAD."\n". $additional_content; } else { $plural = ''; if($row['quantity'] > 1) { $plural = "s"; } $product_list.= " - ".$row['quantity']." ". $product_data['name'].stripslashes($variation_list )." ". $message_price ."\n\r"; if ($shipping > 0) $product_list .= " - ". TXT_WPSC_SHIPPING.":".$shipping_price ."\n\r"; $product_list_html.= " - ".$row['quantity']." ". $product_data['name'].stripslashes($variation_list )." ". $message_price ."\n\r"; if ($shipping > 0) $product_list_html .= " ". TXT_WPSC_SHIPPING.":".$shipping_price ."\n\r"; } $report = get_option('wpsc_email_admin'); $report_product_list.= " - ". $product_data['name'] .stripslashes($variation_list)." ".$message_price ."\n\r"; } // Decrement the stock here if (($purchase_log['processed'] >= 2)) { wpsc_decrement_claimed_stock($purchase_log['id']); } if($purchase_log['discount_data'] != '') { $coupon_data = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_COUPON_CODES."` WHERE coupon_code='".$wpdb->escape($purchase_log['discount_data'])."' LIMIT 1",ARRAY_A); if($coupon_data['use-once'] == 1) { $wpdb->query("UPDATE `".WPSC_TABLE_COUPON_CODES."` SET `active`='0', `is-used`='1' WHERE `id`='".$coupon_data['id']."' LIMIT 1"); } } //$wpdb->query("UPDATE `".WPSC_TABLE_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']; /*tlu osa*/ $query = mysql_query('SELECT * FROM wp_wpsc_has_ordered WHERE user_ID="'.$current_user->ID.'" LIMIT 1') or die(mysql_error()); $row3 = mysql_fetch_array($query); $bonus = $row3['last_bonus']; $bonusleft = $row3['money_on_account']; /*tlu osa lopp*/ $total = $purchase_log['totalprice']; // echo $total; // $message.= "\n\r"; $product_list.= "Your Purchase No.: ".$purchase_log['id']."\n\r"; if($purchase_log['discount_value'] > 0) { $discount_email.= TXT_WPSC_DISCOUNT."\n\r: "; $discount_email .=$purchase_log['discount_data'].' : '.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"; /*tlu osa*/ $total_price_email.= "Boonusraha lahutamine täissummast: ".nzshpcrt_currency_display($bonus,1,true)."\n\r\n\r Boonusraha alles peale tellimust: ".nzshpcrt_currency_display($bonusleft,1,true)."\n\r\n\r".TXT_WPSC_TOTAL.": ".nzshpcrt_currency_display($total,1,true)."\n\r"; /*tlu osa lopp*/ $product_list_html.= "Your Purchase No.: ".$purchase_log['id']."\n\n\r"; if($purchase_log['discount_value'] > 0) { $report.= $discount_email."\n\r"; $total_shipping_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"; /*tlu osa*/ $total_price_html.= "Boonusraha lahutamine täissummast: ".nzshpcrt_currency_display($bonus,1,true)."\n\r\n\r Boonusraha alles peale tellimust: ".nzshpcrt_currency_display($bonusleft,1,true)."\n\r\n\r".TXT_WPSC_TOTAL.": ".nzshpcrt_currency_display($total, 1,true)."\n\r"; /*tlu osa lopp*/ 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"; } //echo "
".print_r($purchase_log,true).""; $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)) { add_filter('wp_mail_from', 'wpsc_replace_reply_address', 0); add_filter('wp_mail_from_name', 'wpsc_replace_reply_name', 0); 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; wp_mail($email, TXT_WPSC_ORDER_PENDING_PAYMENT_REQUIRED, $message); } else { wp_mail($email, TXT_WPSC_PURCHASERECEIPT, $message); } } remove_filter('wp_mail_from_name', 'wpsc_replace_reply_name'); remove_filter('wp_mail_from', 'wpsc_replace_reply_address'); $report_user = TXT_WPSC_CUSTOMERDETAILS."\n\r"; $form_sql = "SELECT * FROM `".WPSC_TABLE_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_data = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_CHECKOUT_FORMS."` WHERE `id` = '".$form_field['form_id']."' LIMIT 1", ARRAY_A); switch($form_data['type']) { case "country": $delivery_region_count = $wpdb->get_var("SELECT COUNT(`regions`.`id`) FROM `".WPSC_TABLE_REGION_TAX."` AS `regions` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `country`.`id` = `regions`.`country_id` WHERE `country`.`isocode` IN('".$wpdb->escape( $purchase_log['billing_country'])."')"); if(is_numeric($purchase_log['shipping_region']) && ($delivery_region_count > 0)) { $report_user .= TXT_WPSC_STATE.": ".wpsc_get_region($purchase_log['billing_region'])."\n"; } $report_user .= $form_data['name'].": ".wpsc_get_country($form_field['value'])."\n"; break; case "delivery_country": $delivery_region_count = $wpdb->get_var("SELECT COUNT(`regions`.`id`) FROM `".WPSC_TABLE_REGION_TAX."` AS `regions` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `country`.`id` = `regions`.`country_id` WHERE `country`.`isocode` IN('".$wpdb->escape( $purchase_log['shipping_country'])."')"); if(is_numeric($purchase_log['shipping_region']) && ($delivery_region_count > 0)) { $report_user .= TXT_WPSC_DELIVERY_STATE.": ".wpsc_get_region($purchase_log['shipping_region'])."\n"; } $report_user .= $form_data['name'].": ".wpsc_get_country($form_field['value'])."\n"; break; default: $report_user .= $form_data['name'].": ".$form_field['value']."\n"; break; } } } $report_user .= "\n\r"; $report = $report_user. $report_id . $report; if($stock_adjusted == true) { $wpdb->query("UPDATE `".WPSC_TABLE_PURCHASE_LOGS."` SET `stock_adjusted` = '1' WHERE `sessionid` = ".$sessionid." LIMIT 1") ; } if((get_option('purch_log_email') != null) && ($purchase_log['email_sent'] != 1)) { wp_mail(get_option('purch_log_email'), TXT_WPSC_PURCHASEREPORT, $report); } if($purchase_log['processed'] < 2) { echo "