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