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"; |