".print_r($_POST,true).""); } //$variations_procesor->edit_add_product_values($_POST['prodid'],$_POST['edit_add_variation_values']); $counter = 0; $item_list = ''; if(count($_POST['category']) > 0) { foreach($_POST['category'] as $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."');"); } } } // send the pings out. wpsc_ping(); $display_added_product = "filleditform(".$product_id.");"; echo "
".TXT_WPSC_ITEMHASBEENADDED."
".TXT_WPSC_ITEMHASNOTBEENADDED."
".TXT_WPSC_MAX_PRODUCTS."
".print_r($variation_association,true).""); if($variation_association != null) { $variation_id = $variation_association['variation_id']; $delete_value_sql = "DELETE FROM `".$table_prefix."variation_values_associations` WHERE `product_id` = '$product_id' AND `variation_id` = '$variation_id'"; //exit($delete_value_sql); $wpdb->query($delete_value_sql); } echo "
".TXT_WPSC_PRODUCTHASBEENEDITED."
".print_r($_POST,true).""); $id = $_POST['prodid']; if(function_exists('edit_submit_extra_images')) { if(($_FILES['extra_image'] != null)) { $var = edit_submit_extra_images($id); } } if(function_exists('edit_extra_images')) { $var = edit_extra_images($id); } $file_name = null; if($_POST['file_url'] != null) { $url_array = array_reverse(explode("/",$_POST['file_url'])); //exit("
".print_r($url_array,true).""); if(is_file(WPSC_FILE_DIR.$url_array[0])) { $file_name = $url_array[0]; } } //written by allen if(isset($_POST['product_tags'])) { $imtags = $_POST['product_tags']; $tags = explode(',',$imtags); product_tag_init(); if(is_array($tags)) { foreach((array)$tags as $tag){ $tt = wp_insert_term((string)$tag, 'product_tag'); } } wp_set_object_terms($id, $tags, 'product_tag'); } //end of written by allen if (isset($_POST['external_link'])) { add_product_meta($_POST['prodid'], 'external_link', $_POST['external_link'],true); } if (isset($_POST['images'])) { $id = (int)$_POST['prodid']; $old_image = $wpdb->get_var("SELECT image FROM {$wpdb->prefix}product_list WHERE id='{$_POST['prodid']}'"); if ($old_image == ''){ $updatelink_sql = "UPDATE `".$wpdb->prefix."product_list` SET `image` = '{$_POST['images'][0]}' WHERE `id` = '$id'"; $updatelink_data = $wpdb->query($updatelink_sql); } } if (isset($_POST['merchant_notes'])) { $id = (int)$_POST['prodid']; $notes = $_POST['merchant_notes']; $updatelink_sql = "SELECT * FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `product_id` = '$id' AND `meta_key`='merchant_notes'"; $updatelink_data = $wpdb->get_results($updatelink_sql, ARRAY_A); if (count($updatelink_data)>0){ $updatelink_sql = "UPDATE `".$wpdb->prefix."wpsc_productmeta` SET `meta_value` = '$notes' WHERE `product_id` = '$id' AND `meta_key`='merchant_notes'"; $updatelink_data = $wpdb->query($updatelink_sql); } else { $updatelink_sql = "INSERT INTO `".$wpdb->prefix."wpsc_productmeta` (`product_id`,`meta_key`,`meta_value`) VALUES('$id','merchant_notes' ,'$notes')"; $updatelink_data = $wpdb->query($updatelink_sql); } } // if (isset($_POST['engrave'])) { // $id = $_POST['prodid']; // $engrave = $_POST['engrave']; // $updatelink_sql = "SELECT * FROM ".$wpdb->prefix."wpsc_productmeta WHERE product_id = $id AND meta_key='merchant_notes'"; // $updatelink_data = $wpdb->get_results($updatelink_sql, ARRAY_A); // if (count($updatelink_data)>0){ // $updatelink_sql = "UPDATE ".$wpdb->prefix."wpsc_productmeta SET meta_value = '$notes' WHERE product_id = $id AND meta_key='merchant_notes'"; // $updatelink_data = $wpdb->query($updatelink_sql); // } else { // $updatelink_sql = "INSERT INTO ".$wpdb->prefix."wpsc_productmeta VALUES('',$id,'merchant_notes' ,'$notes')"; // $updatelink_data = $wpdb->query($updatelink_sql); // } // } /* handle editing file uploads here */ if(!empty($_FILES['file']['name'])) { $fileid = wpsc_item_process_file('edit'); $file = $fileid; } else if (($_POST['select_product_file'] != '')) { $fileid = wpsc_item_reassign_file($_POST['select_product_file'], 'edit'); $file = $fileid; } if($_FILES['pdf'] != null) { foreach($_FILES['pdf'] as $key => $pdf){ move_uploaded_file($_FILES['pdf'][$key]['tmp_name'], WPSC_PREVIEW_DIR.$_FILES['pdf'][$key]['name']); $pdf_names[]=$_FILES['pdf'][$key]['name']; } update_product_meta($product_id,'pdf',$pdf_names); } if(file_exists($_FILES['preview_file']['tmp_name'])) { $fileid = $wpdb->get_var("SELECT `file` FROM `".$wpdb->prefix."product_list` WHERE `id` = '$id' LIMIT 1"); copy($_FILES['preview_file']['tmp_name'], (WPSC_PREVIEW_DIR.basename($_FILES['preview_file']['name']))); $mimetype = wpsc_get_mimetype(WPSC_PREVIEW_DIR.basename($_FILES['preview_file']['name'])); $wpdb->query("UPDATE `".$wpdb->prefix."product_files` SET `preview` = '".$wpdb->escape(basename($_FILES['preview_file']['name']))."', `preview_mimetype` = '".$mimetype."' WHERE `id` = '$fileid' LIMIT 1"); } /* Handle new image uploads here */ $image = wpsc_item_process_image($_POST['prodid'], $_FILES['image']['tmp_name'], $_FILES['image']['name'], $_POST['width'], $_POST['height'], $_POST['image_resize']); if(is_numeric($_POST['prodid'])) { if(($_POST['image_resize'] == 1 || $_POST['image_resize'] == 2) && ($image == '')) { /* resize the image if directed to do so and no new image is supplied */ $image_data = $wpdb->get_row("SELECT `id`,`image` FROM `".$wpdb->prefix."product_list` WHERE `id`=".$_POST['prodid']." LIMIT 1",ARRAY_A); // prevent images from being replaced by those from other products $check_multiple_use = $wpdb->get_var("SELECT COUNT(`image`) AS `count` FROM `".$wpdb->prefix."product_list` WHERE `image`='".$image_data['image']."'"); if($check_multiple_use > 1) { $new_filename = $image_data['id']."_".$image_data['image']; if(file_exists(WPSC_THUMBNAIL_DIR.$image_data['image']) && ($image_data['image'] != null)) { copy(WPSC_THUMBNAIL_DIR.$image_data['image'], WPSC_THUMBNAIL_DIR.$new_filename); } if(file_exists(WPSC_IMAGE_DIR.$image_data['image']) && ($image_data['image'] != null)) { copy(WPSC_IMAGE_DIR.$image_data['image'], WPSC_IMAGE_DIR.$new_filename); } $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `image` = '".$new_filename."' WHERE `id`='".$image_data['id']."' LIMIT 1"); $image_data = $wpdb->get_row("SELECT `id`,`image` FROM `".$wpdb->prefix."product_list` WHERE `id`=".$_POST['prodid']." LIMIT 1",ARRAY_A); } if(file_exists(WPSC_THUMBNAIL_DIR.$image_data['image']) && ($image_data['image'] != '')) { $imagepath = WPSC_IMAGE_DIR . $image_data['image']; $image_output = WPSC_THUMBNAIL_DIR . $image_data['image']; switch($_POST['image_resize']) { case 1: $height = get_option('product_image_height'); $width = get_option('product_image_width'); break; case 2: $height = $_POST['height']; $width = $_POST['width']; break; } image_processing($imagepath, $image_output, $width, $height); update_product_meta($id, 'thumbnail_width', $width); update_product_meta($id, 'thumbnail_height', $height); } } if(is_numeric($_POST['prodid'])) { $counter = 0; $item_list = ''; if(count($_POST['category']) > 0) { foreach($_POST['category'] as $category_id) { $category_id = (int)$category_id; // force it to be an integer rather than check if it is one $check_existing = $wpdb->get_var("SELECT `id` FROM `".$wpdb->prefix."item_category_associations` WHERE `product_id` = ".$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 ('".$id."', '".$category_id."');"); } if($counter > 0) { $item_list .= ", "; } $item_list .= "'".$category_id."'"; $counter++; } } else { $item_list = "'0'"; } $wpdb->query("DELETE FROM `".$wpdb->prefix."item_category_associations` WHERE `product_id`= '$id' AND `category_id` NOT IN (".$item_list.")"); } $key = Array(); if(is_numeric((int)$_POST['quantity']) && ($_POST['quantity_limited'] == "yes")){ $quantity_limited = 1; $quantity = $_POST['quantity']; } else { $quantity_limited = 0; $quantity = 0; } if($_POST['special'] == 'yes') { $special = 1; if(is_numeric($_POST['special_price'])) { $special_price = $_POST['price'] - $_POST['special_price']; } } else { $special = 0; $special_price = ''; } if($_POST['notax'] == 'yes') { $notax = 1; } else { $notax = 0; } if($_POST['display_frontpage'] == "yes") { $display_frontpage = 1; } else { $display_frontpage = 0; } if($_POST['donation'] == "yes") { $is_donation = 1; } else { $is_donation = 0; } if($_POST['no_shipping'] == "yes") { $no_shipping = 1; } else { $no_shipping = 0; } $updatesql = "UPDATE `".$wpdb->prefix."product_list` SET `name` = '".$wpdb->escape($_POST['title'])."', `description` = '".$wpdb->escape($_POST['description'])."', `additional_description` = '".$wpdb->escape($_POST['additional_description'])."', `price` = '".$wpdb->escape(str_replace(",","",$_POST['price']))."', `pnp` = '".(float)$wpdb->escape($_POST['pnp'])."', `international_pnp` = '".(float)$wpdb->escape($_POST['international_pnp'])."', `brand` = '0', quantity_limited = '".$quantity_limited."', `quantity` = '".(int)$quantity."', `special`='$special', `special_price`='$special_price', `display_frontpage`='$display_frontpage', `notax`='$notax', `donation`='$is_donation', `no_shipping` = '$no_shipping', `weight` = '".$wpdb->escape($_POST['weight'])."', `weight_unit` = '".$wpdb->escape($_POST['weight_unit'])."' WHERE `id`='".$_POST['prodid']."' LIMIT 1"; $wpdb->query($updatesql); if(($_FILES['image']['name'] != null) && ($image != null)) { $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `image` = '".$image."' WHERE `id`='".$_POST['prodid']."' LIMIT 1"); } if($_POST['productmeta_values'] != null) { foreach((array)$_POST['productmeta_values'] as $key => $value) { if(get_product_meta($_POST['prodid'], $key) != false) { update_product_meta($_POST['prodid'], $key, $value); } else { add_product_meta($_POST['prodid'], $key, $value); } } } if($_POST['new_custom_meta'] != null) { foreach((array)$_POST['new_custom_meta']['name'] as $key => $name) { $value = $_POST['new_custom_meta']['value'][(int)$key]; if(($name != '') && ($value != '')) { add_product_meta($_POST['prodid'], $name, $value, false, true); } } } if($_POST['custom_meta'] != null) { foreach((array)$_POST['custom_meta'] as $key => $values) { if(($values['name'] != '') && ($values['value'] != '')) { $wpdb->query("UPDATE `".$wpdb->prefix."wpsc_productmeta` SET `meta_key` = '".$wpdb->escape($values['name'])."', `meta_value` = '".$wpdb->escape($values['value'])."' WHERE `id` IN ('".(int)$key."')LIMIT 1 ;"); // echo "UPDATE `".$wpdb->prefix."wpsc_productmeta` SET `meta_key` = '".$wpdb->escape($values['name'])."', `meta_value` = '".$wpdb->escape($values['value'])."' WHERE `id` IN ('".(int)$key."') LIMIT 1 ;"; //add_product_meta($_POST['prodid'], $values['name'], $values['value'], false, true); } } } do_action('wpsc_product_form_submit', $product_id); /* Add or edit tidy url name */ $tidied_name = trim($_POST['title']); $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`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."wpsc_productmeta` WHERE `meta_key` IN ('url_name') AND `meta_value` REGEXP '^($url_name){1}(\d)*$' ",ARRAY_A); $extension_number = ''; if($similar_names['count'] > 0) { $extension_number = (int)$similar_names['max_number']+1; } $stored_name = get_product_meta($_POST['prodid'], 'url_name', true); if(get_product_meta($_POST['prodid'], 'url_name', true) != false) { $current_url_name = get_product_meta($_POST['prodid'], 'url_name'); if($current_url_name[0] != $url_name) { $url_name .= $extension_number; update_product_meta($_POST['prodid'], 'url_name', $url_name); } } else { $url_name .= $extension_number; add_product_meta($_POST['prodid'], 'url_name', $url_name, true); } /* update thumbnail images */ if(!($thumbnail_image == null && $_POST['image_resize'] == 3 && $_POST['current_thumbnail_image'] != null)) { if($thumbnail_image != null) { $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `thumbnail_image` = '".$thumbnail_image."' WHERE `id`='".(int)$_POST['prodid']."' LIMIT 1"); } } $thumbnail_state = $wpdb->get_var("SELECT `thumbnail_state` FROM `".$wpdb->prefix."product_list` WHERE `id`=".(int)$_POST['prodid']." LIMIT 1",ARRAY_A); $image_resize = (int)$_POST['image_resize']; if(!is_numeric($image_resize) || ($image_resize < 1)) { $image_resize = 0; } if(($image_resize == 0) && ($thumbnail_state != 0)) { $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `thumbnail_state` = '".$image_resize."' WHERE `id`='".(int)$_POST['prodid']."' LIMIT 1"); } if($_POST['deleteimage'] == 1) { $wpdb->query("UPDATE `".$wpdb->prefix."product_list` SET `image` = '' WHERE `id`='".(int)$_POST['prodid']."' LIMIT 1"); } $variations_procesor = new nzshpcrt_variations; if($_POST['variation_values'] != null) { //$variations_procesor->add_to_existing_product($_POST['prodid'],$_POST['variation_values']); } if($_POST['edit_variation_values'] != null) { $variations_procesor->edit_product_values($_POST['prodid'],$_POST['edit_variation_values']); } if($_POST['edit_add_variation_values'] != null) { $variations_procesor->edit_add_product_values($_POST['prodid'],$_POST['edit_add_variation_values']); } if($_POST['variation_priceandstock'] != null) { $variations_procesor->update_variation_values($_POST['prodid'], $_POST['variation_priceandstock']); } // send the pings out. wpsc_ping(); echo "
".TXT_WPSC_PRODUCTHASBEENEDITED."
".str_replace(":directory:","
";
}
?>
- ".implode($unwriteable_directories, "
- ")."
";
}
$baseurl = includes_url('js/tinymce');
?>
";
} else {
echo "\n\r";
if (function_exists('add_object_page')){
echo " \n\r";
echo "";
echo "";
?>
";
}
?>
\n\r";
echo "
";
echo "
"; //class postbox ends
} else {
echo "\n\r";
}
//No product closing table fix
if (($product_data_count < 1)&& (IS_WP27)){
echo "";
}
//First column ends here
echo " ".TXT_WPSC_SELECT_PRODUCT."
"; echo "";
}
echo " \n\r";
if (!function_exists('add_object_page')) {
echo "
";
echo "
"; //class inside ends
echo "\n\r";
echo "![Loading](".WPSC_URL."/images/grey-loader.gif "Loading") ";
echo "".TXT_WPSC_SELECT_PRODUCT."";
echo " | \n\r";
echo " |||||||
| \n\r"; echo TXT_WPSC_ADMIN_SEARCH_PRODUCTS.": "; echo " | \n\r"; echo "\n\r";
echo " \n\r";
echo " \n\r";
echo " \n\r";
echo " | \n\r";
echo " ||||||
| \n\r"; echo TXT_WPSC_PLEASESELECTACATEGORY.": "; echo " | \n\r"; /* echo "\n\r";
echo " \n\r";
echo topcategorylist();
*/
//echo " \n\r";
echo " ". topcategorylist() ." ";
/*
echo " | \n\r";
*/
echo " ||||||
| "; echo ""; echo " | \n\r"; echo ""; echo TXT_WPSC_NAME; echo " | \n\r"; echo ""; echo TXT_WPSC_PRICE; echo " | \n\r"; if(!is_numeric($_GET['catid'])) { echo ""; echo TXT_WPSC_CATEGORIES; echo " | \n\r"; } echo "||||
| \n\r";
}
if($product_list != null)
{
$order_number = 0;
if(is_numeric($_GET['catid'])){
echo " ";
echo " \n\r";
}
$tablei=1;
foreach($product_list as $product)
{
/*
* Creates order table entries if they are not already present
* No need for extra database queries to determine the highest order number
* anything without one is automatically at the bottom
* so anything with an order number is already processed by the time it starts adding rows
*/
if(is_numeric($_GET['catid'])){
echo " \n\r";
//echo " \n\r";
echo " \n\r";
} else {
if ($tablei==1) {
echo " \n\r";
echo "\n\r";
echo "";
} else {
echo " \n\r";
echo " \n\r";
if(!is_numeric($_GET['catid'])){
echo "\r\n";
}
echo "";
if(($product['thumbnail_image'] != null) && file_exists(WPSC_THUMBNAIL_DIR.$product['thumbnail_image'])) { // check for custom thumbnail images
echo " | ![".$product[](".WPSC_URL."/no-image-uploaded.gif "Drag to a new position"){kind=small} ";
}
echo "";
if(is_numeric($_GET['catid'])){
echo " \n\r";
} else {
echo "";
}
if(is_numeric($_GET['catid'])) {
echo " | \n\r";
}
echo "";
if ($product['name']=='') {
echo "(".TXT_WPSC_NONAME.")";
} else {
echo htmlentities(stripslashes($product['name']), ENT_QUOTES, 'UTF-8');
}
echo "";
if(is_numeric($_GET['catid'])){
echo " \n\r";
} else {
echo '';
echo "";
}
if(is_numeric($_GET['catid'])){
echo " | \n\r";
}
echo nzshpcrt_currency_display($product['price'], 1);
if(is_numeric($_GET['catid'])){
echo " \n\r";
}
if(!is_numeric($_GET['catid'])) {
echo " \n\r";
$category_list = $wpdb->get_results("SELECT `".$wpdb->prefix."product_categories`.`id`,`".$wpdb->prefix."product_categories`.`name` FROM `".$wpdb->prefix."item_category_associations` , `".$wpdb->prefix."product_categories` WHERE `".$wpdb->prefix."item_category_associations`.`product_id` IN ('".$product['id']."') AND `".$wpdb->prefix."item_category_associations`.`category_id` = `".$wpdb->prefix."product_categories`.`id` AND `".$wpdb->prefix."product_categories`.`active` IN('1')",ARRAY_A);
$i = 0;
foreach((array)$category_list as $category_row) {
if($i > 0) {
echo " | ";
}
// echo "".TXT_WPSC_EDIT."";
echo " "; } echo "".stripslashes($category_row['name']).""; $i++; } } if(!is_numeric($_GET['catid'])){ echo " | |||
| ".TXT_WPSC_SAVE_PRODUCT_ORDER." | |||||||
";
} else {
echo "";
}
$page_links = paginate_links( array(
'base' => add_query_arg( 'pnum', '%#%' ),
'format' => '',
'total' => $num_pages,
'current' => $_GET['pnum'],
'end_size' => 2, // How many numbers on either end including the end
'mid_size' => 2, // How many numbers to either side of current not including current
));
if(function_exists('add_object_page')){
echo "";
} else {
echo "";
}
echo " ";
if (!function_exists('add_object_page')){
echo "
"; //id major-publishing-actions ends
echo "";
echo $page_links;
// for ($i=0;$i<$num_pages;$i++) {
// $newpage=$_GET['pnum']+1;
// $pagenumber=$i+1;
// if (($i==$_GET['pnum']) && is_numeric($_GET['pnum'] )) {
// echo ''.$pagenumber.'';
// } else {
// echo "".$pagenumber."";
// }
// }
//
if (!isset($_GET['catid'])) {
if ($_GET['pnum']==='all') {
echo ''.TXT_WPSC_SHOWALL.'';
} else {
echo "".TXT_WPSC_SHOWALL."";
}
echo "
";
}
echo "