Execute("INSERT INTO " . $oosDBTable['products_options'] . " (products_options_id, products_options_name, products_options_languages_id,products_options_type) VALUES ('" . $_POST['products_options_id'] . "', '" . $option_name[$languages[$i]['id']] . "', '" . $languages[$i]['id'] . "', '" . $option_type . "')"); } switch ($option_type) { case PRODUCTS_OPTIONS_TYPE_TEXT: case PRODUCTS_OPTIONS_TYPE_FILE: $db->Execute("INSERT INTO " . $oosDBTable['products_options_values_to_products_options'] . " (products_options_values_id, products_options_id) values ('" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "', '" . (int)$products_options_id . "')"); break; } oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'add_product_option_values': for ($i = 0, $n = count($languages); $i < $n; $i ++) { $value_name = $_POST['value_name']; $db->Execute("INSERT INTO " . $oosDBTable['products_options_values'] . " (products_options_values_id, products_options_values_languages_id, products_options_values_name) VALUES ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . $value_name[$languages[$i]['id']] . "')"); } $db->Execute("INSERT INTO " . $oosDBTable['products_options_values_to_products_options'] . " (products_options_id, products_options_values_id) VALUES ('" . $_POST['option_id'] . "', '" . $_POST['value_id'] . "')"); oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'add_product_attributes': if (OOS_PRICE_IS_BRUTTO == 'true'){ $sql = "SELECT tr.tax_rate FROM " . $oosDBTable['tax_rates'] . " tr, " . $oosDBTable['products'] . " p WHERE tr.tax_class_id = p.products_tax_class_id AND p.products_id = '".$_POST['products_id']."' "; $tax_result = $db->Execute($sql); $tax = $tax_result->fields; $_POST['value_price'] = ($_POST['value_price']/($tax[tax_rate]+100)*100); } $products_options_result = $db->Execute("SELECT products_options_type FROM " . $oosDBTable['products_options'] . " WHERE products_options_id = '" . $_POST['options_id'] . "'"); $products_options_array = $products_options_result->fields; $values_id = (($products_options_array['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT) or ($products_options_array['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE)) ? PRODUCTS_OPTIONS_VALUE_TEXT_ID : $_POST['values_id']; $db->Execute("INSERT INTO " . $oosDBTable['products_attributes'] . " VALUES ('', '" . $_POST['products_id'] . "', '" . $_POST['options_id'] . "', '" . $_POST['values_id'] . "', '" . $_POST['value_price'] . "', '" . $_POST['price_prefix'] . "', '" . $_POST['sort_order'] . "')"); $products_attributes_id = $db->Insert_ID(); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { $db->Execute("INSERT INTO " . $oosDBTable['products_attributes_download'] . " VALUES (" . $products_attributes_id . ", '" . $_POST['products_attributes_filename'] . "', '" . $_POST['products_attributes_maxdays'] . "', '" . $_POST['products_attributes_maxcount'] . "')"); } oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'update_option_name': for ($i = 0, $n = count($languages); $i < $n; $i ++) { $option_name = $_POST['option_name']; $option_type = $_POST['option_type']; $db->Execute("UPDATE " . $oosDBTable['products_options'] . " SET products_options_name = '" . $option_name[$languages[$i]['id']] . "', products_options_type = '" . $option_type . "' WHERE products_options_id = '" . $_POST['option_id'] . "' AND products_options_languages_id = '" . $languages[$i]['id'] . "'"); } switch ($option_type) { case PRODUCTS_OPTIONS_TYPE_TEXT: case PRODUCTS_OPTIONS_TYPE_FILE: $db->Execute("INSERT INTO " . $oosDBTable['products_options_values_to_products_options'] . " VALUES (NULL, '" . $_POST['option_id'] . "', '" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "')"); break; default: $db->Execute("DELETE FROM " . $oosDBTable['products_options_values_to_products_options'] . " WHERE products_options_values_id = '" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "'"); } oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'update_value': for ($i = 0, $n = count($languages); $i < $n; $i ++) { $value_name = $_POST['value_name']; $db->Execute("UPDATE " . $oosDBTable['products_options_values'] . " SET products_options_values_name = '" . $value_name[$languages[$i]['id']] . "' WHERE products_options_values_id = '" . $_POST['value_id'] . "' AND products_options_values_languages_id= '" . $languages[$i]['id'] . "'"); } // $db->Execute("UPDATE " . $oosDBTable['products_options_values_to_products_options'] . " SET products_options_id = '" . $_POST['option_id'] . "', products_options_values_id = '" . $_POST['value_id'] . "' WHERE products_options_values_to_products_options_id = '" . $_POST['value_id'] . "'"); $db->Execute("UPDATE " . $oosDBTable['products_options_values_to_products_options'] . " SET products_options_id = '" . $_POST['option_id'] . "' WHERE products_options_values_id = '" . $_POST['value_id'] . "'"); oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'update_product_attribute': if (OOS_PRICE_IS_BRUTTO == 'true'){ $sql = "SELECT tr.tax_rate FROM " . $oosDBTable['tax_rates'] . " tr, " . $oosDBTable['products'] . " p WHERE tr.tax_class_id = p.products_tax_class_id AND p.products_id = '".$_POST['products_id']."' "; $tax_result = $db->Execute($sql); $tax = $tax_result->fields; $_POST['value_price'] = ($_POST['value_price']/($tax[tax_rate]+100)*100); } $products_options_result = $db->Execute("SELECT products_options_type FROM " . $oosDBTable['products_options'] . " WHERE products_options_id = '" . $_POST['options_id'] . "'"); $products_options_array = $products_options_result->fields; switch ($products_options_array['products_options_type']) { case PRODUCTS_OPTIONS_TYPE_TEXT: case PRODUCTS_OPTIONS_TYPE_FILE: $values_id = PRODUCTS_OPTIONS_VALUE_TEXT_ID; break; default: $values_id = $_POST['values_id']; } $db->Execute("UPDATE " . $oosDBTable['products_attributes'] . " SET products_id = '" . $_POST['products_id'] . "', options_id = '" . $_POST['options_id'] . "', options_values_id = '" . $_POST['values_id'] . "', options_values_price = '" . $_POST['value_price'] . "', price_prefix = '" . $_POST['price_prefix'] . "', options_sort_order = '" . $_POST['sort_order'] . "' WHERE products_attributes_id = '" . $_POST['attribute_id'] . "'"); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { $db->Execute("UPDATE " . $oosDBTable['products_attributes_download'] . " SET products_attributes_filename='" . $_POST['products_attributes_filename'] . "', products_attributes_maxdays='" . $_POST['products_attributes_maxdays'] . "', products_attributes_maxcount='" . $_POST['products_attributes_maxcount'] . "' WHERE products_attributes_id = '" . $_POST['attribute_id'] . "'"); } oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'delete_option': $db->Execute("DELETE FROM " . $oosDBTable['products_options'] . " WHERE products_options_id = '" . $_GET['option_id'] . "'"); $db->Execute("DELETE FROM " . $oosDBTable['products_options_values_to_products_options'] . " WHERE products_options_id = '" . (int)$option_id . "' AND products_options_values_id = '" . PRODUCTS_OPTIONS_VALUES_TEXT_ID . "'"); oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'delete_value': $db->Execute("DELETE FROM " . $oosDBTable['products_options_values'] . " WHERE products_options_values_id = '" . $_GET['value_id'] . "'"); $db->Execute("DELETE FROM " . $oosDBTable['products_options_values_to_products_options'] . " WHERE products_options_values_id = '" . $_GET['value_id'] . "'"); oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; case 'delete_attribute': $db->Execute("DELETE FROM " . $oosDBTable['products_attributes'] . " WHERE products_attributes_id = '" . $_GET['attribute_id'] . "'"); $db->Execute("DELETE FROM " . $oosDBTable['products_attributes_download'] . " WHERE products_attributes_id = '" . $_GET['attribute_id'] . "'"); oosRedirect(oosLink($aFilename['products_attributes'], $page_info)); break; } } $products_options_types_list = array(); $products_options_types_sql = "SELECT products_options_types_id, products_options_types_name FROM " . $oosDBTable['products_options_types'] . " WHERE products_options_types_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_types_id"; $products_options_types_result = $db->Execute($products_options_types_sql); while ($products_options_type_array = $products_options_types_result->fields) { $products_options_types_list[$products_options_type_array['products_options_types_id']] = $products_options_type_array['products_options_types_name']; $products_options_types_result->MoveNext(); } if (!isset($value_page)) { $value_page = 1; } if (!isset($attribute_page)) { $attribute_page = 1; } ?> > size > 0) { echo $messageStack->output(); } ?>

	' . oosImage(OOS_IMAGES . 'support.png', HEADER_TITLE_SUPPORT_SITE, '50', '50') . '  ' . oosImage(OOS_IMAGES . 'checkout.png', HEADER_TITLE_ONLINE_CATALOG, '50', '50') . '  ' . oosImage(OOS_IMAGES . 'administration.png', HEADER_TITLE_ADMINISTRATION, '50', '50') . ''; ?>
' . HEADER_TITLE_ACCOUNT . ' | ' . HEADER_TITLE_LOGOFF . ''; } else { echo '' . HEADER_TITLE_TOP . ''; }?>	' . HEADER_TITLE_SUPPORT_SITE . '  |  ' . HEADER_TITLE_ONLINE_CATALOG . ' |  ' . HEADER_TITLE_ADMINISTRATION . ''; ?>

Execute("SELECT products_options_id, products_options_name FROM " . $oosDBTable['products_options'] . " WHERE products_options_id = '" . $_GET['option_id'] . "' AND products_options_languages_id = '" . intval($_SESSION['language_id']) . "'"); $options_values = $options->fields; ?> Execute($options); while ($options_values = $options->fields) { $rows++; ?> '; $inputs = ''; for ($i = 0, $n = count($languages); $i < $n; $i ++) { $option_name = $db->Execute("SELECT products_options_name FROM " . $oosDBTable['products_options'] . " WHERE products_options_id = '" . $options_values['products_options_id'] . "' AND products_options_languages_id = '" . $languages[$i]['id'] . "'"); $option_name = $option_name->fields; $inputs .= $languages[$i]['id'] . ':   '; } ?> ' . "\n"; } else { ?> Execute("SELECT max(products_options_id) + 1 as next_id FROM " . $oosDBTable['products_options']); $max_options_id_values = $max_options_id_result->fields; $next_id = $max_options_id_values['next_id']; $options->MoveNext(); } ?> '; $inputs = ''; for ($i = 0, $n = count($languages); $i < $n; $i ++) { $inputs .= oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' '; $inputs .= $languages[$i]['id'] . ':   '; } ?> '; ?>       Execute("SELECT p.products_id, pd.products_name, pov.products_options_values_name FROM " . $oosDBTable['products'] . " p, " . $oosDBTable['products_options_values'] . " pov, " . $oosDBTable['products_attributes'] . " pa, " . $oosDBTable['products_description'] . " pd WHERE pd.products_id = p.products_id AND pov.products_options_values_languages_id = '" . intval($_SESSION['language_id']) . "' AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' AND pa.products_id = p.products_id AND pa.options_id='" . $_GET['option_id'] . "' AND pov.products_options_values_id = pa.options_values_id ORDER BY pd.products_name"); if ($products->RecordCount()) { ?> fields) { $rows++; ?> MoveNext(); } ?>                   '; ?>  '; ?>   '; ?>     >> Execute($options); $option_page_start = ($per_page * $option_page) - $per_page; $num_rows = $option_result->RecordCount(); if ($num_rows <= $per_page) { $num_pages = 1; } else if (($num_rows % $per_page) == 0) { $num_pages = ($num_rows / $per_page); } else { $num_pages = ($num_rows / $per_page) + 1; } $num_pages = (int) $num_pages; $options = $options . " LIMIT $option_page_start, $per_page"; // Previous if ($prev_option_page) { echo ' << | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $option_page) { echo '' . $i . ' | '; } else { echo '' . $i . ' | '; } } // Next if ($option_page != $num_pages) { echo ' >> '; } ?>                   '; ?>            '; ?>  '; ?>        Execute("SELECT products_options_values_id, products_options_values_name FROM " . $oosDBTable['products_options_values'] . " WHERE products_options_values_id = '" . $_GET['value_id'] . "' AND products_options_values_languages_id = '" . intval($_SESSION['language_id']) . "'"); $values_values = $values->fields; ?> Execute($values); while ($values_values = $values->fields) { $options_name = oosOptionsName($values_values['products_options_id']); $option_id = $values_values['products_options_id']; $values_name = $values_values['products_options_values_name']; $rows++; ?> '; $inputs = ''; for ($i = 0, $n = count($languages); $i < $n; $i ++) { $value_name = $db->Execute("SELECT products_options_values_name FROM " . $oosDBTable['products_options_values'] . " WHERE products_options_values_id = '" . $values_values['products_options_values_id'] . "' AND products_options_values_languages_id= '" . $languages[$i]['id'] . "'"); $value_name = $value_name->fields; $inputs .= oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' '; $inputs .= $languages[$i]['id'] . ':   '; } ?> '; } else { ?> Execute("SELECT max(products_options_values_id) + 1 as next_id FROM " . $oosDBTable['products_options_values']); $max_values_id_values = $max_values_id_result->fields; $next_id = $max_values_id_values['next_id']; $values->MoveNext(); } ?> '; ?> '; ?>       Execute("SELECT p.products_id, pd.products_name, po.products_options_name FROM " . $oosDBTable['products'] . " p, " . $oosDBTable['products_attributes'] . " pa, " . $oosDBTable['products_options'] . " po, " . $oosDBTable['products_description'] . " pd WHERE pd.products_id = p.products_id AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' AND po.products_options_languages_id = '" . intval($_SESSION['language_id']) . "' AND pa.products_id = p.products_id AND pa.options_values_id='" . $_GET['value_id'] . "' AND po.products_options_id = pa.options_id ORDER BY pd.products_name"); if ($products->RecordCount()) { ?> fields) { $rows++; ?> MoveNext(); } ?>                   '; ?>  '; ?>   '; ?>        Execute($values); $value_page_start = ($per_page * $value_page) - $per_page; $num_rows = $value_result->RecordCount(); if ($num_rows <= $per_page) { $num_pages = 1; } else if (($num_rows % $per_page) == 0) { $num_pages = ($num_rows / $per_page); } else { $num_pages = ($num_rows / $per_page) + 1; } $num_pages = (int) $num_pages; $values = $values . " LIMIT $value_page_start, $per_page"; // Previous if ($prev_value_page) { echo ' << | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $value_page) { echo '' . $i . ' | '; } else { echo '' . $i . ' | '; } } // Next if ($value_page != $num_pages) { echo ' >> '; } ?>                  Execute("SELECT products_options_id, products_options_name FROM " . $oosDBTable['products_options'] . " WHERE products_options_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_name"); while ($options_values = $options->fields) { echo "\n" . '' . $options_values['products_options_name'] . ''; $options->MoveNext(); } ?>     '; ?>            '; ?>  '; ?>       Execute("SELECT products_options_id, products_options_name FROM " . $oosDBTable['products_options'] . " WHERE products_options_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_name"); while ($options_values = $options->fields) { echo '' . $options_values['products_options_name'] . ''; $options->MoveNext(); } $inputs = ''; for ($i = 0, $n = count($languages); $i < $n; $i ++) { $inputs .= oosImage(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' '; $inputs .= $languages[$i]['id'] . ':   '; } ?>      Execute($attributes); while ($attributes_values = $attributes->fields) { $products_name_only = oosGetProductsName($attributes_values['products_id']); $options_name = oosOptionsName($attributes_values['options_id']); $values_name = oosValuesName($attributes_values['options_values_id']); $rows++; ?> Execute($sql); $tax = $tax_result->fields; $in_price= ($in_price*($tax[tax_rate]+100)/100); } $in_price = round ($in_price,TAX_DECIMAL_PLACES); ?> Execute($download_result_raw); if ($download_result->RecordCount() > 0) { $download = $download_result->fields; $products_attributes_filename = $download['products_attributes_filename']; $products_attributes_maxdays = $download['products_attributes_maxdays']; $products_attributes_maxcount = $download['products_attributes_maxcount']; } ?> Execute($sql); $tax = $tax_result->fields; $in_price = ($in_price*($tax[tax_rate]+100)/100); } $in_price= round($in_price,TAX_DECIMAL_PLACES); ?> Execute("SELECT max(products_attributes_id) + 1 as next_id FROM " . $oosDBTable['products_attributes']); $max_attributes_id_values = $max_attributes_id_result->fields; $next_id = $max_attributes_id_values['next_id']; ?> MoveNext(); } if ($action != 'update_attribute') { ?> Execute($attributes); $attribute_page_start = ($per_page * $attribute_page) - $per_page; $num_rows = $attribute_result->RecordCount(); if ($num_rows <= $per_page) { $num_pages = 1; } else if (($num_rows % $per_page) == 0) { $num_pages = ($num_rows / $per_page); } else { $num_pages = ($num_rows / $per_page) + 1; } $num_pages = (int) $num_pages; $attributes = $attributes . " LIMIT $attribute_page_start, $per_page"; // Previous if ($prev_attribute_page) { echo ' << | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $attribute_page) { echo '' . $i . ' | '; } else { echo '' . $i . ' | '; } } // Next if ($attribute_page != $num_pages) { echo ' >> '; } ?>                              Execute("SELECT p.products_id, pd.products_name FROM " . $oosDBTable['products'] . " p, " . $oosDBTable['products_description'] . " pd WHERE pd.products_id = p.products_id AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name"); while($products_values = $products->fields) { if ($attributes_values['products_id'] == $products_values['products_id']) { echo "\n" . '' . $products_values['products_name'] . ''; } else { echo "\n" . '' . $products_values['products_name'] . ''; } $products->MoveNext(); } ?>     Execute("SELECT * FROM " . $oosDBTable['products_options'] . " WHERE products_options_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_name"); while($options_values = $options->fields) { if ($attributes_values['options_id'] == $options_values['products_options_id']) { echo "\n" . '' . $options_values['products_options_name'] . ''; } else { echo "\n" . '' . $options_values['products_options_name'] . ''; } $options->MoveNext(); } ?>     Execute("SELECT * FROM " . $oosDBTable['products_options_values'] . " WHERE products_options_values_languages_id='" . intval($_SESSION['language_id']) . "' ORDER BY products_options_values_name"); while($values_values = $values->fields) { if ($attributes_values['options_values_id'] == $values_values['products_options_values_id']) { echo "\n" . '' . $values_values['products_options_values_name'] . ''; } else { echo "\n" . '' . $values_values['products_options_values_name'] . ''; } $values->MoveNext(); } ?>        '; ?>      '; ?>                           '; ?>  '; ?>                        '; ?>  '; ?>       Execute("SELECT p.products_id, pd.products_name FROM " . $oosDBTable['products'] . " p, " . $oosDBTable['products_description'] . " pd WHERE pd.products_id = p.products_id AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name"); while ($products_values = $products->fields) { echo '' . $products_values['products_name'] . ''; $products->MoveNext(); } ?>     Execute("SELECT * FROM " . $oosDBTable['products_options'] . " WHERE products_options_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_name"); while ($options_values = $options->fields) { echo '' . $options_values['products_options_name'] . ''; $options->MoveNext(); } ?>     Execute("SELECT * FROM " . $oosDBTable['products_options_values'] . " WHERE products_options_values_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY products_options_values_name"); while ($values_values = $values->fields) { echo '' . $values_values['products_options_values_name'] . ''; $values->MoveNext(); } ?>