category name in emails

[slcomputing]

Script URL:
Version of script:2.1
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:

hey guys i'm new here i've had a look around the forums and can't seem to find an answer so i thought i'd post a new topic, how can i get the email to show the category name instead of the category id - preferably in the subject but could handle it being in the body of the message.

i really appreciate your support and i'ts a great package

Steven

[Klemen]

You'll need to use something like this to get all the category names:

Code: Select all

$all_cat = array();

$sql = 'SELECT `id`,`name` FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'categories` ORDER BY `cat_order` ASC';
$res = hesk_dbQuery($sql);
while ($row=hesk_dbFetchAssoc($res))
{
	$all_cat[$row['id']] = $row['name'];
}

Then you have all the categories names stored in an array. Echoing $all_cat[1] will print the name of the default category. In the submit_ticket.php you could use $all_cat[$category] to access the current category name.

[l00ph0le]

Sorry to be a pain, but I am a little lost on where to place this query and how to call it to put the category into the subject line of the e-mail?

[slcomputing]

but now it has dropped with version 2.2 - any ideas why? thanks for your help

[Klemen]

It should still work, but instead of $all_cat[$category] try using $all_cat[$tmpvar['category']]