Categories order change

[DiegoHowes]

Script URL:
Version of script: 2.5.3
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

Hi everyone!

At the company I work we have more than 130 categories, and based on demand, we've got to add more and more...

The trouble appears when one of us(IT crew) have to organize by alphabetical. At the moment, HESK lists the new categories by insert order, like a row, and after any modification(up or down) the page is actualized(F5) and we need to scroll down and find that category is on use

So, all I want to know is: There is a "query modification" or something like that, can be done to order all categories, including the new ones, by alphabetical?

Thanks for all the help!

[mkoch227]

You can modify line 81 in manage_categories.php:

Code: Select all

$res = hesk_dbQuery("SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."categories` ORDER BY `cat_order` ASC");

Chance `cat_order` to `name`, like so:

Code: Select all

$res = hesk_dbQuery("SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."categories` ORDER BY `name` ASC");