| 736,24 → 736,25 |
|---|
| $show .= "\n\n"; |
| } |
| |
| // Репозитории обновлений и третьих лиц |
| $query = "SELECT * FROM ".$this->prefix."repository r "; |
| $query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id "; |
| $query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id "; |
| $query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id "; |
| $query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id "; |
| $query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id "; |
| $query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id "; |
| $query .= "WHERE r.rtype_id>'1' AND ("; |
| for($i=0;$i<count($data["repository"]);$i++) { |
| $query .= "r.rep_id='".$data["repository"][$i]."' "; |
| if ($i<count($data["repository"])-1) { |
| $query .= " OR "; |
| if (count($data["repository"])>0) { |
| // Репозитории обновлений и третьих лиц |
| $query = "SELECT * FROM ".$this->prefix."repository r "; |
| $query .= "JOIN ".$this->prefix."protos p ON r.proto_id=p.proto_id "; |
| $query .= "JOIN ".$this->prefix."rephost h ON r.rhost_id=h.rhost_id "; |
| $query .= "JOIN ".$this->prefix."repfolder f ON r.rfolder_id=f.rfolder_id "; |
| $query .= "JOIN ".$this->prefix."version v ON r.version=v.version_id "; |
| $query .= "JOIN ".$this->prefix."rtype t ON r.rtype_id=t.rtype_id "; |
| $query .= "JOIN ".$this->prefix."repscheme s ON r.scheme_id=s.scheme_id "; |
| $query .= "WHERE r.rtype_id>'1' AND ("; |
| for($i=0;$i<count($data["repository"]);$i++) { |
| $query .= "r.rep_id='".$data["repository"][$i]."' "; |
| if ($i<count($data["repository"])-1) { |
| $query .= " OR "; |
| } |
| } |
| } |
| $query .= ") ORDER BY r.rtype_id ASC"; |
| $req =& $this->db->query($query); |
| if ($req->numRows()>0) { |
| $query .= ") ORDER BY r.rtype_id ASC"; |
| $req =& $this->db->query($query); |
| |
| while ($req->fetchInto($updates)) { |
| // Формируем type proto://host/folder |
| $show .= "# ".$this->secure->checkStr($updates["repinfo"],1)."\n"; |