[SOLVED] vm_category_menu - possible to sort ?

i'm using the mod_gk_vm_category_menu module.
i would like to sort VM caterogies from A to Z..
is it possible ?
Thanks:)

Im having the same problem as above.

Also in VM under category tree, i have unpublished couple of categories but they are still showing up in the mod_gk_vm_category_menu module. Does anyone else have the same issue?

Any advise would be much appreciated.

Thanks

in helper.php in module catalog change:

Code: Select all

      $query = "
      SELECT
         `c`.`category_name` AS `name` ,
         `c`.`category_id` AS `id` ,
         `x`.`category_parent_id` AS `parent`
      FROM
         `#__{vm}_category_xref` AS `x`
      LEFT JOIN
         `#__{vm}_category` AS `c`
      ON
         `x`.`category_child_id` = `c`.`category_id`
      ORDER BY
         `x`.`category_parent_id`;";


for:

Code: Select all

      $query = "
      SELECT
         `c`.`category_name` AS `name` ,
         `c`.`category_id` AS `id` ,
         `x`.`category_parent_id` AS `parent`
      FROM
         `#__{vm}_category_xref` AS `x`
      LEFT JOIN
         `#__{vm}_category` AS `c`
      ON
         `x`.`category_child_id` = `c`.`category_id`
      ORDER BY
         `x`.`category_name`;";


But I cann't guarantee that it won't causes problems - you must change it and check module

Actually, it works... but with this:

Code: Select all

SELECT
         `c`.`category_name` AS `name` ,
         `c`.`category_id` AS `id` ,
         `x`.`category_parent_id` AS `parent`
      FROM
         `#__{vm}_category_xref` AS `x`
      LEFT JOIN
         `#__{vm}_category` AS `c`
      ON
         `x`.`category_child_id` = `c`.`category_id`
      ORDER BY
         `c`.`category_name`;";

You forgot the `c` !

"Oh My God... i fix something from Dziudek !!! The world is insane !!!" LOOOL

Hi,


Do you have a fix for my ealier query i.e.

In VM under category tree, i have unpublished couple of categories but they are still showing up in the mod_gk_vm_category_menu module. Does anyone else have the same issue?

Any advise would be much appreciated.

Thanks

Thanks

Thnaks for your help. All is working now. that's cool !

I have the same issue with unpublished categories still showing up in the mod_gk_vm_category_menu.

Any help to update this would be appreciated

[SOLVED] Check out this post and replace the existing files with the ones contained in the update:

http://gavick.com/dev/gk_vm_category_me ... nu_1.1.zip

The correction solves some issues but not the sorting.

If you want the sorting to work as laid out in the admin manager change the following in version 1.1.

On line 48 of modules/mod_gk_vm_category_menu/helper.php

CHANGE:
`x`.`category_parent_id`
TO:
`x`.`category_parent_id` ASC, `c`.`list_order` ASC

Line 47 & 48 should now look like:
ORDER BY
`x`.`category_parent_id` ASC, `c`.`list_order` ASC;";

I explicitly set the Ascending order which is a default, but I'm a bit anal when it comes to code

thanks netadvanced

so now i got from you

Code: Select all

SELECT
         `c`.`category_name` AS `name` ,
         `c`.`category_id` AS `id` ,
         `x`.`category_parent_id` AS `parent`
      FROM
         `#__{vm}_category_xref` AS `x`
      LEFT JOIN
         `#__{vm}_category` AS `c`
      ON
         `x`.`category_child_id` = `c`.`category_id`
      ORDER BY
         `x`.`category_parent_id`;";

changed to this and works great thanks as corresponds with order in backend

Code: Select all

      SELECT
         `c`.`category_name` AS `name` ,
         `c`.`category_id` AS `id` ,
         `x`.`category_parent_id` AS `parent`
      FROM
         `#__{vm}_category_xref` AS `x`
      LEFT JOIN
         `#__{vm}_category` AS `c`
      ON
         `x`.`category_child_id` = `c`.`category_id`
      ORDER BY
         `x`.`category_parent_id` ASC, `c`.`list_order` ASC;";

again thankyou

Happy it helped.

Cheers.

Hi all, thanks very much for the code to order the category menu displayed on the front-end of the website. I have tried all the files and help tips in this thread in order to do the following but I cannot seem to get this to work??

In VM under category tree, i have unpublished couple of categories but they are still showing up in the mod_gk_vm_category_menu module. Any help would be much appreciated.

Hope someone has found a way for this to work. I would love to be able to unpublish categories.

I am using Joomla 1.5.8 and VM 1.1.2 and the zip file above does not seem to work but my ordering is fine.

Thanks,
James