Page 1 of 1

Sort categories

Posted: Fri Feb 03, 2006 10:45 am
by jackjoe
Script URL: kressnernetwork.de/support/helpdesk
Version of script: 0.931
Version of PHP: 4.3x
Hosting company: Hosteurope
Have you searched THIS FORUM for your problem: yes
(if not please do before posting)
If so, what terms did you try: category

Write your message below:

How could I sort the categories in alphabetically order?

Greetings Jan

Posted: Fri Feb 03, 2006 2:03 pm
by Klemen
Hi,

Interesting question, might be useful for others too. You will have to edit files index.php, find this code inside:

Code: Select all

$sql = "SELECT * FROM `hesk_categories`";
change it to

Code: Select all

$sql = "SELECT * FROM `hesk_categories` ORDER BY `name`";
That should do the trick.

Thanks and an other question

Posted: Tue Feb 07, 2006 8:47 am
by jackjoe
Thanks I've found it quickly.

I have an other question. on start page, if I would write a new ticket, I could not see the recorded date of the ticket:
example:
https://www.kressnernetwork.de/support/ ... .php?a=add

and this is the codeline:

Code: Select all

<li><?php echo $hesklang['recorded_time']; ?></li>
I think in this line is a fault but I dont found them.

Greetings
Jan

Posted: Tue Feb 07, 2006 10:30 am
by Klemen
It doesn't display the date, just a message saying it has been recorded. See http://www.phpjunkyard.com/hesk/index.php?a=add

Posted: Wed Feb 08, 2006 9:06 am
by jackjoe
Is it possible to display the recorded time and date?

Sorting Categories in Admin_Main

Posted: Sun Jun 11, 2006 12:40 am
by blair.sawler
Thanks for the tip on sorting categories for submitting a ticket. I am trying to get the category drop down menu on the admin_main.php screen to sort by name.

How would one go about doing that?

Thanks, the software is great!