function display() { $customers_statuses_array = olc_get_customers_statuses(); // build Currency Select $curr = ''; $currencies = olc_db_query("SELECT code FROM " . TABLE_CURRENCIES); while ($currencies_data = olc_db_fetch_array($currencies)) { $curr .= olc_draw_radio_field('currencies', $currencies_data['code'], true) . $currencies_data['code'] . HTML_BR; } return array('text' => EXPORT_STATUS_TYPE . HTML_BR . EXPORT_STATUS . HTML_BR . olc_draw_pull_down_menu('status', $customers_statuses_array, '1') . HTML_BR . CURRENCY . HTML_BR . CURRENCY_DESC . HTML_BR . $curr . EXPORT_TYPE . HTML_BR . EXPORT . HTML_BR . olc_draw_radio_field('export', 'no', false) . EXPORT_NO . HTML_BR . olc_draw_radio_field('export', 'yes', true) . EXPORT_YES . HTML_BR . HTML_BR . olc_image_submit('button_export.gif', IMAGE_UPDATE) . HTML_A_START . olc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=preistrend') . '">' . olc_image_button('button_cancel.gif', IMAGE_CANCEL) . HTML_A_END); }
<?php } } ?> </table> <?php break; // end default page // end default page case 'edit': $newsletters_query = olc_db_query("SELECT\n title,body,cc\n FROM " . TABLE_MODULE_NEWSLETTER . "\n WHERE newsletter_id='" . $id_get . APOS); $newsletters_data = olc_db_fetch_array($newsletters_query); case 'safe': case 'new': // action for NEW newsletter! $customers_status = olc_get_customers_statuses(); echo olc_draw_form('edit_newsletter', FILENAME_MODULE_NEWSLETTER, 'action=save', 'post') . olc_draw_hidden_field('id', $id_get); ?> <br/><br/> <table class="main" width="100%" border="0"> <tr> <td width="10%"><?php echo TEXT_TITLE; ?> </td> <td width="90%"> <?php echo olc_draw_textarea_field('title', 'soft', '100%', '3', $newsletters_data['title']); ?> </td> </tr>
-------------------------------------------------------------- based on: (c) 2000-2001 The Exchange Project (earlier name of osCommerce) (c) 2002-2003 osCommerce(customers.php,v 1.76 2003/05/04); www.oscommerce.com (c) 2003 nextcommerce (create_account.php,v 1.17 2003/08/24); www.nextcommerce.org (c) 2004 XT - Commerce; www.xt-commerce.com Released under the GNU General Public License -------------------------------------------------------------- Third Party contribution: Customers Status v3.x (c) 2002-2003 Copyright Elari elari@free.fr | www.unlockgsm.com/dload-osc/ | CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/elari/?sortby=date#dirlist Released under the GNU General Public License --------------------------------------------------------------*/ require_once 'includes/application_top.php'; $customers_statuses_array = olc_get_customers_statuses(); $IsCreateAccount = true; if ($_GET['action'] == 'edit') { // W. Kaiser - Common code for "create_account.php" and "customers.php" $from_table_zones = SQL_FROM . TABLE_ZONES . " where zone_country_id = '"; include DIR_FS_INC . 'olc_get_check_customer_data.inc.php'; // W. Kaiser - Common code for "create_account.php" and "customers.php" // Create insert into admin access table if admin is created. if (!$error) { olc_db_query(INSERT_INTO . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . $cc_id . "', '0', now())"); // Create eMail if ($customers_send_mail == 'yes') { $name = trim($customers_lastname . BLANK . $customers_firstname); $smarty->assign('NAME', $name); $smarty->assign('EMAIL', $customers_email_address); $smarty->assign('COMMENTS', $customers_mail_comments);
/** * Init some data * @return array */ function init($filename, $map_filename) { $this->filename = $filename; $this->map_filename = $map_filename; $this->languages = $this->get_lang(); define('LANGUAGES', count($this->languages)); define('LANGUAGE_0', $this->languages[0][ID]); define('CAT_1_QUERY', SELECT . "c.categories_id" . SQL_FROM . TABLE_CATEGORIES . " c," . TABLE_CATEGORIES_DESCRIPTION . " cd\n\t\t\tWHERE\n\t\t\tcd.categories_name='#' and\n\t\t\tcd.language_id=" . LANGUAGE_0 . " and\n\t\t\tcd.categories_id=c.categories_id and\n\t\t\tparent_id=@"); $this->tax_rates = $this->getTaxRates(); $this->mfn = $this->get_mfn(); $this->errorlog = array(); $this->Groups = olc_get_customers_statuses(); define('GROUPS', count($this->Groups)); $this->prod_desc_fields_array = array(NAME, DESC, SHORTDESC, META_TITLE, META_DESC, META_KEY, URL); if (IS_XTC) { $this->prod_desc_fields_array[] = KEYWORDS; } define('PROD_DESC_FIELDS', count($this->prod_desc_fields_array)); $this->prod_fields_array = array(0 => MODEL, 1 => EAN, 2 => STOCK, 3 => WEIGHT, 4 => STATUS, 5 => IMAGE, 6 => DISC, 7 => TAX, 8 => TAX_VALUE, 9 => PRICENOTAX, 10 => OPTTPL, 11 => FSK18, 12 => TPL, 13 => VPE, 14 => VPE_STATUS, 15 => VPE_VALUE, 16 => SHIPPING, 17 => SORTING); $this->prod_fields_is_text = array(0 => true, 1 => true, 2 => false, 3 => false, 4 => false, 5 => true, 6 => false, 7 => false, 8 => true, 9 => false, 10 => true, 11 => false, 12 => true, 13 => false, 14 => false, 15 => false, 16 => false, 17 => false); if (OL_COMMERCE) { $this->prod_fields_array = array_merge($this->prod_fields_array, array(0 => BASEPRICE_SHOW, 1 => BASEPRICE_VALUE, 2 => MIN_ORDER_QUANTITY, 3 => MIN_ORDER_VPE, 4 => UVPNOTAX)); $this->prod_fields_is_text = array_merge($this->prod_fields_array, array(0 => true, 1 => true, 2 => true, 3 => true, 4 => true)); } define('PROD_FIELDS', count($this->prod_fields_array)); $this->cat_fields_array = array(0 => CAT_HEADING_TITLE, 1 => CAT_DESCRIPTION, 2 => CAT_META_TITLE, 3 => CAT_META_DESCRIPTION, 4 => CAT_META_KEYWORDS); define('CAT_FIELDS', count($this->cat_fields_array)); define('CAT_FIELDS_2', CAT_FIELDS + 2); $this->field_index = array(); $this->new_lines_array = array("\n\r", "\r\n", "\n", "\r", chr(10), chr(13), chr(10) . chr(13), chr(13) . chr(10)); $this->fields_assoc = $this->create_field_associations(); $this->build_CatTree(); $this->time_start = time(); }
function SendProducts() { global $_GET, $LangID; if (defined('SET_TIME_LIMIT')) { @set_time_limit(0); } $schema = '<?xml version="1.0" encoding="' . CHARSET . '"?>' . "\n" . '<PRODUCTS>' . "\n"; $sql = "select products_id,products_fsk18, products_quantity, products_model, products_image, products_price, " . "products_date_added, products_last_modified, products_date_available, products_weight, " . "products_status, products_tax_class_id, manufacturers_id, products_ordered from " . TABLE_PRODUCTS; $from = olc_db_prepare_input($_GET['products_from']); $anz = olc_db_prepare_input($_GET['products_count']); if (isset($from)) { if (!isset($anz)) { $anz = 1000; } $sql .= " limit " . $from . "," . $anz; } $orders_query = olc_db_query($sql); //W. Kaiser require_once DIR_FS_INC . 'olc_image.inc.php'; require_once DIR_FS_INC . 'olc_get_customers_statuses.inc.php'; $http_catalog = HTTP_SERVER . DIR_WS_CATALOG; $deep_link = $http_catalog . $olc_filename['product_info'] . '?products_id='; while ($products = olc_db_fetch_array($orders_query)) { $products_image = $products['products_image']; $products_id = $products['products_id']; $schema .= '<PRODUCT_INFO>' . "\n" . '<PRODUCT_DATA>' . "\n" . '<PRODUCT_ID>' . $products_id . '</PRODUCT_ID>' . "\n" . '<PRODUCT_DEEPLINK>' . $deep_link . $products_id . '</PRODUCT_DEEPLINK>' . "\n" . '<PRODUCT_QUANTITY>' . $products['products_quantity'] . '</PRODUCT_QUANTITY>' . "\n" . '<PRODUCT_MODEL>' . htmlspecialchars($products['products_model']) . '</PRODUCT_MODEL>' . "\n" . '<PRODUCT_FSK18>' . htmlspecialchars($products['products_fsk18']) . '</PRODUCT_FSK18>' . "\n" . '<PRODUCT_IMAGE>' . htmlspecialchars($products_image) . '</PRODUCT_IMAGE>' . "\n"; if ($products_image) { //W. Kaiser - pictures-on-the-fly /* $schema .= '<PRODUCT_IMAGE_POPUP>'. $http_catalog.DIR_WS_POPUP_IMAGES.$products_image. '</PRODUCT_IMAGE_POPUP>'. "\n" . '<PRODUCT_IMAGE_SMALL>'. $http_catalog.DIR_WS_INFO_IMAGES.$products_image. '</PRODUCT_IMAGE_SMALL>'. "\n" . '<PRODUCT_IMAGE_THUMBNAIL>'. $http_catalog.DIR_WS_THUMBNAIL_IMAGES.$products_image. '</PRODUCT_IMAGE_THUMBNAIL>'. "\n" . '<PRODUCT_IMAGE_ORIGINAL>'. $http_catalog.DIR_WS_ORIGINAL_IMAGES.$products_image. '</PRODUCT_IMAGE_ORIGINAL>'. "\n"; */ $schema .= '<PRODUCT_IMAGE_ORIGINAL>' . olc_image($http_catalog . DIR_WS_ORIGINAL_IMAGES . $products_image) . '</PRODUCT_IMAGE_ORIGINAL>' . "\n" . '<PRODUCT_IMAGE_SMALL>' . olc_image($http_catalog . DIR_WS_INFO_IMAGES . $products_image) . '</PRODUCT_IMAGE_SMALL>' . "\n" . '<PRODUCT_IMAGE_POPUP>' . olc_image($http_catalog . DIR_WS_POPUP_IMAGES . $products_image) . '</PRODUCT_IMAGE_POPUP>' . "\n" . '<PRODUCT_IMAGE_THUMBNAIL>' . olc_image($http_catalog . DIR_WS_THUMBNAIL_IMAGES . $products_image) . '</PRODUCT_IMAGE_THUMBNAIL>' . "\n"; //W. Kaiser - pictures-on-the-fly } $schema .= '<PRODUCT_PRICE>' . $products['products_price'] . '</PRODUCT_PRICE>' . "\n"; /* Wird von CAO derzeit nicht verwendet !!! */ $customers_status = olc_get_customers_statuses(); for ($i = 1, $n = sizeof($customers_status); $i < $n; $i++) { if ($customers_status[$i]['id'] != 0) { $schema .= "<PRODUCT_GROUP_PRICES ID='" . $customers_status[$i]['id'] . "' NAME='" . $customers_status[$i]['text'] . "'>" . "\n"; $group_price_query = olc_db_query("SELECT * FROM " . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $customers_status[$i]['id'] . " WHERE products_id='" . $products_id . "'"); while ($group_price_data = olc_db_fetch_array($group_price_query)) { //if ($group_price_data['personal_offer']!='0') //{ $schema .= '<PRICE_ID>' . $group_price_data['price_id'] . '</PRICE_ID>'; $schema .= '<PRODUCT_ID>' . $group_price_data['products_id'] . '</PRODUCT_ID>'; $schema .= '<QTY>' . $group_price_data['quantity'] . '</QTY>'; $schema .= '<PRICE>' . $group_price_data['personal_offer'] . '</PRICE>'; //} } $schema .= "</PRODUCT_GROUP_PRICES>\n"; } } // products Options //W. Kaiser $products_attributes = ''; $products_options_data = array(); $products_options_array = array(); $products_attributes_query = olc_db_query("select count(*) as total\n from " . TABLE_PRODUCTS_OPTIONS . "\n popt, " . TABLE_PRODUCTS_ATTRIBUTES . "\n patrib where\n patrib.products_id='" . $products['products_id'] . "'\n and patrib.options_id = popt.products_options_id\n and popt.language_id = '" . $LangID . "'"); $products_attributes = olc_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { $products_options_name_query = olc_db_query("select distinct\n popt.products_options_id,\n popt.products_options_name\n from " . TABLE_PRODUCTS_OPTIONS . "\n popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib\n where patrib.products_id='" . $products['products_id'] . "'\n and patrib.options_id = popt.products_options_id\n and popt.language_id = '" . $LangID . "' order by popt.products_options_name"); $row = 0; $col = 0; $products_options_data = array(); while ($products_options_name = olc_db_fetch_array($products_options_name_query)) { $selected = 0; $products_options_array = array(); $products_options_data[$row] = array('NAME' => $products_options_name['products_options_name'], 'ID' => $products_options_name['products_options_id'], 'DATA' => ''); $products_options_query = olc_db_query("select\n pov.products_options_values_id,\n pov.products_options_values_name,\n pa.attributes_model,\n pa.options_values_price,\n pa.options_values_weight,\n pa.price_prefix,\n pa.weight_prefix,\n pa.attributes_stock,\n pa.attributes_model\n from " . TABLE_PRODUCTS_ATTRIBUTES . "\n pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . "\n pov\n where\n pa.products_id = '" . $products['products_id'] . "'\n and pa.options_id = '" . $products_options_name['products_options_id'] . "' and\n pa.options_values_id = pov.products_options_values_id and\n pov.language_id = '" . $LangID . "'\n order by pov.products_options_values_name"); $col = 0; while ($products_options = olc_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array) - 1]['text'] .= ' ' . $products_options['price_prefix'] . ' ' . $products_options['options_values_price'] . ' ' . $_SESSION['currency']; } $price = ''; $products_options_data[$row]['DATA'][$col] = array('ID' => $products_options['products_options_values_id'], 'TEXT' => $products_options['products_options_values_name'], 'MODEL' => $products_options['attributes_model'], 'WEIGHT' => $products_options['options_values_weight'], 'PRICE' => $products_options['options_values_price'], 'WEIGHT_PREFIX' => $products_options['weight_prefix'], 'PREFIX' => $products_options['price_prefix']); $col++; } $row++; } } if (sizeof($products_options_data) != 0) { for ($i = 0, $n = sizeof($products_options_data); $i < $n; $i++) { $schema .= "<PRODUCT_ATTRIBUTES NAME='" . $products_options_data[$i]['NAME'] . "'>"; for ($ii = 0, $nn = sizeof($products_options_data[$i]['DATA']); $ii < $nn; $ii++) { $schema .= '<OPTION>'; $schema .= '<ID>' . $products_options_data[$i]['DATA'][$ii]['ID'] . '</ID>'; $schema .= '<MODEL>' . $products_options_data[$i]['DATA'][$ii]['MODEL'] . '</MODEL>'; $schema .= '<TEXT>' . $products_options_data[$i]['DATA'][$ii]['TEXT'] . '</TEXT>'; $schema .= '<WEIGHT>' . $products_options_data[$i]['DATA'][$ii]['WEIGHT'] . '</WEIGHT>'; $schema .= '<PRICE>' . $products_options_data[$i]['DATA'][$ii]['PRICE'] . '</PRICE>'; $schema .= '<WEIGHT_PREFIX>' . $products_options_data[$i]['DATA'][$ii]['WEIGHT_PREFIX'] . '</WEIGHT_PREFIX>'; $schema .= '<PREFIX>' . $products_options_data[$i]['DATA'][$ii]['PREFIX'] . '</PREFIX>'; $schema .= '</OPTION>'; } $schema .= '</PRODUCT_ATTRIBUTES>'; } } /* End Wird zur Zeit nicht verwendet */ require_once DIR_FS_INC . 'olc_get_tax_rate.inc.php'; if (SWITCH_MWST == 'true') { // switch IDs if ($products['products_tax_class_id'] == 1) { $products['products_tax_class_id'] = 2; } else { if ($products['products_tax_class_id'] == 2) { $products['products_tax_class_id'] = 1; } } } $schema .= '<PRODUCT_WEIGHT>' . $products['products_weight'] . '</PRODUCT_WEIGHT>' . "\n" . '<PRODUCT_STATUS>' . $products['products_status'] . '</PRODUCT_STATUS>' . "\n" . '<PRODUCT_TAX_CLASS_ID>' . $products['products_tax_class_id'] . '</PRODUCT_TAX_CLASS_ID>' . "\n" . '<PRODUCT_TAX_RATE>' . olc_get_tax_rate($products['products_tax_class_id']) . '</PRODUCT_TAX_RATE>' . "\n" . '<MANUFACTURERS_ID>' . $products['manufacturers_id'] . '</MANUFACTURERS_ID>' . "\n" . '<PRODUCT_DATE_ADDED>' . $products['products_date_added'] . '</PRODUCT_DATE_ADDED>' . "\n" . '<PRODUCT_LAST_MODIFIED>' . $products['products_last_modified'] . '</PRODUCT_LAST_MODIFIED>' . "\n" . '<PRODUCT_DATE_AVAILABLE>' . $products['products_date_available'] . '</PRODUCT_DATE_AVAILABLE>' . "\n" . '<PRODUCTS_ORDERED>' . $products['products_ordered'] . '</PRODUCTS_ORDERED>' . "\n"; /* Wird von CAO derzeit nicht verwendet !!! */ $categories_query = olc_db_query("SELECT\n categories_id\n FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "\n where products_id='" . $products['products_id'] . "'"); $categories = array(); while ($categories_data = olc_db_fetch_array($categories_query)) { $categories[] = $categories_data['categories_id']; } $categories = implode(',', $categories); $schema .= '<PRODUCTS_CATEGORIES>' . $categories . '</PRODUCTS_CATEGORIES>' . "\n"; /* Ende Wird zur Zeit nicht verwendet */ $detail_query = olc_db_query("select\n products_id,\n language_id,\n products_name, " . TABLE_PRODUCTS_DESCRIPTION . ".products_description,\n products_short_description,\n products_meta_title,\n products_meta_description,\n products_meta_keywords,\n products_url,\n name as language_name, code as language_code " . "from " . TABLE_PRODUCTS_DESCRIPTION . ", " . TABLE_LANGUAGES . " " . "where " . TABLE_PRODUCTS_DESCRIPTION . ".language_id=" . TABLE_LANGUAGES . ".languages_id " . "and " . TABLE_PRODUCTS_DESCRIPTION . ".products_id=" . $products['products_id']); while ($details = olc_db_fetch_array($detail_query)) { $schema .= "<PRODUCT_DESCRIPTION ID='" . $details["language_id"] . "' CODE='" . $details["language_code"] . "' NAME='" . $details["language_name"] . "'>\n"; if ($details["products_name"] != 'Array') { $schema .= "<NAME>" . htmlspecialchars($details["products_name"]) . "</NAME>" . "\n"; } $schema .= "<URL>" . htmlspecialchars($details["products_url"]) . "</URL>" . "\n"; $prod_details = $details["products_description"]; if ($prod_details != 'Array') { $schema .= "<DESCRIPTION>" . htmlspecialchars($details["products_description"]) . "</DESCRIPTION>" . "\n"; $schema .= "<SHORT_DESCRIPTION>" . htmlspecialchars($details["products_short_description"]) . "</SHORT_DESCRIPTION>" . "\n"; $schema .= "<META_TITLE>" . htmlspecialchars($details["products_meta_title"]) . "</META_TITLE>" . "\n"; $schema .= "<META_DESCRIPTION>" . htmlspecialchars($details["products_meta_description"]) . "</META_DESCRIPTION>" . "\n"; $schema .= "<META_KEYWORDS>" . htmlspecialchars($details["products_meta_keywords"]) . "</META_KEYWORDS>" . "\n"; } $schema .= "</PRODUCT_DESCRIPTION>\n"; } // NEU JP 26.08.2005 Aktionspreise exportieren $special_query = "SELECT * from " . TABLE_SPECIALS . " " . "where products_id=" . $products['products_id'] . " limit 0,1"; $special_result = olc_db_query($special_query); while ($specials = olc_db_fetch_array($special_result)) { $schema .= '<SPECIAL>' . "\n" . '<SPECIAL_PRICE>' . $specials['specials_new_products_price'] . '</SPECIAL_PRICE>' . "\n" . '<SPECIAL_DATE_ADDED>' . $specials['specials_date_added'] . '</SPECIAL_DATE_ADDED>' . "\n" . '<SPECIAL_LAST_MODIFIED>' . $specials['specials_last_modified'] . '</SPECIAL_LAST_MODIFIED>' . "\n" . '<SPECIAL_DATE_EXPIRES>' . $specials['expires_date'] . '</SPECIAL_DATE_EXPIRES>' . "\n" . '<SPECIAL_STATUS>' . $specials['status'] . '</SPECIAL_STATUS>' . "\n" . '<SPECIAL_DATE_STATUS_CHANGE>' . $specials['date_status_change'] . '</SPECIAL_DATE_STATUS_CHANGE>' . "\n" . '</SPECIAL>' . "\n"; } // Ende Aktionspreise $schema .= '</PRODUCT_DATA>' . "\n" . '</PRODUCT_INFO>' . "\n"; } $schema .= '</PRODUCTS>' . "\n\n"; echo $schema; }
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'] . "'"); } } } }
function olc_cfg_pull_down_customers_status_list($customers_status_id, $key = '') { $name = $key ? 'configuration[' . $key . ']' : 'configuration_value'; return olc_draw_pull_down_menu($name, olc_get_customers_statuses(), $customers_status_id); }