Organizing Categories

I've been hounding Boonexpert for weeks if he'd consider updating his Categories Slider (http://www.boonex.com/m/Categories_Slider) for 7.1.4 - nothing has transpired, and was wondering if anyone has a work around where I can organize categories as I see fit.  Hell, even getting categories to display by ASC would help.  I made code changes in the function getCategoriesList on /inc/classesBxDolCategories:

GROUP BY `cat`.`{$this->aTagFields['tag']}` ORDER BY `Order` ASC";

That didn't work...

Any suggestions

Thanks, Jethro

Strange...that seems like it should work. Have you tried clearing cache after you made the coding changes?

MySQL limitation. ORDER BY cannot be use with GROUP BY in the same query.

Google search reveled it can be done in a complex left join query with order by coming first. You will need to look up how to use group by with order by on google yourself. It's advanced mysql and it's beyond me. I don't bother with complex querys such as that. If i can't find a simple way to do things, then i don't do it.