QT Pro 4.2 & Attrib_sort_v1.11

[jpearson311]

Hello everyone, newbie here.

 

I just installed QT Pro 4.2 in order to add dropdown boxes for our clothes sizes (eg, s,m,l,xl,xxl). The only problem is that I got it working correctly, but the sizes are being listed from largest to smallest and not smallest to largest like I want them too.

 

I began doing some research for sorting attribute contributions and downloaded Attribute Sorter 1.11, I ran the .sql file in order to add a sort column to the product_attributes table, but when I reached the *next step, the code was not listed in product_info.php. I'm pulling my hairout trying to figure this one out. Man, this is challenging.

 

*FIND:

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

 

REPLACE WITH:

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.attribute_sort");

 

 

 

Now, I remember reading in the installation manual for QT Pro, that some files will be effected through the install, product_attributes.php, product_info.php and order.php to be exact, but the explanation on how to fix this is very difficult to understand.

 

All I want to do is have freedom on the sorting order of my dropdown boxes and perhaps the way my categories are listed on each page. If anyone has anything to offer me here, I would greatly appreciate. Thanks so much.

 

Jesse