function support_substatus_load_nid in Support Ticketing System 6

2 calls to support_substatus_load_nid()

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 477

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_load_nid($nid, $cid = 0) {
  static $substatus = array();
  if (!isset($substatus[$nid][$cid])) {
    if ($cid) {
      $substatus[$nid][$cid] = db_fetch_object(db_query("SELECT * FROM {support_substatus_ticket} sst LEFT JOIN {support_substatus} ss ON sst.subid = ss.ssid WHERE sst.type = 'comment' AND sst.id = %d", $cid));
    }
    else {
      $substatus[$nid][$cid] = db_fetch_object(db_query('SELECT * FROM {support_substatus_ticket} sst LEFT JOIN {support_substatus} ss ON sst.subid = ss.ssid WHERE sst.id = %d', $nid));
    }
    drupal_alter('support_substatus_load_nid', $substatus[$nid][$cid]);
  }
  return $substatus[$nid][$cid];
}