Fix display of tickets by Category order (code attached)
PROBLEM: When the list of tickets is displayed, the categories are not listed in the order specified in "Manage Categories" (version 2.4.2)
SOLUTION:
- in inc/print_tickets.inc.php, line 38, change this...
$sql = "SELECT t1
.* , t2
.name
AS repliername
FROM ".hesk_dbEscape($hesk_settings['db_pfix'])."tickets
AS t1
LEFT JOIN ".hesk_dbEscape($hesk_settings['db_pfix'])."users
AS t2
ON t1
.replierid
= t2
.id
WHERE ";
...to this:
$sql = "SELECT t1
.* , t2
.name
AS repliername
, t3
.catorder
FROM `".heskdbEscape($hesksettings['dbpfix'])."ticketsAS
t1
".heskdbEscape($hesksettings['dbpfix'])."users
LEFT JOINAS
t2ON
t1.
replierid=
t2.
id
".heskdbEscape($hesksettings['dbpfix'])."categories
LEFT JOINAS
t3ON
t1.
category=
t3.
id`
WHERE ";
- in inc/prepareticketsearch.inc.php, line 72, change this...
$sql .= ' ORDER BY ';
...to this:
$sql .= ' ORDER BY t3
.cat_order
, ';
Voila! The tickets now display in the expected order as set by the user in Manage Tickets (click on "Categories" from the Admin menu).
-
Jesse commented
Now it´s version 2.5.5 and i can't find this line: $sql = "SELECT `t1`.* , `t2`.`name` AS `repliername`
FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` AS `t1` LEFT JOIN `".hesk_dbEscape($hesk_settings['db_pfix'])."users` AS `t2` ON `t1`.`replierid` = `t2`.`id`
WHERE ";in the inc/print_tickets.inc.php file
-
Alcazar commented
Why bother using an old/outdated hesk version?
Actual version is 2.5.3