Редакция 642 | Редакция 644 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 642 | Редакция 643 | ||
|---|---|---|---|
| Строка 1915... | Строка 1915... | ||
| 1915 | * @param string $actor
|
1915 | * @param string $actor
|
| 1916 | * @param string $format
|
1916 | * @param string $format
|
| 1917 | * @return string
|
1917 | * @return string
|
| 1918 | */
|
1918 | */
|
| 1919 | public function showRepositoriesList($name, $actor, $format = 'list') { |
1919 | public function showRepositoriesList($name, $actor, $format = 'list') { |
| 1920 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(d.distname,' ',v.version,'“',v.vname,'”') AS fullname FROM ".$this->prefix."repository r "; |
1920 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(d.distname,' ',v.version,' “',v.vname,'”') AS fullname FROM ".$this->prefix."repository r "; |
| 1921 | $query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
1921 | $query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
| 1922 | $query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
1922 | $query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
| 1923 | $query .= "JOIN ".$this->prefix."distribution d ON d.dist_id=v.dist_id "; |
1923 | $query .= "JOIN ".$this->prefix."distribution d ON d.dist_id=v.dist_id "; |
| 1924 | $query .= "ORDER BY v.version_id,r.rep_id ASC"; |
1924 | $query .= "ORDER BY v.version_id,r.rep_id ASC"; |
| 1925 | $rq =& $this->db->query($query); |
1925 | $rq =& $this->db->query($query); |