// Tickets awaiting response.
$request = shd_db_query('
SELECT COUNT(id_ticket)
FROM {db_prefix}helpdesk_tickets AS hdt
WHERE {query_see_ticket} AND status IN (0,1)', array());
if ($smcFunc['db_num_rows']($request) > 0)
list($context['helpdeskTickets']['waiting']) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
// Defaults.
require_once($sourcedir . '/Subs-SimpleDesk.php');
$context['helpdeskTickets'] = array(
'open' => shd_count_helpdesk_tickets('open', true),
'waiting' => shd_count_helpdesk_tickets('staff', false),
);