Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Attribute Sort in Table

Guest

By Guest
in General Add-Ons Support

 Share

Recommended Posts

Guest

Guest

Posted
Posted

Hello...

 

If someone could help me change the sort order in this table it would be great. I circled in red the list out of order. I beleive that is the value_id that I want in order but i could be wrong. BTW this is in my /admin/categories.php after i add new product i can add new attrib values to it. Thank you very much.

 

--Jeremy

 

test.jpg

 

<!-- products_attributes //-->
<?php
 #PR Save or update section for products attributes
 if ($HTTP_GET_VARS['action_att']) {
   $page_info = 'option_page=' . $HTTP_GET_VARS['option_page'] . '&value_page=' . $HTTP_GET_VARS['value_page'] . '&attribute_page=' . $HTTP_GET_VARS['attribute_page'];
   switch($HTTP_GET_VARS['action_att']) {
     case 'add_product_options':
       for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
         $option_name = $HTTP_POST_VARS['option_name'];
         tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . $HTTP_POST_VARS['products_options_id'] . "', '" . $option_name[$languages[$i]['id']] . "', '" . $languages[$i]['id'] . "')");
       }
       break;
     case 'add_product_option_values':
       for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
         $value_name = $HTTP_POST_VARS['value_name'];
         $value_description = $HTTP_POST_VARS['value_description'];
         tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name, products_options_description) values ('" . $HTTP_POST_VARS['value_id'] . "', '" . $languages[$i]['id'] . "', '" . $value_name[$languages[$i]['id']] . "', '" . $value_description[$languages[$i]['id']] . "')");
       }
       tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . $HTTP_POST_VARS['option_id'] . "', '" . $HTTP_POST_VARS['value_id'] . "')");
       break;
     case 'add_product_attributes':
       tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . $HTTP_POST_VARS['products_id'] . "', '" . $HTTP_POST_VARS['options_id'] . "', '" . $HTTP_POST_VARS['values_id'] . "', '" . $HTTP_POST_VARS['value_price'] . "', '" . $HTTP_POST_VARS['price_prefix'] . "')");
       $products_attributes_id = tep_db_insert_id();
       if ((DOWNLOAD_ENABLED == 'true') && $HTTP_POST_VARS['products_attributes_filename'] != '') {
         tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . $products_attributes_id . ", '" . $HTTP_POST_VARS['products_attributes_filename'] . "', '" . $HTTP_POST_VARS['products_attributes_maxdays'] . "', '" . $HTTP_POST_VARS['products_attributes_maxcount'] . "')");
       }
       break;
     case 'update_option_name':
       for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
         $option_name = $HTTP_POST_VARS['option_name'];
         tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . $option_name[$languages[$i]['id']] . "' where products_options_id = '" . $HTTP_POST_VARS['option_id'] . "' and language_id = '" . $languages[$i]['id'] . "'");
       }
       break;
     case 'update_value':
       for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {
         $value_name = $HTTP_POST_VARS['value_name'];
         $value_description = $HTTP_POST_VARS['value_description'];
         tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . $value_name[$languages[$i]['id']] . "', products_options_description = '" . $value_description[$languages[$i]['id']] . "' where products_options_values_id = '" . $HTTP_POST_VARS['value_id'] . "' and language_id = '" . $languages[$i]['id'] . "'");
       }
       #PR. NOTE: BUG in original distribution!
       # WAS where products_options_values_to_products_options_id = ...
       # NOW: where products_options_values_id = ...
       tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " set products_options_id = '" . $HTTP_POST_VARS['option_id'] . "', products_options_values_id = '" . $HTTP_POST_VARS['value_id'] . "'  where products_options_values_id = '" . $HTTP_POST_VARS['value_id'] . "'");
       break;
     case 'update_product_attribute':
       tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id = '" . $HTTP_POST_VARS['products_id'] . "', options_id = '" . $HTTP_POST_VARS['options_id'] . "', options_values_id = '" . $HTTP_POST_VARS['values_id'] . "', options_values_price = '" . $HTTP_POST_VARS['value_price'] . "', price_prefix = '" . $HTTP_POST_VARS['price_prefix'] . "' where products_attributes_id = '" . $HTTP_POST_VARS['attribute_id'] . "'");
       if ((DOWNLOAD_ENABLED == 'true') && $HTTP_POST_VARS['products_attributes_filename'] != '') {
         tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "
                       set products_attributes_filename='" . $HTTP_POST_VARS['products_attributes_filename'] . "',
                           products_attributes_maxdays='" . $HTTP_POST_VARS['products_attributes_maxdays'] . "',
                           products_attributes_maxcount='" . $HTTP_POST_VARS['products_attributes_maxcount'] . "'
                       where products_attributes_id = '" . $HTTP_POST_VARS['attribute_id'] . "'");
       }
       break;
     case 'delete_option':
       tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $HTTP_GET_VARS['option_id'] . "'");
       break;
     case 'delete_value':
       tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $HTTP_GET_VARS['value_id'] . "'");
       tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $HTTP_GET_VARS['value_id'] . "'");
       tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . $HTTP_GET_VARS['value_id'] . "'");
       break;
     case 'delete_attribute':
       tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . $HTTP_GET_VARS['attribute_id'] . "'");
// Added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled
       tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $HTTP_GET_VARS['attribute_id'] . "'");
       break;
   }
 }
 #PR End of save attributes section
?>

<?php
if ( ( $HTTP_GET_VARS['action'] == 'insert_product' || $HTTP_GET_VARS['action'] == 'new_product'
       || $HTTP_GET_VARS['action'] == 'update_product' ) && $pInfo->products_id) {
?>
     <tr>
       <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="pageHeading"> <a name = 'atts'><?php echo HEADING_TITLE_ATRIB; ?></a> </td>
           <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td>
         </tr>
       </table></td>
     </tr>
     <tr>
<?php
   if ($HTTP_GET_VARS['action_att'] == 'update_attribute') {
     $form_action = 'update_product_attribute';
   } else {
     $form_action = 'add_product_attributes';
   }
?>
       <td><form name="attributes" action="<?php echo tep_href_link(FILENAME_CATEGORIES, 'action_att=' . $form_action . '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath. '#atts'); ?>" method="post">
       <table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td colspan="7" class="smallText">
<?php
       $attributes = "select pa.* from " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pa.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' where pd.products_id = " . $pInfo->products_id;
 if (!$attribute_page)
 {
       $attribute_page = 1;
 }

?>
           </td>
         </tr>
         <tr>
           <td colspan="7"><?php echo tep_black_line(); ?></td>
         </tr>
         <tr class="dataTableHeadingRow">
           <td class="dataTableHeadingContent"> <?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>
           <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td>
           <td class="dataTableHeadingContent" align="right"> <?php echo TABLE_HEADING_OPT_PRICE; ?> </td>
           <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_OPT_PRICE_PREFIX; ?> </td>
           <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td>
         </tr>
         <tr>
           <td colspan="7"><?php echo tep_black_line(); ?></td>
         </tr>
<?php
 $next_id = 1;
 $attributes = tep_db_query($attributes);
 while ($attributes_values = tep_db_fetch_array($attributes))
 {
   $products_name_only = tep_get_products_name($attributes_values['products_id']);
   $options_name = tep_options_name($attributes_values['options_id']);
   $values_name = tep_values_name($attributes_values['options_values_id']);
   $rows++;
?>
         <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">
<?php
   if (($HTTP_GET_VARS['action_att'] == 'update_attribute') && ($HTTP_GET_VARS['attribute_id'] == $attributes_values['products_attributes_id'])) {
?>
           <td class="smallText"> <?php echo $attributes_values['products_attributes_id']; ?><input type="hidden" name="attribute_id" value="<?php echo $attributes_values['products_attributes_id']; ?>"> </td>
           <td class="smallText"> <select name="products_id">
<?php
     $products = "select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and pd.products_id = " . $pInfo->products_id;
     $products = tep_db_query($products);
     while($products_values = tep_db_fetch_array($products)) {
       if ($attributes_values['products_id'] == $products_values['products_id']) {
         echo "\n" . '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '" SELECTED>' . $products_values['products_name'] . '</option>';
       } else {
         echo "\n" . '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_name'] . '</option>';
       }
     }
?>
           </select> </td>
<script language=JavaScript>
<!-- Begin
<?php
     $options = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name");
     while($options_values = tep_db_fetch_array($options)) {
         echo "\n" .' var Array' . $options_values['products_options_id'] . ' = new Array(';
               $values = tep_db_query("select pov.* from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " potv where pov.language_id ='" . $languages_id . "' and potv.products_options_id = " . $options_values['products_options_id'] . " and potv.products_options_values_id = pov.products_options_values_id order by pov.products_options_values_name");
               $comma = '';
               while($values_values = tep_db_fetch_array($values)) {
               if ($attributes_values['options_values_id'] == $values_values['products_options_values_id']) {
                        echo "\n".' "(\''.$values_values['products_options_values_name'].'\', \''.$values_values['products_options_values_id'] . '\', true, true)"';
                       $comma = ',';
                 }
               }
               $values = tep_db_query("select pov.* from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " potv where pov.language_id ='" . $languages_id . "' and potv.products_options_id = " . $options_values['products_options_id'] . " and potv.products_options_values_id = pov.products_options_values_id order by pov.products_options_values_name");
               while($values_values = tep_db_fetch_array($values)) {
                       echo "\n".$comma.' "(\''.$values_values['products_options_values_name'].'\', \''.$values_values['products_options_values_id'] . '\')"';
                       $comma = ',';
               }
     echo ");";
     }
?>

function populateOptions(inForm,selected)
{
 var selectedArray = eval("Array" + selected);
 while (selectedArray.length < inForm.values_id.options.length)
 {
   inForm.values_id.options[(inForm.values_id.options.length - 1)] = null;
 }
 for (var i=0; i < selectedArray.length; i++)
 {
   eval("inForm.values_id.options[i]=" + "new Option" + selectedArray[i]);
 }
 if (inForm.options_id.options[0].value == '')
 {
   inForm.options_id.options[0]= null;
   if ( navigator.appName == 'Netscape')
       {
     if (parseInt(navigator.appVersion) < 4)
         {
       window.history.go(0);
     }
     else
         {
       if (navigator.platform == 'Win32' || navigator.platform == 'Win16')
               {
                 if(!document.getElementById)
           window.history.go(0);
       }
     }
   }
 }
}
// End -->
</script>
           <td class="smallText"> 
           <select name="options_id" onchange=populateOptions(document.attributes,document.attributes.options_id.options[document.attributes.options_id.selectedIndex].value)>
<?php
     $options = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name");
     while($options_values = tep_db_fetch_array($options)) {
       if ($attributes_values['options_id'] == $options_values['products_options_id']) {
         echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '" SELECTED>' . $options_values['products_options_name'] . '</option>';
       } else {
         echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>';
       }
     }
?>
           </select> </td>
           <td class="smallText"> <select name="values_id">
               <OPTION selected value=""><-----------</OPTION>
           </select> </td>
<script language=JavaScript>
<!-- Begin
populateOptions(document.attributes, document.attributes.options_id.options[document.attributes.options_id.selectedIndex].value);
// End -->
</script>
           <td align="right" class="smallText"> <input type="text" name="value_price" value="<?php echo $attributes_values['options_values_price']; ?>" size="6"> </td>
           <td align="center" class="smallText"> <input type="text" name="price_prefix" value="<?php echo $attributes_values['price_prefix']; ?>" size="2"> </td>
           <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, '&attribute_page=' . $attribute_page . '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath . '#atts', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td>
<?php
     if (DOWNLOAD_ENABLED == 'true') {
       $download_query_raw ="select products_attributes_filename, products_attributes_maxdays, products_attributes_maxcount
                             from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . "
                             where products_attributes_id='" . $attributes_values['products_attributes_id'] . "'";
       $download_query = tep_db_query($download_query_raw);
       if (tep_db_num_rows($download_query) > 0) {
         $download = tep_db_fetch_array($download_query);
         $products_attributes_filename = $download['products_attributes_filename'];
         $products_attributes_maxdays  = $download['products_attributes_maxdays'];
         $products_attributes_maxcount = $download['products_attributes_maxcount'];
       }
?>
         <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>">
           <td> </td>
           <td colspan="5">
             <table>
               <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>">
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DOWNLOAD; ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_FILENAME; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_filename', $products_attributes_filename, 'size="15"'); ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_MAX_DAYS; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxdays', $products_attributes_maxdays, 'size="5"'); ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_MAX_COUNT; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td>
               </tr>
             </table>
           </td>
           <td> </td>
         </tr>
<?php
     }
?>
<?php
   } elseif (($HTTP_GET_VARS['action_att'] == 'delete_product_attribute') && ($HTTP_GET_VARS['attribute_id'] == $attributes_values['products_attributes_id'])) {
?>
           <td class="smallText"> <b><?php echo $attributes_values["products_attributes_id"]; ?></b> </td>
           <td class="smallText"> <b><?php echo $products_name_only; ?></b> </td>
           <td class="smallText"> <b><?php echo $options_name; ?></b> </td>
           <td class="smallText"> <b><?php echo $values_name; ?></b> </td>
           <td align="right" class="smallText"> <b><?php echo $attributes_values["options_values_price"]; ?></b> </td>
           <td align="center" class="smallText"> <b><?php echo $attributes_values["price_prefix"]; ?></b> </td>
           <td align="center" class="smallText"> <b><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action_att=delete_attribute&attribute_id=' . $HTTP_GET_VARS['attribute_id']. '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath. '#atts') . '">'; ?><?php echo tep_image_button('button_confirm.gif', IMAGE_CONFIRM); ?></a>  <?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, '&attribute_page=' . $attribute_page. '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath. '#atts', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </b></td>
<?php
   } else {
?>
           <td class="smallText"> <?php echo $attributes_values["products_attributes_id"]; ?> </td>
           <td class="smallText"> <?php echo $products_name_only; ?> </td>
           <td class="smallText"> <?php echo $options_name; ?> </td>
           <td class="smallText"> <?php echo $values_name; ?> </td>
           <td align="right" class="smallText"> <?php echo $attributes_values["options_values_price"]; ?> </td>
           <td align="center" class="smallText"> <?php echo $attributes_values["price_prefix"]; ?> </td>
           <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action_att=update_attribute&attribute_id=' . $attributes_values['products_attributes_id'] . '&attribute_page=' . $attribute_page . '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath. '#atts', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a>  <?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action_att=delete_product_attribute&attribute_id=' . $attributes_values['products_attributes_id'] . '&attribute_page=' . $attribute_page . '&action=' . $HTTP_GET_VARS['action'] . '&pID=' . $pInfo->products_id . '&cPath=' .$cPath. '#atts', 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td>
<?php
   }
   $max_attributes_id_query = tep_db_query("select max(products_attributes_id) + 1 as next_id from " . TABLE_PRODUCTS_ATTRIBUTES);
   $max_attributes_id_values = tep_db_fetch_array($max_attributes_id_query);
   $next_id = $max_attributes_id_values['next_id'];
?>
         </tr>
<?php
 }
 if ($HTTP_GET_VARS['action_att'] != 'update_attribute') {
?>
         <tr>
           <td colspan="7"><?php echo tep_black_line(); ?></td>
         </tr>
         <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">
           <td class="smallText"> <?php echo $next_id; ?> </td>
                 <td class="smallText"> <select name="products_id">
<?php
   $products = "select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and pd.products_id = " . $pInfo->products_id;
   $products = tep_db_query($products);
   while ($products_values = tep_db_fetch_array($products)) {
     echo '<option name="' . $products_values['products_name'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_name'] . '</option>';
   }
?>
           </select> </td>
           <td class="smallText"> <select name="options_id">
<?php
   $options = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name");
   while ($options_values = tep_db_fetch_array($options)) {
     echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values['products_options_name'] . '</option>';
   }
?>
           </select> </td>
           <td class="smallText"> <select name="values_id">
<?php
   $values = tep_db_query("SELECT products_options_values.products_options_values_id,
                                                                  products_options_values.products_options_values_name,
                                                                  products_options.products_options_id,
                                                                  products_options.products_options_name,
                                                                  products_options_values_to_products_options.products_options_id,
                                                                  products_options_values_to_products_options.products_options_values_id
                                                                                  FROM products_options_values,
                                                                                        products_options,
                                                                                        products_options_values_to_products_options
                                                                                                 WHERE products_options_values.products_options_values_id = products_options_values_to_products_options.products_options_values_id AND
                                                                                                         products_options.products_options_id = products_options_values_to_products_options.products_options_id
                                                                                                                         ORDER BY products_options.products_options_name, products_options_values.products_options_values_name") or die(mysql_error());
   //while ($values_values = tep_db_fetch_array($values)) {
   while ($values_values = mysql_fetch_array($values)) {
         echo '<option name="' . $values_values['products_options_values_name'] . '" value="' . $values_values['products_options_values_id'] . '">' . $values_values['products_options_name'] . ' - ' . $values_values['products_options_values_name'] . '</option>';
   }
       //mysql_free_result($values);
?>
           </select> </td>


           <td align="right" class="smallText"> <input type="text" name="value_price" size="6"> </td>
           <td align="right" class="smallText"> <input type="text" name="price_prefix" size="2" value="+"> </td>
           <td align="center" class="smallText"> <?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?> </td>
         </tr>
<?php
     if (DOWNLOAD_ENABLED == 'true') {
       $products_attributes_maxdays  = DOWNLOAD_MAX_DAYS;
       $products_attributes_maxcount = DOWNLOAD_MAX_COUNT;
?>
         <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>">
           <td> </td>
           <td colspan="5">
             <table>
               <tr class="<?php echo (!($rows % 2)? 'attributes-even' : 'attributes-odd');?>">
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DOWNLOAD; ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_FILENAME; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_filename', $products_attributes_filename, 'size="15"'); ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_MAX_DAYS; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxdays', $products_attributes_maxdays, 'size="5"'); ?> </td>
                 <td class="smallText"><?php echo TABLE_TEXT_MAX_COUNT; ?></td>
                 <td class="smallText"><?php echo tep_draw_input_field('products_attributes_maxcount', $products_attributes_maxcount, 'size="5"'); ?> </td>
               </tr>
             </table>
           </td>
           <td> </td>
         </tr>
<?php
     } // end of DOWNLOAD_ENABLED section
?>
<?php
 }
?>
         <tr>
           <td colspan="7"><?php echo tep_black_line(); ?></td>
         </tr>
       </table></form></td>
     </tr>
   </table></td>
</tr>
<?php
}
?>
<!-- products_attributes_eof //-->

Link to comment
Share on other sites
Guest

Guest

Posted
Posted (edited)
easy way is to add the attribute sort contribution

 

This has been modified w/ a few contributions and tweeking of my own.. But i don't beleive there is an order by that i want in contributions that fits the /admin/categories.php file.. So if theres anyone that is good w/ php or might know of a contribution they've tested and knows works for this. Please shout out.. btw thanks in advance.

 

--Jeremy

 

BTW most of them sort contribs.. have way to much install that i don't need.. i just want this particular table to be sorted.. nothing else.

 

test.jpg

Edited by Jeremy_DoC
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...