Access to support ticket departments on homepage.tpl

[Nullified]

I have checked in {debug} and it seems no such variables exists within homepage.tpl that would allow me to list the support ticket departments on the homepage. Is it possible to get such data inserted? I am simply trying to add links to my support departments on the homepage.

[jclarke]

You just need to grab the list from the database. You can do that inside the template or by creating a hook. Here is an example of just adding it to the template:

 

{php}

$result = mysql_query("SELECT id, name FROM tblticketdepartments WHERE hidden = "");

$departments = array();

while ($data = mysql_fetch_array($result)) {

array_push($departments, $data);

}

$this->_tpl_vars['departments'] = $departments;

{/php}

[Nullified]

that worked with changing the query to:

"SELECT id, name FROM tblticketdepartments WHERE hidden = ''"

 

thanks for the response.