Редакция 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(); |
| 78 | 43 | ||
| Строка 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 | ?>
|