product_id; $quantity = $cart_item->quantity; $product_variations = $cart_item->product_variations; $extras = $cart_item->extras; $extras_count=count($extras); $raw_price = 0; $variation_count = count($product_variations); if($variation_count > 0) { foreach($product_variations as $product_variation) { $value_id = $product_variation; $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A); } } //$total_quantity += $quantity; $sql = "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id` = '$product_id' LIMIT 1"; $product = $wpdb->get_row($sql,ARRAY_A); if($product['donation'] == 1) { $price = $quantity * $cart_item->donation_price; } else { $price = $quantity * calculate_product_price($product_id, $product_variations,'stay',$extras); if($country_code != null) { if($product['notax'] != 1) { $price = nzshpcrt_calculate_tax($price, $_SESSION['selected_country'], $_SESSION['selected_region']); } $shipping = nzshpcrt_determine_item_shipping($product_id, $quantity, $country_code); $price += $shipping; } $all_donations = false; } if($product['no_shipping'] != 1) { $all_no_shipping = false; } $total += $price; } if(($country_code != null) && ($all_donations == false) && ($all_no_shipping == false)) { //echo $_SESSION['selected_country']; //exit(nzshpcrt_determine_base_shipping(0, $country_code)); $total += nzshpcrt_determine_base_shipping(0, $_SESSION['delivery_country']); } if(!empty($_SESSION['coupon_num']) && ($no_discount !== true)){ $total += nzshpcrt_apply_coupon($total,$_SESSION['coupon_num']) - $total ; } if($for_display === true) { $total = nzshpcrt_currency_display($total,1); if(($country_code == null) && (get_option('add_plustax') == 1)) { $total .= " + ".TXT_WPSC_POSTAGE_AND_TAX.""; } } return $total; } //written by allen function nzshpcrt_overall_total_price_numeric($country_code = null, $for_display = false) { /* * Determines the total in the shopping cart, adds the tax and shipping if a country code is supplied * Adds a dollar sign and information if there is no tax and shipping if $for_display is true */ global $wpdb; $cart =& $_SESSION['nzshpcrt_cart']; $total_quantity =0; $total_weight = 0; $all_donations = true; $all_no_shipping = true; foreach($cart as $cart_item) { $product_id = $cart_item->product_id; $quantity = $cart_item->quantity; $product_variations = $cart_item->product_variations; $raw_price = 0; $variation_count = count($product_variations); if($variation_count > 0) { foreach($product_variations as $product_variation) { $value_id = $product_variation; $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A); } } //$total_quantity += $quantity; $sql = "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id` = '$product_id' LIMIT 1"; $product = $wpdb->get_row($sql,ARRAY_A); if($product['donation'] == 1) { $price = $quantity * $cart_item->donation_price; } else { $price = $quantity * calculate_product_price($product_id, $product_variations); if($country_code != null) { if($product['notax'] != 1) { $price = nzshpcrt_calculate_tax($price, $_SESSION['selected_country'], $_SESSION['selected_region']); } $shipping = nzshpcrt_determine_item_shipping($product_id, $quantity, $country_code); $price += $shipping; } $all_donations = false; } if($product['no_shipping'] != 1) { $all_no_shipping = false; } $total += $price; } if(($country_code != null) && ($all_donations == false) && ($all_no_shipping == false)) { $total += nzshpcrt_determine_base_shipping(0, $country_code); } return $total; } //end of written by allen function nzshpcrt_calculate_tax($price, $country, $region) { global $wpdb; $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('".$region."') ",ARRAY_A) ; $tax_percentage = $region_data['tax']; } else { $tax_percentage = $country_data['tax']; } $add_tax = false; if($country == get_option('base_country')) { $add_tax = true; } if($add_tax === true) { $price = $price * (1 + ($tax_percentage/100)); } return $price; } function nzshpcrt_find_total_price($purchase_id,$country_code) { global $wpdb; if(is_numeric($purchase_id)) { $purch_sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `id`='".$purchase_id."'"; $purch_data = $wpdb->get_row($purch_sql,ARRAY_A) ; $cartsql = "SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`=".$purchase_id.""; $cart_log = $wpdb->get_results($cartsql,ARRAY_A) ; if($cart_log != null) { $all_donations = true; $all_no_shipping = true; foreach($cart_log as $cart_row) { $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); $price = ($cart_row['price'] * $cart_row['quantity']); if($purch_data['shipping_country'] != '') { $country_code = $purch_data['shipping_country']; } if($cart_row['donation'] == 1) { $shipping = 0; } else { $all_donations = false; } if($cart_row['no_shipping'] == 1) { $shipping = 0; } else { $all_no_shipping = false; } if(($cart_row['donation'] != 1) && ($cart_row['no_shipping'] != 1)) { $shipping = nzshpcrt_determine_item_shipping($cart_row['prodid'], $cart_row['quantity'], $country_code); } $endtotal += $shipping + $price; } if(($all_donations == false) && ($all_no_shipping == false)){ if($purch_data['base_shipping'] > 0) { $base_shipping = $purch_data['base_shipping']; } else { $base_shipping = nzshpcrt_determine_base_shipping(0, $country_code); } $endtotal += $base_shipping; } if($purch_data['discount_value'] > 0) { $endtotal -= $purch_data['discount_value']; if($endtotal < 0) { $endtotal = 0; } } } return $endtotal; } } //written by Allen function nzshpcrt_apply_coupon($price,$coupon_num){ global $wpdb; $now = date("Y-m-d H:i:s"); $now = strtotime($now); //echo $now; if ($coupon_num!=NULL) { $coupon_sql = "SELECT * FROM `".$wpdb->prefix."wpsc_coupon_codes` WHERE coupon_code='".$coupon_num."' LIMIT 1"; $coupon_data = $wpdb->get_results($coupon_sql,ARRAY_A); $coupon_data = $coupon_data[0]; } if ( ($coupon_data['active']=='1') && !(($coupon_data['use_once']=='1') && ($coupon_data['is_used']=='1'))){ if ((strtotime($coupon_data['start']) < $now)&&(strtotime($coupon_data['expiry']) > $now)){ if ($coupon_data['is-percentage']=='1'){ $price = $price*(1-$coupon_data['value']/100); } else { if ($coupon_data['every_product']=='1') { $cart = $_SESSION['nzshpcrt_cart']; $total_quantity=0; foreach($cart as $product) { $total_quantity+=$product->quantity; } $price = $price-$coupon_data['value']*$total_quantity; } else { $price = $price-$coupon_data['value']; } } } else { return $price; } } if($price<0){ $price = 0; } return $price; } //End of written by Allen function nzshpcrt_determine_base_shipping($per_item_shipping, $country_code) { global $wpdb, $wpsc_shipping_modules; if(get_option('do_not_use_shipping') != 1) { $custom_shipping = get_option('custom_shipping_options'); if(array_search($_SESSION['quote_shipping_method'], $custom_shipping) === false) { //unset($_SESSION['quote_shipping_method']); } $shipping_quotes = null; if($_SESSION['quote_shipping_method'] != null) { // use the selected shipping module $shipping_quotes = $wpsc_shipping_modules[$_SESSION['quote_shipping_method']]->getQuote(); } else { // otherwise select the first one with any quotes foreach($custom_shipping as $shipping_module) { $_SESSION['quote_shipping_method'] = $shipping_module; $shipping_quotes = $wpsc_shipping_modules[$_SESSION['quote_shipping_method']]->getQuote(); if(count($shipping_quotes) > 0) { // if we have any shipping quotes, break the loop. break; } } } //echo "
".print_r($_SESSION['quote_shipping_method'],true)."
"; if(count($shipping_quotes) < 1) { $_SESSION['quote_shipping_option'] = ''; } if(($_SESSION['quote_shipping_option'] == null) && ($shipping_quotes != null)) { $_SESSION['quote_shipping_option'] = array_pop(array_keys(array_slice($shipping_quotes[0],0,1))); } foreach((array)$shipping_quotes as $shipping_quote) { foreach((array)$shipping_quote as $key=>$quote) { if($key == $_SESSION['quote_shipping_option']) { $shipping = $quote; } } } } else { $shipping = 0; } return $shipping; } function nzshpcrt_determine_item_shipping($product_id, $quantity, $country_code) { global $wpdb; if(is_numeric($product_id) && (get_option('do_not_use_shipping') != 1) && ($_SESSION['quote_shipping_method'] == 'flatrate')) { $sql = "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`='$product_id' LIMIT 1"; $product_list = $wpdb->get_row($sql,ARRAY_A) ; if($product_list['no_shipping'] == 0) { //if the item has shipping if($country_code == get_option('base_country')) { $additional_shipping = $product_list['pnp']; } else { $additional_shipping = $product_list['international_pnp']; } $shipping = $quantity * $additional_shipping; } else { //if the item does not have shipping $shipping = 0; } } else { //if the item is invalid or all items do not have shipping $shipping = 0; } return $shipping; } function nzshpcrt_currency_display($price_in, $tax_status, $nohtml = false, $id = false, $no_dollar_sign = false) { global $wpdb; $currency_sign_location = get_option('currency_sign_location'); $currency_type = get_option('currency_type'); $currency_data = $wpdb->get_results("SELECT `symbol`,`symbol_html`,`code` FROM `".$wpdb->prefix."currency_list` WHERE `id`='".$currency_type."' LIMIT 1",ARRAY_A) ; $price_out = null; $currency_sign_location = get_option('currency_sign_location'); $currency_type = get_option('currency_type'); $currency_data = $wpdb->get_results("SELECT `symbol`,`symbol_html`,`code` FROM `".$wpdb->prefix."currency_list` WHERE `id`='".$currency_type."' LIMIT 1",ARRAY_A) ; $price_out = null; $price_out = number_format($price_in, 2, '.', ','); if($currency_data[0]['symbol'] != '') { if($nohtml == false) { $currency_sign = $currency_data[0]['symbol_html']; } else { $currency_sign = $currency_data[0]['symbol']; } } else { $currency_sign = $currency_data[0]['code']; } switch($currency_sign_location) { case 1: $output = $price_out.$currency_sign; break; case 2: $output = $price_out.' '.$currency_sign; break; case 3: $output = $currency_sign.$price_out; break; case 4: $output = $currency_sign.' '.$price_out; break; } if($nohtml == true) { $output = "".$output.""; } else { $output = "".$output.""; //$output = "".$output.""; } if($no_dollar_sign == true) { return $price_out; } return $output; } function admin_display_total_price($start_timestamp = '', $end_timestamp = '') { global $wpdb; if(($start_timestamp != '') && ($end_timestamp != '')) { $sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `processed` > '1' AND `date` BETWEEN '$start_timestamp' AND '$end_timestamp' ORDER BY `date` DESC"; } else { $sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `processed` > '1' AND `date` != ''"; } $purchase_log = $wpdb->get_results($sql,ARRAY_A) ; $total = 0; if($purchase_log != null) { foreach($purchase_log as $purchase) { // $country_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase['id']."' AND `form_id` = '".get_option('country_form_field')."' LIMIT 1"; // $country_data = $wpdb->get_results($country_sql,ARRAY_A); // $country = $country_data[0]['value']; // $total += nzshpcrt_find_total_price($purchase['id'],$country); $total += $purchase['totalprice']; } } return $total; } function calculate_product_price($product_id, $variations = false, $pm='',$extras=false) { global $wpdb; if(is_numeric($product_id)) { if(is_array($variations) && (count($variations) >= 1)) { $variation_count = count($variations); $variations = array_values($variations); array_walk($variations, 'wpsc_sanitise_keys'); } /// the start of the normal price determining code. if($variation_count >= 1) { // if we have variations, grab the individual price for them. $variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `{$wpdb->prefix}variation_values` WHERE `id` IN ('".implode("','",$variations)."')"); 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` = '$product_id' AND `value_id` IN ( '".implode("', '",$variations )."' ) AND `all_variation_ids` IN('$all_variation_ids') GROUP BY `priceandstock_id` HAVING COUNT( `priceandstock_id` ) = '".count($variations)."' LIMIT 1"); $price = $wpdb->get_var("SELECT `price` FROM `".$wpdb->prefix."variation_priceandstock` WHERE `id` = '{$priceandstock_id}' LIMIT 1"); } else { $sql = "SELECT `price`,`special`,`special_price` FROM `".$wpdb->prefix."product_list` WHERE `id`='".$product_id."' LIMIT 1"; $product_data = $wpdb->get_row($sql,ARRAY_A); if($product_data['special_price'] > 0) { $price = $product_data['price'] - $product_data['special_price']; } else { $price = $product_data['price']; } } } else { $price = false; } return $price; } function check_in_stock($product_id, $variations, $item_quantity = 1) { global $wpdb; $product_id = (int)$product_id; $item_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`='{$product_id}' LIMIT 1",ARRAY_A); $item_stock = null; $variation_count = count($variations); if($variation_count > 0) { foreach($variations as $variation_id) { if(is_numeric($variation_id)) { $variation_ids[] = $variation_id; } } if(count($variation_ids) > 0) { $actual_variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `{$wpdb->prefix}variation_values` WHERE `id` IN ('".implode("','",$variation_ids)."')"); asort($actual_variation_ids); $all_variation_ids = implode(",", $actual_variation_ids); $priceandstock_id = $wpdb->get_var("SELECT `priceandstock_id` FROM `".$wpdb->prefix."wpsc_variation_combinations` WHERE `product_id` = '{$product_id}' AND `value_id` IN ( '".implode("', '",$variation_ids )."' ) AND `all_variation_ids` IN('$all_variation_ids') GROUP BY `priceandstock_id` HAVING COUNT( `priceandstock_id` ) = '".count($variation_ids)."' LIMIT 1"); $variation_stock_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."variation_priceandstock` WHERE `id` = '{$priceandstock_id}' LIMIT 1", ARRAY_A); $item_stock = $variation_stock_data['stock']; } } if($item_stock === null) { $item_stock = $item_data['quantity']; } if((($item_data['quantity_limited'] == 1) && ($item_stock > 0) && ($item_stock >= $item_quantity)) || ($item_data['quantity_limited'] == 0)) { $output = true; } else { $output = false; } return $output; } function wpsc_item_process_image($id, $input_file, $output_filename, $width = 0, $height = 0, $resize_method = 1) { // the function for processing images, takes a product_id, input_file outout file name, height and width global $wpdb; //$_FILES['image']['tmp_name'] //$_FILES['image']['name'] if(preg_match("/\.(gif|jp(e)*g|png){1}$/i",$output_filename) && apply_filters( 'wpsc_filter_file', $input_file )) { //$active_signup = apply_filters( 'wpsc_filter_file', $_FILES['image']['tmp_name'] ); if(function_exists("getimagesize")) { $image_name = basename($output_filename); if(is_file((WPSC_IMAGE_DIR.$image_name))) { $name_parts = explode('.',basename($image_name)); $extension = array_pop($name_parts); $name_base = implode('.',$name_parts); $dir = glob(WPSC_IMAGE_DIR."$name_base*"); foreach($dir as $file) { $matching_files[] = basename($file); } $image_name = null; $num = 2; // loop till we find a free file name, first time I get to do a do loop in yonks do { $test_name = "{$name_base}-{$num}.{$extension}"; if(!file_exists(WPSC_IMAGE_DIR.$test_name)) { $image_name = $test_name; } $num++; } while ($image_name == null); } //exit("
".print_r($image_name,true)."
"); $new_image_path = WPSC_IMAGE_DIR.$image_name; rename($input_file, $new_image_path); $stat = stat( dirname( $new_image_path )); $perms = $stat['mode'] & 0000770; @ chmod( $new_image_path, $perms ); switch($resize_method) { case 2: if($height < 1) { $height = get_option('product_image_height'); } if($width < 1) { $width = get_option('product_image_width'); } break; case 0: $height = null; $width = null; break; case 1: default: $height = get_option('product_image_height'); $width = get_option('product_image_width'); break; } if(($resize_method == 3) && ($_FILES['thumbnailImage'] != null) && file_exists($_FILES['thumbnailImage']['tmp_name'])) { $imagefield='thumbnailImage'; $image= image_processing($_FILES['thumbnailImage']['tmp_name'], (WPSC_THUMBNAIL_DIR.$image_name),null,null,$imagefield); $thumbnail_image = $image; } else { image_processing($new_image_path, (WPSC_THUMBNAIL_DIR.$image_name), $width, $height); } $updatelink_sql = "UPDATE `".$wpdb->prefix."product_list` SET `image` = '".$image_name."', `thumbnail_image` = '".$thumbnail_image."' WHERE `id` = '$id'"; $wpdb->query($updatelink_sql); if(function_exists('getimagesize')) { $imagetype = getimagesize(WPSC_THUMBNAIL_DIR.$image_name); update_product_meta($id, 'thumbnail_width', $imagetype[0]); update_product_meta($id, 'thumbnail_height', $imagetype[1]); } $image = $wpdb->escape($image_name); } else { $image_name = basename($output_filename); if(is_file((WPSC_IMAGE_DIR.$image_name))) { $name_parts = explode('.',basename($image_name)); $extension = array_pop($name_parts); $name_base = implode('.',$name_parts); $dir = glob(WPSC_IMAGE_DIR."$name_base*"); foreach($dir as $file) { $matching_files[] = basename($file); } $image_name = null; $num = 2; // loop till we find a free file name do { $test_name = "{$name_base}-{$num}.{$extension}"; if(!file_exists(WPSC_IMAGE_DIR.$test_name)) { $image_name = $test_name; } $num++; } while ($image_name == null); } $new_image_path = WPSC_IMAGE_DIR.$image_name; move_uploaded_file($input_file, $new_image_path); $stat = stat( dirname( $new_image_path )); $perms = $stat['mode'] & 0000770; @ chmod( $new_image_path, $perms ); $image = $wpdb->escape($image_name); } } else { $image_data = $wpdb->get_row("SELECT `id`,`image` FROM `".$wpdb->prefix."product_list` WHERE `id`='".(int)$id."' LIMIT 1",ARRAY_A); //exit("
".print_r($image_data,true)."
"); if(($_POST['image_resize'] == 3) && ($_FILES['thumbnailImage'] != null) && file_exists($_FILES['thumbnailImage']['tmp_name'])) { $imagefield='thumbnailImage'; $image=image_processing($_FILES['thumbnailImage']['tmp_name'], WPSC_THUMBNAIL_DIR.$_FILES['thumbnailImage']['name'],null,null,$imagefield); $thumbnail_image = $image; $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `thumbnail_image` = '".$thumbnail_image."' WHERE `id` = '".$image_data['id']."'"); $stat = stat( dirname( (WPSC_THUMBNAIL_DIR.$image_data['image']) )); $perms = $stat['mode'] & 0000770; @ chmod( (WPSC_THUMBNAIL_DIR.$image_data['image']), $perms ); } $image = false; } return $image; } function wpsc_item_process_file($mode = 'add') { global $wpdb; $files = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}product_files ORDER BY id ASC", ARRAY_A); if (is_array($files)){ foreach($files as $file){ $file_names[] = $file['filename']; $file_hashes[] = $file['idhash']; } } if(apply_filters( 'wpsc_filter_file', $_FILES['file']['tmp_name'] )) { // initialise $idhash to null to prevent issues with undefined variables and error logs $idhash = null; switch($mode) { case 'edit': /* if we are editing, grab the current file and ID hash */ $product_id = $_POST['prodid']; $fileid_data = $wpdb->get_results("SELECT `file` FROM `".$wpdb->prefix."product_list` WHERE `id` = '$product_id' LIMIT 1",ARRAY_A); case 'add': default: /* if we are adding, make a new file row and get the ID of it */ $timestamp = time(); $query_results = $wpdb->query("INSERT INTO `".$wpdb->prefix."product_files` ( `filename` , `mimetype` , `idhash` , `date` ) VALUES ( '', '', '', '$timestamp');"); $fileid = $wpdb->get_var("SELECT LAST_INSERT_ID() FROM `".$wpdb->prefix."product_files`"); break; } /* if there is no idhash, generate it */ if($idhash == null) { $idhash = sha1($fileid); if($idhash == '') { // if sha1 doesnt spit an error, but doesnt return anything either (it has done so on some servers) $idhash = md5($fileid); } } // if needed, we can add code here to stop hash doubleups in the unlikely event that they shoud occur $mimetype = wpsc_get_mimetype($_FILES['file']['tmp_name']); $filename = basename($_FILES['file']['name']); if (in_array($_FILES['file']['name'],(array)$file_names)){ $i=0; $new_name = $_FILES['file']['name'].".old"; while(file_exists(WPSC_FILE_DIR.$new_name)){ $new_name = $_FILES['file']['name'].".old_".$i; $i++; } $old_idhash_id = array_search($_FILES['file']['name'],(array)$file_names); $old_idhash = $file_hashes[$old_idhash_id]; while(!file_exists(WPSC_FILE_DIR.$old_idhash)){ unset($file_hashes[$old_idhash_id]); unset($file_names[$old_idhash_id]); $old_idhash_id = array_search($_FILES['file']['name'],(array)$file_names); $old_idhash = $file_hashes[$old_idhash_id]; } copy(WPSC_FILE_DIR.$old_idhash, WPSC_FILE_DIR.$new_name); unlink(WPSC_FILE_DIR.$old_idhash); } if(move_uploaded_file($_FILES['file']['tmp_name'],(WPSC_FILE_DIR.$idhash))) { $stat = stat( dirname( (WPSC_FILE_DIR.$idhash) )); $perms = $stat['mode'] & 0000666; @ chmod( (WPSC_FILE_DIR.$idhash), $perms ); if(function_exists("make_mp3_preview")) { if($mimetype == "audio/mpeg" && (!isset($_FILES['preview_file']['tmp_name']))) { // if we can generate a preview file, generate it (most can't due to sox being rare on servers and sox with MP3 support being even rarer), thus this needs to be enabled by editing code make_mp3_preview((WPSC_FILE_DIR.$idhash), (WPSC_PREVIEW_DIR.$idhash.".mp3")); $preview_filepath = (WPSC_PREVIEW_DIR.$idhash.".mp3"); } else if(file_exists($_FILES['preview_file']['tmp_name'])) { $preview_filename = basename($_FILES['preview_file']['name']); $preview_mimetype = wpsc_get_mimetype($_FILES['preview_file']['tmp_name']); copy($_FILES['preview_file']['tmp_name'], (WPSC_PREVIEW_DIR.$preview_filename)); $preview_filepath = (WPSC_PREVIEW_DIR.$preview_filename); $wpdb->query("UPDATE `".$wpdb->prefix."product_files` SET `preview` = '".$wpdb->escape($preview_filename)."', `preview_mimetype` = '".$preview_mimetype."' WHERE `id` = '$fileid' LIMIT 1"); } $stat = stat( dirname($preview_filepath)); $perms = $stat['mode'] & 0000666; @ chmod( $preview_filepath, $perms ); } $wpdb->query("UPDATE `".$wpdb->prefix."product_files` SET `filename` = '".$wpdb->escape($filename)."', `mimetype` = '$mimetype', `idhash` = '$idhash' WHERE `id` = '$fileid' LIMIT 1"); } if($mode == 'edit') { //if we are editing, update the file ID in the product row, this cannot be done for add because the row does not exist yet. $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `file` = '$fileid' WHERE `id` = '$product_id' LIMIT 1"); } return $fileid; } else { return false; } } function wpsc_item_reassign_file($selected_product_file, $mode = 'add') { global $wpdb; // initialise $idhash to null to prevent issues with undefined variables and error logs $idhash = null; if($mode == 'edit') { /* if we are editing, grab the current file and ID hash */ $product_id = (int)$_POST['prodid']; if($selected_product_file == '.none.') { // unlikely that anyone will ever upload a file called .none., so its the value used to signify clearing the product association $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `file` = '0' WHERE `id` = '$product_id' LIMIT 1"); return null; } // if we already use this file, there is no point doing anything more. $current_fileid = $wpdb->get_var("SELECT `file` FROM `".$wpdb->prefix."product_list` WHERE `id` = '$product_id' LIMIT 1",ARRAY_A); if($current_fileid > 0) { $current_file_data = $wpdb->get_row("SELECT `id`,`idhash` FROM `".$wpdb->prefix."product_files` WHERE `id` = '$current_fileid' LIMIT 1",ARRAY_A); if(basename($selected_product_file) == $file_data['idhash']) { return $current_fileid; } } } $selected_product_file = basename($selected_product_file); if(file_exists(WPSC_FILE_DIR.$selected_product_file)) { $timestamp = time(); $file_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."product_files` WHERE `idhash` IN('".$wpdb->escape($selected_product_file)."') LIMIT 1", ARRAY_A); $fileid = (int)$file_data['id']; if($fileid < 1) { // if the file does not have a database row, add one. $mimetype = wpsc_get_mimetype(WPSC_FILE_DIR.$selected_product_file); $filename = $idhash = $selected_product_file; $timestamp = time(); $wpdb->query("INSERT INTO `{$wpdb->prefix}product_files` ( `filename` , `mimetype` , `idhash` , `date` ) VALUES ( '{$filename}', '{$mimetype}', '{$idhash}', '{$timestamp}');"); $fileid = $wpdb->get_var("SELECT `id` FROM `".$wpdb->prefix."product_files` WHERE `date` = '{$timestamp}' AND `filename` IN ('{$filename}')"); } if($mode == 'edit') { //if we are editing, update the file ID in the product row, this cannot be done for add because the row does not exist yet. $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `file` = '$fileid' WHERE `id` = '$product_id' LIMIT 1"); } } return $fileid; } function wpsc_get_mimetype($file, $check_reliability = false) { // Sometimes we need to know how useless the result from this is, hence the "check_reliability" parameter if(file_exists($file)) { if(function_exists('finfo_open') && function_exists('finfo_file')) { // fileinfo apparently works best, wish it was included with PHP by default $finfo_handle = finfo_open(FILEINFO_MIME); $mimetype = finfo_file($finfo_handle,$file); $is_reliable = true; } else if(function_exists('mime_content_type')) { //obsolete, but probably second best due to completeness $mimetype = mime_content_type($file); $is_reliable = true; } else { //included with plugin, uses the extention, limited and odd list, last option $mimetype_class = new mimetype(); $mimetype = $mimetype_class->getType($file); $is_reliable = false; } } else { $mimetype = false; $is_reliable = false; } if($check_reliability == true) { return array('mime_type' =>$mimetype, 'is_reliable' => $is_reliable ); } else { return $mimetype; } } function shopping_cart_total_weight(){ global $wpdb; $cart = $_SESSION['nzshpcrt_cart']; $total_weight=0; foreach((array)$cart as $item) { $sql="SELECT weight, weight_unit FROM ".$wpdb->prefix."product_list WHERE id='".$item->product_id."'"; $weight=$wpdb->get_results($sql, ARRAY_A); $weight = $weight[0]; switch($weight['weight_unit']) { case "kilogram": $weight = $weight['weight'] / 0.45359237; break; case "gram": $weight = $weight['weight'] / 453.59237; break; case "once": case "ounces": $weight = $weight['weight'] / 16; break; default: $weight = $weight['weight']; break; } $subweight = $weight*$item->quantity; $total_weight+=$subweight; } return $total_weight; } function usps_shipping_methods() { /// this section of code needs to be tidied up and all references to "ereg" changed to "preg_match" or similar. global $wpdb; if(function_exists('curl_init')) { echo "
\n\r"; $dest = $_SESSION['delivery_country']; if ($dest == get_option('base_country')) { // $request = ''; // $allowed_types = explode(", ", MODULE_SHIPPING_USPS_TYPES); // // while (list($key, $value) = each($this->types)) { // if ( !in_array($key, $allowed_types) ) continue; // // if ($key == 'FIRST CLASS'){ // $this->FirstClassMailType = 'LETTER'; // } else { // $this->FirstClassMailType = ''; // } // // if ($key == 'PRIORITY'){ // $this->container = 'FLAT RATE ENVELOPE'; // } // // if ($key == 'EXPRESS'){ // $this->container = 'FLAT RATE ENVELOPE'; // } // // if ($key == 'PARCEL POST'){ // $this->container = 'REGULAR'; // $this->machinable = 'false'; // } // // $request .= '' . // '' . $key . '' . // $this->FirstClassMailType . // '' . SHIPPING_ORIGIN_ZIP . '' . // '' . $dest_zip . '' . // '' . $this->pounds . '' . // '' . $this->ounces . '' . // '' . $this->container . '' . // '' . $this->size . '' . // '' . $this->machinable . '' . // ''; // // if ($transit) { // $transitreq = 'USERID="' . MODULE_SHIPPING_USPS_USERID . // '" PASSWORD="' . MODULE_SHIPPING_USPS_PASSWORD . '">' . // '' . STORE_ORIGIN_ZIP . '' . // '' . $dest_zip . ''; // // switch ($key) { // case 'EXPRESS': $transreq[$key] = 'API=ExpressMail&XML=' . // urlencode( ''); // break; // case 'PRIORITY': $transreq[$key] = 'API=PriorityMail&XML=' . // urlencode( ''); // break; // case 'PARCEL': $transreq[$key] = 'API=StandardB&XML=' . // urlencode( ''); // break; // default: $transreq[$key] = ''; // break; // } // } // // $services_count++; // } // $request .= ''; //''; //Changed by Greg Deeth April 30, 2008 // $request = 'API=RateV3&XML=' . urlencode($request); } else { $dest=$wpdb->get_var("SELECT country FROM ".$wpdb->prefix."currency_list WHERE isocode='".$dest."'"); $weight = shopping_cart_total_weight(); $request = '' . '' . '' . $weight . '' . '' . '0' . '' . 'Package' . '' . $dest . '' . '' . ''; $request = 'API=IntlRate&XML=' . urlencode($request); } //$http = new httpClient(); $usps_server = 'production.shippingapis.com'; //'stg-production.shippingapis.com'; // or stg-secure.shippingapis.com //'production.shippingapis.com'; $api_dll = 'shippingapi.dll'; //'shippingapi.dll'; //if ($http->Connect($usps_server, 80)) { $url = 'http://'.$usps_server.'/' . $api_dll . '?' . $request; $ch=curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_NOPROGRESS, 1); curl_setopt($ch, CURLOPT_VERBOSE, 1); curl_setopt($ch, CURLOPT_FOLLOWLOCATION,1); curl_setopt($ch, CURLOPT_TIMEOUT, 120); curl_setopt($ch, CURLOPT_USERAGENT, 'osCommerce'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $body = curl_exec($ch); //$error = curl_error($ch); curl_close($ch); // $http->addHeader('Host', $usps_server); // $http->addHeader('User-Agent', 'osCommerce'); // $http->addHeader('Connection', 'Close'); //if ($http->Get('/' . $api_dll . '?' . $request)) $body = $http->getBody(); // if ($transit && is_array($transreq) && ($order->delivery['country']['id'] == STORE_COUNTRY)) { // while (list($key, $value) = each($transreq)) { // if ($http->Get('/' . $api_dll . '?' . $value)) $transresp[$key] = $http->getBody(); // } // } //$http->Disconnect(); if($body == '') { //return false; } $response=array(); while (true) { if ($start = strpos($body, ''); $response[] = substr($body, 0, $end+10); $body = substr($body, $end+9); } else { break; } } $rates = array(); if ($dest == get_option('base_country')) { if (sizeof($response) == '1') { if (ereg('', $response[0])) { $number = ereg('(.*)', $response[0], $regs); $number = $regs[1]; $description = ereg('(.*)', $response[0], $regs); $description = $regs[1]; //return array('error' => $number . ' - ' . $description); } } $n = sizeof($response); for ($i=0; $i<$n; $i++) { if (strpos($response[$i], '')) { $service = ereg('(.*)', $response[$i], $regs); $service = $regs[1]; $postage = ereg('(.*)', $response[$i], $regs); $postage = $regs[1]; $rates[] = array($service => $postage); if ($transit) { switch ($service) { case 'EXPRESS': $time = ereg('(.*)', $transresp[$service], $tregs); $time = $tregs[1]; if ($time == '' || $time == 'No Data') { $time = 'Estimated 1 - 2 ' . 'Days'; } else { $time = 'Tomorrow by ' . $time; } break; case 'PRIORITY': $time = ereg('(.*)', $transresp[$service], $tregs); $time = $tregs[1]; if ($time == '' || $time == 'No Data') { $time = 'Estimated 1 - 3 ' . 'Days'; } elseif ($time == '1') { $time .= ' ' . 'Day'; } else { $time .= ' ' . 'Days'; } break; case 'PARCEL': $time = ereg('(.*)', $transresp[$service], $tregs); $time = $tregs[1]; if ($time == '' || $time == 'No Data') { $time = 'Estimated 2 - 9 ' . 'Days'; } elseif ($time == '1') { $time .= ' ' . 'Day'; } else { $time .= ' ' . 'Days'; } break; case 'First-Class Mail': $time = 'Estimated 1 - 5 ' . 'Days'; break; case 'MEDIA': $time = 'Estimated 2 - 9 ' . 'Days'; break; case 'BPM': $time = 'Estimated 2 - 9 ' . 'Days'; break; default: $time = ''; break; } if ($time != '') $transittime[$service] = ': ' . $time . ''; } } } } else { if (ereg('', $response[0])) { $number = ereg('(.*)', $response[0], $regs); $number = $regs[1]; $description = ereg('(.*)', $response[0], $regs); $description = $regs[1]; return array('error' => $number . ' - ' . $description); } else { $body = $response[0]; $services = array(); while (true) { if ($start = strpos($body, ''); $services[] = substr($body, 0, $end+10); $body = substr($body, $end+9); } else { break; } } $allowed_types = Array( 'EXPRESS MAIL INT' => "Express Mail International (EMS)", 'EXPRESS MAIL INT FLAT RATE ENV' => "Express Mail International (EMS) Flat-Rate Envelope", 'PRIORITY MAIL INT' => "Priority Mail International", 'PRIORITY MAIL INT FLAT RATE ENV' => "Priority Mail International Flat-Rate Envelope", 'PRIORITY MAIL INT FLAT RATE BOX' => "Priority Mail International Flat-Rate Box", 'FIRST-CLASS MAIL INT' => "First Class Mail International Letters" ); //foreach( explode(", ", MODULE_SHIPPING_USPS_TYPES_INTL) as $value ) $allowed_types[$value] = $this->intl_types[$value]; $size = sizeof($services); for ($i=0, $n=$size; $i<$n; $i++) { if (strpos($services[$i], '')) { $service = ereg('(.*)', $services[$i], $regs); $service = $regs[1]; $postage = ereg('(.*)', $services[$i], $regs); $postage = $regs[1]; $time = ereg('(.*)', $services[$i], $tregs); $time = $tregs[1]; $time = preg_replace('/Weeks$/', 'Weeks',$time); $time = preg_replace('/Days$/', 'Days', $time); $time = preg_replace('/Day$/', 'Day', $time); if( !in_array($service, $allowed_types) ) continue; // if (isset($this->service) && ($service != $this->service) ) { // continue; // } $rates[] = array($service => $postage); if ($time != '') $transittime[$service] = ' (' . $time . ')'; } } $uspsQuote=$rates; } } // usps changes ends echo "
"; } } function wpsc_ping() { $services = get_option('ping_sites'); $services = explode("\n", $services); foreach ( (array) $services as $service ) { $service = trim($service); if($service != '' ) { wpsc_send_ping($service); } } } function wpsc_send_ping($server) { global $wp_version; include_once(ABSPATH . WPINC . '/class-IXR.php'); // using a timeout of 3 seconds should be enough to cover slow servers $client = new IXR_Client($server, ((!strlen(trim($path)) || ('/' == $path)) ? false : $path)); $client->timeout = 3; $client->useragent .= ' -- WordPress/'.$wp_version; // when set to true, this outputs debug messages by itself $client->debug = false; $home = trailingslashit( get_option('product_list_url') ); $rss_url = get_option('siteurl')."/index.php?rss=true&action=product_list"; if ( !$client->query('weblogUpdates.extendedPing', get_option('blogname'), $home, $rss_url ) ) { $client->query('weblogUpdates.ping', get_option('blogname'), $home); } } function wpsc_add_product($product_values) { global $wpdb; // takes an array, inserts it into the database as a product $success = false; $insertsql = "INSERT INTO `".$wpdb->prefix."product_list` SET"; $insertsql .= "`name` = '".$wpdb->escape($product_values['name'])."',"; $insertsql .= "`description` = '".$wpdb->escape($product_values['description'])."',"; $insertsql .= "`additional_description` = '".$wpdb->escape($product_values['additional_description'])."',"; $insertsql .= "`price` = '".$wpdb->escape($product_values['price'])."',"; $insertsql .= "`quantity_limited` = '".$wpdb->escape($product_values['quantity_limited'])."',"; $insertsql .= "`quantity` = '".$wpdb->escape($product_values['quantity'])."',"; $insertsql .= "`special` = '".$wpdb->escape($product_values['special'])."',"; $insertsql .= "`special_price` = '".$wpdb->escape($product_values['special_price'])."',"; $insertsql .= "`weight` = '".$wpdb->escape($product_values['weight'])."',"; $insertsql .= "`weight_unit` = '".$wpdb->escape($product_values['weight_unit'])."',"; $insertsql .= "`no_shipping` = '".$wpdb->escape($product_values['no_shipping'])."',"; $insertsql .= "`pnp` = '".$wpdb->escape($product_values['pnp'])."',"; $insertsql .= "`international_pnp` = '".$wpdb->escape($product_values['international_pnp'])."',"; $insertsql .= "`donation` = '".$wpdb->escape($product_values['donation'])."',"; $insertsql .= "`display_frontpage` = '".$wpdb->escape($product_values['display_frontpage'])."',"; $insertsql .= "`notax` = '".$wpdb->escape($product_values['notax'])."',"; $insertsql .= "`image` = '0',"; $insertsql .= "`file` = '0',"; $insertsql .= "`thumbnail_state` = '0' ;"; //Insert the data if($wpdb->query($insertsql)) { // if we succeeded, we have a product id, we wants it for the next stuff $product_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `".$wpdb->prefix."product_list` LIMIT 1"); // add the tags if(function_exists('wp_insert_term')) { product_tag_init(); $tags = $product_values['product_tag']; if ($tags!="") { $tags = explode(',',$tags); foreach($tags as $tag) { $tt = wp_insert_term((string)$tag, 'product_tag'); } $return = wp_set_object_terms($product_id, $tags, 'product_tag'); } } $image = wpsc_item_process_image($product_id, $product_values['image_path'], basename($product_values['image_path']), $product_values['width'], $product_values['height'], $product_values['image_resize']); if(($image != null)) { $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `image` = '".$wpdb->escape($image)."' WHERE `id`='".$product_id."' LIMIT 1"); } // add the product meta values if($product_values['productmeta_values'] != null) { foreach((array)$product_values['productmeta_values'] as $key => $value) { if(get_product_meta($product_id, $key) != false) { update_product_meta($product_id, $key, $value); } else { add_product_meta($product_id, $key, $value); } } } // and the custom meta values if($product_values['new_custom_meta'] != null) { foreach((array)$product_values['new_custom_meta']['name'] as $key => $name) { $value = $product_values['new_custom_meta']['value'][(int)$key]; if(($name != '') && ($value != '')) { add_product_meta($product_id, $name, $value, false, true); } } } // Add the tidy url name $tidied_name = trim($product_values['name']); $tidied_name = strtolower($tidied_name); $url_name = preg_replace(array("/(\s)+/","/[^\w-]+/i"), array("-", ''), $tidied_name); $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`meta_value`, '".$wpdb->escape($url_name)."', '')) AS `max_number` FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `meta_key` IN ('url_name') AND `meta_value` REGEXP '^(".$wpdb->escape($url_name)."){1}(\d)*$' ",ARRAY_A); $extension_number = ''; if($similar_names['count'] > 0) { $extension_number = (int)$similar_names['max_number']+1; } $url_name .= $extension_number; add_product_meta($product_id, 'url_name', $url_name,true); // Add the varations and associated values $variations_procesor = new nzshpcrt_variations; if($product_values['variation_values'] != null) { $variations_procesor->add_to_existing_product($product_id,$product_values['variation_values']); } if($product_values['variation_priceandstock'] != null) { $variations_procesor->update_variation_values($product_id, $product_values['variation_priceandstock']); } // Add the selelcted categories $item_list = ''; if(count($product_values['category']) > 0) { foreach($product_values['category'] as $category_id) { $category_id = (int)$category_id; $check_existing = $wpdb->get_var("SELECT `id` FROM `".$wpdb->prefix."item_category_associations` WHERE `product_id` = ".$product_id." AND `category_id` = '$category_id' LIMIT 1"); if($check_existing == null) { $wpdb->query("INSERT INTO `".$wpdb->prefix."item_category_associations` ( `product_id` , `category_id` ) VALUES ( '".$product_id."', '".$category_id."');"); } } } $success = true; } return $success; } function wpsc_sanitise_keys($value) { /// Function used to cast array items to integer. return (int)$value; } ?>