[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
Zen Cart 源代码 options_values_manager.php

Zen Cart 源代码 options_values_manager.php




下载文件

文件名: options_values_manager.php
文件类型: PHP文件
文件大小: 64.18 KiB
MD5: 1d796a1fbfe93f36c6c66ed3e3e040f9

options_values_manager.php - 关闭高亮
  1. <?php
  2. /**
  3.  * @package admin
  4.  * @copyright Copyright 2003-2010 Zen Cart Development Team
  5.  * @copyright Portions Copyright 2003 osCommerce
  6.  * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
  7.  * @version $Id: options_values_manager.php 17903 2010-10-09 21:20:37Z wilt $
  8.  */
  9.  
  10.   require('includes/application_top.php');
  11.  
  12.   // verify option names and values
  13.   $chk_option_names = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS_OPTIONS . " where language_id='" . $_SESSION['languages_id'] . "' limit 1");
  14.   if ($chk_option_names->fields['count'] < 1) {
  15.     $messageStack->add_session(ERROR_DEFINE_OPTION_NAMES, 'caution');
  16.     zen_redirect(zen_href_link(FILENAME_OPTIONS_NAME_MANAGER));
  17.   }
  18.  
  19.   $languages = zen_get_languages();
  20.  
  21.   $action = (isset($_GET['action']) ? $_GET['action'] : '');
  22.  
  23. // display or hide copier features
  24.   if (!isset($_SESSION['option_names_values_copier'])) {
  25.     $_SESSION['option_names_values_copier'] = OPTION_NAMES_VALUES_GLOBAL_STATUS;
  26.   }
  27.   if (!isset($_GET['reset_option_names_values_copier'])) {
  28.     $reset_option_names_values_copier = $_SESSION['option_names_values_copier'];
  29.   }
  30.  
  31.   if (zen_not_null($action)) {
  32.     $_SESSION['page_info'] = '';
  33.     if (isset($_GET['option_page'])) $_SESSION['page_info'] .= 'option_page=' . $_GET['option_page'] . '&';
  34.     if (isset($_GET['value_page'])) $_SESSION['page_info'] .= 'value_page=' . $_GET['value_page'] . '&';
  35.     if (isset($_GET['attribute_page'])) $_SESSION['page_info'] .= 'attribute_page=' . $_GET['attribute_page'] . '&';
  36.     if (zen_not_null($_SESSION['page_info'])) {
  37.       $_SESSION['page_info'] = substr($_SESSION['page_info'], 0, -1);
  38.     }
  39.  
  40.     switch ($action) {
  41.       case 'set_option_names_values_copier':
  42.         $_SESSION['option_names_values_copier'] = $_GET['reset_option_names_values_copier'];
  43.         $action='';
  44.         zen_redirect(zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER));
  45.         break;
  46.       case 'add_product_option_values':
  47.         $value_name_array = $_POST['value_name'];
  48.         $value_id = zen_db_prepare_input($_POST['value_id']);
  49.         $option_id = zen_db_prepare_input($_POST['option_id']);
  50.         $products_options_values_sort_order = zen_db_prepare_input($_POST['products_options_values_sort_order']);
  51.  
  52.         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
  53.           $value_name = zen_db_prepare_input($value_name_array[$languages[$i]['id']]);
  54.  
  55.           $db->Execute("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . "
  56.                      (products_options_values_id, language_id, products_options_values_name, products_options_values_sort_order)
  57.                      values ('" . (int)$value_id . "',
  58.                              '" . (int)$languages[$i]['id'] . "',
  59.                              '" . zen_db_input($value_name) . "',
  60.                              '" . (int)$products_options_values_sort_order . "')");
  61.         }
  62.  
  63.         $db->Execute("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
  64.                    (products_options_id, products_options_values_id)
  65.                    values ('" . (int)$option_id . "', '" . (int)$value_id . "')");
  66.  
  67. // alert if possible duplicate
  68.         $duplicate_option_values= '';
  69.         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
  70.           $value_name = zen_db_prepare_input($value_name_array[$languages[$i]['id']]);
  71.  
  72.           if (!empty($value_name)) {
  73.             $check= $db->Execute("select pov.products_options_values_id, pov.products_options_values_name, pov.language_id
  74.                                from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
  75.                                left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id
  76.                                where pov.language_id= '" . $languages[$i]['id'] . "'
  77.                                and pov.products_options_values_name='" . zen_db_input($value_name) . "'
  78.                                and pov2po.products_options_id ='" . (int)$option_id .
  79.                                 "'");
  80.             if ($check->RecordCount() > 1) {
  81.               while (!$check->EOF) {
  82.                 $check_dups .= ' - ' . $check->fields['products_options_values_id'];
  83.                 $check->MoveNext();
  84.               }
  85.               $duplicate_option_values .= ' <b>' . strtoupper(zen_get_language_name($languages[$i]['id'])) . '</b> : ' . $check_dups;
  86.             }
  87.           }
  88.         }
  89.         if (!empty($duplicate_option_values)) {
  90.           $messageStack->add_session(ATTRIBUTE_POSSIBLE_OPTIONS_VALUE_WARNING_DUPLICATE . ' ' . $duplicate_option_values, 'caution');
  91.         }
  92.  
  93.         zen_redirect(zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, $_SESSION['page_info']));
  94.         break;
  95.       case 'update_value':
  96.         $value_name_array = $_POST['value_name'];
  97.         $value_id = zen_db_prepare_input($_POST['value_id']);
  98.         $option_id = zen_db_prepare_input($_POST['option_id']);
  99.         $products_options_values_sort_order = zen_db_prepare_input($_POST['products_options_values_sort_order']);
  100.  
  101.         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
  102.           $value_name = zen_db_prepare_input($value_name_array[$languages[$i]['id']]);
  103.  
  104.           $db->Execute("update " . TABLE_PRODUCTS_OPTIONS_VALUES . "
  105.                        set products_options_values_name = '" . zen_db_input($value_name) . "', products_options_values_sort_order = '" . (int)$products_options_values_sort_order . "'
  106.                        where products_options_values_id = '" . zen_db_input($value_id) . "'
  107.                        and language_id = '" . (int)$languages[$i]['id'] . "'");
  108.  
  109.         }
  110.  
  111.         $db->Execute("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
  112.                      set products_options_id = '" . (int)$option_id . "'
  113.                      where products_options_values_id = '" . (int)$value_id . "'");
  114.  
  115.  
  116. // alert if possible duplicate
  117.         $duplicate_option_values= '';
  118.         for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {
  119.           $value_name = zen_db_prepare_input($value_name_array[$languages[$i]['id']]);
  120.  
  121.           if (!empty($value_name)) {
  122.             $check= $db->Execute("select pov.products_options_values_id, pov.products_options_values_name, pov.language_id
  123.                                from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov
  124.                                left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id
  125.                                where pov.language_id= '" . $languages[$i]['id'] . "'
  126.                                and pov.products_options_values_name='" . zen_db_input($value_name) . "'
  127.                                and pov2po.products_options_id ='" . (int)$option_id .
  128.                                 "'");
  129.  
  130.             if ($check->RecordCount() > 1) {
  131.               while (!$check->EOF) {
  132.                 $check_dups .= ' - ' . $check->fields['products_options_values_id'];
  133.                 $check->MoveNext();
  134.               }
  135.               $duplicate_option_values .= ' <b>' . strtoupper(zen_get_language_name($languages[$i]['id'])) . '</b> : ' . $check_dups;
  136.             }
  137.           }
  138.         }
  139.         if (!empty($duplicate_option_values)) {
  140.           $messageStack->add_session(ATTRIBUTE_POSSIBLE_OPTIONS_VALUE_WARNING_DUPLICATE . ' ' . $duplicate_option_values, 'caution');
  141.         }
  142.  
  143.         zen_redirect(zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, $_SESSION['page_info']));
  144.         break;
  145.       case 'delete_value':
  146.         // demo active test
  147.         if (zen_admin_demo()) {
  148.           $_GET['action']= '';
  149.           $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
  150.           zen_redirect(zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, $_SESSION['page_info']));
  151.         }
  152.         $value_id = zen_db_prepare_input($_GET['value_id']);
  153.  
  154. // remove all attributes from products with value
  155.         $remove_attributes_query = $db->Execute("select products_attributes_id, options_id, options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where options_values_id ='" . (int)$value_id . "'");
  156.         if ($remove_attributes_query->RecordCount() > 0) {
  157.           // clean all tables of option value
  158.           while (!$remove_attributes_query->EOF) {
  159.  
  160.             $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "
  161.                          where products_attributes_id='" . $remove_attributes_query->fields['products_attributes_id'] . "'");
  162.  
  163.             $remove_attributes_query->MoveNext();
  164.           }
  165.           $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES . "
  166.                        where options_values_id='" . (int)$value_id . "'");
  167.         }
  168.  
  169.         $db->Execute("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . "
  170.                      where products_options_values_id = '" . (int)$value_id . "'");
  171.  
  172.         $db->Execute("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . "
  173.                      where products_options_values_id = '" . (int)$value_id . "'");
  174.  
  175.         zen_redirect(zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, $_SESSION['page_info']));
  176.         break;
  177.  
  178. ////////////////////////////////////////////////////
  179. // copy option values based on existance of another option value
  180.     case 'copy_options_values_one_to_another':
  181.  
  182.       $options_id_from = $_POST['options_id_from'];
  183.       $options_values_values_id_from = $_POST['options_values_values_id_from'];
  184.  
  185.       $options_id_to = $_POST['options_id_to'];
  186.       $options_values_values_id_to = $_POST['options_values_values_id_to'];
  187.  
  188.       // one category of products or all products
  189.       if ($_POST['copy_to_categories_id'] != '') {
  190.         $products_only = $db->Execute("select ptc.products_id from " . TABLE_PRODUCTS_TO_CATEGORIES  . " ptc left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on pa.products_id=ptc.products_id where ptc.categories_id='" . $_POST['copy_to_categories_id'] . "' and (pa.options_id='" . $options_id_from . "' and pa.options_values_id='" . $options_values_values_id_from . "')");
  191.       } else {
  192.         $products_only = $db->Execute("select pa.products_id from " . TABLE_PRODUCTS_ATTRIBUTES  . " pa where pa.options_id='" . $options_id_from . "' and pa.options_values_id='" . $options_values_values_id_from . "'");
  193.       }
  194.  
  195. /*
  196. // debug code
  197.             while(!$products_only->EOF) {
  198.               echo 'Product ' . $products_only->fields['products_id'] . '<br>';
  199.               $products_only->MoveNext();
  200.             }
  201.  
  202.  
  203. die('I SEE match from: ' . $options_id_from . '-' . $options_values_values_id_from . ' add to: ' . $options_id_to . ' -' . $options_values_values_id_to . ' | only for cat ' . $_POST['copy_to_categories_id'] . ' | found matches ' . $products_only->RecordCount());
  204. */
  205.  
  206.  
  207.       if ($_POST['copy_to_categories_id'] == '') {
  208.         $zc_categories = ' All Products ';
  209.       } else {
  210.         $zc_categories = ' Category: ' . $_POST['copy_to_categories_id'];
  211.       }
  212.  
  213.       $new_attribute=0;
  214.  
  215.       if ($options_values_values_id_from == $options_values_values_id_to) {
  216.         // cannot copy to self
  217.         $messageStack->add(ERROR_OPTION_VALUES_COPIED . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to), 'warning');
  218.       } else {
  219.         if (!zen_validate_options_to_options_value($options_id_from, $options_values_values_id_from) or !zen_validate_options_to_options_value($options_id_to, $options_values_values_id_to)) {
  220.           $messageStack->add(ERROR_OPTION_VALUES_COPIED_MISMATCH . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to), 'warning');
  221.         } else {
  222.           // check for existing combination
  223.           if ($products_only->RecordCount() > 0) {
  224.             // check existing matching products and add new attributes
  225.             while(!$products_only->EOF) {
  226.               $current_products_id = $products_only->fields['products_id'];
  227.               $sql = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_id, options_id, options_values_id) values('" . $current_products_id . "', '" . $options_id_to . "', '" . $options_values_values_id_to . "')";
  228.               $check_previous = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $current_products_id . "' and options_id='" . $options_id_to . "' and options_values_id='" . $options_values_values_id_to . "' limit 1");
  229.               // do not add duplicate attributes
  230.               if ($check_previous->fields['count'] < 1) {
  231.                 $db->Execute($sql);
  232.                 $new_attribute++;
  233.               }
  234.               $products_only->MoveNext();
  235.             }
  236.  
  237.             // display how many products were updated
  238.             if ($new_attribute < 1) {
  239.               // nothing was added due to duplicates
  240.               $messageStack->add(SUCCESS_OPTION_VALUES_COPIED . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'caution');
  241.             } else {
  242.               // successful addition of new attributes that were not duplicates
  243.               $messageStack->add(SUCCESS_OPTION_VALUES_COPIED . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'success');
  244.             }
  245.           } else {
  246.             // warning nothing to copy
  247.             $messageStack->add(ERROR_OPTION_VALUES_NONE . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to) . $zc_categories, 'warning');
  248.           }
  249.         } // mismatch
  250.       } // same option value
  251.     break;
  252. ////////////////////////////////////
  253.  
  254. // fix here copy_options_values_one_to_another_options_id
  255.  
  256. ////////////////////////////////////////////////////
  257. // copy option values based on existance of another option value
  258.     case 'copy_options_values_one_to_another_options_id':
  259.  
  260.       $options_id_from = $_POST['options_id_from'];
  261.       $options_values_values_id_from = $_POST['options_values_values_id_from'];
  262.       $copy_from_products_id = $_POST['copy_from_products_id'];
  263.  
  264.       $options_id_to = $_POST['options_id_to'];
  265.       $options_values_values_id_to = $_POST['options_values_values_id_to'];
  266.  
  267.       // one category of products or all products
  268.       if ($_POST['copy_to_categories_id'] != '') {
  269.         $products_only = $db->Execute("select distinct ptc.products_id from " . TABLE_PRODUCTS_TO_CATEGORIES  . " ptc left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on pa.products_id=ptc.products_id where ptc.categories_id='" . $_POST['copy_to_categories_id'] . "' and (pa.options_id='" . $options_id_to . "')");
  270.       } else {
  271.         $products_only = $db->Execute("select distinct pa.products_id from " . TABLE_PRODUCTS_ATTRIBUTES  . " pa where pa.options_id='" . $options_id_to . "'");
  272.       }
  273.  
  274.       $products_attributes_defaults = $db->Execute("select pa.* from " . TABLE_PRODUCTS_ATTRIBUTES  . " pa where pa.products_id = '" . $copy_from_products_id . "' and options_id='" . $options_id_from . "' and pa.options_values_id='" . $options_values_values_id_from . "'");
  275.  
  276.       $options_id = zen_db_prepare_input($options_id_from);
  277.       $values_id = zen_db_prepare_input($options_values_values_id_from);
  278.  
  279.       if (!$products_attributes_defaults->EOF) {
  280.         $options_values_price = zen_db_prepare_input($products_attributes_defaults->fields['options_values_price']);
  281.         $price_prefix = zen_db_prepare_input($products_attributes_defaults->fields['price_prefix']);
  282.  
  283.         $products_options_sort_order = zen_db_prepare_input($products_attributes_defaults->fields['products_options_sort_order']);
  284.         $product_attribute_is_free = zen_db_prepare_input($products_attributes_defaults->fields['product_attribute_is_free']);
  285.         $products_attributes_weight = zen_db_prepare_input($products_attributes_defaults->fields['products_attributes_weight']);
  286.         $products_attributes_weight_prefix = zen_db_prepare_input($products_attributes_defaults->fields['products_attributes_weight_prefix']);
  287.         $attributes_display_only = zen_db_prepare_input($products_attributes_defaults->fields['attributes_display_only']);
  288.         $attributes_default = zen_db_prepare_input($products_attributes_defaults->fields['attributes_default']);
  289.         $attributes_discounted = zen_db_prepare_input($products_attributes_defaults->fields['attributes_discounted']);
  290.         $attributes_price_base_included = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_base_included']);
  291.  
  292.         $attributes_price_onetime = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_onetime']);
  293.         $attributes_price_factor = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_factor']);
  294.         $attributes_price_factor_offset = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_factor_offset']);
  295.         $attributes_price_factor_onetime = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_factor_onetime']);
  296.         $attributes_price_factor_onetime_offset = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_factor_onetime_offset']);
  297.         $attributes_qty_prices = zen_db_prepare_input($products_attributes_defaults->fields['attributes_qty_prices']);
  298.         $attributes_qty_prices_onetime = zen_db_prepare_input($products_attributes_defaults->fields['attributes_qty_prices_onetime']);
  299.  
  300.         $attributes_price_words = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_words']);
  301.         $attributes_price_words_free = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_words_free']);
  302.         $attributes_price_letters = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_letters']);
  303.         $attributes_price_letters_free = zen_db_prepare_input($products_attributes_defaults->fields['attributes_price_letters_free']);
  304.         $attributes_required = zen_db_prepare_input($products_attributes_defaults->fields['attributes_required']);
  305.       }
  306.  
  307. /*
  308. /////
  309. // debug code
  310.             while(!$products_only->EOF) {
  311.               echo 'Product ' . $products_only->fields['products_id'] . '<br>';
  312.               $products_only->MoveNext();
  313.             }
  314.  
  315.  
  316. die('I SEE match from products_id:' . $copy_from_products_id . ' options_id_from: ' . $options_id_from . '-' . $options_values_values_id_from . ' add to: ' . $options_id_to . ' | only for cat ' . $_POST['copy_to_categories_id'] . ' | found matches ' . $products_only->RecordCount() . '<br>' .
  317. 'from products_id: ' . $products_attributes_defaults->fields['products_id'] . ' option_id: ' . $products_attributes_defaults->fields['options_id'] . ' options_values_id: ' . $products_attributes_defaults->fields['options_values_id']
  318. );
  319. /////
  320. */
  321.  
  322.       if ($_POST['copy_to_categories_id'] == '') {
  323.         $zc_categories = ' All Products ';
  324.       } else {
  325.         $zc_categories = ' Category: ' . $_POST['copy_to_categories_id'];
  326.       }
  327.  
  328.       $new_attribute=0;
  329.  
  330.         if (!zen_validate_options_to_options_value($options_id_from, $options_values_values_id_from) or ($products_attributes_defaults->EOF and $copy_from_products_id != '')) {
  331.           if ($products_attributes_defaults->EOF and $copy_from_products_id != '') {
  332.           // bad product_id with no match
  333.             $messageStack->add(ERROR_OPTION_VALUES_COPIED_MISMATCH_PRODUCTS_ID . $copy_from_products_id . ': ' . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from), 'warning');
  334.           } else {
  335.           // mismatched Option Name/Value
  336.             $messageStack->add(ERROR_OPTION_VALUES_COPIED_MISMATCH . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from), 'warning');
  337.           }
  338.         } else {
  339.           // check for existing combination
  340.           if ($products_only->RecordCount() > 0) {
  341.             // check existing matching products and add new attributes
  342.  
  343.             while(!$products_only->EOF) {
  344.               $current_products_id = $products_only->fields['products_id'];
  345.  
  346. //              $sql = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . "(products_id, options_id, options_values_id) values('" . $current_products_id . "', '" . $options_id_from . "', '" . $options_values_values_id_from . "')";
  347.                 $sql = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)
  348.                          values (0,
  349.                                  '" . (int)$current_products_id . "',
  350.                                  '" . (int)$options_id . "',
  351.                                  '" . (int)$values_id . "',
  352.                                  '" . zen_db_input($options_values_price) . "',
  353.                                  '" . zen_db_input($price_prefix) . "',
  354.                                  '" . (int)zen_db_input($products_options_sort_order) . "',
  355.                                  '" . (int)zen_db_input($product_attribute_is_free) . "',
  356.                                  '" . (float)zen_db_input($products_attributes_weight) . "',
  357.                                  '" . zen_db_input($products_attributes_weight_prefix) . "',
  358.                                  '" . (int)zen_db_input($attributes_display_only) . "',
  359.                                  '" . (int)zen_db_input($attributes_default) . "',
  360.                                  '" . (int)zen_db_input($attributes_discounted) . "',
  361.                                  '" . zen_db_input($attributes_image_name) . "',
  362.                                  '" . (int)zen_db_input($attributes_price_base_included) . "',
  363.                                  '" . (float)zen_db_input($attributes_price_onetime) . "',
  364.                                  '" . (float)zen_db_input($attributes_price_factor) . "',
  365.                                  '" . (float)zen_db_input($attributes_price_factor_offset) . "',
  366.                                  '" . (float)zen_db_input($attributes_price_factor_onetime) . "',
  367.                                  '" . (float)zen_db_input($attributes_price_factor_onetime_offset) . "',
  368.                                  '" . zen_db_input($attributes_qty_prices) . "',
  369.                                  '" . zen_db_input($attributes_qty_prices_onetime) . "',
  370.                                  '" . (float)zen_db_input($attributes_price_words) . "',
  371.                                  '" . (int)zen_db_input($attributes_price_words_free) . "',
  372.                                  '" . (float)zen_db_input($attributes_price_letters) . "',
  373.                                  '" . (int)zen_db_input($attributes_price_letters_free) . "',
  374.                                  '" . (int)zen_db_input($attributes_required) . "')";
  375.  
  376.               $check_previous = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $current_products_id . "' and options_id='" . $options_id_from . "' and options_values_id='" . $options_values_values_id_from . "' limit 1");
  377.               // do not add duplicate attributes
  378.               if ($check_previous->fields['count'] < 1) {
  379.               // add new attribute
  380.                 $db->Execute($sql);
  381.                 //echo $sql . '<br>';
  382.                 $new_attribute++;
  383.               } else {
  384.                 // ignore
  385.                 if ($_POST['copy_attributes'] == 'copy_attributes_ignore') {
  386.                   //echo 'skipped already exists: ' . $current_products_id . '<br>';
  387.                 } else {
  388.                 // delete old and add new
  389.                 //echo 'delete old and add new: ' . $current_products_id . '<br>';
  390.                   $db->Execute("DELETE from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $current_products_id . "' and options_id='" . $options_id_from . "' and options_values_id='" . $options_values_values_id_from . "'");
  391.                   $db->Execute($sql);
  392.                   $new_attribute++;
  393.                 }
  394.               }
  395.               $products_only->MoveNext();
  396.             }
  397.  
  398.             // display how many products were updated
  399.             if ($new_attribute < 1) {
  400.               // nothing was added
  401.               $messageStack->add(ERROR_OPTION_VALUES_NONE . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'warning');
  402.             } else {
  403.               // successful addition of new attributes that were not duplicates
  404.               $messageStack->add(SUCCESS_OPTION_VALUES_COPIED . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'success');
  405.             }
  406.           } else {
  407.             // warning nothing to copy
  408.             $messageStack->add(ERROR_OPTION_VALUES_NONE . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' for: ' . $zc_categories, 'warning');
  409.           }
  410.         } // mismatch
  411.     break;
  412. ////////////////////////////////////
  413.  
  414.  
  415.  
  416.  
  417.     case ('delete_options_values_of_option_name'):
  418.  
  419.       $options_id_from = $_POST['options_id_from'];
  420.       $options_values_values_id_from = $_POST['options_values_values_id_from'];
  421.  
  422.       // one category of products or all products
  423.       if ($_POST['copy_to_categories_id'] != '') {
  424.         $products_only = $db->Execute("select ptc.products_id from " . TABLE_PRODUCTS_TO_CATEGORIES  . " ptc left join " . TABLE_PRODUCTS_ATTRIBUTES . " pa on pa.products_id=ptc.products_id where ptc.categories_id='" . $_POST['copy_to_categories_id'] . "' and (pa.options_id='" . $options_id_from . "' and pa.options_values_id='" . $options_values_values_id_from . "')");
  425.       } else {
  426.         $products_only = $db->Execute("select pa.products_id from " . TABLE_PRODUCTS_ATTRIBUTES  . " pa where pa.options_id='" . $options_id_from . "' and pa.options_values_id='" . $options_values_values_id_from . "'");
  427.       }
  428.  
  429.       if ($_POST['copy_to_categories_id'] == '') {
  430.         $zc_categories = ' All Products ';
  431.       } else {
  432.         $zc_categories = ' Category: ' . $_POST['copy_to_categories_id'];
  433.       }
  434.  
  435.       $new_attribute=0;
  436.  
  437.       if (!zen_validate_options_to_options_value($options_id_from, $options_values_values_id_from)) {
  438.         $messageStack->add(ERROR_OPTION_VALUES_DELETE_MISMATCH . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from), 'warning');
  439.       } else {
  440.         // check for existing combination
  441.         if ($products_only->RecordCount() > 0) {
  442.           // check existing matching products and add new attributes
  443.           while(!$products_only->EOF) {
  444.             $current_products_id = $products_only->fields['products_id'];
  445.  
  446.             // check for associated downloads
  447.             $downloads_remove_query = "select products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $current_products_id . "' and options_id='" . $options_id_from . "' and options_values_id='" . $options_values_values_id_from . "'";
  448.             $downloads_remove = $db->Execute($downloads_remove_query);
  449.  
  450.             $sql = "delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $current_products_id . "' and options_id='" . $options_id_from . "' and options_values_id='" . $options_values_values_id_from . "'";
  451.             $delete_selected = $db->Execute($sql);
  452.  
  453.             // delete associated downloads
  454.             while (!$downloads_remove->EOF) {
  455.               $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "
  456.                            where products_attributes_id='" . $downloads_remove->fields['products_attributes_id'] . "'");
  457.               $downloads_remove->MoveNext();
  458.             }
  459.             // count deleted attribute
  460.             $new_attribute++;
  461.             $products_only->MoveNext();
  462.           }
  463.  
  464.           // display how many products were updated
  465.           if ($new_attribute < 1) {
  466.             // nothing was added due to duplicates
  467.             $messageStack->add(ERROR_OPTION_VALUES_NONE . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'caution');
  468.           } else {
  469.             // successful addition of new attributes that were not duplicates
  470.             $messageStack->add(SUCCESS_OPTION_VALUES_DELETE . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . ' for: ' . $zc_categories . ' ' . $new_attribute . ' products', 'success');
  471.           }
  472.         } else {
  473.           // warning nothing to copy
  474.           $messageStack->add(ERROR_OPTION_VALUES_NONE . TEXT_INFO_FROM . zen_options_name($options_id_from) . ' ' . zen_values_name($options_values_values_id_from) . TEXT_INFO_TO . zen_options_name($options_id_to) . ' ' . zen_values_name($options_values_values_id_to) . $zc_categories, 'warning');
  475.         }
  476.       } // mismatch
  477.  
  478.     break;
  479.     }
  480.  
  481.  
  482.   }
  483. ?>
  484. <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
  485. <html <?php echo HTML_PARAMS; ?>>
  486. <head>
  487. <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
  488. <title><?php echo TITLE; ?></title>
  489. <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
  490. <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
  491. <script language="javascript" src="includes/menu.js"></script>
  492. <script language="javascript"><!--
  493. function go_option() {
  494.   if (document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value != "none") {
  495.     location = "<?php echo zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'option_page=' . ($_GET['option_page'] ? $_GET['option_page'] : 1)); ?>&option_order_by="+document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value;
  496.   }
  497. }
  498. //--></script>
  499. <script type="text/javascript">
  500.   <!--
  501.   function init()
  502.   {
  503.     cssjsmenu('navbar');
  504.     if (document.getElementById)
  505.     {
  506.       var kill = document.getElementById('hoverJS');
  507.       kill.disabled = true;
  508.     }
  509.   }
  510.   // -->
  511. </script>
  512. </head>
  513. <body onLoad="init()">
  514. <!-- header //-->
  515. <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
  516.   <table border="0" width="75%" cellspacing="0" cellpadding="0" align="center">
  517.       <tr>
  518.         <td width="100%">
  519.            <table width="100%" border="0" cellspacing="0" cellpadding="2">
  520.              <tr>
  521.                <td height="40" valign="bottom">
  522.                  <a href="<?php echo  zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, '', 'NONSSL') ?>"><?php echo zen_image_button('button_edit_attribs.gif', IMAGE_EDIT_ATTRIBUTES); ?></a> &nbsp;
  523.                  <a href="<?php echo  zen_href_link(FILENAME_OPTIONS_NAME_MANAGER, '', 'NONSSL') ?>"><?php echo zen_image_button('button_option_names.gif', IMAGE_OPTION_NAMES); ?></a>
  524.                </td>
  525.               <td class="main" height="40" valign="bottom">
  526.                 <?php
  527. // toggle switch for show copier features
  528.                   $option_names_values_copier_array = array(array('id' => '0', 'text' => TEXT_SHOW_OPTION_NAMES_VALUES_COPIER_OFF),
  529.                                         array('id' => '1', 'text' => TEXT_SHOW_OPTION_NAMES_VALUES_COPIER_ON),
  530.                                         );
  531.                   echo zen_draw_form('set_option_names_values_copier_form', FILENAME_OPTIONS_VALUES_MANAGER, '', 'get') . '&nbsp;&nbsp;' . zen_draw_pull_down_menu('reset_option_names_values_copier', $option_names_values_copier_array, $reset_option_names_values_copier, 'onChange="this.form.submit();"') .
  532.                   zen_hide_session_id() .
  533.                   zen_draw_hidden_field('action', 'set_option_names_values_copier') .
  534.                   '</form>';
  535.                 ?>
  536.               </td>
  537.                <td class="main" align="right" valign="bottom"><?php echo TEXT_PRODUCT_OPTIONS_INFO; ?></td>
  538.              </tr>
  539.           </table>
  540.        </td>
  541.      </tr>
  542.      <tr>
  543.         <td valign="top" width="50%">
  544.            <table width="100%" border="0" cellspacing="0" cellpadding="2">
  545. <!-- value //-->
  546. <?php
  547.   if ($action == 'delete_option_value') { // delete product option value
  548.     $values_values = $db->Execute("select products_options_values_id, products_options_values_name
  549.                                   from " . TABLE_PRODUCTS_OPTIONS_VALUES . "
  550.                                   where products_options_values_id = '" . (int)$_GET['value_id'] . "'
  551.                                   and language_id = '" . (int)$_SESSION['languages_id'] . "'");
  552.  
  553. ?>
  554.               <tr>
  555.                 <td colspan="3" class="pageHeading">&nbsp;<?php echo $values_values->fields['products_options_values_name']; ?>&nbsp;</td>
  556.               </tr>
  557.               <tr>
  558.                 <td colspan="4"><?php echo zen_black_line(); ?></td>
  559.               </tr>
  560. <?php
  561.     $products_values = $db->Execute("select p.products_id, pd.products_name, po.products_options_name, pa.options_id
  562.                              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, "
  563.                                      . TABLE_PRODUCTS_OPTIONS . " po, " . TABLE_PRODUCTS_DESCRIPTION . " pd
  564.                              where pd.products_id = p.products_id
  565.                              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
  566.                              and po.language_id = '" . (int)$_SESSION['languages_id'] . "'
  567.                              and pa.products_id = p.products_id
  568.                              and pa.options_values_id='" . (int)$_GET['value_id'] . "'
  569.                              and po.products_options_id = pa.options_id
  570.                              order by pd.products_name");
  571.  
  572.     if ($products_values->RecordCount() > 0) {
  573. ?>
  574. <?php
  575. // extra cancel button
  576.     if ($products_values->RecordCount() > 10) {
  577. ?>
  578.                   <tr>
  579.                     <td class="main" colspan="3"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td>
  580.                     <td class="main" align="right"><br /><?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_value&value_id=' . $_GET['value_id'] . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_delete.gif', ' delete '); ?></a>&nbsp;&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_cancel.gif', ' cancel '); ?></a>&nbsp;</td>
  581.                   </tr>
  582. <?php
  583.   } // extra cancel
  584. ?>
  585.                   <tr class="dataTableHeadingRow">
  586.                     <td class="dataTableHeadingContent" align="center">&nbsp;<?php echo TABLE_HEADING_ID; ?>&nbsp;</td>
  587.                     <td class="dataTableHeadingContent">&nbsp;<?php echo TABLE_HEADING_PRODUCT; ?>&nbsp;</td>
  588.                     <td class="dataTableHeadingContent" align="right">&nbsp;<?php echo TABLE_HEADING_OPTION_SORT_ORDER; ?>&nbsp;</td>
  589.                     <td class="dataTableHeadingContent">&nbsp;<?php echo TABLE_HEADING_OPT_NAME; ?>&nbsp;</td>
  590.                   </tr>
  591.                   <tr>
  592.                     <td colspan="4"><?php echo zen_black_line(); ?></td>
  593.                   </tr>
  594.  
  595. <?php
  596.       while (!$products_values->EOF) {
  597.         $rows++;
  598. ?>
  599.                   <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">
  600.                     <td align="center" class="smallText">&nbsp;<?php echo $products_values->fields['products_id']; ?>&nbsp;</td>
  601.                     <td class="smallText">&nbsp;<?php echo $products_values->fields['products_name']; ?>&nbsp;</td>
  602.                     <td class="smallText" align="right">&nbsp;<?php echo $options_values->fields["products_options_sort_order"]; ?>&nbsp;</td>
  603.                     <td class="smallText">&nbsp;<?php echo $products_values->fields['products_options_name']; ?>&nbsp;</td>
  604.                   </tr>
  605. <?php
  606.         $products_values->MoveNext();
  607.       }
  608. ?>
  609.                   <tr>
  610.                     <td colspan="4"><?php echo zen_black_line(); ?></td>
  611.                   </tr>
  612.                   <tr>
  613.                     <td class="main" colspan="3"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td>
  614.                     <td class="main" align="right"><br /><?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_value&value_id=' . $_GET['value_id'] . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_delete.gif', ' delete '); ?></a>&nbsp;&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_cancel.gif', ' cancel '); ?></a>&nbsp;</td>
  615.                   </tr>
  616. <?php
  617.     } else {
  618. ?>
  619.                   <tr>
  620.                     <td class="main" colspan="3"><br /><?php echo TEXT_OK_TO_DELETE; ?></td>
  621.                   </tr>
  622.                   <tr>
  623.                     <td class="main" align="right" colspan="3"><br /><?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_value&value_id=' . $_GET['value_id'] . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_delete.gif', ' delete '); ?></a>&nbsp;&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_cancel.gif', ' cancel '); ?></a>&nbsp;</td>
  624.                   </tr>
  625. <?php
  626.     }
  627. ?>
  628.                 </table></td>
  629.               </tr>
  630. <?php
  631.   } else {
  632. ?>
  633.               <tr>
  634.                 <td colspan="3" class="pageHeading">&nbsp;<?php echo HEADING_TITLE_VAL; ?>&nbsp;</td>
  635.               </tr>
  636.               <tr>
  637.                 <td colspan="5" class="smallText">
  638. <?php
  639.     $per_page = MAX_ROW_LISTS_OPTIONS;
  640. //    $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '" . (int)$_SESSION['languages_id'] . "' and pov2po.products_options_values_id !='" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "' order by LPAD(pov2po.products_options_id,11,'0'), LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name";
  641.     $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id, pov.products_options_values_sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id     left join " . TABLE_PRODUCTS_OPTIONS . " po on pov2po.products_options_id = po.products_options_id where pov.language_id = '" . (int)$_SESSION['languages_id'] . "' and po.language_id = '" . (int)$_SESSION['languages_id'] . "' and po.language_id = pov.language_id and pov2po.products_options_values_id !='" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "' order by  po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name";
  642.     if (!isset($_GET['value_page'])) {
  643.       $_GET['value_page'] = 1;
  644.     }
  645.     $prev_value_page = $_GET['value_page'] - 1;
  646.     $next_value_page = $_GET['value_page'] + 1;
  647.  
  648.     $value_query = $db->Execute($values);
  649.  
  650.     $value_page_start = ($per_page * $_GET['value_page']) - $per_page;
  651.     $num_rows = $value_query->RecordCount();
  652.  
  653.     if ($num_rows <= $per_page) {
  654.       $num_pages = 1;
  655.     } else if (($num_rows % $per_page) == 0) {
  656.       $num_pages = ($num_rows / $per_page);
  657.     } else {
  658.       $num_pages = ($num_rows / $per_page) + 1;
  659.     }
  660.     $num_pages = (int) $num_pages;
  661.  
  662. // fix limit error on some versions
  663.     if ($value_page_start < 0) { $value_page_start = 0; }
  664.  
  665.     $values = $values . " LIMIT $value_page_start, $per_page";
  666.  
  667.     // Previous
  668.     if ($prev_value_page)  {
  669.       echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> &lt;&lt; </a> | ';
  670.     }
  671.  
  672.     for ($i = 1; $i <= $num_pages; $i++) {
  673.       if ($i != $_GET['value_page']) {
  674.          echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $i) . '">' . $i . '</a> | ';
  675.       } else {
  676.          echo '<b><font color=red>' . $i . '</font></b> | ';
  677.       }
  678.     }
  679.  
  680.     // Next
  681.     if ($_GET['value_page'] != $num_pages) {
  682.       echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $next_value_page) . '"> &gt;&gt;</a> ';
  683.     }
  684. ?>
  685.                 </td>
  686.               </tr>
  687.               <tr>
  688.                 <td colspan="6"><?php echo zen_black_line(); ?></td>
  689.               </tr>
  690.               <tr class="dataTableHeadingRow">
  691.                 <td class="dataTableHeadingContent">&nbsp;<?php echo TABLE_HEADING_ID; ?>&nbsp;</td>
  692.                 <td class="dataTableHeadingContent">&nbsp;<?php echo TABLE_HEADING_OPT_NAME; ?>&nbsp;</td>
  693.                 <td class="dataTableHeadingContent">&nbsp;<?php echo TABLE_HEADING_OPT_VALUE; ?>&nbsp;</td>
  694.                 <td class="dataTableHeadingContent" align="right">&nbsp;<?php echo TABLE_HEADING_OPTION_VALUE_SORT_ORDER; ?></td>
  695.                 <td class="dataTableHeadingContent" align="center">&nbsp;<?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
  696.               </tr>
  697.               <tr>
  698.                 <td colspan="6"><?php echo zen_black_line(); ?></td>
  699.               </tr>
  700. <?php
  701.     $next_id = 1;
  702.     $rows = 0;
  703.     $values_values = $db->Execute($values);
  704.     while (!$values_values->EOF) {
  705.       $options_name = zen_options_name($values_values->fields['products_options_id']);
  706. // iii 030813 added: Option Type Feature and File Uploading
  707. // fetch products_options_id for use if the option value is deleted
  708. // with TEXT and FILE Options, there are multiple options for the single TEXT
  709. // value and only the single reference should be deleted
  710.       $option_id = $values_values->fields['products_options_id'];
  711.  
  712.       $values_name = $values_values->fields['products_options_values_name'];
  713.       $products_options_values_sort_order = $values_values->fields['products_options_values_sort_order'];
  714.       $rows++;
  715. ?>
  716.               <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">
  717. <?php
  718. // FIX HERE
  719. // edit option values
  720.       if (($action == 'update_option_value') && ($_GET['value_id'] == $values_values->fields['products_options_values_id'])) {
  721.         echo '<form name="values" action="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=update_value' . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '" method="post">';
  722.         echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']);
  723.         $inputs = '';
  724.         for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
  725.           $value_name = $db->Execute("select products_options_values_name
  726.                                      from " . TABLE_PRODUCTS_OPTIONS_VALUES . "
  727.                                      where products_options_values_id = '" . (int)$values_values->fields['products_options_values_id'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'");
  728.           $inputs .= $languages[$i]['code'] . ':&nbsp;<input type="text" name="value_name[' . $languages[$i]['id'] . ']" ' . zen_set_field_length(TABLE_PRODUCTS_OPTIONS_VALUES, 'products_options_values_name', 50) . ' value="' . zen_output_string($value_name->fields['products_options_values_name']) . '">&nbsp;<br />';
  729.         }
  730.           $products_options_values_sort_order = $db->Execute("select distinct products_options_values_sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$values_values->fields['products_options_values_id'] . "'");
  731.           $inputs2 .= '&nbsp;<input type="text" name="products_options_values_sort_order" size="4" value="' . $products_options_values_sort_order->fields['products_options_values_sort_order'] . '">&nbsp;';
  732. ?>
  733.                 <td align="center" class="attributeBoxContent">&nbsp;<?php echo $values_values->fields['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values->fields['products_options_values_id']; ?>">&nbsp;</td>
  734.                 <td align="center" class="attributeBoxContent">&nbsp;<?php echo "\n"; ?><select name="option_id">
  735. <?php
  736.         $options_values = $db->Execute("select products_options_id, products_options_name, products_options_type
  737.                                       from " . TABLE_PRODUCTS_OPTIONS . "
  738.                                       where language_id = '" . (int)$_SESSION['languages_id'] . "' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_TEXT . "' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_FILE . "'
  739.                                       order by products_options_name");
  740.  
  741.         while (!$options_values->EOF) {
  742.           echo "\n" . '<option name="' . $options_values->fields['products_options_name'] . '" value="' . $options_values->fields['products_options_id'] . '"';
  743.           if ($values_values->fields['products_options_id'] == $options_values->fields['products_options_id']) {
  744.             echo ' selected';
  745.           }
  746.           echo '>' . $options_values->fields['products_options_name'] . '</option>';
  747.           $options_values->MoveNext();
  748.         }
  749. ?>
  750.                 </select>&nbsp;</td>
  751.                 <td height="50" class="attributeBoxContent"><?php echo $inputs; ?></td>
  752.                 <td class="attributeBoxContent" align="right"><?php echo $inputs2; ?></td>
  753.                 <td align="center" class="attributeBoxContent">&nbsp;<?php echo zen_image_submit('button_update.gif', IMAGE_UPDATE); ?>&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a>&nbsp;</td>
  754. <?php
  755.         echo '</form>';
  756.       } else {
  757. // iii 030813 added:  option ID to parameter list of delete button's href
  758. // allows delete to specify just that option/value pair when deleting from
  759. // the TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS table
  760. ?>
  761.                 <td align="center" class="smallText">&nbsp;<?php echo $values_values->fields["products_options_values_id"]; ?>&nbsp;</td>
  762.                 <td align="center" class="smallText">&nbsp;<?php echo $options_name; ?>&nbsp;</td>
  763.                 <td class="smallText">&nbsp;<?php echo $values_name; ?>&nbsp;</td>
  764.                 <td class="smallText" align="right"><?php echo $values_values->fields['products_options_values_sort_order']; ?></td>
  765. <?php
  766. // hide buttons when editing
  767.   if ($action== 'update_option_value') {
  768. ?>
  769.             <td width='120' align="center" class="smallText">&nbsp;</td>
  770. <?php
  771.   } else {
  772. ?>
  773. <!--                <td align="center" class="smallText">&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=update_option_value&value_id=' . $values_values->fields['products_options_values_id'] . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] : ''), 'NONSSL') . '">'; ?><?php echo zen_image_button('button_edit.gif', IMAGE_UPDATE); ?></a>&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_option_value&value_id=' . $values_values->fields['products_options_values_id'] . '&option_id=' . $option_id, 'NONSSL') , '">'; ?><?php echo zen_image_button('button_delete.gif', IMAGE_DELETE); ?></a>&nbsp;</td> -->
  774.                 <td align="center" class="smallText">&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=update_option_value&value_id=' . $values_values->fields['products_options_values_id'] . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '">'; ?><?php echo zen_image_button('button_edit.gif', IMAGE_UPDATE); ?></a>&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_option_value&value_id=' . $values_values->fields['products_options_values_id'] . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) , '">'; ?><?php echo zen_image_button('button_delete.gif', IMAGE_DELETE); ?></a>&nbsp;</td>
  775. <?php
  776. //    $values_values->MoveNext();
  777.   }
  778. ?>
  779. <?php
  780.       }
  781.       $max_values_id_values = $db->Execute("select max(products_options_values_id) + 1
  782.                                           as next_id from " . TABLE_PRODUCTS_OPTIONS_VALUES);
  783.  
  784.       $next_id = $max_values_id_values->fields['next_id'];
  785. // good one
  786.       $values_values->MoveNext();
  787.     }
  788. ?>
  789.               </tr>
  790.               <tr>
  791.                 <td colspan="5"><?php echo zen_black_line(); ?></td>
  792.               </tr>
  793. <?php
  794.     if ($action != 'update_option_value') {
  795. ?>
  796.               <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">
  797. <?php
  798.       echo '<form name="values" action="' . zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=add_product_option_values' . (isset($_GET['option_page']) ? '&option_page=' . $_GET['option_page'] . '&' : '') . (isset($_GET['value_page']) ? '&value_page=' . $_GET['value_page'] . '&' : '') . (isset($_GET['attribute_page']) ? '&attribute_page=' . $_GET['attribute_page'] : '') ) . '" method="post">';echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']);
  799. ?>
  800.                 <td align="center" class="smallText">&nbsp;<?php echo $next_id; ?>&nbsp;</td>
  801.                 <td align="center" class="smallText">&nbsp;<select name="option_id">
  802. <?php
  803.       $options_values = $db->Execute("select products_options_id, products_options_name, products_options_type
  804.                                      from " . TABLE_PRODUCTS_OPTIONS . "
  805.                                      where language_id = '" . $_SESSION['languages_id'] . "' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_TEXT . "' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_FILE . "'
  806.                                      order by products_options_name");
  807.  
  808.       while (!$options_values->EOF) {
  809.         echo '<option name="' . $options_values->fields['products_options_name'] . '" value="' . $options_values->fields['products_options_id'] . '">' . $options_values->fields['products_options_name'] . '</option>';
  810.         $options_values->MoveNext();
  811.       }
  812.  
  813.       $inputs = '';
  814.       $inputs = '';
  815.       for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
  816.         $inputs .= $languages[$i]['code'] . ':&nbsp;<input type="text" name="value_name[' . $languages[$i]['id'] . ']" ' . zen_set_field_length(TABLE_PRODUCTS_OPTIONS_VALUES, 'products_options_values_name', 50) . '>&nbsp;<br />';
  817.       }
  818.         $inputs2 .= TEXT_SORT . '<input type="text" name="products_options_values_sort_order" size="4">&nbsp;';
  819. ?>
  820.                 </select>&nbsp;</td>
  821.                 <td class="smallText"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs; ?></td>
  822.                 <td colspan="1" class="smallText"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs2; ?></td>
  823.                 <td align="center" class="smallText">&nbsp;<?php echo zen_image_submit('button_insert.gif', IMAGE_INSERT); ?>&nbsp;</td>
  824. <?php
  825.       echo '</form>';
  826. ?>
  827.               </tr>
  828.               <tr>
  829.                 <td colspan="5"><?php echo zen_black_line(); ?></td>
  830.               </tr>
  831. <?php
  832.     }
  833.   }
  834. ?>
  835.             </td>
  836.           </tr>
  837.  
  838.  
  839. <?php if ($_SESSION['option_names_values_copier'] == '0') { ?>
  840.   <table align="center" width="90%">
  841.     <tr>
  842.       <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '5'); ?></td>
  843.     </tr>
  844.     <tr>
  845.       <td class="pageHeading" align="center"><?php echo TEXT_INFO_OPTION_NAMES_VALUES_COPIER_STATUS; ?></td>
  846.     </tr>
  847.     <tr>
  848.       <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '5'); ?></td>
  849.     </tr>
  850.   </table>
  851. <?php } else { ?>
  852.  
  853. <?php
  854.   // bof: build dropdowns for delete and add
  855.  
  856. /*
  857.   this builds the resulting values for use in the case statements above
  858.       $options_id_from = $_POST['options_id_from'];
  859.       $options_values_values_id_from = $_POST['options_values_values_id_from'];
  860.  
  861.       $options_id_to = $_POST['options_id_to'];
  862.       $options_values_values_id_to = $_POST['options_values_values_id_to'];
  863. */
  864.  
  865.   // build dropdown for option_name from
  866.   $options_values_from = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' and products_options_name !='' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_TEXT . "' and products_options_type !='" . PRODUCTS_OPTIONS_TYPE_FILE . "' order by products_options_name");
  867.   while(!$options_values_from->EOF) {
  868.     $option_from_dropdown .= "\n" . '  <option name="' . $options_values_from->fields['products_options_name'] . '" value="' . $options_values_from->fields['products_options_id'] . '">' . $options_values_from->fields['products_options_name'] . '</option>';
  869.     $options_values_from->MoveNext();
  870.   }
  871.  
  872.   $option_to_dropdown= $option_from_dropdown;
  873.  
  874.   $option_from_dropdown = "\n" . '<select name="options_id_from">' . $option_from_dropdown;
  875.   $option_from_dropdown.= "\n" . '</select>';
  876.  
  877.   $option_to_dropdown = "\n" . '<select name="options_id_to">' . $option_to_dropdown;
  878.   $option_to_dropdown.= "\n" . '</select>';
  879.  
  880.   // build dropdown for option_values from
  881.   $options_values_values_from = $db->Execute("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where language_id = '" . $_SESSION['languages_id'] . "' and products_options_values_id !='0' order by products_options_values_name");
  882.   while(!$options_values_values_from->EOF) {
  883.     $show_option_name= '&nbsp;&nbsp;&nbsp;[' . strtoupper(zen_get_products_options_name_from_value($options_values_values_from->fields['products_options_values_id'])) . ']';
  884.     $option_values_from_dropdown .= "\n" . '  <option name="' . $options_values_values_from->fields['products_options_values_name'] . '" value="' . $options_values_values_from->fields['products_options_values_id'] . '">' . $options_values_values_from->fields['products_options_values_name'] . $show_option_name . '</option>'; echo zen_draw_hidden_field('option_value_from_filter', $_GET['options_id_from']);
  885.     $options_values_values_from->MoveNext();
  886.   }
  887.  
  888.   $option_values_to_dropdown = $option_values_from_dropdown;
  889.  
  890.   $option_values_from_dropdown = "\n" . '<select name="options_values_values_id_from">' . $option_values_from_dropdown;
  891.   $option_values_from_dropdown .= "\n" . '</select>';
  892.  
  893.   $option_values_to_dropdown = "\n" . '<select name="options_values_values_id_to">' . $option_values_to_dropdown;
  894.   $option_values_to_dropdown .= "\n" . '</select>';
  895.  
  896.   $to_categories_id = TEXT_SELECT_OPTION_VALUES_TO_CATEGORIES_ID . '<br />&nbsp;<input type="text" name="copy_to_categories_id" size="4">&nbsp;';
  897.  
  898.   $options_id_from_products_id = TEXT_SELECT_OPTION_FROM_PRODUCTS_ID . '&nbsp;<input type="text" name="copy_from_products_id" size="4">&nbsp;';
  899.  
  900.   // eof: build dropdowns for delete and add
  901. ?>
  902.  
  903. <!--
  904. bof: copy Option Name and Value From to Option Name and Value to - all products
  905. example: Copy Color Red to products with Size Small
  906. -->
  907.  
  908.             <tr>
  909.               <td colspan="5"><?php echo zen_draw_separator('pixel_black.gif', '100%', '10'); ?></td>
  910.             </tr>
  911.             <tr>
  912.               <td class="main" colspan="4"><?php echo TEXT_OPTION_VALUE_COPY_ALL; ?></td>
  913.               <td class="main" colspan="1"> </td>
  914.             </tr>
  915.             <tr>
  916.               <td class="main" colspan="4"><?php echo TEXT_INFO_OPTION_VALUE_COPY_ALL; ?></td>
  917.               <td class="main" colspan="1"> </td>
  918.             </tr>
  919.             <tr class="dataTableHeadingRow">
  920.               <td colspan="5"><table border="1" cellspacing="0" cellpadding="2" width="100%">
  921.                 <tr class="dataTableHeadingRow">
  922.                   <form name="quick_jump" method="post" action="<?php echo zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=copy_options_values_one_to_another', 'NONSSL'); ?>"><?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>
  923.                   <td class="dataTableHeadingContent">
  924.                   <?php echo
  925.                   TEXT_SELECT_OPTION_FROM . '<br />' . $option_from_dropdown . '&nbsp;<br />' .
  926.                   TEXT_SELECT_OPTION_VALUES_FROM . '<br />' . $option_values_from_dropdown; ?>&nbsp;
  927.                   </td>
  928.                   <td class="dataTableHeadingContent">
  929.                   <?php echo
  930.                   TEXT_SELECT_OPTION_TO . '<br />' . $option_to_dropdown . '&nbsp<br />' .
  931.                   TEXT_SELECT_OPTION_VALUES_TO . '<br />' . $option_values_to_dropdown;?>&nbsp;
  932.                   </td>
  933.                   <td class="dataTableHeadingContent"><?php echo $to_categories_id; ?>&nbsp;</td>
  934.                   <td align="center" class="dataTableHeadingContent">&nbsp;<?php echo zen_image_submit('button_insert.gif', IMAGE_INSERT); ?>&nbsp;</td>
  935.                   </form>
  936.                 </tr>
  937.               </table></td>
  938.             </tr>
  939. <!-- eof: copy all option values to another Option Name -->
  940.  
  941.  
  942. <!--
  943. bof: delete all Option Name for an Value
  944. example: Delete Color Red
  945. -->
  946.  
  947.             <tr>
  948.               <td colspan="5"><?php echo zen_draw_separator('pixel_black.gif', '100%', '10'); ?></td>
  949.             </tr>
  950.             <tr>
  951.               <td class="main" colspan="4"><?php echo TEXT_OPTION_VALUE_DELETE_ALL; ?></td>
  952.               <td class="main" colspan="1"> </td>
  953.             </tr>
  954.             <tr>
  955.               <td class="main" colspan="4"><?php echo TEXT_INFO_OPTION_VALUE_DELETE_ALL; ?></td>
  956.               <td class="main" colspan="1"> </td>
  957.             </tr>
  958.             <tr class="dataTableHeadingRow">
  959.               <td colspan="5"><table border="1" cellspacing="0" cellpadding="2" width="100%">
  960.                 <tr class="dataTableHeadingRow">
  961.                   <form name="quick_jump" method="post" action="<?php echo zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=delete_options_values_of_option_name', 'NONSSL'); ?>"><?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>
  962.                   <td class="dataTableHeadingContent">
  963.                   <?php echo
  964.                   TEXT_SELECT_DELETE_OPTION_FROM . '<br />' . $option_from_dropdown . '&nbsp;<br />' .
  965.                   TEXT_SELECT_DELETE_OPTION_VALUES_FROM . '<br />' . $option_values_from_dropdown; ?>&nbsp;
  966.                   </td>
  967.                   <td class="dataTableHeadingContent"><?php echo $to_categories_id; ?>&nbsp;</td>
  968.                   <td align="center" class="dataTableHeadingContent">&nbsp;<?php echo zen_image_submit('button_delete.gif', IMAGE_DELETE); ?>&nbsp;</td>
  969.                   </form>
  970.                 </tr>
  971.               </table></td>
  972.             </tr>
  973. <!-- eof: delete all matching option name for option values -->
  974.  
  975.  
  976. <!--
  977. bof: copy Option Name and Value From to Option Name and Value to - all products
  978. example: Copy Color Red to products with Size Small
  979. -->
  980.  
  981.             <tr>
  982.               <td colspan="5"><?php echo zen_draw_separator('pixel_black.gif', '100%', '10'); ?></td>
  983.             </tr>
  984.             <tr>
  985.               <td class="main" colspan="4"><?php echo TEXT_OPTION_VALUE_COPY_OPTIONS_TO; ?></td>
  986.               <td class="main" colspan="1"> </td>
  987.             </tr>
  988.             <tr>
  989.               <td class="main" colspan="4"><?php echo TEXT_INFO_OPTION_VALUE_COPY_OPTIONS_TO; ?></td>
  990.               <td class="main" colspan="1"> </td>
  991.             </tr>
  992.             <tr class="dataTableHeadingRow">
  993.               <td colspan="5"><table border="1" cellspacing="0" cellpadding="2" width="100%">
  994.                 <tr class="dataTableHeadingRow">
  995.                   <form name="quick_jump" method="post" action="<?php echo zen_href_link(FILENAME_OPTIONS_VALUES_MANAGER, 'action=copy_options_values_one_to_another_options_id', 'NONSSL'); ?>"><?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>
  996.                   <td class="dataTableHeadingContent" valign="top">
  997.                   <?php echo
  998.                   TEXT_SELECT_OPTION_FROM_ADD . '<br />' . $option_from_dropdown . '&nbsp;<br />' .
  999.                   TEXT_SELECT_OPTION_VALUES_FROM_ADD . '<br />' . $option_values_from_dropdown . '&nbsp;<br /><br />' .
  1000.                   $options_id_from_products_id; ?>&nbsp;
  1001.                   </td>
  1002.                   <td class="dataTableHeadingContent" valign="top">
  1003.                   <?php echo
  1004.                   TEXT_SELECT_OPTION_TO_ADD_TO . '<br />' . $option_to_dropdown;?>&nbsp;
  1005.                   </td>
  1006.                   <td class="dataTableHeadingContent" valign="top">
  1007.                   <?php
  1008.                   echo $to_categories_id . '<br />' .
  1009.                   TEXT_COPY_ATTRIBUTES_CONDITIONS . '<br />' . zen_draw_radio_field('copy_attributes', 'copy_attributes_update') . ' ' . TEXT_COPY_ATTRIBUTES_UPDATE . '<br />' . zen_draw_radio_field('copy_attributes', 'copy_attributes_ignore', true) . ' ' . TEXT_COPY_ATTRIBUTES_IGNORE;
  1010.                   ?>&nbsp;</td>
  1011.                   <td align="center" class="dataTableHeadingContent" valign="top">&nbsp;<?php echo zen_image_submit('button_insert.gif', IMAGE_INSERT); ?>&nbsp;</td>
  1012.                   </form>
  1013.                 </tr>
  1014.               </table></td>
  1015.             </tr>
  1016. <!-- eof: copy all option values to another Option Name -->
  1017. <?php } // show copier features ?>
  1018.  
  1019.         </table>
  1020. </td></tr></table>
  1021. <!-- option value eof //-->
  1022.  
  1023. <!-- body_text_eof //-->
  1024. <!-- footer //-->
  1025. <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
  1026. <!-- footer_eof //-->
  1027. </body>
  1028. </html>
  1029. <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  1030.  


cron