Jump to content
minionsweb

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

Recommended Posts

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

 

Support thread is dead for years.

http://forums.oscommerce.com/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

Share this post


Link to post
Share on other sites

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


KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×