} else {
        //Fall back if no multi-image data
        $products_query = olc_db_query($products_query_sql);
        $products_values = olc_db_fetch_array($products_query);
    }
}
// get x and y of the image
$products_image = $products_values['products_image'];
$img = DIR_WS_POPUP_IMAGES . $products_image;
$osize = GetImageSize($img);
$obwidth = $osize[0];
$oheight = $osize[1];
$bwidth = obwidth;
$bheight = $oheight;
//get data for mo_images
$mo_images = olc_get_products_mo_images($pID);
if (isset($mo_images)) {
    foreach ($mo_images as $mo_img) {
        $img = DIR_WS_POPUP_IMAGES . $mo_img['image_name'];
        $mo_size = GetImageSize($img);
        if ($mo_size[0] > $bwidth) {
            $bwidth = $mo_size[0];
        }
        if ($mo_size[1] > $bheight) {
            $bheight = $mo_size[1];
        }
    }
    $bheight += 50;
}
include DIR_WS_INCLUDES . 'header.php';
$products_name = $products_values['products_name'];
if ($_GET['action'] == 'new_product') {
    // display images fields:
    echo '<tr><td colspan="4">' . olc_draw_separator('pixel_trans.gif', '1', '10') . '</td></tr>';
    if ($pInfo->products_image) {
        echo '<tr><td colspan="4"><table><tr><td align="center" class="main" width="' . (PRODUCT_IMAGE_THUMBNAIL_WIDTH + 15) . '">' . olc_image(DIR_WS_CATALOG_THUMBNAIL_IMAGES . $pInfo->products_image, 'Standard Image') . '</td>';
    }
    $products_previous_image = 'products_previous_image_';
    echo '<td class="main">' . TEXT_PRODUCTS_IMAGE . HTML_BR . olc_draw_file_field('products_image') . HTML_BR . olc_draw_separator('pixel_trans.gif', '24', '15') . HTML_NBSP . $pInfo->products_image . olc_draw_hidden_field($products_previous_image . '0', $pInfo->products_image);
    if ($pInfo->products_image) {
        echo '</td></tr></table>';
    } else {
        echo '</td></tr>';
    }
    // display MO PICS
    if (MO_PICS > 0) {
        $mo_images = olc_get_products_mo_images($pInfo->products_id);
        for ($i = 0; $i < MO_PICS; $i++) {
            echo '<tr><td colspan="4">' . olc_draw_separator('pixel_black.gif', '100%', '1') . '</td></tr>';
            echo '<tr><td colspan="4">' . olc_draw_separator('pixel_trans.gif', '1', '10') . '</td></tr>';
            $image_name = $mo_images[$i]["image_name"];
            $i1 = $i + 1;
            if ($image_name) {
                echo '<tr><td colspan="4"><table><tr><td align="center" class="main" width="' . (PRODUCT_IMAGE_THUMBNAIL_WIDTH + 15) . '">' . olc_image(DIR_WS_CATALOG_THUMBNAIL_IMAGES . $image_name, 'Image ' . $i1) . '</td>';
            } else {
                echo '<tr>';
            }
            echo '<td class="main">' . TEXT_PRODUCTS_IMAGE . BLANK . $i1 . HTML_BR . olc_draw_file_field('mo_pics_' . $i) . HTML_BR . olc_draw_separator('pixel_trans.gif', '24', '15') . HTML_NBSP . $image_name . olc_draw_hidden_field($products_previous_image . $i1, $image_name);
            if ($image_name) {
                echo '</tr><tr><td align="center" valign="middle">' . olc_draw_selection_field('del_mo_pic[]', 'checkbox', $image_name) . BLANK . TEXT_DELETE . '</td></tr></table>';
            } else {
                echo '</td></tr>';
 function duplicate_product($src_products_id, $dest_categories_id)
 {
     $product_query = xtDBquery("SELECT *\n\t\t\t\t    \t                                 FROM " . TABLE_PRODUCTS . "\n\t\t\t\t    \t                                WHERE products_id = '" . olc_db_input($src_products_id) . "'");
     $product = olc_db_fetch_array($product_query);
     if ($dest_categories_id == 0) {
         $startpage = 1;
         $products_status = 1;
     } else {
         $startpage = 0;
         $products_status = $product['products_status'];
     }
     $sql_data_array = array('products_quantity' => $product['products_quantity'], 'products_model' => $product['products_model'], 'products_ean' => $product['products_ean'], 'products_shippingtime' => $product['products_shippingtime'], 'products_sort' => $product['products_sort'], 'products_startpage' => $startpage, 'products_sort' => $product['products_sort'], 'products_price' => $product['products_price'], 'products_discount_allowed' => $product['products_discount_allowed'], 'products_date_added' => 'now()', 'products_date_available' => $product['products_date_available'], 'products_weight' => $product['products_weight'], 'products_status' => $products_status, 'products_tax_class_id' => $product['products_tax_class_id'], 'manufacturers_id' => $product['manufacturers_id'], 'product_template' => $product['product_template'], 'options_template' => $product['options_template'], 'products_fsk18' => $product['products_fsk18']);
     $customers_statuses_array = olc_get_customers_statuses();
     for ($i = 0; $n = sizeof($customers_statuses_array), $i < $n; $i++) {
         if (isset($customers_statuses_array[$i]['id'])) {
             $sql_data_array = array_merge($sql_data_array, array('group_permission_' . $customers_statuses_array[$i]['id'] => $product['group_permission_' . $customers_statuses_array[$i]['id']]));
         }
     }
     olc_db_perform(TABLE_PRODUCTS, $sql_data_array);
     //get duplicate id
     $dup_products_id = olc_db_insert_id();
     //duplicate image if there is one
     if ($product['products_image'] != '') {
         //build new image_name for duplicate
         $pname_arr = explode('.', $product['products_image']);
         $nsuffix = array_pop($pname_arr);
         $dup_products_image_name = $dup_products_id . '_0' . '.' . $nsuffix;
         //write to DB
         xtDBquery("SQL_UPDATE " . TABLE_PRODUCTS . " SET products_image = '" . $dup_products_image_name . "' WHERE products_id = '" . $dup_products_id . "'");
         @copy(DIR_FS_CATALOG_ORIGINAL_IMAGES . '/' . $product['products_image'], DIR_FS_CATALOG_ORIGINAL_IMAGES . '/' . $dup_products_image_name);
         @copy(DIR_FS_CATALOG_INFO_IMAGES . '/' . $product['products_image'], DIR_FS_CATALOG_INFO_IMAGES . '/' . $dup_products_image_name);
         @copy(DIR_FS_CATALOG_THUMBNAIL_IMAGES . '/' . $product['products_image'], DIR_FS_CATALOG_THUMBNAIL_IMAGES . '/' . $dup_products_image_name);
         @copy(DIR_FS_CATALOG_POPUP_IMAGES . '/' . $product['products_image'], DIR_FS_CATALOG_POPUP_IMAGES . '/' . $dup_products_image_name);
     } else {
         unset($dup_products_image_name);
     }
     $description_query = olc_db_query("SELECT *\n\t\t\t\t    \t                                     FROM " . TABLE_PRODUCTS_DESCRIPTION . "\n\t\t\t\t    \t                                    WHERE products_id = '" . olc_db_input($src_products_id) . "'");
     $old_products_id = olc_db_input($src_products_id);
     while ($description = olc_db_fetch_array($description_query)) {
         olc_db_query("INSERT INTO " . TABLE_PRODUCTS_DESCRIPTION . "\n\t\t\t\t\t\t    \t\t                 SET products_id                = '" . $dup_products_id . "',                                      \n\t\t\t\t\t\t    \t\t                     language_id                = '" . $description['language_id'] . "',                           \n\t\t\t\t\t\t    \t\t                     products_name              = '" . addslashes($description['products_name']) . "',             \n\t\t\t\t\t\t    \t\t                     products_description       = '" . addslashes($description['products_description']) . "',      \n\t\t\t\t\t\t    \t\t                     products_keywords          = '" . addslashes($description['products_keywords']) . "',\n\t\t\t\t\t\t    \t\t                     products_short_description = '" . addslashes($description['products_short_description']) . "',\n\t\t\t\t\t\t    \t\t                     products_meta_title        = '" . addslashes($description['products_meta_title']) . "',       \n\t\t\t\t\t\t    \t\t                     products_meta_description  = '" . addslashes($description['products_meta_description']) . "', \n\t\t\t\t\t\t    \t\t                     products_meta_keywords     = '" . addslashes($description['products_meta_keywords']) . "',    \n\t\t\t\t\t\t    \t\t                     products_url               = '" . $description['products_url'] . "',                          \n\t\t\t\t\t\t    \t\t                     products_viewed            = '0'");
     }
     olc_db_query("INSERT INTO " . TABLE_PRODUCTS_TO_CATEGORIES . "\n\t\t\t\t    \t                 SET products_id   = '" . $dup_products_id . "',\n\t\t\t\t    \t                     categories_id = '" . olc_db_input($dest_categories_id) . "'");
     //mo_images by Novalis@eXanto.de
     $mo_images = olc_get_products_mo_images($src_products_id);
     if (is_array($mo_images)) {
         foreach ($mo_images as $dummy => $mo_img) {
             //build new image_name for duplicate
             $pname_arr = explode('.', $mo_img['image_name']);
             $nsuffix = array_pop($pname_arr);
             $dup_products_image_name = $dup_products_id . '_' . $mo_img['image_nr'] . '.' . $nsuffix;
             //copy org images to duplicate
             @copy(DIR_FS_CATALOG_ORIGINAL_IMAGES . '/' . $mo_img['image_name'], DIR_FS_CATALOG_ORIGINAL_IMAGES . '/' . $dup_products_image_name);
             @copy(DIR_FS_CATALOG_INFO_IMAGES . '/' . $mo_img['image_name'], DIR_FS_CATALOG_INFO_IMAGES . '/' . $dup_products_image_name);
             @copy(DIR_FS_CATALOG_THUMBNAIL_IMAGES . '/' . $mo_img['image_name'], DIR_FS_CATALOG_THUMBNAIL_IMAGES . '/' . $dup_products_image_name);
             @copy(DIR_FS_CATALOG_POPUP_IMAGES . '/' . $mo_img['image_name'], DIR_FS_CATALOG_POPUP_IMAGES . '/' . $dup_products_image_name);
             olc_db_query("INSERT INTO " . TABLE_PRODUCTS_IMAGES . "\n\t\t\t\t\t\t\t\t    \t\t\t                 SET products_id = '" . $dup_products_id . "',\n\t\t\t\t\t\t\t\t    \t\t\t                     image_nr    = '" . $mo_img['image_nr'] . "',\n\t\t\t\t\t\t\t\t    \t\t\t                     image_name  = '" . $dup_products_image_name . "'");
         }
     }
     //mo_images EOF
     $products_id = $dup_products_id;
     $i = 0;
     $group_query = olc_db_query("SELECT customers_status_id\n\t\t\t\t    \t                               FROM " . TABLE_CUSTOMERS_STATUS . "\n\t\t\t\t    \t                              WHERE language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t    \t                                AND customers_status_id != '0'");
     while ($group_values = olc_db_fetch_array($group_query)) {
         // load data into array
         $i++;
         $group_data[$i] = array('STATUS_ID' => $group_values['customers_status_id']);
     }
     for ($col = 0, $n = sizeof($group_data); $col < $n + 1; $col++) {
         if ($group_data[$col]['STATUS_ID'] != '') {
             $copy_query = olc_db_query("SELECT quantity,\n\t\t\t\t\t\t\t\t    \t\t\t                                   personal_offer\n\t\t\t\t\t\t\t\t    \t\t\t                              FROM personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . "\n\t\t\t\t\t\t\t\t    \t\t\t                             WHERE products_id = '" . $old_products_id . "'");
             while ($copy_data = olc_db_fetch_array($copy_query)) {
                 olc_db_query("INSERT INTO personal_offers_by_customers_status_" . $group_data[$col]['STATUS_ID'] . "\n\t\t\t\t\t\t\t\t\t\t    \t\t\t\t                 SET price_id       = '',\n\t\t\t\t\t\t\t\t\t\t    \t\t\t\t                     products_id    = '" . $products_id . "',\n\t\t\t\t\t\t\t\t\t\t    \t\t\t\t                     quantity       = '" . $copy_data['quantity'] . "',\n\t\t\t\t\t\t\t\t\t\t    \t\t\t\t                     personal_offer = '" . $copy_data['personal_offer'] . "'");
             }
         }
     }
 }
 if ($image) {
     $image = DIR_WS_INFO_IMAGES . $image;
     if (!$is_pdf) {
         if ($fake_print || $is_gallery) {
             $text = EMPTY_STRING;
         } else {
             $text = TEXT_CLICK_TO_ENLARGE;
         }
         $image = olc_image($image, $text);
     }
 }
 $products_image = 'PRODUCTS_IMAGE';
 $info_smarty->assign($products_image, $image);
 //W. Kaiser	INCI-link
 //mo_images by Novalis@eXanto.de
 $mo_images = olc_get_products_mo_images($products_id);
 if (isset($mo_images)) {
     foreach ($mo_images as $img) {
         $mo_img = $img['image_name'];
         if ($mo_img) {
             $mo_img = olc_image(DIR_WS_INFO_IMAGES . $mo_img, TEXT_CLICK_TO_ENLARGE);
             //$image=str_replace(TILDE,$mo_img,$image_link0);
             $info_smarty->assign($products_image . UNDERSCORE . $img['image_nr'], $image);
         }
     }
 }
 //mo_images EOF
 if (CUSTOMER_DISCOUNT != '0.00') {
     if ($_SESSION['customers_status']['customers_status_public'] == 1) {
         $discount = CUSTOMER_DISCOUNT;
         if ($product_info['products_discount_allowed'] <= CUSTOMER_DISCOUNT) {
    Released under the GNU General Public License 
   -----------------------------------------------------------------------------------------
   Third Party contributions:
   Modified by BIA Solutions (www.biasolutions.com) to create a bordered look to the image
   (c) 2004      XT - Commerce; www.xt-commerce.com

    Released under the GNU General Public License 
   ---------------------------------------------------------------------------------------*/
require 'includes/application_top.php';
require_once DIR_FS_INC . 'olc_get_products_mo_images.inc.php';
?>

<table align="center">
<tr>
<?php 
$mo_images = olc_get_products_mo_images((int) $_GET['pID']);
if ((int) $_GET['imgID'] == 0) {
    $actual = ' bgcolor="#FF0000"';
} else {
    unset($actual);
}
echo '<td align="left"' . $actual . '>';
$products_query = olc_db_query("select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int) $_GET['pID'] . "' and pd.language_id = '" . SESSION_LANGUAGE_ID . APOS);
$products_values = olc_db_fetch_array($products_query);
echo '<a href="popup_image.php?pID=' . (int) $_GET['pID'] . '&imgID=0" target="_parent">' . olc_image(DIR_WS_THUMBNAIL_IMAGES . $products_values['products_image'], $products_values['products_name']) . HTML_A_END;
echo '</td>';
foreach ($mo_images as $mo_img) {
    if ($mo_img['image_nr'] == (int) $_GET['imgID']) {
        $actual = ' bgcolor="#FF0000"';
    } else {
        unset($actual);