Хранилища Subversion ant

        $query =& $db->query("SELECT * FROM settings");

        $settings = array();

        while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {

                $settings[$secure->stripStr($setting["opt"])] = $secure->stripStr($setting["optvalue"]);

        };

        $query =& $db->query("SELECT * FROM version v JOIN distribution d ON d.dist_id=v.dist_id JOIN dtype p ON d.disttype=p.type_id WHERE v.dist_id='$dist' AND v.version_id='$vers'");

        $query->fetchInto($infodist, DB_FETCHMODE_ASSOC);

        $query =& $db->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id WHERE v.ver_id='$vers' ORDER BY r.rtype_id, r.scheme_id ASC");

        $result = "# Ant: sources.list generator :: http://track.altlug.ru/project/show/ant\n\n";

        while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {

                $querysect =& $db->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE

r.rep_id='$resinfo[rep_id]'");

                $sections = "";

                while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {

                        $sections .= $secure->stripStr($section["sectname"])." ";

                }

                $repscheme = str_replace("{TYPE}",$secure->stripStr($infodist["type"]),$repscheme);

                $repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);

                $repscheme = str_replace("{ROOT}",$secure->stripStr($resinfo["root_folder"]),$repscheme);

                $repscheme = str_replace("{URL}",$settings["url"],$repscheme);

                $repscheme = str_replace("{REP}",$secure->stripStr($resinfo["repname"]),$repscheme);

                $repscheme = str_replace("{DIST}",$secure->stripStr($infodist["vcodename"]),$repscheme);

                $repscheme = str_replace("{SECT}",$sections,$repscheme);

                $result .= "# ".$secure->stripStr($resinfo["repdescribe"])."\n".$repscheme."\n\n";

        }