function _support_substatus_set_current in Support Ticketing System 6

Update current flag to allow for filtering and sorting.

2 calls to _support_substatus_set_current()

support_substatus_comment in support_substatus/support_substatus.module

support_substatus_nodeapi in support_substatus/support_substatus.module

Implementation of hook_nodeapi().

File

support_substatus/support_substatus.module, line 576

Support Substatus -- allows per-status sub-status values, so for example a "pending" ticket can be further marked with "needs review", etc. @author Jeremy Andrews <jeremy@tag1consulting.com> @package Support

Code

function _support_substatus_set_current($nid) {
  $trid = db_result(db_query_range('SELECT trid FROM {support_substatus_ticket} WHERE nid = %d ORDER BY trid DESC', $nid, 0, 1));
  db_query('UPDATE {support_substatus_ticket} SET current = 0 WHERE nid = %d', $nid);
  db_query('UPDATE {support_substatus_ticket} SET current = 1 WHERE trid = %d', $trid);
}