".TXT_WPSC_SELECTACATEGORY."\r\n"; $values = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_brands` WHERE `active`='1' ORDER BY `id` ASC",ARRAY_A); $options .= "\r\n"; foreach((array)$values as $option) { if($current_brand == $option['id']) { $selected = "selected='selected'"; } $options .= "\r\n"; $selected = ""; } $concat .= "\r\n"; return $concat; } $sql = "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`=$prodid LIMIT 1"; $product_data = $wpdb->get_results($sql,ARRAY_A); $product = $product_data[0]; $sql = "SELECT * FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `product_id`=$prodid AND meta_key='external_link' LIMIT 1"; $meta_data = $wpdb->get_results($sql,ARRAY_A); $product['external_link'] = $meta_data[0]['meta_value']; $sql = "SELECT * FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `product_id`=$prodid AND meta_key='merchant_notes' LIMIT 1"; $meta_data = $wpdb->get_results($sql,ARRAY_A); $product['merchant_notes'] = $meta_data[0]['meta_value']; $engrave = get_product_meta($prodid,'engraved',true); $can_have_uploaded_image = get_product_meta($prodid,'can_have_uploaded_image',true); $table_rate_price = get_product_meta($prodid,'table_rate_price',true); // exit("
".print_r($table_rate_price,1)."
"); if(function_exists('wp_insert_term')) { $term_relationships = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."term_relationships WHERE object_id = $prodid", ARRAY_A); foreach ((array)$term_relationships as $term_relationship) { $tt_ids[] = $term_relationship['term_taxonomy_id']; } foreach ((array)$tt_ids as $tt_id) { $results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."term_taxonomy WHERE term_taxonomy_id = ".$tt_id." AND taxonomy = 'product_tag'", ARRAY_A); $term_ids[] = $results[0]['term_id']; } foreach ((array)$term_ids as $term_id ) { if ($term_id != NULL){ $results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."terms WHERE term_id=".$term_id." ",ARRAY_A); $tags[] = $results[0]['name']; } } if ($tags != NULL){ $imtags = implode(',', $tags); } } $check_variation_value_count = $wpdb->get_var("SELECT COUNT(*) as `count` FROM `".$wpdb->prefix."variation_values_associations` WHERE `product_id` = '".$product['id']."'"); $current_user = wp_get_current_user(); $closed_postboxes = (array)get_usermeta( $current_user->ID, 'closedpostboxes_editproduct'); if (IS_WP27){ $output .= "
"; $output .= "
"; $output .= "

". TXT_WPSC_PRODUCTDETAILS." ".TXT_WPSC_ENTERPRODUCTDETAILSHERE."

"; $output .= "
"; } else { $output .= "
"; $output .= "
". TXT_WPSC_PRODUCTDETAILS." ".TXT_WPSC_ENTERPRODUCTDETAILSHERE."
"; } $output .= " \n\r"; $output .= " \n\r"; /* $output .= " \n\r"; */ $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= ""; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; /* $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; // $output .=""; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; */ if (IS_WP27) { $output .= "
\n\r"; $output .= TXT_WPSC_PRODUCTNAME.": "; $output .= " \n\r"; $output .= "
\n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= "
\n\r"; // $output .= "
Embed Product:
[buy_now_button={$product['id']}]
\n\r"; // $output .= "
Buy Now Button:
\n\r"; $output .= "
Buy Now Shortcode:
[buy_now_button={$product['id']}]
\n\r"; $output .= "
Buy Now PHP:
<?php echo wpsc_buy_now_button({$product['id']}); ?>
\n\r"; $output .= "
\n\r"; $output .= "
\n\r"; $output .= "
\n\r"; $output .= "
\n\r"; $output .= "
\n\r"; $output .= TXT_WPSC_SKU_FULL." :
"; /* $output .= " 		\n\r"; */ $sku = get_product_meta($product['id'], 'sku'); $sku = $sku[0]; $output .= "\n\r"; $output .= " "; $output .= TXT_WPSC_PRICE." :
"; $output .= ""; $output .= "
\n\r"; /* $output .= TXT_WPSC_PRODUCTDESCRIPTION.": "; $output .= " \n\r"; */ $output .= "
"; $output .= ""; $output .= "
"; $output .= "
\n\r"; $output .= "".TXT_WPSC_ADDITIONALDESCRIPTION." :
"; /* $output .= " 		\n\r"; */ $output .= ""; $output .= "
\n\r"; $output .= TXT_WPSC_PRODUCT_TAGS.": "; $output .= " \n\r"; $output .= "
Seperate with commas"; $output .= "
 
".TXT_WPSC_CATEGORISATION.":\n\r"; $categorisation_groups = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}wpsc_categorisation_groups` WHERE `active` IN ('1')", ARRAY_A); foreach((array)$categorisation_groups as $categorisation_group) { $category_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}product_categories` WHERE `group_id` IN ('{$categorisation_group['id']}')"); if($category_count > 0) { $output .= "

"; $category_group_name = str_replace("[categorisation]", $categorisation_group['name'], TXT_WPSC_PRODUCT_CATEGORIES); $output .= "".$category_group_name.":
"; $output .= categorylist($categorisation_group['id'], $product['id'], 'edit_'); $output .= "

\n\r"; } } $output .= "
\n\r"; $output .= "
"; $output .= "
"; } else { $output .= ""; $output .= ""; if ($box == "product_image") { $output .= ""; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
"; } $order = get_option('wpsc_product_page_order'); if (($order == '') || (count($order < 7 ))){ $order=array("category_and_tag", "price_and_stock", "shipping", "variation", "advanced", "product_image", "product_download"); } update_option('wpsc_product_page_order', $order); foreach((array)$order as $key => $box) { $box_function_name = $box."_box"; $output .= call_user_func($box_function_name,$product); //echo $output; if(!IS_WP27 && ($key!=count($order)-1)) { $output .= "
"; } else { $output .= "
"; } if ($box == "price_and_stock") { ob_start(); do_action('wpsc_product_form', $product['id']); $output .= ob_get_contents(); ob_end_clean(); } } } if (!IS_WP27) { $output .= "
\n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= ""; $output .= ""; $output .= ""; $output .= "".TXT_WPSC_DELETE_PRODUCT.""; $output .= " 		\n\r"; $output .= "
\n\r"; } else { $output .= ""; $output .= ""; $output .= ""; $output .= "".TXT_WPSC_DELETE_PRODUCT.""; } $output .= "
"; return $output; } function nzshpcrt_getcategoryform($catid) { global $wpdb,$nzshpcrt_imagesize_info; $sql = "SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `id`=$catid LIMIT 1"; $product_data = $wpdb->get_results($sql,ARRAY_A) ; $product = $product_data[0]; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; if ($product['display_type'] == 'grid') { $display_type1="selected='selected'"; } else if ($product['display_type'] == 'default') { $display_type2="selected='selected'"; } switch($product['display_type']) { case "grid": if(function_exists('product_display_grid')) { $product_view3 = "selected ='true'"; break; } case "list": if(function_exists('product_display_list')) { $product_view2 = "selected ='true'"; break; } default: $product_view1 = "selected ='true'"; break; } $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; if(function_exists("getimagesize")) { if($product['image'] != '') { $imagepath = WPSC_CATEGORY_DIR . $product['image']; $imagetype = @getimagesize($imagepath); //previously exif_imagetype() $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; } else { $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; } } $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= TXT_WPSC_NAME.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= TXT_WPSC_DESCRIPTION.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= TXT_WPSC_CATEGORY_PARENT.": "; $output .= " \n\r"; $output .= wpsc_parent_category_list($product['group_id'], $product['id'], $product['category_parent']); $output .= "
\n\r"; $output .= " ". TXT_WPSC_DISPLAYTYPE.":\n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= TXT_WPSC_CATEGORY_PRODUCT_IMAGE.": "; $output .= " \n\r"; $output .= TXT_WPSC_HEIGHT.": "; $output .= TXT_WPSC_WIDTH.":
"; $output .= "
\n\r"; $output .= TXT_WPSC_IMAGE.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= " \n\r"; $output .= TXT_WPSC_HEIGHT.": ".TXT_WPSC_WIDTH.":
$nzshpcrt_imagesize_info"; $output .= "
\n\r"; $output .= " \n\r"; $output .= TXT_WPSC_HEIGHT.": ".TXT_WPSC_WIDTH.":
$nzshpcrt_imagesize_info"; $output .= "
\n\r"; $output .= TXT_WPSC_DELETEIMAGE.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= " \n\r"; $output .= ""; $output .= ""; $output .= ""; $output .= "".TXT_WPSC_DELETE.""; $output .= "
\n\r"; return $output; } function nzshpcrt_getbrandsform($catid) { global $wpdb,$nzshpcrt_imagesize_info; $sql = "SELECT * FROM `".$wpdb->prefix."product_brands` WHERE `id`='$catid' LIMIT 1"; $product_data = $wpdb->get_results($sql,ARRAY_A) ; $product = $product_data[0]; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= TXT_WPSC_NAME.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= TXT_WPSC_DESCRIPTION.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= " \n\r"; $output .= ""; $output .= ""; $output .= ""; $output .= "".TXT_WPSC_DELETE.""; $output .= "
\n\r"; return $output; } function nzshpcrt_getvariationform($variation_id) { global $wpdb,$nzshpcrt_imagesize_info; $variation_sql = "SELECT * FROM `".$wpdb->prefix."product_variations` WHERE `id`='$variation_id' LIMIT 1"; $variation_data = $wpdb->get_results($variation_sql,ARRAY_A) ; $variation = $variation_data[0]; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= TXT_WPSC_NAME.": "; $output .= " \n\r"; $output .= ""; $output .= "
\n\r"; $output .= TXT_WPSC_VARIATION_VALUES.": "; $output .= " \n\r"; $variation_values_sql = "SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `variation_id`='$variation_id' ORDER BY `id` ASC"; $variation_values = $wpdb->get_results($variation_values_sql,ARRAY_A); $variation_value_count = count($variation_values); $output .= "
"; $num = 0; foreach($variation_values as $variation_value) { $output .= ""; $output .= ""; if($variation_value_count > 1) { $output .= " ".TXT_WPSC_DELETE.""; } $output .= "
"; $output .= ""; $num++; } $output .= "
"; $output .= "".TXT_WPSC_ADD.""; $output .= "
\n\r"; $output .= " \n\r"; $output .= ""; $output .= ""; $output .= ""; $output .= "".TXT_WPSC_DELETE.""; $output .= "
\n\r"; return $output; } function coupon_edit_form($coupon) { $start_timestamp = strtotime($coupon['start']); $end_timestamp = strtotime($coupon['expiry']); $id = $coupon['id']; $output = ''; $output .= "
\n\r"; $output .= " \n\r"; $output .= "\n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
".TXT_WPSC_COUPON_CODE."".TXT_WPSC_DISCOUNT."".TXT_WPSC_START."".TXT_WPSC_EXPIRY."".TXT_WPSC_USE_ONCE."".TXT_WPSC_ACTIVE."".TXT_WPSC_PERTICKED."
\n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $coupon_start = explode(" ",$coupon['start']); $output .= ""; /* $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r";*/ $output .= " \n\r"; $coupon_expiry = explode(" ",$coupon['expiry']); $output .= ""; /*$output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r";*/ $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; //$output .= " \n\r"; $output .= " \n\r"; $output .= " \n\r"; $output .= "
\n\r"; $output .= "
\n\r"; return $output; } function setting_button(){ $itemsFeedURL = "http://www.google.com/base/feeds/items"; $next_url = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']."?page=wp-shopping-cart/display-items.php"; $redirect_url = 'https://www.google.com/accounts/AuthSubRequest?session=1'; $redirect_url .= '&next='; $redirect_url .= urlencode($next_url); $redirect_url .= "&scope="; $redirect_url .= urlencode($itemsFeedURL); // $output.="
"; $output.="
| Settings »"; $output.="  
"; return $output; } function wpsc_right_now() { global $wpdb,$nzshpcrt_imagesize_info; $year = date("Y"); $month = date("m"); $start_timestamp = mktime(0, 0, 0, $month, 1, $year); $end_timestamp = mktime(0, 0, 0, ($month+1), 0, $year); $replace_values[":productcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."product_list` WHERE `active` IN ('1')"); $product_count = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."product_list` WHERE `active` IN ('1')"); $replace_values[":productcount:"] .= " ".(($replace_values[":productcount:"] == 1) ? TXT_WPSC_PRODUCTCOUNT_SINGULAR : TXT_WPSC_PRODUCTCOUNT_PLURAL); $product_unit = (($replace_values[":productcount:"] == 1) ? TXT_WPSC_PRODUCTCOUNT_SINGULAR : TXT_WPSC_PRODUCTCOUNT_PLURAL); $replace_values[":groupcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."product_categories` WHERE `active` IN ('1')"); $group_count = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."product_categories` WHERE `active` IN ('1')"); $replace_values[":groupcount:"] .= " ".(($replace_values[":groupcount:"] == 1) ? TXT_WPSC_GROUPCOUNT_SINGULAR : TXT_WPSC_GROUPCOUNT_PLURAL); $group_unit = (($replace_values[":groupcount:"] == 1) ? TXT_WPSC_GROUPCOUNT_SINGULAR : TXT_WPSC_GROUPCOUNT_PLURAL); $replace_values[":salecount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$start_timestamp."' AND '".$end_timestamp."'"); $sales_count = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$start_timestamp."' AND '".$end_timestamp."'"); $replace_values[":salecount:"] .= " ".(($replace_values[":salecount:"] == 1) ? TXT_WPSC_SALECOUNT_SINGULAR : TXT_WPSC_SALECOUNT_PLURAL); $sales_unit = (($replace_values[":salecount:"] == 1) ? TXT_WPSC_SALECOUNT_SINGULAR : TXT_WPSC_SALECOUNT_PLURAL); $replace_values[":monthtotal:"] = nzshpcrt_currency_display(admin_display_total_price($start_timestamp, $end_timestamp),1); $replace_values[":overaltotal:"] = nzshpcrt_currency_display(admin_display_total_price(),1); $variation_count = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."product_variations`"); $variation_unit = (($variation_count == 1) ? TXT_WPSC_VARIATION_SINGULAR : TXT_WPSC_VARIATION_PLURAL); $replace_values[":pendingcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."purchase_logs` WHERE `processed` IN ('1')"); $pending_sales = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."purchase_logs` WHERE `processed` IN ('1')"); $replace_values[":pendingcount:"] .= " " . (($replace_values[":pendingcount:"] == 1) ? TXT_WPSC_PENDINGCOUNT_SINGULAR : TXT_WPSC_PENDINGCOUNT_PLURAL); $pending_sales_unit = (($replace_values[":pendingcount:"] == 1) ? TXT_WPSC_PENDINGCOUNT_SINGULAR : TXT_WPSC_PENDINGCOUNT_PLURAL); $accept_sales = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."purchase_logs` WHERE `processed` IN ('2' ,'3', '4')"); $accept_sales_unit = (($accept_sales == 1) ? TXT_WPSC_PENDINGCOUNT_SINGULAR : TXT_WPSC_PENDINGCOUNT_PLURAL); $replace_values[":theme:"] = get_option('wpsc_selected_theme'); $replace_values[":versionnumber:"] = WPSC_PRESENTABLE_VERSION; if (function_exists('add_object_page')) { $output=""; $output.="
"; $output.="

"; $output.=" "._('Current Month').""; //$output.=" ".TXT_WPSC_ADDNEWPRODUCT.""; $output.="
"; $output.="

"; $output .= "
"; $output .= "

At a Glance

"; //$output.="

".TXT_WPSC_SALES_DASHBOARD."

"; $output .= "
"; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= ""; $output .= "
"; $output .= "".$product_count.""; $output .= ""; $output .= ""; $output .= ucfirst($product_unit); $output .= ""; $output .= ""; $output .= "".$sales_count.""; $output .= ""; $output .= ""; $output .= ucfirst($sales_unit); $output .= ""; $output .= "
"; $output .= "".$group_count.""; $output .= ""; $output .= ""; $output .= ucfirst($group_unit); $output .= ""; $output .= ""; $output .= "".$pending_sales.""; $output .= ""; $output .= "Pending "; $output .= ucfirst($pending_sales_unit); $output .= ""; $output .= "
"; $output .= "".$variation_count.""; $output .= ""; $output .= ""; $output .= ucfirst($variation_unit); $output .= ""; $output .= ""; $output .= "".$accept_sales.""; $output .= ""; $output .= "Closed "; $output .= ucfirst($accept_sales_unit); $output .= ""; $output .= "
"; $output .= "
"; $output .= "
"; $output .= "

Add new productHere you can add products, groups or variations

"; $output .= "
"; $output .= "
"; $output.="
"; } else { $output=""; $output.="
\n\r"; $output.="

\n\r"; $output.=" ".TXT_WPSC_ADDNEWPRODUCT."\n\r"; $output.=" "._('Right Now')."\n\r"; //$output.="
\n\r"; $output.="

\n\r"; $output.="

".TXT_WPSC_SALES_DASHBOARD."

\n\r"; $output.="

\n\r"; $output.=" ".TXT_WPSC_YOUAREUSING."\n\r"; //$output.=" Change Theme\n\r"; //$output.="This is WordPress version 2.6. Update to 2.6.1\n\r"; $output.="

\n\r"; $output.="
\n\r"; $output.="
\n\r"; $output = str_replace(array_keys($replace_values), array_values($replace_values),$output); } return $output; } function wpsc_packing_slip($purchase_id) { global $wpdb; $purch_sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `id`='".$purchase_id."'"; $purch_data = $wpdb->get_row($purch_sql,ARRAY_A) ; //echo "

".TXT_WPSC_DATE.":".date("jS M Y", $purch_data['date'])."

"; $cartsql = "SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`=".$purchase_id.""; $cart_log = $wpdb->get_results($cartsql,ARRAY_A) ; $j = 0; if($cart_log != null) { echo "
\n\r"; echo "

".TXT_WPSC_PACKING_SLIP."

\n\r"; echo "".TXT_WPSC_ORDER." # ".$purchase_id."

\n\r"; echo "\n\r"; $form_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".(int)$purchase_id."'"; $input_data = $wpdb->get_results($form_sql,ARRAY_A); foreach($input_data as $input_row) { $rekeyed_input[$input_row['form_id']] = $input_row; } if($input_data != null) { $form_data = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}collect_data_forms` WHERE `active` = '1'",ARRAY_A); foreach($form_data as $form_field) { switch($form_field['type']) { case 'country': if(is_numeric($purch_data['shipping_region'])) { echo " \n\r"; } echo " \n\r"; break; case 'delivery_country': echo " \n\r"; break; case 'heading': echo " \n\r"; break; default: echo " \n\r"; break; } } } else { echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; } if(get_option('payment_method') == 2) { $gateway_name = ''; foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) { if($purch_data['gateway'] != 'testmode') { if($gateway['internalname'] == $purch_data['gateway'] ) { $gateway_name = $gateway['name']; } } else { $gateway_name = "Manual Payment"; } } } // echo " \n\r"; // echo " \n\r"; // //echo " \n\r"; // echo " \n\r"; // $engrave_line = explode(",",$purch_data['engravetext']); // echo " \n\r"; // echo " \n\r"; // echo " \n\r"; // if($purch_data['transactid'] != '') { // echo " \n\r"; // } echo "
".TXT_WPSC_STATE.":".get_region($purch_data['shipping_region'])."
".$form_field['name'].":".get_country($purch_data['billing_country'])."
".$form_field['name'].":".get_country($purch_data['shipping_country'])."
".$form_field['name'].":
".$form_field['name'].":".$rekeyed_input[$form_field['id']]['value']."
".TXT_WPSC_NAME.":".$purch_data['firstname']." ".$purch_data['lastname']."
".TXT_WPSC_ADDRESS.":".$purch_data['address']."
".TXT_WPSC_PHONE.":".$purch_data['phone']."
".TXT_WPSC_EMAIL.":".$purch_data['email']."
".TXT_WPSC_PAYMENT_METHOD.":".$gateway_name."
".TXT_WPSC_PURCHASE_NUMBER.":".$purch_data['id']."
".TXT_WPSC_HOWCUSTOMERFINDUS.":".$purch_data['find_us']."
".TXT_WPSC_ENGRAVE."
".TXT_WPSC_ENGRAVE_LINE_ONE.":".$engrave_line[0]."
".TXT_WPSC_ENGRAVE_LINE_TWO.":".$engrave_line[1]."
".TXT_WPSC_TXN_ID.":".$purch_data['transactid']."
\n\r"; echo ""; echo ""; echo " "; echo " "; echo " "; echo " "; echo ''; $endtotal = 0; $all_donations = true; $all_no_shipping = true; $file_link_list = array(); foreach($cart_log as $cart_row) { $alternate = ""; $j++; if(($j % 2) != 0) { $alternate = "class='alt'"; } $productsql= "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`=".$cart_row['prodid'].""; $product_data = $wpdb->get_results($productsql,ARRAY_A); $variation_sql = "SELECT * FROM `".$wpdb->prefix."cart_item_variations` WHERE `cart_id`='".$cart_row['id']."'"; $variation_data = $wpdb->get_results($variation_sql,ARRAY_A); $variation_count = count($variation_data); if($variation_count > 1) { $variation_list = " ("; $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($cart_row['donation'] != 1) { $all_donations = false; } if($cart_row['no_shipping'] != 1) { $shipping = $cart_row['pnp'] * $cart_row['quantity']; $total_shipping += $shipping; $all_no_shipping = false; } else { $shipping = 0; } $price = $cart_row['price'] * $cart_row['quantity']; $gst = $price - ($price / (1+($cart_row['gst'] / 100))); if($gst > 0) { $tax_per_item = $gst / $cart_row['quantity']; } echo ""; echo " "; echo " "; echo " "; echo " "; echo ''; } echo "
".TXT_WPSC_QUANTITY." ".TXT_WPSC_NAME."".TXT_WPSC_PRICE." ".TXT_WPSC_SHIPPING."
"; echo $cart_row['quantity']; echo " "; echo $product_data[0]['name']; echo $variation_list; echo " "; echo nzshpcrt_currency_display( $price, 1); echo " "; echo nzshpcrt_currency_display($shipping, 1); echo "
"; echo "
\n\r"; } else { echo "
".TXT_WPSC_USERSCARTWASEMPTY; } } function edit_multiple_image_gallery($id) { global $wpdb; $siteurl = get_option('siteurl'); $main_image = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id` = '$id'",ARRAY_A); $timestamp = time(); $output .= "
  • "; if ($main_image[0]['image'] == '') { $output .=''; } else { $output .= "