'; print_r($ret);exit;
        return $ret;
    }
  
  
  /// rendering tricks
  
  
    function updateWho($link)
    {
        return  $link->username(
                $this->updated ? 
                    MTrackChangeset::get($this->updated)->who :
                    MTrackAuth::whoami()
        );
        
    }
    function updateWhen($link) 
    {
        return  $link->date( $this->updated ? 
                MTrackChangeset::get($this->updated)->when :
                MTrackDB::unixtime(time()) 
        );
    }
    function createdWho($link)
    {
        return  $link->username(
                $this->created ? 
                    MTrackChangeset::get($this->created)->who :
                    MTrackAuth::whoami()
        );
        
    }
    function createdWhen($link) 
    {
        return  $link->date( $this->created ? 
                MTrackChangeset::get($this->created)->when :
                MTrackDB::unixtime(time()) 
        );
    }
  
    function keywordsToHtml() 
    {
        $value = array();
        foreach ($this->getKeywords() as $kw) {
            $value[] = mtrack_keyword($kw);
        }
        return  join(' ', $value);
    }
    

    
    function componentsToHtml() 
    {
        $res = array();
        $value = join(',',array_keys($this->getComponents()));
        
        if (!strlen($value)) {
            return '';
        }
        $q = MTrackDB::q(
              "select name, deleted from components where compid in ($value)");
        foreach ($q->fetchAll() as $row) {
            
            $c = ($row['deleted'] ? '' : '') .
                htmlentities($row['name'], ENT_QUOTES, 'utf-8') . 
                ($row['deleted'] ? '' : '');
            $res[] = $c;
        }
        
        return join(", ", $res);
       
    }
    
    function milestonesToHtml($msurl) 
    {
        if (empty($this->milestone_url)) {
            die("requires issue->milestone_url to be set.");
        }
        $res = array();
        $value = join(',',array_keys($this->getMilestones()));
        
        if (!strlen($value)) {
            return '';
        }
        foreach (MTrackDB::q(
          "select name, completed, deleted from milestones where mid in ($value)")
          ->fetchAll() as $row) {
              
            $row['deleted'] =   strlen($row['completed']) ? 1 : 0;
                
            $c = "milestone_url}" . urlencode($row['name']) . '">' .
                htmlentities($row['name'], ENT_QUOTES, 'utf-8') .
                "";
            $res[] = $c;
        }
        return join(", ", $res);
    }
    function descriptionToHtml()
    {
        return MTrack_Wiki::format_to_html($this->description);
    }
   /* function attachmentsToHtml()
    {
        require_once 'Attachment.php';
        return MTrackAttachment::renderList("ticket:{$this->tid}");
    }
    function attachmentsDeleteToHtml() {
        require_once 'Attachment.php';
        return MTrackAttachment::renderDeleteList("ticket:{$this->tid}");
    }
 */
    function toIdString() {
        return "ticket:{$this->tid}";
            
    }
    
    // watcher related.
    function watcherButton()
    {
        return MTrackWatch::renderWatchUI('ticket', $this->tid);
    }
    
    function watchType() 
    {
        return 'ticket';
    }
    function watchId()
    {
        return $this->tid;
    }
    
    function watchers()
    {
        return MTrackWatch::objectWatchers($this);
    }
    
    
    private function resolveMilestone($ms)
    {
        if ($ms instanceof MTrack_Milestone) {
          return $ms;
        }
        if (ctype_digit($ms)) {
          return MTrack_Milestone::loadById($ms);
        }
        return MTrack_Milestone::loadByName($ms);
    }

  private function resolveKeyword($kw)
  {
    if ($kw instanceof MTrackKeyword) {
      return $kw;
    }
    $k = MTrackKeyword::loadByWord($kw);
    if ($k === null) {
      if (ctype_digit($kw)) {
        return MTrackKeyword::loadById($kw);
      }
      throw new Exception("unknown keyword $kw");
    }
    return $k;
  }
  private function compute_diff(MTrackChangeset $CS, $label,
        $tablename, $keyname, $current, $orig) {
    if (!is_array($current)) {
      $current = array();
    }
    if (!is_array($orig)) {
      $orig = array();
    }
    $added = array_keys(array_diff_key($current, $orig));
    $removed = array_keys(array_diff_key($orig, $current));

    $db = MTrackDB::get();
    $ADD = $db->prepare(
      "insert into $tablename (tid, $keyname) values (?, ?)");
    $DEL = $db->prepare(
      "delete from $tablename where tid = ? AND $keyname = ?");
    foreach ($added as $key) {
      $ADD->execute(array($this->tid, $key));
    }
    foreach ($removed as $key) {
      $DEL->execute(array($this->tid, $key));
    }
    if (count($added) + count($removed)) {
      $old = join(',', array_keys($orig));
      $new = join(',', array_keys($current));
      $CS->add(
        "ticket:$this->tid:@$label", $old, $new);
    }
  }
  private function resolveComponent($comp)
  {
    if ($comp instanceof MTrackComponent) {
      return $comp;
    }
    if (ctype_digit($comp)) {
      return MTrackComponent::loadById($comp);
    }
    return MTrackComponent::loadByName($comp);
  }
}