Редакция 636 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 636 | Редакция 639 | ||
|---|---|---|---|
| Строка 1920... | Строка 1920... | ||
| 1920 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(v.version,' ',v.vname) AS fullname FROM ".$this->prefix."repository r "; |
1920 | $query = "SELECT r.*,rt.*,v.version_id,CONCAT(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 .= "ORDER BY v.version_id,r.rep_id ASC"; |
1923 | $query .= "ORDER BY v.version_id,r.rep_id ASC"; |
| 1924 | $rq =& $this->db->query($query); |
1924 | $rq =& $this->db->query($query); |
| 1925 | $show = "<ul>"; |
1925 | $show = "<ul><li class='nomarker'></li>"; |
| 1926 | $splitter = 0; |
1926 | $splitter = 0; |
| 1927 | while ($rq->fetchInto($element)) { |
1927 | while ($rq->fetchInto($element)) { |
| 1928 | if ($splitter != $this->secure->checkInt($element["version_id"])) { |
1928 | if ($splitter != $this->secure->checkInt($element["version_id"])) { |
| 1929 | $splitter = $this->secure->checkInt($element["version_id"]); |
1929 | $splitter = $this->secure->checkInt($element["version_id"]); |
| 1930 | $show .= "</ul><ul><li class='nomarker'><strong>Репозитории для ".$this->secure->checkStr($element["fullname"],1)."</strong></li>"; |
1930 | $show .= "</ul><ul><li class='nomarker'><strong>Репозитории для ".$this->secure->checkStr($element["fullname"],1)."</strong></li>"; |