Alphabetical ordering in [contribution] Multilayer SEO Pop Out Menu by FWR_Media

[minionsweb]

http://addons.oscommerce.com/info/5942

 

Support thread is dead for years.

http://www.oscommerce.com/forums/topic/302088-contribution-multilayer-seo-pop-out-menu/page-10

 

Stumbled upon a little flaw.

The categories section mostly works well.
uncovered issues IF you use c.sort_order as the preference via admin console.
If  multiple categories are set at a common int (in this case all are set to 129),  the order is alphabetically descending as show below.

 

 

    LED UV Blacklights

    LED Spot Light Fixtures

    LED Pixel Light Strings

    LED Outdoor Spotlight Bulbs

    LED Outdoor Flood Light Fixtures

    LED Outdoor Flood Light Dimmable

    LED Outdoor DMX Light Fixtures

    LED Outdoor DMX Flood Lights

    LED Meteor Tubes Mini Snow Falli

    LED Flexible Strip Light

    LED DC Spotlight Bulbs

    LED Club/DJ DMX Lights
 

But that is contradictory to alphabetizing.

I cannot figure out where the ascending/descending flag is switched.

Betting I am missing the obvious, but a 2nd set of eyes would help.

 

See problem live

http://www.minionsweb.com/osStore

 

Little help please.

 
Thanks

Corey

Minions Web

[♥bruyndoncx]

find in catalog/includes/functions/ fwr_cat_functions

 

function categoriesFullScan($order_by, $languages_id){
  $sql = "
SELECT c.categories_id, c.parent_id, c.sort_order, cDescr.categories_name
FROM " . TABLE_CATEGORIES . " AS c
INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " AS cDescr
WHERE c.categories_id = cDescr.categories_id
AND cDescr.language_id = '" . (int)$languages_id . "'
ORDER BY c.parent_id, $order_by, cDescr.categories_name
DESC";

  return tep_db_query($sql);
}

 

these 2 lines

ORDER BY c.parent_id, $order_by, cDescr.categories_name
DESC

 

enforce the order

 

if you change DESC to ASC it should be fixed

[minionsweb]

and I was looking for == 'd' to switch to == 'a'

didnt occur to me that was descending

Thank  you