function wpsc_delete_images() { global $wpdb; $product_id = absint($_POST['product_id']); $element_id = $_POST['del_img_id']; $image_id = absint(str_replace("product_image_", '', $element_id)); if ($image_id > 0) { $deletion_success = $wpdb->query("DELETE FROM `" . WPSC_TABLE_PRODUCT_IMAGES . "` WHERE `id`='{$image_id}' LIMIT 1"); echo "element_id = '{$element_id}';\n"; //echo "/*\n"; //print_r($deletion_success); //echo "*/\n"; if ($product_id > 0 && $deletion_success == true) { $next_image = $wpdb->get_row("SELECT * FROM `" . WPSC_TABLE_PRODUCT_IMAGES . "` WHERE `product_id` = '{$product_id}' ORDER BY `image_order` ASC LIMIT 1", ARRAY_A); if (count($next_image) > 0) { $wpdb->query("UPDATE `" . WPSC_TABLE_PRODUCT_LIST . "` SET `image` = '{$next_image['id']}' WHERE `id` = '{$product_id}' LIMIT 1"); $output = wpsc_main_product_image_menu($product_id); $height = get_option('product_image_height'); $width = get_option('product_image_width'); $image_input = WPSC_IMAGE_DIR . $next_image['file']; $image_output = WPSC_THUMBNAIL_DIR . $next_image['file']; if ($product['file'] != '' and file_exists($image_input)) { image_processing($image_input, $image_output, $width, $height); update_product_meta($product_id, 'thumbnail_width', $width); update_product_meta($product_id, 'thumbnail_height', $height); } echo "image_menu='" . str_replace(array("\n", "\r"), array('\\n', '\\r'), addslashes($output)) . "';\n"; echo "image_id='" . $next_image['id'] . "';\n"; } else { $wpdb->query("UPDATE `" . WPSC_TABLE_PRODUCT_LIST . "` SET `image` = NULL WHERE `id` = '{$product_id}' LIMIT 1"); } } } exit; }
function wpsc_rearrange_images() { global $wpdb; $images = explode(",", $_POST['order']); $product_id = absint($_POST['product_id']); $timestamp = time(); $new_main_image = null; $have_set_first_item = false; $i = 0; foreach ($images as $image) { if ($image > 0) { $wpdb->update($wpdb->posts, array('menu_order' => $i), array('ID' => $image), '%d', '%d'); $i++; } } $output = wpsc_main_product_image_menu($product_id); echo "image_menu = '';\n\r"; echo "image_id = '" . $new_main_image . "';\n\r"; exit; }
function edit_multiple_image_gallery($product_data) { global $wpdb; $siteurl = get_option('siteurl'); if ($product_data['id'] > 0) { $main_image = $wpdb->get_row("SELECT `images`.* FROM `" . WPSC_TABLE_PRODUCT_IMAGES . "` AS `images` JOIN `" . WPSC_TABLE_PRODUCT_LIST . "` AS `product` ON `product`.`image` = `images`.`id` WHERE `product`.`id` = '{$product_data['id']}' LIMIT 1", ARRAY_A); } $timestamp = time(); ?> <ul id="gallery_list" class="ui-sortable" style="position: relative;"> <li class='first gallery_image' id='product_image_<?php echo $main_image['id']; ?> '> <input type='hidden' name='gallery_product_id[]' class='image-id' value='<?php echo $main_image['id']; ?> ' /> <div class='previewimage' id='gallery_image_<?php echo $main_image['id']; ?> '> <?php if ($main_image['image'] != '') { ?> <?php $image_data = getimagesize(WPSC_IMAGE_DIR . $main_image['image']); ?> <a id='extra_preview_link_0' href='' title='' rel='product_extra_image_0' > <img class='previewimage' onclick='return false;' src='<?php echo WPSC_IMAGE_URL . $main_image['image']; ?> ' alt='<?php echo TXT_WPSC_PREVIEW; ?> ' title='<?php echo TXT_WPSC_PREVIEW; ?> ' /> </a> <?php } ?> <?php echo wpsc_main_product_image_menu($product_data['id']); ?> </div> </li> <?php $num = 0; if (function_exists('gold_shpcrt_display_gallery') && $product_data['id'] > 0) { $values = $wpdb->get_results("SELECT * FROM `" . WPSC_TABLE_PRODUCT_IMAGES . "` WHERE `product_id` = '{$product_data['id']}' AND `id` NOT IN ('{$main_image['id']}') ORDER BY CAST(`image_order` AS SIGNED INT) ASC", ARRAY_A); //echo "<pre>".print_r($values,true)."</pre>"; if ($values != null) { foreach ($values as $image) { if (function_exists("getimagesize")) { if ($image['image'] != '') { $num++; $imagepath = WPSC_IMAGE_DIR . $image['image']; $image_data = getimagesize(WPSC_IMAGE_DIR . $image['image']); ?> <li id="product_image_<?php echo $image['id']; ?> " class='gallery_image'> <input type='hidden' class='image-id' name='gallery_image_id[]' value='<?php echo $image['id']; ?> ' /> <div class='previewimage' id='gallery_image_<?php echo $image['id']; ?> '> <a id='extra_preview_link_<?php echo $image['id']; ?> ' onclick='return false;' href='' rel='product_extra_image_<?php echo $image['id']; ?> ' > <img class='previewimage' src='<?php echo WPSC_IMAGE_URL . $image['image']; ?> ' alt='<?php echo TXT_WPSC_PREVIEW; ?> ' title='<?php echo TXT_WPSC_PREVIEW; ?> ' /> </a> <img alt='-' class='deleteButton' src='<?php echo WPSC_URL; ?> /images/cross.png' /> </div> </li> <?php } } } } } ?> </ul> <?php //return $output; }
function wpsc_rearrange_images() { global $wpdb; $images = explode(",", $_POST['order']); $product_id = absint($_POST['product_id']); $timestamp = time(); $new_main_image = null; $have_set_first_item = false; $i = 0; foreach ($images as $image) { if ($image > 0) { $wpdb->query($wpdb->prepare("UPDATE `{$wpdb->posts}` SET `menu_order`='%d' WHERE `ID`='%d' LIMIT 1", $i, $image)); $i++; } } $output = wpsc_main_product_image_menu($product_id); echo "image_menu = '';\n\r"; echo "image_id = '" . $new_main_image . "';\n\r"; exit; }