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;
}
