Land Of Coder

Hi Mate,

If you want to ordering sub-categories of the module, please try to do as following:
- Open the file "helper.php" in the folder "modules/mod_lofk2tabnews/", then find code:

    $query = 'SELECT id, alias, name, parent' .

                ' FROM jos_k2_categories AS c' .

                ' WHERE c.id IN ('.$parent_id.')';

Replace to:

    $query = 'SELECT id, alias, name, parent' .

                ' FROM jos_k2_categories AS c' .

                ' WHERE c.id IN ('.$parent_id.') ORDER BY ordering';

- To add a piont of : published date and modified date, please try to do as following:
+ Open the file "mod_lofk2tabnews.xml" in the folder "modules/mod_lofk2tabnews/", then find code:

<option value="created_asc">DATE_ASCENDING</option>

                        <option value="created_desc">DATE_DESCENDING</option>

Replace to:

<option value="created_asc">DATE_ASCENDING</option>

<option value="created_desc">DATE_DESCENDING</option>

<option value="modified_asc">Modified ASC</option>

<option value="modified_desc">Modified DESC</option>

Hi Mate,

Please try to do as my previous post:

  If you want to ordering sub-categories of the module, please try to do as following:
- Open the file "helper.php" in the folder "modules/mod_lofk2tabnews/", then find code:

Hello:
I need to sort categories in Theme3 - this solution is not working.
I tried some other workarounds in the helper.php, for example:

  public static function getListCatId( $parent_id ){
        $db = &JFactory::getDBO();               
        $query = 'SELECT id, alias, name, parent' .
                ' FROM jos_k2_categories AS c' .
                ' WHERE c.id IN ('.$parent_id.') ORDER BY c.name';
        $db->setQuery( $query );
        $sesion = $db->loadObjectList();
        return $sesion;
    }
Any help would be greatly appreciated!
Thanks,
Alan