gz2000 Posted September 16, 2011 Report Share Posted September 16, 2011 Hallo, ich habe folgendes Modul im Einsatz. funktioniert auch. Allerdings hätte ich gerne, dass im Adminbereich unter Artikelmerkmale Optionwerte die hochgeladenen Bilder als Vorschau in der Tabelle erscheinen. Kann mir jemand helfen? ######### <?php /* -------------------------------------------------------------- $Id: products_attributes.php 1155 2005-08-13 15:47:33Z matthias $ XT-Commerce - community made shopping xt:Commerce - Shopsoftware für Onlineshops - Webshop kostenlos downloaden Copyright © 2003 XT-Commerce -------------------------------------------------------------- based on: © 2000-2001 The Exchange Project (earlier name of osCommerce) © 2002-2003 osCommerce(products_attributes.php,v 1.48 2002/11/22); osCommerce, Open Source Online Shop E-Commerce Solutions © 2003 nextcommerce (products_attributes.php,v 1.10 2003/08/18); nextcommerce.org Released under the GNU General Public License --- 26.07.2005 Copyright © 2005 Sergej Stroh http://www.*****************************************************************************.de - Einfügen von kurzen Beschreibung - Zuweisen eine Attributbildes --------------------------------------------------------------*/ require('includes/application_top.php'); $languages = xtc_get_languages(); if ($_GET['action']) { $page_info = 'option_page=' . $_GET['option_page'] . '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $_GET['attribute_page']; switch($_GET['action']) { case 'add_product_options': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = $_POST['option_name']; xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . $_POST['products_options_id'] . "', '" . $option_name[$languages[$i]['id']] . "', '" . $languages[$i]['id'] . "')"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'add_product_option_values': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $value_name = $_POST['value_name']; $value_desc = $_POST['value_desc']; if ($image = &xtc_try_upload('value_image'.$i, DIR_FS_CATALOG_IMAGES.'product_options/')) { $paname_arr = explode('.',$image -> filename); $pnsuffix = array_pop($paname_arr); $value_image_name = $_POST['value_id'].'_'. $i .'.' . $pnsuffix; @unlink(DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); rename(DIR_FS_CATALOG_IMAGES.'product_options/'.$image -> filename, DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); } xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name, products_options_values_desc, products_options_values_image) values ('" . $_POST['value_id'] . "', '" . $languages[$i]['id'] . "', '" . $value_name[$languages[$i]['id']] . "', '" . $value_desc[$languages[$i]['id']] . "', '" . $value_image_name . "')"); } xtc_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . $_POST['option_id'] . "', '" . $_POST['value_id'] . "')"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'add_product_attributes': xtc_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $_POST['products_id'] . "', '" . $_POST['options_id'] . "', '" . $_POST['values_id'] . "', '" . $_POST['value_price'] . "', '" . $_POST['price_prefix'] . "')"); $products_attributes_id = xtc_db_insert_id(); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { xtc_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . $products_attributes_id . ", '" . $_POST['products_attributes_filename'] . "', '" . $_POST['products_attributes_maxdays'] . "', '" . $_POST['products_attributes_maxcount'] . "')"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_option_name': for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = $_POST['option_name']; xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $option_name[$languages[$i]['id']] . "' where products_options_id = '" . $_POST['option_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_value': $value_name = $_POST['value_name']; $value_desc = $_POST['value_desc']; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { if($_FILES['value_image'.$i]['name'] != '') { if ($image = &xtc_try_upload('value_image'.$i, DIR_FS_CATALOG_IMAGES.'product_options/')) { $paname_arr = explode('.',$image -> filename); $pnsuffix = array_pop($paname_arr); $value_image_name = $_POST['value_id'].'_'. $i .'.' . $pnsuffix; @unlink(DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); rename(DIR_FS_CATALOG_IMAGES.'product_options/'.$image -> filename, DIR_FS_CATALOG_IMAGES.'product_options/'.$value_image_name); // sql update ergaenzen $image_sql = ', products_options_values_image =\''. $value_image_name . '\''; } } elseif($_POST['del_value_image'. $i] == true) { // bild loeschen $image_sql = ', products_options_values_image = \'\''; } else { $image_sql = ''; } xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . $value_name[$languages[$i]['id']] . "', products_options_values_desc = '" . $value_desc[$languages[$i]['id']] . "' ". $image_sql ." where products_options_values_id = '" . $_POST['value_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); } xtc_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " set products_options_id = '" . $_POST['option_id'] . "' where products_options_values_id = '" . $_POST['value_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_product_attribute': xtc_db_query("update " . TABLE_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'] . "' where products_attributes_id = '" . $_POST['attribute_id'] . "'"); if ((DOWNLOAD_ENABLED == 'true') && $_POST['products_attributes_filename'] != '') { xtc_db_query("update " . TABLE_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'] . "'"); } xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_option': $del_options = xtc_db_query("select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); while($del_options_values = xtc_db_fetch_array($del_options)){ xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['option_id'] . "'"); } xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_value': xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . $_GET['value_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'delete_attribute': xtc_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . $_GET['attribute_id'] . "'"); // Added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled xtc_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $_GET['attribute_id'] . "'"); xtc_redirect(xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $_SESSION['language_charset']; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script type="text/javascript"><!-- function go_option() { if (document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value != "none") { location = "<?php echo xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '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; } } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="boxCenter" width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <!-- options and values//--> <tr> <td width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="top" class="main" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <!-- options //--> <?php if ($_GET['action'] == 'delete_product_option') { // delete product option $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $_GET['option_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'"); $options_values = xtc_db_fetch_array($options); ?> <tr> <td class="pageHeading"> <?php echo $options_values['products_options_name']; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $products = xtc_db_query("select p.products_id, pd.products_name, pov.products_options_values_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pov.language_id = '" . $_SESSION['languages_id'] . "' and pd.language_id = '" . $_SESSION['languages_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 (xtc_db_num_rows($products)) { ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php while ($products_values = xtc_db_fetch_array($products)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> <td class="smallText"> <?php echo $products_values['products_options_values_name']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr> <td colspan="3" class="main"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td> </tr> <tr> <td align="right" colspan="3" class="main"><br /><?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_OK_TO_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option&option_id=' . $_GET['option_id'], 'NONSSL'));?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&order_by=' . $order_by . '&page=' . $page, 'NONSSL'));?> </td> </tr> <?php } ?> </table></td> </tr> <?php } else { if ($_GET['option_order_by']) { $option_order_by = $_GET['option_order_by']; } else { $option_order_by = 'products_options_id'; } ?> <tr> <td colspan="2" class="pageHeading"> <?php echo HEADING_TITLE_OPT; ?> </td> <td align="right"><br /><form name="option_order_by" action="<?php echo FILENAME_PRODUCTS_ATTRIBUTES; ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td> </tr> <tr> <td colspan="3" class="smallText"> <?php $per_page = MAX_ROW_LISTS_OPTIONS; $options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by " . $option_order_by; if (!$option_page) { $option_page = 1; } $prev_option_page = $option_page - 1; $next_option_page = $option_page + 1; $option_query = xtc_db_query($options); $option_page_start = ($per_page * $option_page) - $per_page; $num_rows = xtc_db_num_rows($option_query); 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 '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $prev_option_page) . '"> << </a> | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $option_page) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $i) . '">' . $i . '</a> | '; } else { echo '<b><font color=red>' . $i . '</font></b> | '; } } // Next if ($option_page != $num_pages) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $next_option_page) . '"> >> </a>'; } ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $next_id = 1; $options = xtc_db_query($options); while ($options_values = xtc_db_fetch_array($options)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php if (($_GET['action'] == 'update_option') && ($_GET['option_id'] == $options_values['products_options_id'])) { echo '<form name="option" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_name', 'NONSSL') . '" method="post">'; $inputs = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = xtc_db_query("select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_values['products_options_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); $option_name = xtc_db_fetch_array($option_name); $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20" value="' . $option_name['products_options_name'] . '"> <br />'; } ?> <td align="center" class="smallText"> <?php echo $options_values['products_options_id']; ?><input type="hidden" name="option_id" value="<?php echo $options_values['products_options_id']; ?>"> </td> <td class="smallText"><?php echo $inputs; ?></td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_UPDATE); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL'));?> </td> <?php echo '</form>' . "\n"; } else { ?> <td align="center" class="smallText"> <?php echo $options_values["products_options_id"]; ?> </td> <td class="smallText"> <?php echo $options_values["products_options_name"]; ?> </td> <td align="center" class="smallText"> <?php echo xtc_button_link(BUTTON_EDIT, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option&option_id=' . $options_values['products_options_id'] . '&option_order_by=' . $option_order_by . '&option_page=' . $option_page, 'NONSSL'));?> <?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_product_option&option_id=' . $options_values['products_options_id'], 'NONSSL'));?> </td> <?php } ?> </tr> <?php $max_options_id_query = xtc_db_query("select max(products_options_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS); $max_options_id_values = xtc_db_fetch_array($max_options_id_query); $next_id = $max_options_id_values['next_id']; } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php if ($_GET['action'] != 'update_option') { ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php echo '<form name="options" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_options&option_page=' . $option_page, 'NONSSL') . '" method="post"><input type="hidden" name="products_options_id" value="' . $next_id . '">'; $inputs = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20"> <br />'; } ?> <td align="center" class="smallText"> <?php echo $next_id; ?> </td> <td class="smallText"><?php echo $inputs; ?></td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_INSERT); ?> </td> <?php echo '</form>'; ?> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php } } ?> </table></td> <!-- options eof //--> </tr><tr></tr> <td valign="top" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <!-- value //--> <?php if ($_GET['action'] == 'delete_option_value') { // delete product option value $values = xtc_db_query("select products_options_values_id, products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $_GET['value_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'"); $values_values = xtc_db_fetch_array($values); ?> <tr> <td colspan="3" class="pageHeading"> <?php echo $values_values['products_options_values_name']; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php $products = xtc_db_query("select p.products_id, pd.products_name, po.products_options_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS . " po, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and po.language_id = '" . $_SESSION['languages_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 (xtc_db_num_rows($products)) { ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> </tr> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <?php while ($products_values = xtc_db_fetch_array($products)) { $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td> <td class="smallText"> <?php echo $products_values['products_name']; ?> </td> <td class="smallText"> <?php echo $products_values['products_options_name']; ?> </td> </tr> <?php } ?> <tr> <td colspan="3"><?php echo xtc_black_line(); ?></td> </tr> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_WARNING_OF_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } else { ?> <tr> <td class="main" colspan="3"><br /><?php echo TEXT_OK_TO_DELETE; ?></td> </tr> <tr> <td class="main" align="right" colspan="3"><br /><?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_value&value_id=' . $_GET['value_id'], 'NONSSL')); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&option_page=' . $option_page . '&value_page=' . $_GET['value_page'] . '&attribute_page=' . $attribute_page, 'NONSSL'));?> </td> </tr> <?php } ?> </table></td> </tr> <?php } else { ?> <tr> <td colspan="3" class="pageHeading"> <?php echo HEADING_TITLE_VAL; ?> </td> <td> <?php echo xtc_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td> </tr> <tr> <td colspan="4" class="smallText"> <?php $per_page = MAX_ROW_LISTS_OPTIONS; $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id 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 = '" . $_SESSION['languages_id'] . "' order by pov.products_options_values_id"; if (!$_GET['value_page']) { $_GET['value_page'] = 1; } $prev_value_page = $_GET['value_page'] - 1; $next_value_page = $_GET['value_page'] + 1; $value_query = xtc_db_query($values); $value_page_start = ($per_page * $_GET['value_page']) - $per_page; $num_rows = xtc_db_num_rows($value_query); 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 '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> << </a> | '; } for ($i = 1; $i <= $num_pages; $i++) { if ($i != $_GET['value_page']) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $i) . '">' . $i . '</a> | '; } else { echo '<b><font color=red>' . $i . '</font></b> | '; } } // Next if ($_GET['value_page'] != $num_pages) { echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $next_value_page) . '"> >></a> '; } ?> </td> </tr> <!-- === ATTRIBUTS, IMAGE, DESCRIPTION, *****************************************************************************.de ============================ --> <tr class="attributs_header"> <td class="attributs_content" width="5%"> <?php echo TABLE_HEADING_ID; ?> </td> <td class="attributs_content"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> <td class="attributs_content"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> <td class="attributs_content" align="center" width="30%"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $next_id = 1; $values = xtc_db_query($values); while ($values_values = xtc_db_fetch_array($values)) { $options_name = xtc_options_name($values_values['products_options_id']); $values_name = $values_values['products_options_values_name']; $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php if (($_GET['action'] == 'update_option_value') && ($_GET['value_id'] == $values_values['products_options_values_id'])) { echo '<form name="values" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_value', 'NONSSL') . '" method="post" enctype="multipart/form-data">'; $inputs = ''; $inputs_desc = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $value_name = xtc_db_query("select products_options_values_name, products_options_values_desc, products_options_values_image from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $values_values['products_options_values_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); $value_name = xtc_db_fetch_array($value_name); $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="50" value="' . $value_name['products_options_values_name'] . '"> <br />'; if($value_name['products_options_values_image'] != '') { $inputs_image .= xtc_image(DIR_WS_CATALOG_IMAGES.'product_options/'. $value_name['products_options_values_image'], 'Optionsimage').'<br />'; $inputs_image .= xtc_draw_selection_field('del_value_image'. $i, 'checkbox', 'value_image'. $i) .' '. TABLE_TEXT_DELETE .'<br /><br />'; } $inputs_image .= $languages[$i]['code'] . ': '. xtc_draw_file_field('value_image'. $i). ' <br />'; $inputs_desc .= $languages[$i]['code'] . ': <textarea name="value_desc[' . $languages[$i]['id'] . ']" cols="50" rows="4">' . $value_name['products_options_values_desc'] . '</textarea> <br />'; } ?> <td align="left" class="smallText" colspan="4"> <!-- update optionaname, image and description --> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr class="attributs_new"> <td class="attributs_new" width="4%"> <?php echo $values_values['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values['products_options_values_id']; ?>"> </td> <td class="attributs_new" width="20%"> <strong><?php echo TABLE_HEADING_OPT_NAME; ?></strong> </td> <td class="attributs_new" width="40%"> <?php echo "\n"; ?><select name="option_id"> <?php $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by products_options_name"); while ($options_values = xtc_db_fetch_array($options)) { echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '"'; if ($values_values['products_options_id'] == $options_values['products_options_id']) { echo ' selected'; } echo '>' . $options_values['products_options_name'] . '</option>'; } ?> </select> </td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_UPDATE); ?> <?php echo xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL')); ?> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsname --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_VALUE; ?></strong> </td> <td class="attributs_name"><?php echo $inputs; ?></td> </tr> </table> <!-- optionsname EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsimage --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_IMAGE; ?></strong> </td> <td class="attributs_name"><?php echo $inputs_image; ?></td> </tr> </table> <!-- optionsimage EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsdescription --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_DESC; ?></strong> </td> <td class="attributs_name"><?php echo $inputs_desc; ?></td> </tr> </table> <!-- optionsdescription EOF --> </td> </tr> </table> <!-- update optionaname, image and description EOF --> </td> <?php echo '</form>'; } else { // attributanzeige ?> <td align="center" class="smallText"> <?php echo $values_values["products_options_values_id"]; ?> </td> <td align="center" class="smallText"> <?php echo $options_name; ?> </td> <td class="smallText"> <?php echo $values_name; ?> </td> <td align="center" class="smallText"> <?php echo xtc_button_link(BUTTON_EDIT, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_value&value_id=' . $values_values['products_options_values_id'] . '&value_page=' . $_GET['value_page'], 'NONSSL')); ?> <?php echo xtc_button_link(BUTTON_DELETE, xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option_value&value_id=' . $values_values['products_options_values_id'], 'NONSSL')); ?> </td> <?php } $max_values_id_query = xtc_db_query("select max(products_options_values_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS_VALUES); $max_values_id_values = xtc_db_fetch_array($max_values_id_query); $next_id = $max_values_id_values['next_id']; } ?> </tr> <tr> <td colspan="4"><?php echo xtc_black_line(); ?></td> </tr> <?php if ($_GET['action'] != 'update_option_value') { ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php echo '<form name="values" action="' . xtc_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_option_values&value_page=' . $_GET['value_page'], 'NONSSL') . '" method="post" enctype="multipart/form-data">'; ?> <td align="left" class="smallText" colspan="4"> <!-- optionaname, image and description --> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr class="attributs_new"> <td class="attributs_new" width="5%"> <?php echo $next_id; ?> </td> <td class="attributs_new" width="20%"> <strong><?php echo TABLE_HEADING_OPT_NAME; ?></strong> </td> <td class="attributs_new" width="55%"> <select name="option_id"> <?php $options = xtc_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $_SESSION['languages_id'] . "' order by products_options_name"); while ($options_values = xtc_db_fetch_array($options)) { echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>'; } $inputs = ''; $inputs_desc = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15"> <br />'; $inputs_image .= $languages[$i]['code'] . ': '. xtc_draw_file_field('value_image'. $i). ' <br />'; $inputs_desc .= $languages[$i]['code'] . ': <textarea name="value_desc[' . $languages[$i]['id'] . ']" cols="50" rows="4"></textarea> <br />'; } ?> </select> </td> <td align="center" class="smallText"> <?php echo xtc_button(BUTTON_INSERT); ?> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsname --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_VALUE; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs; ?></td> </tr> </table> <!-- optionsname EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsimage --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_IMAGE; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs_image; ?></td> </tr> </table> <!-- optionsimage EOF --> </td> </tr> <tr> <td class="attributs_name"> </td> <td class="smallText" colspan="3"> <!-- optionsdescription --> <table width="100%" cellpadding="2" cellspacing="0" border="0"> <tr> <td class="attributs_name" width="20%"> <strong><?php echo TABLE_HEADING_OPT_DESC; ?></strong> </td> <td class="attributs_name"><input type="hidden" name="value_id" value="<?php echo $next_id; ?>"><?php echo $inputs_desc; ?></td> </tr> </table> <!-- optionsdescription EOF --> </td> </tr> </table> <!-- optionaname, image and description EOF --> </td> <?php echo '</form>'; ?> </tr> <tr> <td colspan="4"><?php echo xtc_black_line(); ?></td> </tr> <?php } } ?> </table></td> </tr> </table></td> <!-- option value eof //--> </tr> </table></td> <!-- products_attributes_eof //--> </tr> </table> <!-- body_text_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.