Редакция 195 | Весь файл | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 195 | Редакция 196 | ||
---|---|---|---|
Строка 6... | Строка 6... | ||
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 | if ($_GET['mainreps']!='no'){ |
- | |
12 | $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'"); |
- | |
13 | $query->fetchInto($infodist, DB_FETCHMODE_ASSOC); |
- | |
14 | $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' AND r.rtype_id!=3 ORDER BY r.rtype_id, r.scheme_id ASC"); |
11 | $repos=array_values($_GET); |
15 | $pre=-1; |
- | |
16 | while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) { |
- | |
17 | $repscheme = stripslashes($resinfo["scheme"]); |
- | |
18 | - | ||
19 | $querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE |
- | |
20 | r.rep_id='$resinfo[rep_id]'"); |
- | |
21 | $sections = ""; |
- | |
22 | while ($querysect->fetchInto($section,DB_FETCHMODE_ASSOC)) { |
- | |
23 | $sections .= stripslashes($section["sectname"])." "; |
- | |
24 | }
|
- | |
25 | - | ||
26 | $repscheme = str_replace("{TYPE}",stripslashes($infodist["type"]),$repscheme); |
- | |
27 | $repscheme = str_replace("{PROTO}",$settings["proto"],$repscheme); |
- | |
28 | $repscheme = str_replace("{URL}",$settings["url"],$repscheme); |
- | |
29 | $repscheme = str_replace("{REP}",stripslashes($resinfo["repname"]),$repscheme); |
- | |
30 | $repscheme = str_replace("{DIST}",stripslashes($infodist["vcodename"]),$repscheme); |
- | |
31 | $repscheme = str_replace("{SECT}",$sections,$repscheme); |
- | |
32 | $repscheme = str_replace("{ROOT}",stripslashes($resinfo["root_folder"]),$repscheme); |
- | |
33 | - | ||
34 | if($pre != $resinfo["orig_id"]) { |
- | |
35 | $result .= "### ".$resinfo["origin"]."( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n"; |
- | |
36 | }
|
- | |
37 | $pre = $resinfo["orig_id"]; |
- | |
38 | - | ||
39 | $result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n"; |
- | |
40 | }
|
- | |
41 | }
|
- | |
42 | if (count($_GET)>3){ |
- | |
43 | $addsreps=array_values($_GET); |
- | |
44 | if (isset($_GET['mainreps'])){$offs=1;}else{$offs=0;} //пока такой костыль |
- | |
45 | for ($i=3;$i<count($addsreps)-$offs;$i++){ |
12 | for ($i=3;$i<count($repos);$i++){ |
46 | $pre=-1; |
13 | $pre=-1; //wtf? |
47 | $id=(int)$addsreps[$i]; |
14 | $id=(int)$repos[$i]; |
48 | $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); |
15 | $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); |
49 | $sql->fetchInto($resinfo, DB_FETCHMODE_ASSOC); |
16 | $sql->fetchInto($resinfo, DB_FETCHMODE_ASSOC); |
50 | 17 | ||
51 | $repscheme = stripslashes($resinfo["scheme"]); |
18 | $repscheme = stripslashes($resinfo["scheme"]); |
52 | $querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE |
19 | $querysect =& $dblink->query("SELECT * FROM section s JOIN sect2rep r ON s.sect_id=r.sect_id WHERE |
Строка 66... | Строка 33... | ||
66 | $result .= "### ".$resinfo["origin"]."( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n"; |
33 | $result .= "### ".$resinfo["origin"]."( ".$resinfo["desk"]." ) - ".$resinfo["homeurl"]." ###\n"; |
67 | }
|
34 | }
|
68 | $pre = $resinfo["orig_id"]; |
35 | $pre = $resinfo["orig_id"]; |
69 | $result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n"; |
36 | $result .= "# ".stripslashes($resinfo["repdescribe"])."\n".$repscheme."\n\n"; |
70 | }
|
37 | }
|
71 | }
|
- | |
72 | - | ||
73 | return $result; |
38 | return $result; |
74 | }
|
39 | }
|
75 | 40 | ||
76 | function getInfo($message,$dblink){ |
41 | function getInfo($message,$dblink){ |
77 | $answer = array(); |
42 | $answer = array(); |
Строка 179... | Строка 144... | ||
179 | while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) { |
144 | while ($query->fetchInto($setting, DB_FETCHMODE_ASSOC)) { |
180 | $settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]); |
145 | $settings[stripslashes($setting["opt"])] = stripslashes($setting["optvalue"]); |
181 | }; |
146 | }; |
182 | $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'"); |
147 | $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'"); |
183 | $query->fetchInto($infodist, DB_FETCHMODE_ASSOC); |
148 | $query->fetchInto($infodist, DB_FETCHMODE_ASSOC); |
184 | $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' AND r.rtype_id=3 ORDER BY r.rtype_id, r.scheme_id ASC"); |
149 | $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"); |
185 | $result.='<input type="hidden" name="d" value="'.$_GET['d'].'"> |
150 | $result.='<input type="hidden" name="d" value="'.$_GET['d'].'"> |
186 | <input type="hidden" name="v" value="'.$_GET['v'].'">'; |
151 | <input type="hidden" name="v" value="'.$_GET['v'].'">'; |
187 | $tmp=0; |
152 | $tmp=0; |
188 | while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) { |
153 | while ($query->fetchInto($resinfo, DB_FETCHMODE_ASSOC)) { |
189 | $tmp++; |
154 | $tmp++; |
- | 155 | if ($resinfo['rtype_id']!=3){$ch='checked';}else{$ch='';} |
|
190 | $result.='<input type="checkbox" name="'.$tmp.'" value="'.$resinfo['rep_id'].'">'.$resinfo['repname'].' <em>('.$resinfo['repdescribe'].')</em><br>'; |
156 | $result.='<input type="checkbox" name="'.$tmp.'" '.$ch.' value="'.$resinfo['rep_id'].'">'.$resinfo['repname'].' <em>('.$resinfo['repdescribe'].')</em><br>'; |
191 | }
|
157 | }
|
192 | return $result; |
158 | return $result; |
193 | }
|
159 | }
|
194 | }
|
160 | }
|
195 | ?>
|
161 | ?>
|