Редакция 694 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 694 | Редакция 695 | ||
|---|---|---|---|
| Строка 2106... | Строка 2106... | ||
| 2106 | public function showRepositoriesList($name, $actor, $format = 'list') { |
2106 | public function showRepositoriesList($name, $actor, $format = 'list') { |
| 2107 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(d.distname,' ',v.version,' “',v.vname,'”') AS fullname FROM ".$this->prefix."repository r "; |
2107 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(d.distname,' ',v.version,' “',v.vname,'”') AS fullname FROM ".$this->prefix."repository r "; |
| 2108 | $query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
2108 | $query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
| 2109 | $query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
2109 | $query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
| 2110 | $query .= "JOIN ".$this->prefix."distribution d ON d.dist_id=v.dist_id "; |
2110 | $query .= "JOIN ".$this->prefix."distribution d ON d.dist_id=v.dist_id "; |
| 2111 | $query .= "ORDER BY v.version_id,r.rep_id ASC"; |
2111 | $query .= "ORDER BY v.version_id,rt.rtype_id,r.rep_id ASC"; |
| 2112 | $rq =& $this->db->query($query); |
2112 | $rq =& $this->db->query($query); |
| 2113 | $show = "<ul><li class='nomarker'></li>"; |
2113 | $show = "<ul><li class='nomarker'></li>"; |
| 2114 | $splitter = 0; |
2114 | $splitter = 0; |
| 2115 | while ($rq->fetchInto($element)) { |
2115 | while ($rq->fetchInto($element)) { |
| 2116 | if ($splitter != $this->secure->checkInt($element["version_id"])) { |
2116 | if ($splitter != $this->secure->checkInt($element["version_id"])) { |