company_id = $au->sqlValue("(SELECT id from Companies where comptype='OWNER' LIMIT 1)"); if (!$au->get('email', $_REQUEST['email']) ) { $this->err("invalid email"); } $pd = DB_DataObject::Factory('ProjectDirectory'); $pd->whereAdd("role LIKE '%DEVELOPER%'"); $pd->person_id = $au->id; $pd->selectAdd(); $pd->selectAdd('distinct(project_id) AS project_id'); $pids = $pd->fetchAll('project_id'); $repo = DB_DataObject::Factory('mtrack_repos'); $repo->whereAddIn('project_id', $pids, 'int'); $repos = $repo->fetchAll('shortname'); $this->jok($repos); } }