| 1917,9 → 1917,10 |
|---|
| * @return string |
| */ |
| public function showRepositoriesList($name, $actor, $format = 'list') { |
| $query = "SELECT r.*,rt.*,v.version_id,CONCAT(v.version,' ',v.vname) AS fullname FROM ".$this->prefix."repository r "; |
| $query = "SELECT r.*,rt.*,v.version_id,CONCAT(d.distname,' ',v.version,' ',v.vname) AS fullname FROM ".$this->prefix."repository r "; |
| $query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
| $query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
| $query .= "JOIN ".$this->prefix."distibution d ON d.dist_id=v.dist_id "; |
| $query .= "ORDER BY v.version_id,r.rep_id ASC"; |
| $rq =& $this->db->query($query); |
| $show = "<ul><li class='nomarker'></li>"; |