WebSVN - ant - Различия - Редакция 234 и 266


<?php

/**
 * Project:     Ant: sources.list generator
 * File:        core.php
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 *
 */


class Core {

        function getSourceList($distro,$version,$repos,$dblink) {
                // TODO optimize this
                if(count($repos)==0) return;
                // Fetch settings
                $query =& $dblink->query("SELECT * FROM settings");
                $settings = array();
                while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {
                    $settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);
                };
                // Fetch info about distribution
                $query =& $dblink->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='$distro' AND v.version_id='$version'");
                $query->fetchInto($infodist, DB_FETCHMODE_ASSOC);
                // Fetch default repos if not defined
                if($repos[0]=="-1") {
                    $querydrep =& $dblink->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 WHERE r.defaultrep='1' AND v2.version_id='$version'");
                    $i=0;
                    while ($querydrep->fetchInto($dreps,DB_FETCHMODE_ASSOC)) {
                        $repos[$i] = $dreps["rep_id"];
                        $i++;
                    }
                };
                if(count($repos)==0) return;
                // Processing repos
                $porigid = -1; // Previous origin id
                for($i=0;$i<count($repos);$i++) {
                    $id=$repos[$i];
                    // Fetch info about origin and scheme
                    $sql =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE r.rep_id=".$id);
                    $sql->fetchInto($resinfo, DB_FETCHMODE_ASSOC);
                    $repscheme = stripslashes($resinfo["scheme"]);
                    // Fetch info about sections
                    $querysect =& $dblink->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 .= stripslashes($section["sectname"])." ";
                    }
                    // Conversion scheme
                    $repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);
                    $repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);
                    $repscheme = str_replace("{URL}",$settings["url"],$repscheme);
                    $repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);
                    $repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);
                    $repscheme = str_replace("{SECT}",$sections,$repscheme);
                    $repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);
                    // Comment if another origin
                    if($porigid != $resinfo["orig_id"]) {
                        $result .= "### ".$resinfo["origin"]." ( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n";
                    }
                    $porigid = $resinfo["orig_id"];
                    // Result
                    $result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";
                }
                return $result;
        }
       
        // For backward compatibility for Modern interface. Current getRepList() crushed his.
        function getRepListLegacy($distro,$version,$dblink) {
                $query =& $dblink->query("SELECT * FROM settings");
                $settings = array();
                while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {
                        $settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);
                };
                $query =& $dblink->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='$distro' AND v.version_id='$version'");
                $query->fetchInto($infodist, DB_FETCHMODE_ASSOC);
                $query =& $dblink->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 JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");
                while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {
                        $repscheme = stripslashes($resinfo["scheme"]);
           
                        $querysect =& $dblink->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 .= stripslashes($section["sectname"])." ";
                        }

                        $repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);
                        $repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);
                        $repscheme = str_replace("{URL}",$settings["url"],$repscheme);
                        $repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);
                        $repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);
                        $repscheme = str_replace("{SECT}",$sections,$repscheme);
                        $repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);
           
                        $result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";
                }
                return $result;
        }

        function getInfo($message,$dblink){
                $answer = array();

                if (preg_match("/linux/i",$message)) {
                        $dist_id = 0;
                        $dist_info = "";
                        $vers_id = 0;
                        $vers_info = "";
                        $qd =& $dblink->query("SELECT * FROM distribution");
                        while ($qd->fetchInto($res, DB_FETCHMODE_ASSOC)) {
                                if (preg_match("/".stripslashes($res["distua"])."/i",$message)) {
                                        $dist_id = $res["dist_id"];
                                        $dist_info = stripslashes($res["distname"]);
                                        $qv =& $dblink->query("SELECT * FROM version WHERE dist_id='$dist_id'");
                                        while($qv->fetchInto($rev, DB_FETCHMODE_ASSOC)) {
                                                if (preg_match("/".stripslashes($rev["vcodename"])."/i",$message)) {
                                                        $vers_id = $rev["version_id"];
                                                        $vers_info = stripslashes($rev["version"])." &#8220;".stripslashes($rev["vname"])."&#8221;";
                                                }
                                        }
                                }
                        }
                        $answer[] = "Linux";
                        $answer[] = _("It seems you have an operating system "); // "Судя по всему у Вас операционная система ";
                        if ($dist_id!=0) {
                                $answer[] = $dist_id;
                                $answer[] = $dist_info;
                        }
                        if ($vers_id!=0) {
                                $answer[] = $vers_id;
                                $answer[] = $vers_info;
                        }

                } else {
                        $answer[] = "unknown";
                        $answer[] = _("The resource not for your operating system!"); // "Ресурс рассчитан явно не на Вашу операционную систему!";
                }

                return $answer;
        }

        function getInterfacesList($current,$dblink) {
                $url  = parse_url($current);
                $path = array();
                $path = split("/",$url["path"]);
                $currentIF = str_replace(".php","",$path[count($path)-1]);
                $req =& $dblink->query("SELECT * FROM interfaces WHERE interface NOT LIKE '$currentIF'");
                $iflist = "<a href='./'>"._("Interfaces")."</a>: ";
                while ($req->fetchInto($if, DB_FETCHMODE_ASSOC)) {
                        $iflist .= "<a href='./".stripslashes($if["interface"]).".php'>".strtolower(stripslashes($if["interfaceinfo"]))."</a>, ";
                }
                $iflist = substr($iflist, 0, strlen($iflist)-2);
                return $iflist;
        }

        function getCSSList($dblink) {
                $req =& $dblink->query("SELECT * FROM distribution");
                if ($req->numRows()>0) {
                        $css = "<style type=\"text/css\">\n";
                        while ($req->fetchInto($dist, DB_FETCHMODE_ASSOC)) {
                                if ($dist["distlogo"]) {
                                        $css .= ".".stripslashes($dist["distua"])." { display: inline; padding-left: 16px; background: transparent url(./img/logo/".stripslashes($dist["distua"]).".png) top left no-repeat; }\n";
                                        $css .= ".".stripslashes($dist["distua"])."-em { display: inline; padding-left: 32px; background: transparent url(./img/logo/".stripslashes($dist["distua"])."-em.png) top left no-repeat; }\n";
                                } else {
                                        $css .= "";
                                }
                        }
                        $css .= "</style>";
                } else {
                        $css = "";
                }
                return $css;
        }

        function getSetting($setting, $dblink) {
                $query =& $dblink->query("SELECT * FROM settings WHERE opt LIKE '".$setting."'");
                $query->fetchInto($sett, DB_FETCHMODE_ASSOC);
                return stripslashes($sett["optvalue"]);
        }

        function getUUID($param) {
                $param_s = md5($param);
                $time_low = bin2hex(substr($param_s,0, 4));
                $time_mid = bin2hex(substr($param_s,4, 2));
                $time_hi_and_version = bin2hex(substr($param_s,6, 2));
                $clock_seq_hi_and_reserved = bin2hex(substr($param_s,8, 2));
                $node = bin2hex(substr($param_s,10, 6));

                $time_hi_and_version = hexdec($time_hi_and_version);
                $time_hi_and_version = $time_hi_and_version >> 4;
                $time_hi_and_version = $time_hi_and_version | 0x4000;
       
                $clock_seq_hi_and_reserved = hexdec($clock_seq_hi_and_reserved);
                $clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved >> 2;
                $clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved | 0x8000;
       
                return sprintf('%08s-%04s-%04x-%04x-%012s',$time_low, $time_mid, $time_hi_and_version, $clock_seq_hi_and_reserved, $node);
        }


    function getRepList($distro,$version,$dblink) {
        $query =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");
        $i=-1;
        while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {
            $i++;
            $res[0][$i]=$resinfo["rep_id"];
            $res[1][$i]=$resinfo["repname"];
            $res[2][$i]=$resinfo["repdescribe"];
            $res[3][$i]=$resinfo["defaultrep"];
        }
        return $res;
    }
}
?>
 

Хранилища Subversion ant

(root)/trunk/lib/core.php @ 278 - Редакция 234 → 266

Редакция 234		Редакция 266
1	<?php	1	<?php
2		2
3	/**	3	/**
4	* Project: Ant: sources.list generator	4	* Project: Ant: sources.list generator
5	* File: core.php	5	* File: core.php
6	*	6	*
7	* This library is free software; you can redistribute it and/or	7	* This library is free software; you can redistribute it and/or
8	* modify it under the terms of the GNU Lesser General Public	8	* modify it under the terms of the GNU Lesser General Public
9	* License as published by the Free Software Foundation; either	9	* License as published by the Free Software Foundation; either
10	* version 2.1 of the License, or (at your option) any later version.	10	* version 2.1 of the License, or (at your option) any later version.
11	*	11	*
12	* This library is distributed in the hope that it will be useful,	12	* This library is distributed in the hope that it will be useful,
13	* but WITHOUT ANY WARRANTY; without even the implied warranty of	13	* but WITHOUT ANY WARRANTY; without even the implied warranty of
14	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU	14	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15	* Lesser General Public License for more details.	15	* Lesser General Public License for more details.
16	*	16	*
17	* You should have received a copy of the GNU Lesser General Public	17	* You should have received a copy of the GNU Lesser General Public
18	* License along with this library; if not, write to the Free Software	18	* License along with this library; if not, write to the Free Software
19	* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA	19	* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20	*	20	*
21	*/	21	*/
22		22
23		23
24	class Core {	24	class Core {
25		25
26	function getSourceList($distro,$version,$repos,$dblink) {	26	function getSourceList($distro,$version,$repos,$dblink) {
27	// TODO optimize this	27	// TODO optimize this
28	if(count($repos)==0) return;	28	if(count($repos)==0) return;
29	// Fetch settings	29	// Fetch settings
30	$query =& $dblink->query("SELECT * FROM settings");	30	$query =& $dblink->query("SELECT * FROM settings");
31	$settings = array();	31	$settings = array();
32	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {	32	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {
33	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);	33	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);
34	};	34	};
35	// Fetch info about distribution	35	// Fetch info about distribution
36	$query =& $dblink->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='$distro' AND v.version_id='$version'");	36	$query =& $dblink->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='$distro' AND v.version_id='$version'");
37	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);	37	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);
38	// Fetch default repos if not defined	38	// Fetch default repos if not defined
39	if($repos[0]=="-1") {	39	if($repos[0]=="-1") {
40	$querydrep =& $dblink->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 WHERE r.defaultrep='1' AND v2.version_id='$version'");	40	$querydrep =& $dblink->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 WHERE r.defaultrep='1' AND v2.version_id='$version'");
41	$i=0;	41	$i=0;
42	while ($querydrep->fetchInto($dreps,DB_FETCHMODE_ASSOC)) {	42	while ($querydrep->fetchInto($dreps,DB_FETCHMODE_ASSOC)) {
43	$repos[$i] = $dreps["rep_id"];	43	$repos[$i] = $dreps["rep_id"];
44	$i++;	44	$i++;
45	}	45	}
46	};	46	};
47	if(count($repos)==0) return;	47	if(count($repos)==0) return;
48	// Processing repos	48	// Processing repos
49	$porigid = -1; // Previous origin id	49	$porigid = -1; // Previous origin id
50	for($i=0;$i<count($repos);$i++) {	50	for($i=0;$i<count($repos);$i++) {
51	$id=$repos[$i];	51	$id=$repos[$i];
52	// Fetch info about origin and scheme	52	// Fetch info about origin and scheme
53	$sql =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE r.rep_id=".$id);	53	$sql =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE r.rep_id=".$id);
54	$sql->fetchInto($resinfo, DB_FETCHMODE_ASSOC);	54	$sql->fetchInto($resinfo, DB_FETCHMODE_ASSOC);
55	$repscheme = stripslashes($resinfo["scheme"]);	55	$repscheme = stripslashes($resinfo["scheme"]);
56	// Fetch info about sections	56	// Fetch info about sections
57	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$resinfo[rep_id]'");	57	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE r.rep_id='$resinfo[rep_id]'");
58	$sections = "";	58	$sections = "";
59	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {	59	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {
60	$sections .= stripslashes($section["sectname"])." ";	60	$sections .= stripslashes($section["sectname"])." ";
61	}	61	}
62	// Conversion scheme	62	// Conversion scheme
63	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);	63	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);
64	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);	64	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);
65	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);	65	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);
66	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);	66	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);
67	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);	67	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);
68	$repscheme = str_replace("{SECT}",$sections,$repscheme);	68	$repscheme = str_replace("{SECT}",$sections,$repscheme);
69	$repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);	69	$repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);
70	// Comment if another origin	70	// Comment if another origin
71	if($porigid != $resinfo["orig_id"]) {	71	if($porigid != $resinfo["orig_id"]) {
72	$result .= "### ".$resinfo["origin"]." ( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n";	72	$result .= "### ".$resinfo["origin"]." ( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n";
73	}	73	}
74	$porigid = $resinfo["orig_id"];	74	$porigid = $resinfo["orig_id"];
75	// Result	75	// Result
76	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";	76	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";
77	}	77	}
78	return $result;	78	return $result;
79	}	79	}
80		80
81	// For backward compatibility for Modern interface. Current getRepList() crushed his.	81	// For backward compatibility for Modern interface. Current getRepList() crushed his.
82	function getRepListLegacy($distro,$version,$dblink) {	82	function getRepListLegacy($distro,$version,$dblink) {
83	$query =& $dblink->query("SELECT * FROM settings");	83	$query =& $dblink->query("SELECT * FROM settings");
84	$settings = array();	84	$settings = array();
85	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {	85	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {
86	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);	86	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);
87	};	87	};
88	$query =& $dblink->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='$distro' AND v.version_id='$version'");	88	$query =& $dblink->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='$distro' AND v.version_id='$version'");
89	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);	89	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);
90	$query =& $dblink->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 JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");	90	$query =& $dblink->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 JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");
91	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {	91	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {
92	$repscheme = stripslashes($resinfo["scheme"]);	92	$repscheme = stripslashes($resinfo["scheme"]);
93		93
94	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE	94	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE
95	r.rep_id='$resinfo[rep_id]'");	95	r.rep_id='$resinfo[rep_id]'");
96	$sections = "";	96	$sections = "";
97	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {	97	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {
98	$sections .= stripslashes($section["sectname"])." ";	98	$sections .= stripslashes($section["sectname"])." ";
99	}	99	}
100		100
101	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);	101	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);
102	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);	102	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);
103	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);	103	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);
104	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);	104	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);
105	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);	105	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);
106	$repscheme = str_replace("{SECT}",$sections,$repscheme);	106	$repscheme = str_replace("{SECT}",$sections,$repscheme);
107	$repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);	107	$repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme);
108		108
109	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";	109	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";
110	}	110	}
111	return $result;	111	return $result;
112	}	112	}
113		113
114	function getInfo($message,$dblink){	114	function getInfo($message,$dblink){
115	$answer = array();	115	$answer = array();
116		116
117	if (preg_match("/linux/i",$message)) {	117	if (preg_match("/linux/i",$message)) {
118	$dist_id = 0;	118	$dist_id = 0;
119	$dist_info = "";	119	$dist_info = "";
120	$vers_id = 0;	120	$vers_id = 0;
121	$vers_info = "";	121	$vers_info = "";
122	$qd =& $dblink->query("SELECT * FROM distribution");	122	$qd =& $dblink->query("SELECT * FROM distribution");
123	while ($qd->fetchInto($res, DB_FETCHMODE_ASSOC)) {	123	while ($qd->fetchInto($res, DB_FETCHMODE_ASSOC)) {
124	if (preg_match("/".stripslashes($res["distua"])."/i",$message)) {	124	if (preg_match("/".stripslashes($res["distua"])."/i",$message)) {
125	$dist_id = $res["dist_id"];	125	$dist_id = $res["dist_id"];
126	$dist_info = stripslashes($res["distname"]);	126	$dist_info = stripslashes($res["distname"]);
127	$qv =& $dblink->query("SELECT * FROM version WHERE dist_id='$dist_id'");	127	$qv =& $dblink->query("SELECT * FROM version WHERE dist_id='$dist_id'");
128	while($qv->fetchInto($rev, DB_FETCHMODE_ASSOC)) {	128	while($qv->fetchInto($rev, DB_FETCHMODE_ASSOC)) {
129	if (preg_match("/".stripslashes($rev["vcodename"])."/i",$message)) {	129	if (preg_match("/".stripslashes($rev["vcodename"])."/i",$message)) {
130	$vers_id = $rev["version_id"];	130	$vers_id = $rev["version_id"];
131	$vers_info = stripslashes($rev["version"])." “".stripslashes($rev["vname"])."”";	131	$vers_info = stripslashes($rev["version"])." “".stripslashes($rev["vname"])."”";
132	}	132	}
133	}	133	}
134	}	134	}
135	}	135	}
136	$answer[] = "Linux";	136	$answer[] = "Linux";
137	$answer[] = "Судя по всему у Вас операционная система ";	137	$answer[] = _("It seems you have an operating system "); // "Судя по всему у Вас операционная система ";
138	if ($dist_id!=0) {	138	if ($dist_id!=0) {
139	$answer[] = $dist_id;	139	$answer[] = $dist_id;
140	$answer[] = $dist_info;	140	$answer[] = $dist_info;
141	}	141	}
142	if ($vers_id!=0) {	142	if ($vers_id!=0) {
143	$answer[] = $vers_id;	143	$answer[] = $vers_id;
144	$answer[] = $vers_info;	144	$answer[] = $vers_info;
145	}	145	}
146		146
147	} else {	147	} else {
148	$answer[] = "unknown";	148	$answer[] = "unknown";
149	$answer[] = "Ресурс рассчитан явно не на Вашу операционную систему!";	149	$answer[] = _("The resource not for your operating system!"); // "Ресурс рассчитан явно не на Вашу операционную систему!";
150	}	150	}
151		151
152	return $answer;	152	return $answer;
153	}	153	}
154		154
155	function getInterfacesList($current,$dblink) {	155	function getInterfacesList($current,$dblink) {
156	$url = parse_url($current);	156	$url = parse_url($current);
157	$path = array();	157	$path = array();
158	$path = split("/",$url["path"]);	158	$path = split("/",$url["path"]);
159	$currentIF = str_replace(".php","",$path[count($path)-1]);	159	$currentIF = str_replace(".php","",$path[count($path)-1]);
160	$req =& $dblink->query("SELECT * FROM interfaces WHERE interface NOT LIKE '$currentIF'");	160	$req =& $dblink->query("SELECT * FROM interfaces WHERE interface NOT LIKE '$currentIF'");
161	$iflist = "<a href='./'>Интерфейсы</a>: ";	161	$iflist = "<a href='./'>"._("Interfaces")."</a>: ";
162	while ($req->fetchInto($if, DB_FETCHMODE_ASSOC)) {	162	while ($req->fetchInto($if, DB_FETCHMODE_ASSOC)) {
163	$iflist .= "<a href='./".stripslashes($if["interface"]).".php'>".strtolower(stripslashes($if["interfaceinfo"]))."</a>, ";	163	$iflist .= "<a href='./".stripslashes($if["interface"]).".php'>".strtolower(stripslashes($if["interfaceinfo"]))."</a>, ";
164	}	164	}
165	$iflist = substr($iflist, 0, strlen($iflist)-2);	165	$iflist = substr($iflist, 0, strlen($iflist)-2);
166	return $iflist;	166	return $iflist;
167	}	167	}
168		168
169	function getCSSList($dblink) {	169	function getCSSList($dblink) {
170	$req =& $dblink->query("SELECT * FROM distribution");	170	$req =& $dblink->query("SELECT * FROM distribution");
171	if ($req->numRows()>0) {	171	if ($req->numRows()>0) {
172	$css = "<style type=\"text/css\">\n";	172	$css = "<style type=\"text/css\">\n";
173	while ($req->fetchInto($dist, DB_FETCHMODE_ASSOC)) {	173	while ($req->fetchInto($dist, DB_FETCHMODE_ASSOC)) {
174	if ($dist["distlogo"]) {	174	if ($dist["distlogo"]) {
175	$css .= ".".stripslashes($dist["distua"])." { display: inline; padding-left: 16px; background: transparent url(./img/logo/".stripslashes($dist["distua"]).".png) top left no-repeat; }\n";	175	$css .= ".".stripslashes($dist["distua"])." { display: inline; padding-left: 16px; background: transparent url(./img/logo/".stripslashes($dist["distua"]).".png) top left no-repeat; }\n";
176	$css .= ".".stripslashes($dist["distua"])."-em { display: inline; padding-left: 32px; background: transparent url(./img/logo/".stripslashes($dist["distua"])."-em.png) top left no-repeat; }\n";	176	$css .= ".".stripslashes($dist["distua"])."-em { display: inline; padding-left: 32px; background: transparent url(./img/logo/".stripslashes($dist["distua"])."-em.png) top left no-repeat; }\n";
177	} else {	177	} else {
178	$css .= "";	178	$css .= "";
179	}	179	}
180	}	180	}
181	$css .= "</style>";	181	$css .= "</style>";
182	} else {	182	} else {
183	$css = "";	183	$css = "";
184	}	184	}
185	return $css;	185	return $css;
186	}	186	}
187		187
188	function getSetting($setting, $dblink) {	188	function getSetting($setting, $dblink) {
189	$query =& $dblink->query("SELECT * FROM settings WHERE opt LIKE '".$setting."'");	189	$query =& $dblink->query("SELECT * FROM settings WHERE opt LIKE '".$setting."'");
190	$query->fetchInto($sett, DB_FETCHMODE_ASSOC);	190	$query->fetchInto($sett, DB_FETCHMODE_ASSOC);
191	return stripslashes($sett["optvalue"]);	191	return stripslashes($sett["optvalue"]);
192	}	192	}
193		193
194	function getUUID($param) {	194	function getUUID($param) {
195	$param_s = md5($param);	195	$param_s = md5($param);
196	$time_low = bin2hex(substr($param_s,0, 4));	196	$time_low = bin2hex(substr($param_s,0, 4));
197	$time_mid = bin2hex(substr($param_s,4, 2));	197	$time_mid = bin2hex(substr($param_s,4, 2));
198	$time_hi_and_version = bin2hex(substr($param_s,6, 2));	198	$time_hi_and_version = bin2hex(substr($param_s,6, 2));
199	$clock_seq_hi_and_reserved = bin2hex(substr($param_s,8, 2));	199	$clock_seq_hi_and_reserved = bin2hex(substr($param_s,8, 2));
200	$node = bin2hex(substr($param_s,10, 6));	200	$node = bin2hex(substr($param_s,10, 6));
201		201
202	$time_hi_and_version = hexdec($time_hi_and_version);	202	$time_hi_and_version = hexdec($time_hi_and_version);
203	$time_hi_and_version = $time_hi_and_version >> 4;	203	$time_hi_and_version = $time_hi_and_version >> 4;
204	$time_hi_and_version = $time_hi_and_version \| 0x4000;	204	$time_hi_and_version = $time_hi_and_version \| 0x4000;
205		205
206	$clock_seq_hi_and_reserved = hexdec($clock_seq_hi_and_reserved);	206	$clock_seq_hi_and_reserved = hexdec($clock_seq_hi_and_reserved);
207	$clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved >> 2;	207	$clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved >> 2;
208	$clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved \| 0x8000;	208	$clock_seq_hi_and_reserved = $clock_seq_hi_and_reserved \| 0x8000;
209		209
210	return sprintf('%08s-%04s-%04x-%04x-%012s',$time_low, $time_mid, $time_hi_and_version, $clock_seq_hi_and_reserved, $node);	210	return sprintf('%08s-%04s-%04x-%04x-%012s',$time_low, $time_mid, $time_hi_and_version, $clock_seq_hi_and_reserved, $node);
211	}	211	}
212		212
213		213
214	function getRepList($distro,$version,$dblink) {	214	function getRepList($distro,$version,$dblink) {
215	$query =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");	215	$query =& $dblink->query("SELECT * FROM repository r JOIN ver2rep v ON r.rep_id=v.rep_id JOIN origin o ON o.orig_id=r.orig_id JOIN version v2 ON v.ver_id=v2.version_id JOIN scheme s ON s.scheme_id=r.scheme_id JOIN root r2 ON r2.root_id=r.root_id WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");
216	$i=-1;	216	$i=-1;
217	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {	217	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {
218	$i++;	218	$i++;
219	$res[0][$i]=$resinfo["rep_id"];	219	$res[0][$i]=$resinfo["rep_id"];
220	$res[1][$i]=$resinfo["repname"];	220	$res[1][$i]=$resinfo["repname"];
221	$res[2][$i]=$resinfo["repdescribe"];	221	$res[2][$i]=$resinfo["repdescribe"];
222	$res[3][$i]=$resinfo["defaultrep"];	222	$res[3][$i]=$resinfo["defaultrep"];
223	}	223	}
224	return $res;	224	return $res;
225	}	225	}
226	}	226	}
227	?>	227	?>
228		228