WebSVN - ant - Различия - Редакция 82 и 83


<?php

class Core {

        function getRepList($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 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);
           
                        $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[] = "Судя по всему у Вас операционная система ";
                        if ($dist_id!=0) {
                                $answer[] = $dist_id;
                                $answer[] = $dist_info;
                        }
                        if ($vers_id!=0) {
                                $answer[] = $vers_id;
                                $answer[] = $vers_info;
                        }

                } else {
                        $answer[] = "unknown";
                        $answer[] = "Ресурс рассчитан явно не на Вашу операционную систему!";
                }

                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='./'>Интерфейсы</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: 15px; background: transparent url(./img/logo/".stripslashes($dist["distua"]).".png) top left no-repeat; }\n";
                                        $css .= ".".stripslashes($dist["distua"])."-em { display: inline; padding-left: 30px; background: transparent url(./img/logo/".stripslashes($dist["distua"])."-em.png) top left no-repeat; }\n";
                                } else {
                                        $css .= "";
                                }
                        }
                        $css .= "</style>";
                } else {
                        $css = "";
                }
                return $css;
        }
}

?>
 

Редакция 82	Редакция 83
1	<?php	1	<?php
2		2
3	class Core {	3	class Core {
4		4
5	function getRepList($distro,$version,$dblink) {	5	function getRepList($distro,$version,$dblink) {
6	$query =& $dblink->query("SELECT * FROM settings");	6	$query =& $dblink->query("SELECT * FROM settings");
7	$settings = array();	7	$settings = array();
8	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {	8	while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) {
9	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);	9	$settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]);
10	};	10	};
11	$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'");	11	$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'");
12	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);	12	$query->fetchInto($infodist, DB_FETCHMODE_ASSOC);
13	$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 WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");	13	$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 WHERE v.ver_id='$version' ORDER BY r.rtype_id, r.scheme_id ASC");
14	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {	14	while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) {
15	$repscheme = stripslashes($resinfo["scheme"]);	15	$repscheme = stripslashes($resinfo["scheme"]);
16		16
17	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE	17	$querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE
18	r.rep_id='$resinfo[rep_id]'");	18	r.rep_id='$resinfo[rep_id]'");
19	$sections = "";	19	$sections = "";
20	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {	20	while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) {
21	$sections .= stripslashes($section["sectname"])." ";	21	$sections .= stripslashes($section["sectname"])." ";
22	}	22	}
23		23
24	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);	24	$repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme);
25	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);	25	$repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme);
26	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);	26	$repscheme = str_replace("{URL}",$settings["url"],$repscheme);
27	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);	27	$repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme);
28	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);	28	$repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme);
29	$repscheme = str_replace("{SECT}",$sections,$repscheme);	29	$repscheme = str_replace("{SECT}",$sections,$repscheme);
30		30
31	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";	31	$result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n";
32	}	32	}
33	return $result;	33	return $result;
34	}	34	}
35		35
36	function getInfo($message,$dblink){	36	function getInfo($message,$dblink){
37	$answer = array();	37	$answer = array();
38		38
39	if (preg_match("/linux/i",$message)) {	39	if (preg_match("/linux/i",$message)) {
40	$dist_id = 0;	40	$dist_id = 0;
41	$dist_info = "";	41	$dist_info = "";
42	$vers_id = 0;	42	$vers_id = 0;
43	$vers_info = "";	43	$vers_info = "";
44	$qd =& $dblink->query("SELECT * FROM distribution");	44	$qd =& $dblink->query("SELECT * FROM distribution");
45	while ($qd->fetchInto($res, DB_FETCHMODE_ASSOC)) {	45	while ($qd->fetchInto($res, DB_FETCHMODE_ASSOC)) {
46	if (preg_match("/".stripslashes($res["distua"])."/i",$message)) {	46	if (preg_match("/".stripslashes($res["distua"])."/i",$message)) {
47	$dist_id = $res["dist_id"];	47	$dist_id = $res["dist_id"];
48	$dist_info = stripslashes($res["distname"]);	48	$dist_info = stripslashes($res["distname"]);
49	$qv =& $dblink->query("SELECT * FROM version WHERE dist_id='$dist_id'");	49	$qv =& $dblink->query("SELECT * FROM version WHERE dist_id='$dist_id'");
50	while($qv->fetchInto($rev, DB_FETCHMODE_ASSOC)) {	50	while($qv->fetchInto($rev, DB_FETCHMODE_ASSOC)) {
51	if (preg_match("/".stripslashes($rev["vcodename"])."/i",$message)) {	51	if (preg_match("/".stripslashes($rev["vcodename"])."/i",$message)) {
52	$vers_id = $rev["version_id"];	52	$vers_id = $rev["version_id"];
53	$vers_info = stripslashes($rev["version"])." “".stripslashes($rev["vname"])."”";	53	$vers_info = stripslashes($rev["version"])." “".stripslashes($rev["vname"])."”";
54	}	54	}
55	}	55	}
56	}	56	}
57	}	57	}
58	$answer[] = "Linux";	58	$answer[] = "Linux";
59	$answer[] = "Судя по всему у Вас операционная система ";	59	$answer[] = "Судя по всему у Вас операционная система ";
60	if ($dist_id!=0) {	60	if ($dist_id!=0) {
61	$answer[] = $dist_id;	61	$answer[] = $dist_id;
62	$answer[] = $dist_info;	62	$answer[] = $dist_info;
63	}	63	}
64	if ($vers_id!=0) {	64	if ($vers_id!=0) {
65	$answer[] = $vers_id;	65	$answer[] = $vers_id;
66	$answer[] = $vers_info;	66	$answer[] = $vers_info;
67	}	67	}
68		68
69	} else {	69	} else {
70	$answer[] = "unknown";	70	$answer[] = "unknown";
71	$answer[] = "Ресурс рассчитан явно не на Вашу операционную систему!";	71	$answer[] = "Ресурс рассчитан явно не на Вашу операционную систему!";
72	}	72	}
73		73
74	return $answer;	74	return $answer;
75	}	75	}
76		76
77	function getInterfacesList($current,$dblink) {	77	function getInterfacesList($current,$dblink) {
78	$url = parse_url($current);	78	$url = parse_url($current);
79	$path = array();	79	$path = array();
80	$path = split("/",$url["path"]);	80	$path = split("/",$url["path"]);
81	$currentIF = str_replace(".php","",$path[count($path)-1]);	81	$currentIF = str_replace(".php","",$path[count($path)-1]);
82	$req =& $dblink->query("SELECT * FROM interfaces WHERE interface NOT LIKE '$currentIF'");	82	$req =& $dblink->query("SELECT * FROM interfaces WHERE interface NOT LIKE '$currentIF'");
83	$iflist = "<a href='./'>Интерфейсы</a>: ";	83	$iflist = "<a href='./'>Интерфейсы</a>: ";
84	while ($req->fetchInto($if, DB_FETCHMODE_ASSOC)) {	84	while ($req->fetchInto($if, DB_FETCHMODE_ASSOC)) {
85	$iflist .= "<a href='./".stripslashes($if["interface"]).".php'>".strtolower(stripslashes($if["interfaceinfo"]))."</a>, ";	85	$iflist .= "<a href='./".stripslashes($if["interface"]).".php'>".strtolower(stripslashes($if["interfaceinfo"]))."</a>, ";
86	}	86	}
87	$iflist = substr($iflist, 0, strlen($iflist)-2);	87	$iflist = substr($iflist, 0, strlen($iflist)-2);
88	return $iflist;	88	return $iflist;
89	}	89	}
90		90
91	function getCSSList($dblink) {	91	function getCSSList($dblink) {
92	$req =& $dblink->query("SELECT * FROM distribution");	92	$req =& $dblink->query("SELECT * FROM distribution");
93	if ($req->numRows()>0) {	93	if ($req->numRows()>0) {
-		94	$css = "<style type=\"text/css\">\n";
94	while ($req->fetchInto($dist, DB_FETCHMODE_ASSOC)) {	95	while ($req->fetchInto($dist, DB_FETCHMODE_ASSOC)) {
95	if ($dist["distlogo"]) {	96	if ($dist["distlogo"]) {
96	$css .= ".".stripslashes($dist["distua"])." { display: inline; padding-left: 15px; background: transparent url(./img/logo/".$dist["distua"].".png) top left no-repeat; }\n";	97	$css .= ".".stripslashes($dist["distua"])." { display: inline; padding-left: 15px; background: transparent url(./img/logo/".stripslashes($dist["distua"]).".png) top left no-repeat; }\n";
97	$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";	98	$css .= ".".stripslashes($dist["distua"])."-em { display: inline; padding-left: 30px; background: transparent url(./img/logo/".stripslashes($dist["distua"])."-em.png) top left no-repeat; }\n";
98	} else {	99	} else {
99	$css .= "";	100	$css .= "";
100	}	101	}
101	}	102	}
-		103	$css .= "</style>";
102	} else {	104	} else {
103	$css = "";	105	$css = "";
104	}	106	}
105	return $css;	107	return $css;
106	}	108	}
107	}	109	}
108		110
109	?>	111	?>
110		112

Хранилища Subversion ant

(root)/trunk/lib/core.php - Редакция 82 → 83